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
3
votes
1 answer

How to pivot googlefinance() horizontally?

In Google Sheets, is there a way to pivot the output of googlefinance() horizontally? Currently, it outputs prices/dates vertically.
4thSpace
  • 43,672
  • 97
  • 296
  • 475
3
votes
2 answers

How come pandas_datareader for google doesn't work?

I tried to grab data from google finance by the following code: import pandas_datareader.data as wb import datetime as dt start = dt.datetime(2015, 1, 1) end = dt.datetime(2017, 1, 1) dt = wb.DataReader('FB', 'google', start, end) dt.head() and I…
saga
  • 736
  • 2
  • 8
  • 20
3
votes
3 answers

issues downloading stock data from google finance using panda datareader

Things used to work great until several days ago. Now when I run the following: from pandas_datareader import data symbol = 'AMZN' data_source='google' start_date = '2010-01-01' end_date = '2016-01-01' df = data.DataReader(symbol, data_source,…
Michael
  • 33
  • 1
  • 1
  • 4
3
votes
3 answers

DataReader google finance date not working

I was just using pandas datareader to get the stock data for the past two weeks or so and it was working fine. All of a sudden since yesterday the date provided wasnt working anymore. It just gives me the past year data and I cant change the date.…
user1179317
  • 2,693
  • 3
  • 34
  • 62
3
votes
2 answers

Google API changed for data from google finance

I have a software that extracts intraday data from google finance. However, as API was updated by Google yesterday so the software giving error Conversion from string HTML HEAD meta http-equiv="con" to type 'Double' is not valid. I have one…
Rishi 007
  • 33
  • 1
  • 4
3
votes
3 answers

How to fix mpl_finance package for MatPlotLib?

Getting this error message: MatplotlibDeprecationWarning: The finance module has been deprecated in mpl 2.0 and will be removed in mpl 2.2. Please use the module mpl_finance instead. How do I put in place the mpl_finance package instead. I have it…
sgerbhctim
  • 3,420
  • 7
  • 38
  • 60
3
votes
3 answers

nodejs talib MACD

I am using talib technical analysis library to calculate MACD. I used AAPL data to calculate MACD(8, 17, 9) but the talib values are completely different from Google and Yahoo finance.Here is my javascript (I copied last AAPL close data since…
Stefano Piovesan
  • 1,185
  • 3
  • 19
  • 37
3
votes
3 answers

Getting Tokyo stock price data to appear on Google spreadsheet

I have no problem retrieving price data of US stocks. For example, to retrieve Apple price data, this formula =GOOGLEFINANCE("AAPL","changepct")/100 works fine. When I tried to retrieve Tokyo stocks price data, this formula…
guagay_wk
  • 26,337
  • 54
  • 186
  • 295
3
votes
3 answers

Stop rounding when importing Google finance currency

I am importing currency from Google finance to Google spreadsheets (latest version). The number that is imported is rounded both in terms of what is displayed and the underlying number. Is there a way to get the actual underlying currency number to…
Flyer
  • 31
  • 3
2
votes
2 answers

Get Google or Yahoo API live option price

Is there a way to get the live options information from Yahoo or Google's API. By options information I mean: call, ask volume. I basically need the information on this page thanks for your help!
Nick
  • 605
  • 3
  • 11
  • 27
2
votes
1 answer

ARRAYFORMULA with GOOGLEFINANCE function

I want to create a simple function that returns company name for every line that is filled with the Symbol via GoogleFinance function, however, I am not able to make the script work for every line. Here is the…
vohratom
  • 422
  • 7
  • 16
2
votes
1 answer

google finance function in google sheets to get all time high price?

Is it possible to get the all time high for a ticker using google finance function in google sheets? Can't find it in https://blog.sheetgo.com/google-sheets-formulas/googlefinance-formula-google-sheets/, but I do see 52 week high
user3226932
  • 2,042
  • 6
  • 39
  • 76
2
votes
2 answers

Google Sheets: List of Cryptocurrencies Available for GoogleFinance Funtion?

As well as Stocks, my portfolio in Sheets also contains Cryptocurrencies. Is there an updated list of cryptos supported using the GoogleFinance() function anywhere, or do I need to resort to trial and error?
maxhugen
  • 1,870
  • 4
  • 22
  • 44
2
votes
0 answers

How to save the cell values returned by GoogleFinance( ) API in Google sheets

I am trying to download 1 year price data for all NSE stocks in google sheets using Google Finance API. I just want the API to run only once (not on each sheet load)and populate the data. I want to save the data. I tried to copy paste the data into…
prashantkumar dhotre
  • 31
  • 2
2
votes
2 answers

Is Google spreadsheets =ImportHtml() done locally or on a Google server?

Immediate problem: =ImportHtml("http://127.0.0.1/~themis/transactions.html";"table";1) is placed into a cell. The page exists; I can open it in Chrome. My guess is that it's done remotely as the error is "the data could not be retrieved". My…
themis
  • 1,047
  • 11
  • 16
1 2 3
…
27 28