Questions tagged [google-finance]
For questions about Google Finance - service focusing on business news and financial information. Can be applied also on Google Sheets' GOOGLEFINANCE function.
26
questions with no upvoted or accepted answers
3
votes
1
answer
1k
views
What ticker symbol to use for the crude oil price?
Which ticker symbol can I use for the crude oil price for the GOOGLEFINANCE function?
Nasdaq Brent oil is "BZ:NMX"
https://www.nasdaq.com/market-activity/commodities/bz:nmx
Nasdaq Crude oil ...
- 271
2
votes
1
answer
2k
views
How do I get GOOGLEFINANCE to return only the date and not the date and time of stock price history?
=GOOGLEFINANCE("NASDAQ:GOOGL","close",date(2021,1,1),today(),1)
returns closing history in two columns "Date" and "Close" since Jan. 1, 2021. The date column ...
- 121
1
vote
0
answers
669
views
Google Finance in historical mode (WEEKLY): extra rows and not always aligned to Fridays
I am trying to use GOOGLEFINANCE function to query the weekly close price of an instrument (SP500, ticker ".INX"), for the last 52 weeks.
I first tried using the following formula:
...
- 11
1
vote
1
answer
1k
views
Google Finance Historical Data with Multiple Attributes? (Dates, high, low, close,)
I'm using this formula:
=ARRAY_CONSTRAIN(GOOGLEFINANCE("NYSE:"&A4, "all", DATE(2020,4,1), DATE(2020,4,30), "DAILY"), 2, 4)
I'm only getting one column for April 1, 2020.
I would like to get ...
1
vote
0
answers
154
views
Script to send email when a cell value is changed automatically by GOOGLEFINANCE function
I have a column of values that pulls data from GoogleFinance using the =GOOGLEFINANCE function in Google Sheets. When the function is working, the column will return a series of figures. Occasionally, ...
- 11
1
vote
1
answer
182
views
how to get max high of the given days excluding weekly off days
Can any one help how to get maximum high of given days excluding weekly off days (sat/sunday) from google finance.
I am using formula like: =query(GOOGLEFINANCE("NSE:"&Y3,"high",(TODAY()-55),...
- 11
1
vote
1
answer
106
views
Fetch value of a cell based on dropdown menu items results on another sheet
I have 2 Sheets named as Sheet1 and Sheet2...
Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column.
Sheet2: ...
- 11
1
vote
0
answers
483
views
How to see Sparkline for Mutual Funds using googlefinance?
In Google sheets when I try to plot the mutual fund price for the last one year using sparkline function, I keep getting an error.
When evaluating GOOGLEFINANCE, the query for the symbol: ...
- 11
1
vote
1
answer
2k
views
Google Spreadsheet Stock Sparkline Trend Conditional Formatting
I am trying to do a Sparkline whose color changes based on the trend and for some reason the if clause which gets its input from google finance isn't working
=sparkline(query(googlefinance($C5, "...
- 11
0
votes
0
answers
75
views
Googlefinance historic currency exchange rate wrong
If in google sheets I do
=GOOGLEFINANCE("Currency:EURIDR")*GOOGLEFINANCE("Currency:IDREUR")
I get a value close to 1 as expected. (Product of exchange rate and reverse rate should ...
- 101
0
votes
0
answers
87
views
How can I solve this formula?
=index(importhtml(concatenate("https://finance.yahoo.com/quote/";A6;"/key-statistics?p="A6";"EN_US");1;2)
A6 is tiker: MO
I need Dividend date: Oct 10, 2022
Original ...
- 23
0
votes
0
answers
588
views
Google Finance Sheets: Dividends and Stock Splits
I am building a Google Finance Spread Sheet for my portfolio and curious about a few things.
Generally, I am trying to calculate the monthly returns for each month and essentially outputted the ...
- 1
0
votes
1
answer
154
views
How to make formula based off a withholding table?
I have been attempting to make a formula to easily calculate federal income tax rates. The picture attached is the withholding table that I've transferred onto a sheet. These are the thresholds I am ...
- 1
0
votes
0
answers
402
views
Google Finance returns currency for US stocks but not others (for example UK)
Google Finance, in Google Sheets, works for US stocks but not others (for example UK).
US stock:
msft
=GOOGLEFINANCE("msft","price") works
=GOOGLEFINANCE("msft","...
- 101
0
votes
0
answers
59
views
How to create a google sheets formula to return a value based on % values in other cells & weighted average formula? (FIXED)
I've been trying to create a scoring system for expected stock market returns -
Sheet
I'm having problems creating a formula to firstly give stocks a score in multiple conditions for example SS
I want ...
0
votes
1
answer
611
views
google sheets get stock in specific currency
To track stocks I made an overview of bought and sold stocks, and generate a pivot table with the current amount of stocks owned.
I want to calculate the total value of my stocks.
The problem I have ...
0
votes
1
answer
468
views
How to Run a Query in Google Sheets for New 26-Week Highs 2 of Last 4 Days Using GOOGLEFINANCE Function
I already have a query that returns a list of 26-Week Highs (from a sheet with my list of stocks (Column A), column of today's high (Column B), column of 26-Week High (Column C)). I'd like to have a ...
- 1
0
votes
1
answer
537
views
SPX 500 Monthly Return Google Finance
I need to formulate the SPX500 return from "x start date" to "x end date".
I have managed to figure out "x start date" to current date (year to date return) but I cant ...
0
votes
1
answer
246
views
How to get AUD price of bitcoin at a particular date using GOOGLEFINANCE
I am trying to find out how to get the price of bitcoin, ethereum, litecoin and bitcoin cash in AUD at a particular date.
I have a table as follows
+------------+-------+
| Date | Price |
+------...
- 101
0
votes
1
answer
179
views
Appending current Share Price to Historic Daily Share Price on Google Sheet GOOGLEFINANCE Function Sparkline
I have a sparkline for the daily price for the last 30 days for a share in google sheets using the following formula (F1):
F1 =SPARKLINE(GOOGLEFINANCE("GOOG","price",Today()-30,...
0
votes
0
answers
81
views
List with all cryptocurrencies available in the GOOGLEFINANCE formula?
I tried to find some documentation on what cryptocurrencies are retrievable with the GOOGLEFINANCE formula, but I couldn't find any. There's only this general helpsheet on the topic, which doesn't ...
- 227
0
votes
0
answers
308
views
Currency Conversion, Array Formula, Google Sheets
I was hoping to use array formula in conjunction with Google Finance to convert currencies on specific dates. I've been using a google form to enter basic expense information and the form adds a new ...
- 1
0
votes
1
answer
717
views
How can I get stocks' historical high, low, and close prices?
How can I retrieve historical stock prices in Google Sheets?
I'd like to be able to return historical weekly and monthly high, low and close prices.
- 1
0
votes
1
answer
385
views
Having trouble outputting GOOGLEFINANCE data
My wish is to create a table in Google sheets looking something like this:
price
day A B C D ... Z
1997-01-02 132.54 . . . .
1997-01-...
- 1
-1
votes
1
answer
39
views
Smallest number recorded in a cell
A value in a cell that changes automatically (using Google Finance), I want to record the lowest value in another cell.
-1
votes
1
answer
407
views
Scraping currency conversion rate from Oanda.com
A currency conversation formula for example:
=GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,)
Will display the closing price by default under "price". There is no option for the Average price. ...
