Questions tagged [google-finance-api]

API used to query information about portfolios stored in Google Finance. Note this API was deprecated in May 2011 and will be permanently shut down on October 20, 2012.

API used to query information about portfolios stored in Google Finance.

Note this API was deprecated in May 2011 and will be permanently shut down on October 20, 2012.

https://developers.google.com/finance/

92 questions
6
votes
0 answers

geting an empty dataframe after using the example code on googlefinance.client

I am trying to run the sample code from the googlefinance.client 1.3.0 documentation after I install the package using pip install googlefinance.client from googlefinance.client import get_price_data, get_prices_data, get_prices_time_data # Dow…
Pumpkin C
  • 1,452
  • 6
  • 21
  • 27
6
votes
4 answers

get minute bar historical data from Google finance?

I can get daily data easily using this link: https://www.google.com/finance/getprices?q=LHA&x=ETR&i=60&p=1d&f=d,c,h,l,o,v But when I try to change "1d" to "1y" I still get 1 day's data. I am trying to get 2 years' worth. Is there a way to do this?…
ManInMoon
  • 6,795
  • 15
  • 70
  • 133
4
votes
3 answers

How to get peak price of a stock after a particular date in Google Spreadsheet?

I'm trying to create an automated Google Spreadsheet to track my positions. There's a column which needs to display peak price of a stock after I have added it in my portfolio. Say I added a stock on 3rd November, I need to know what's the highest…
4
votes
0 answers

Google Finance API Still works?

I still can obtain some data from finance google API using links like: http://finance.google.com/finance/info?client=ig&q=NASDAQ:GOOG Is that fine? Or it's will be closed soon? But here is https://developers.google.com/finance/?csw=1 Google says:…
4
votes
3 answers

Price data from yahoo finance (or google finance) that is more precise than one point per day

Is it possible to retrieve historical price data from yahoo (or google) finance using pandas.io.data.yahoo in python with hour or 10 minutes resolution instead of 1 point per day? If it is not possible, is it limitation of pandas module or yahoo…
user1569115
4
votes
2 answers

How to get Taiwan Stock Exchange Index in google spreadsheet

How to get Taiwan Stock Exchange Index in google spreadsheet? This index do exist in google finance under https://www.google.com/finance?q=TPE%3ATAIEX I tried the following formula, but all of them are failed. =GoogleFinance("TPE:TAIEX";…
3
votes
1 answer

How to get X-year low price of a stock with Google Finance using Google Sheets

I can currently get the 52-week low of a stock by using this call in Google Sheets. =GOOGLEFINANCE("NYSE:UBER","low52") How do I get the 3-year and 5-year low of a stock? For a 3-year low I tried something like…
steve238
  • 831
  • 1
  • 10
  • 19
3
votes
3 answers

java.lang.ClassNotFoundException

I have a java project that I'm working on which was working until a few days ago. I'm not sure what I did to my Eclipse set-up to hose it but now I'm getting a java.lang.ClassNotFoundException when I try to run some code that accesses the google…
user341493
  • 414
  • 1
  • 7
  • 15
3
votes
1 answer

Not able to find an API for getting BSE stock quote for my Android app

I searched 2days in google but still i am not able to get a proper API which i can use to get data. I found one API https://finance.google.com/finance/info?client=w&q=BSE:YESBANK which i am getting resonse data, but the data is not correct. am i…
kumar
  • 708
  • 4
  • 15
  • 39
3
votes
1 answer

create nodeJS mongoDB web app using live streaming from Yahoo Finance API

considering to build a hands-free web app for myself that uses nodeJS, express and mongoose with historical and live (dont mind if its 20min delay) from Yahoo Finance API. Naturally i preferred Google Finance, but it was deprecated circa Oct 2012.…
2
votes
1 answer

Is YQL not reliably returning the correct data - Any replacements?

I'm writing an application that chooses companies based upon market cap and dividend yield. It uses Yahoo!'s YQL REST API to get this data. It seemed to work well yesterday, but today I saw that my program says that one of the companies had a…
firebush
  • 5,180
  • 4
  • 34
  • 45
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…
2
votes
1 answer

Does microsoft excel 2016 has function "=googleFinance()" which is available in google sheets?

I want to get the live market price(Indian Market) of some stocks which are already mentioned in my MSExcel sheet, which can automatically update. I saw a function in google sheet (=googleFinance()) that does the same thing. But this function is not…
2
votes
4 answers

How to get Historical Financial Data for Data Analysis in Python?

I need to get Stock data using pandas DataReader for the following banks: Bank of America CitiGroup Goldman Sachs JPMorgan Chase Morgan Stanley Wells Fargo How to get the stock data from Jan 1st 2006 to Jan 1st 2016 for each…
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