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
0 answers

google finance getprices URL works via browser but not working since 03 august 2018

google finance getprices URL works via browser but not working since 03 august 2018 any solution why I have checked programatically also in PHP array( "verify_peer"=>false, …
Atul
  • 51
  • 1
  • 3
2
votes
0 answers

Got blocked by Google Finance

I was trying to write come code for stock market predictions and everything was working fine until it suddenly stopped working and threw an error: ----> 1 get_price_data({'q': 'GOOG', 'i': 86400, 'x': 'NASDAQ', 'p':…
Raksha
  • 1,572
  • 2
  • 28
  • 53
2
votes
3 answers

Google Sheets - googlefinance not working

I have one google sheet using googlefinance function on multiple stocks. It was working fine until this morning. Now, googlefinace is not giving output for all stocks and giving output for only some of the stocks. Please share, if is anyone else…
Syed Mohammed Mehdi
  • 183
  • 2
  • 5
  • 15
2
votes
1 answer

Error in Google finance API

I want to convert currencies using google finance api. But its not working in my local machine(India). It works fine when I hit from one server located in USA and provides proper result. Url :…
maulik sakhare
  • 1,957
  • 1
  • 12
  • 19
2
votes
0 answers

How to get TSX stock prices from Morningstar using Pandas Datareader (small-cap stock)?

Since using Google/Yahoo finance gives errors, I'm using Morningstar to get stock data in a dataframe. It works well with common NYSE/NASDAQ stock but is there a prefix/suffix to specify a stock is from the TSX (or other exchange)? import…
Five9
  • 147
  • 6
2
votes
2 answers

Is there easy way to retrieve Google Finance data?

Once in a day we want to download google finance data for 6100+ stock symbols. Right now we are going to this url and getting the data for all stock symbols. http://www.google.com/finance?q=NYSE:AA&fstype=ii Getting the data like this use lots of…
Suresh
  • 21
  • 1
  • 2
2
votes
1 answer

How to fetch data from Google Finance API post 6th September 2017 for multiple stocks

Post 6th September I am working on a project where I want to display live prices from Google Finance API for multiple stock with information like change change in % volume Timestamp of data and few ratios like ROI/E, ROA, Net-profit-margin -- This…
Shreyansh Lodha
  • 83
  • 2
  • 10
2
votes
0 answers

Downloading currency data from Google Finance with DataReader

i am trying to download EUR/USD historical data from Google Finance with DateReader but i got error and i can't deal with it. My code: imported_data = data.DataReader('CURRENCY:EUR', 'google') It works for 'NASDAQ:AAPL', 'NYSEARCA:GLD' and any…
overb
  • 127
  • 2
  • 10
2
votes
2 answers

GoogleFinance - Remove USD Symbol

Using google spreadsheets to display currency data, with USD as primary field for formula: =LEFT(V10*GoogleFinance("currency:USDEUR"),5) I cannot figure out how to remove the the USD Symbol ($) from not show up for the additional currencies. It…
Abela
  • 1,225
  • 3
  • 19
  • 42
2
votes
1 answer

What are meaning of these short words?. (return value from google finance)

The return data from http://www.google.com/finance/info?q=NASDAQ%3aGOOG is { "id": "304466804484872" , "t" : "GOOG" , "e" : "NASDAQ" , "l" : "525.02" , "l_fix" : "525.02" , "l_cur" : "525.02" , "s": "2" , "ltt":"4:47PM EDT" , "lt" : "Jul 7, 4:47PM…
graz
  • 49
  • 1
  • 6
2
votes
2 answers

Using Google Finance Package in Python

I am very new to Python. I have just recently installed the Google Finance Python package via PIP. But as soon as i try to run import googlefinance I get an error message :- No module named googlefinance . Can someone please help me? I am not…
vicky113
  • 351
  • 1
  • 6
  • 19
2
votes
1 answer

Quantmod, empty dates in getSymbols from Google

Quantmod version 0.4.0 Function getSymbols returns empty dates when using Google as source, not using Yahoo. Google data seems fine, checking…
chrisdc
  • 33
  • 5
2
votes
1 answer

Guide to using google URL to get options chain data?

I'd like to enter a URL into google and get all options chain data for a particular stock. Is there a guide that shows you how to use it, like if I wanted to grab all options that expire in the next year without knowing the individual expiration…
user1106278
  • 747
  • 1
  • 9
  • 18
1
vote
1 answer

Caching and updating OHLC historical stock quotes locally

OK, I don't mean for this to be another "how do I get historical stock data" question. I've already found plenty of readily available sources for that, even neatly exported into direct CSV downloads from the likes of Google Finance and Yahoo and…
Marcos
  • 4,796
  • 5
  • 40
  • 64
1
vote
2 answers

How can I get NSE stocks only opening and closing price in Google sheet from Google finance?

I tried using this formula for cells to enter the opening and closing price for mentioned stocks in google sheets. =INDEX(GOOGLEFINANCE(B2, "open", A2), 2, 2) Column B has stock symbols mentioned. but it is always showing Error When evaluating…
ni9khil
  • 1
  • 5
1 2 3
…
27 28