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
2
votes
2 answers

Trying to get Cryptocurrencies Price Data in Google Sheets with no common coins such us SNX

I have a google sheet in which I am some Cryptocurrencies Price Data that I get using googleFinance or yahoo. However, I found it difficult to do this with some coins such as Synthetix Network Token. I have been reading other questions in…
Manolo Dominguez Becerra
  • 1,205
  • 11
  • 21
2
votes
3 answers

Find sector by share symbol in google sheets

Is there a way to print out the GICS sector name for a specific share/ETF symbol in google sheets using the GOOGLEFINANCE commands or any other way? Many thanks
mindbomb
  • 1,642
  • 4
  • 20
  • 35
2
votes
2 answers

How to get Historical Price from a specific time?

Does anyone know if it is possible to get the price of a stock using =googlefinance from a time stamp? Dates are fairly easy but it does not seem possible to do times on days? for example if I wanted to look at GOOG for 10:00AM…
B33T
  • 21
  • 1
  • 2
2
votes
1 answer

Google Sheet: how to align two timeseries

Using Google Finance in Google Sheet, I get two timeseries: A) =GOOGLEFINANCE("SPY", "close", DATE(2015,1,1), TODAY(), "DAILY") that has 1483 values B) =GOOGLEFINANCE("IBTM", "close", DATE(2015,1,1), TODAY(), "DAILY") that has 1489 values For…
SubZeno
  • 341
  • 3
  • 15
2
votes
1 answer

Googlefinance - return high price AND date

I'm using GOOGLEFINANCE formula to retrieve highest values and relative date for a stock from a given period. For example: =GOOGLEFINANCE(AAPL,"HIGH",08/5/2020,08/11/2020) return the following results: Date, High 8/5/2020 16:00:00, 441.57 8/6/2020…
Terataz
  • 185
  • 2
  • 2
  • 8
2
votes
5 answers

GoogleFinance function to calculate Exponential moving average in google sheets

I am using google sheets and GoogleFinance functions to get stock data. I am able to calculate a simple moving average with the below formula. I am trying to get an Exponential moving average for lengths 8,13,21,55 for each stock. Any suggestion on…
Kurkula
  • 6,386
  • 27
  • 127
  • 202
2
votes
1 answer

Google Sheets Array Function over Google Finance Currencies

I'm looking to assign an array over currency conversion rates from the google finance function. I copied this formula above and adapted it to my spreadsheet, but I keep getting the following error message: "Error: Did not find value '4/8/2020' in…
Galeano
  • 21
  • 1
2
votes
1 answer

GOOGLEFINANCE - How to get Amsterdam data?

I want to get market data for the shares listed in Euronext Amsterdam (for example 'Royal Dutch Shell plc (RDSB.AS)'). Google's Finance Data Listing says that for the Euronext Amsterdam the symbol 'AMS' needs to be used as a prefix for a…
Tauno
  • 187
  • 2
  • 10
2
votes
1 answer

Custom aggregation of Finance data in Google sheets

I am currently working on a calculation to identify data trend on stock prices and is currently using google finance libraries for the same. I would like to compute the following information in an automated way. Percent of days with positive…
pknpkn21
  • 23
  • 3
2
votes
2 answers

How to use TODAY() function with GOOGLEFINANCE() function in GoogleSheets

I am trying to create a sheet with stock data from the current day and yesterday. Neither this: =GOOGLEFINANCE(B2;"price";TODAY()) Nor this: =GOOGLEFINANCE(B2;"price";DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()))) works. But this…
Jonas Kaufmann-Ludwig
  • 31
  • 1
  • 4
2
votes
3 answers

Why does Google Finance display the wrong price for IOC (Indian Oil Corporation) in Google Sheets?

I am using Google Sheets for fetching EOD prices of Indian stocks, using the function =GOOGLEFINANCE("IOC","price") Google is returning 19.51 but the closing price for IOC on 11-11-2019 is INR 135.40.
Pawan Kumar Pandey
  • 29
  • 1
  • 2
2
votes
1 answer

How to get current weekly closing price of stock in google sheet?

How can I fetch current weekly closing price of a stock in google sheet? I have tried using the formula GOOGLEFINANCE("GOOG", "price", TODAY(), TODAY(), "WEEKLY"). But its showing no results.
Ameerudheen.K
  • 657
  • 1
  • 11
  • 31
2
votes
3 answers

Download stock and option data using python

I need to download historical "stock data" and current "option price data" for a ticker. Can someone please point me to right package. I tried yahoo-finance package, but it is not working. Can someone please post a code snippet to download the…
Raghava kattamudi
  • 67
  • 1
  • 1
  • 7
2
votes
2 answers

Getting historical Stock prices in Google Apps Script

So to my huge surprise, it seems impossible to get historical stock prices inside a Google Apps Script (for populating a google sheet) in any way. For some nice reason the scripts do not allow to call GoogleFinance and the FinanceApp does not exist…
Alex Botev
  • 1,369
  • 2
  • 19
  • 34
2
votes
0 answers

Get the last update time for Google Finance for currency

I am using google sheets and getting currency with this code: =GOOGLEFINANCE("CURRENCY:USDTRY") it looks perfect and working but result sometimes return me old value of currency. to be sure, I want to get last update date and hour for given…
mehmet
  • 1,558
  • 5
  • 30
  • 41
1 2 3
…
27 28