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.
5
questions
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
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
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
2
votes
1
answer
5k
views
How can I use GOOGLEFINANCE to return a share price in a certain currency?
I have shares in different currencies that I want to track in only a single currency. I currently have a cell that returns the currency and one that returns the price, I then multiply them. However, I'...
- 21
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 ...
