Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-finance]

The tag has no usage guidance.

-1
votes
0answers
15 views

Google Finance update in Google Sheets

I want close of a stock for every 15 min in Google Sheets. The previous data in intraday should be available along with the current data.
0
votes
0answers
37 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: ...
0
votes
1answer
53 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?
0
votes
1answer
173 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, "...
0
votes
1answer
190 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
0
votes
1answer
495 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=...
0
votes
2answers
1k 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 markets where closed the formula returns #N/A. ...
3
votes
1answer
1k 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 ...
3
votes
2answers
2k 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 ...
1
vote
2answers
5k 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)
2
votes
1answer
208 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
1answer
140 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 ...
1
vote
1answer
1k 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?
0
votes
2answers
330 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 ...
5
votes
1answer
4k 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 ...
14
votes
4answers
28k 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 ...