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

Get daily stock data from google or some other sites

Is there any sites to get the NASDAQ and NYSE stock price data by day? I could find the historical prices by stock from google finance (csv) https://www.google.com/finance/historical?q=NASDAQ:GOOG However I want to get prices by day not by…
whitebear
  • 11,200
  • 24
  • 114
  • 237
1
vote
1 answer

crawl realtime google finance price

I want to create a small excel sheet which sort of like Bloomberg's launchpad for me to monitor live stock market price. So far, out of all the available free data source, I only found Google finance provides real time price for a list of exchanges…
Rookie
  • 161
  • 1
  • 3
  • 11
1
vote
1 answer

Python pandas-datareader fails on comma

I am trying to get a price of a stock from google by using pandas-datareader.data but when I try to call Amazon(amazons price right now is over 1,000) it gives me a value error. I assume it is because of the comma in the price. It automatically…
Bruno
  • 487
  • 2
  • 8
  • 17
1
vote
0 answers

Unable to read S&P500 using pandas_datareader on Google Finance

Goal: I'm trying to read historical data from Google Finance for the S&P500 using pandas_datareader. Issue I'm using the symbol on google finance but I keep getting the same error "unable to read url". I pretty sure I'm putting in the wrong…
Brent
  • 196
  • 7
1
vote
1 answer

Python - Pulling Indices data from Google Finance

I am trying to pull Historical data of Indices from Google Finance, but it's not working. While I am able to pull historical data of an individual stock easily. Am I doing something wrong with Indices? My code for Stock from pandas_datareader import…
vicky113
  • 351
  • 1
  • 6
  • 19
1
vote
3 answers

Python Google Finance historical data foreign stock Codes eg ASX

The code below works for the American stocks APLE and BHP however when I replace them with the ASX codes it crashes. I though it was due to the colon and have placed str(ASX:BHP) with out success. Unfortunately Yahoo is no longer supplying…
user1870243
  • 31
  • 3
1
vote
2 answers

What's the exchange suffix for German and Australian stocks for GoogleFinance API?

What's the exchange suffix for German and Australian stocks for GoogleFinance API? For London stocks, it's .L (e.g. VOD.L). Just wonder what's the suffix for Germany and Aussie? I tried something like .DE for German but it didn't work..(that's the…
Calvin Lau
  • 11
  • 1
  • 2
1
vote
1 answer

Matlab - Convert char to cell

I have this output from urlread function: // [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "148.59" ,"l_fix" : "148.59" ,"l_cur" : "148.59" ,"s": "0" ,"ltt":"1:13PM EDT" ,"lt" : "May 5, 1:13PM EDT" ,"lt_dts" : "2017-05-05T13:13:23Z" ,"c" :…
user27103
  • 13
  • 2
1
vote
0 answers

Get Stock quote using GoogleFinance for date and time

I know that we can get stock quote from google finance and there are various attributes and period variables but I couldn't find any syntax to fetch stock prices for a past date and time. for example if I want to understand variance or pattern of a…
Ankit Agarwal
  • 111
  • 1
  • 1
  • 4
1
vote
3 answers

google finance pandas read table to pandas dataframe

How to convert that html table to pandas dataframe? https://www.google.com/finance/getprices?q=HINDALCO&i=60&p=15d&f=d,o,h,l,c,v Example data:
Lakhan Pahuja
  • 47
  • 8
1
vote
4 answers

Search for specific class using bs4

I am trying to scrape this google finance link. This page has a class with SP_arrow_last_off class. So, if I do something like this: url =…
Ni3_k
  • 56
  • 12
1
vote
1 answer

googlefinance python3 error

Hi guys I'm using python3 and install googlefinace module(https://pypi.python.org/pypi/googlefinance) and the example says it's works >>> from googlefinance import getQuotes >>> import json >>> print json.dumps(getQuotes('AAPL'), indent=2) but I…
pathfineder
  • 23
  • 4
1
vote
0 answers

Finance google infoquote all explained?

I am fiddling around with google finance API and do not understand all keys in the reply. Can anyone comment them for me? I googled around, picked up here and there and guessed around afterwards. See below: I was not able to post JSON in a human…
derdigge
  • 21
  • 5
1
vote
1 answer

error using R's htmltab: Error in `*tmp*`[[index]] : subscript out of bounds

Trying to download INX from Google Finance using x <- htmltab(doc = "https://www.google.com/finance/historical?q=INDEXSP%3A.INX&ei=Qu-TWOn-AtW1mQGQ06WYCQ") and it gives this error: Error in `*tmp*`[[index]] : subscript out of bounds
Paul Holdsworth
  • 13
  • 3
1
vote
1 answer

Getting industry from Yahoo.Finance for list of stock ticker

How can I (preferably using R) get the industry classification for a list of stock tickers from Yahoo.Finance, Google Finance or anything else. To illustrate, I have a list of tickers, such as ticker_industy <-…
Stefan Voigt
  • 209
  • 2
  • 5
  • 18
1 2 3
…
27 28