Stack Overflow
Stack Overflow

Questions tagged [google-finance]

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. Use with tags(eg: [google-sheets-formula]), where the service is involved.

Google Finance is a service used to track stock and portfolio information. Originally had a public API, but the API was shutdown. However the service is still running. Limited programmatic access is also available through

Official Website

417 questions
1
vote
1 answer

Google Sheets IFS statement for currency conversion based from same document cell queries

UPDATE #2 So after some searching, I've found a statement to convert the other currencies (COP & USD) to CAD based on the historical DATE value using the following: =H85*average(index(GOOGLEFINANCE(CONCATENATE("CURRENCY:" & G85 & "CAD"), "price",…
Ty Snaden
  • 13
  • 3
1
vote
1 answer

How to use Google Finance to fetch stock data when the column contains stock ticker?

The B3 cell contains the stock ticker symbol say TCS. When i try to execute =GOOGLEFINANCE("NSE:B3","PRICE") The formula is giving error "When evaluating GOOGLEFINANCE, the query for the symbol: 'B3' returned no data." I want TCS to be used instead…
Avinash K
  • 43
  • 5
1
vote
0 answers

Ticker finder on Google sheets

How to find ticker from stock name on Google finance. You can do the opposite by typing =GOOGLEFINANCE(ticker,"name") but the problem is you can find the company name faster than the ticker
Murtaza Mahuvawala
  • 11
  • 2
1
vote
1 answer

Trying to reference a cell in importxml

My B3 is CULP. It's a stock ticker symbol. This import XML is supposed to get the annual dividend yield number which is 5.76%, but I'm getting an error instead which states "imported content is empty" Getting the annual dividend yield works when I…
user17737438
1
vote
1 answer

Google Finance Function in Google Sheets is excluding todays price when looking back over a series of days?

I have here a picture of What I have. I want the previous 5 days closing prices in a column including todays price. The problem is that I only get 4 date prices (cell range F6:F9) excluding todays date price (cell F3). I understand that the date is…
Jimtim59
  • 13
  • 3
1
vote
2 answers

Is there a method for retrieving stock price data for the most recent open market day with google finance?

I am using google sheets, and would like to know the most recent stock pricing available for the date calculated. Currently i am using this, =GOOGLEFINANCE("NASDAQ:TSLA", "close",EOMONTH(today(),-1)) If the date it returned is not an open market…
JordanLeo
  • 25
  • 5
1
vote
1 answer

How to Find Date of a stock's ATH in Google Sheets

I have been trying to come up with the formula to give in 2 neighboring cells: 1.) the ALT of the stock and 2.) next the first cell, the date of the ATH value. The example is the following: table structure snapshot I managed to address 1.) with the…
Homelander123123
  • 11
  • 1
1
vote
2 answers

How to find the average price between two specific dates in the past in Google Sheets Finance

I'm trying to write a formula to give the average price of a stock between two specific dates in the past in Google Sheets Finance, say between October 3rd, 2013 and November 12th, 2013. If anyone can help, it would be much appreciated. Thanks, Nick
Nick
  • 29
  • 1
  • 4
1
vote
1 answer

To retrieve price for CVE-WT by GOOGLEFINANCE

The price of CVE on TSX can be retrived by =GOOGLEFINANCE("TSE:CVE", "price") in Google Sheets. How does one get the price of CVE-WT using GOOGLEFINANCE?
sofname
  • 429
  • 1
  • 5
  • 20
1
vote
1 answer

How to calculate monthly std deviation of daily returns in google sheets using google finance api

how to calculate monlthy std diviatoin of daily returns in google sheets using google finance api? I think we need to use QUERY()but I am not sure how to form single data set in QUERY() by calling googlefinance() two times So far : My stock symbols…
prashantkumar dhotre
  • 31
  • 2
1
vote
1 answer

How to append today's price in historical GoogleFinance prices to generate SPARKLINE?

I am trying to make SPARKLINE in Google Sheet with this formula: =SPARKLINE(INDEX(GOOGLEFINANCE("AAPL", "close", WORKDAY(TODAY(), -100), TODAY()), , 2)) It shows a perfect line chart, but it fetches data till yesterday's date. I want today's live…
Vilashkumar Daate
  • 73
  • 4
1
vote
2 answers

Google Finance doesn't recognise my date field and is returning an error message

I'm having an issue with the following formula in google sheets: =IFS(F2<> "EUR", E2*GOOGLEFINANCE("Currency:"&F2&$G$1,"price", H2), F2 = "EUR", E2) H2 is a cell which holds a date. I am trying to get a formula I can use for multiple different…
Chiara
  • 63
  • 6
1
vote
1 answer

How to calculate currency conversion for ZARCAD for a specific date with GOOGLEFINANCE?

I have a Google sheet that I use multiple currencies in. I purchase a product on a specific date and I want to lock in the conversion for that date. However, I have not been able to do that with all the different formulas that I have tried. I keep…
Rolanda Dueck
  • 23
  • 4
1
vote
1 answer

How to write array to sheets column and add custom formula to column next to it using google apps script?

Here's the problem: Get a list of tickers from a column in a sheet (LIST OF STOCKS) Push it, so as each ticker appears in the array 105 times Write the resulting array to another sheet's column (TickersData) Next to the first ticker each element…
onit
  • 2,275
  • 11
  • 25
1
vote
1 answer

What is the symbol for blockchain eos in googlefinance in EUR and GBP

My google sheet returns Na when I write =GOOGLEFINANCE("EOSEUR") # or =GOOGLEFINANCE("EOSGBP") However, when I introduce =GOOGLEFINANCE("BTCEUR") # or =GOOGLEFINANCE("EOS") I got the right output. Where can I find a list of symbols for…
user14618562
1 2 3
…
27 28