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.
65
questions
2
votes
1
answer
4k
views
How can I get ''OHLC'' data rather the Close only?
=GoogleFinance("CURRENCY:EURUSD","all","1/23/2005","50")
The code above just fetch the close rate and leaves the other columns blank. How to fix that?
- 21
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
4
answers
6k
views
googleFinance calculating the standard deviation of a stock over a time period
Can I calculate the standard deviation of a stock over a time period in GoogleFinance?
https://support.google.com/docs/answer/3093281?hl=en-GB
- 111
0
votes
1
answer
2k
views
How to get Google Finance Intraday data into Google Spreadsheet?
I want to import data from following link into Google Spreadsheet
https://www.google.com/finance/getprices?q=BANKBARODA&x=NSE&i=900&p=1d&f=v&df=cpct&auto=1&ts=...
- 103
8
votes
6
answers
30k
views
How to get close price for last date market was open?
When using the GOOGLEFINANCE formula to get historical prices and performance for different periods, if the date used in the formula is one where the market was closed the formula returns #N/A. This ...
- 441
6
votes
1
answer
11k
views
Stock Sparkline for today/hourly
I am trying to make a sparkline graph in Google Sheets that tracks the stock price of TODAY using google finance as time progresses. For example, at 8am it would show the opening price, and by close ...
- 61
5
votes
2
answers
9k
views
Automatically store updated GOOGLEFINANCE values with a script
Hello, I want to keep track of the profit of the combination of many stock values. To do that I have my google Spreadsheet with many formulas calculating the profits or losses ratios taking into ...
- 267
8
votes
1
answer
10k
views
Remove Header from GOOGLEFINANCE query [duplicate]
I want to create a graph with different stock values starting and ending at a certain day. To do that I create a table like this:
Where the first column is the market and the second one is the ticker ...
- 267
1
vote
4
answers
53k
views
Google Finance API call for stock dividend (Yield)?
Is there an API call to use in a Google Spreadsheet to get a stock's Dividend Yield (% annual yield)
- 3,051
2
votes
1
answer
465
views
How to add refreshed data to new column in Google Sheets
I am making a Google Sheets app that reads column A which has a stock symbol and puts the price in the column to the right using =GOOGLEFINANCE
I have this refreshing every day and appending to the ...
1
vote
1
answer
560
views
Google Finance / Spreadsheets
I have been trying to get Net Assets and 1 Week Return for SPY on Google Spreadsheets but keep ending up with #N/A.
I have been following the information from this sheet but have yet to figure out ...
- 87
5
votes
3
answers
28k
views
How can I get GoogleFinance to see 1 year and 5 year return of a stock?
You can use GOOGLEFINANCE("name", "return52") for mutual funds, but not for stocks. Is there another way to get the same result?
- 51
0
votes
2
answers
554
views
Google Finance Chart Zoom not working
If I pick a stock, say Ferrari, and view it's stock price chart at Google Finance, and click on different zoom levels, e.g. 5y or 10y, the chart does not update.
This occurs in Chrome and Internet ...
- 183
5
votes
1
answer
5k
views
Automatic currency conversion
I would like to add an automatic conversion thing to my spreadsheet.
I have two columns, A1 titled Money in USD and B1 titled Money in BRL.
I want to make it so whenever I enter a value in the USD ...
- 53
54
votes
5
answers
91k
views
How can I get GOOGLEFINANCE to return only the historical price of a stock and not an array?
I'm trying to figure out the cost basis of some stock that I sold last year and I can't quite get GOOGLEFINANCE to do what I want. The stock was purchased through a DRIP so there are about five shares ...
- 651