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.

22 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
7 views

How to link cell within googlefinance formula

I'm trying to get the googlefinance formula to work for multiple country exchanges. e.g. Tencent is listed on Hong Kong stock exchange, the code is 0700. If I put =googlefinance(HKG:0700,"price"), ...
1
vote
1answer
14 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
1answer
82 views

Why does close price results have a date shift (one day off) while using GOOGLEFINANCE in a Query

I want to get last 40 days close price of stocks. I used below formula for the same but the result not showing the last day close price. =QUERY( GOOGLEFINANCE("nse:"&B2,"all",$A$2-80,81),...
1
vote
1answer
718 views

Google Finance Historical Data with Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =...
1
vote
0answers
251 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
0answers
17 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 ...
0
votes
0answers
17 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 ...
0
votes
1answer
31 views

How can I get GoogleFinance to see the return of a stock from a specified date range?

How can I see the percentage of return from a stock from a specified date range to today? For example: February 19, 2020 to today = -31.93%. So far I have: =GOOGLEFINANCE("GOOG","price") / index(...
0
votes
0answers
30 views

How can I get GoogleFinance to see 1 year return of a stock from a specified date?

This works so far but how would I do this if I wanted to do 365 days from a specified date instead of today? For example, 2020/2/19 and 365 days prior. =GOOGLEFINANCE(A2,"price") / index(...
0
votes
1answer
25 views

Google Finance function returns Date not Currency Conversion

I am trying to calculate the USD:AUD conversion from M3 and show the result of the current conversion rate in the next cell, but it is only resolving the date I am trying to get cell M3 to convert to ...
0
votes
0answers
40 views

Why doesn't the GOOGLEFINANCE function work inside a calculated field in a pivot table?

I can use VLOOKUP to find something from a calculated field, but the GOOGLEFINANCE function just gets stuck loading forever: In this example, GOOGLEFINANCE is used to find the stock name, the "Tag" ...
0
votes
1answer
23 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),...
0
votes
1answer
308 views

Google Sheets - Historical Data not returning yesterday

The formula below is been used to get the historical data until today: =GOOGLEFINANCE("GOOG","ALL",DATE(YEAR(TODAY())-1,1,1),"12/05/2019","DAILY") Unfortunately I don't receive today's data (until ...
0
votes
0answers
24 views

I'm using googlefinance in sheets; printing to PDF shows N/A in place of calculation values

in calc using googlefinance function, when working/looking in worksheet, it calculates properly BUT when I go to print/PDF with control P, then open PDF the print shows N/A Here's a simple example ...
0
votes
1answer
149 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-...
0
votes
1answer
75 views

Google sheet formula for previous 7 day high

Need a formula for previous 7 working day high for a share =INDEX(GOOGLEFINANCE("nse:"&A2, "high", TODAY()-3.3), 2, 2) Used the above formula but I need only workday formula.
0
votes
1answer
1k views

Google Sheets formula to find previous day high of a share price

Need previous day high/low price of a share. This formula gives answer =googlefinance("nse:"&columno.,"high",today()-2.1) This gives an answer with date and time in separate columns. But I need ...
0
votes
1answer
455 views

How to get 15 mins high low data from Google Finance?

I would like to retrieve 15 mins High Low data from Google Finance to Google Sheets. But unable to get any formula. Please guide me.
0
votes
1answer
43 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: ...
0
votes
1answer
505 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'...
0
votes
1answer
841 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, "...
-1
votes
1answer
92 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. ...