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

344 questions
120
votes
13 answers

How can I get stock quotes using Google Finance API?

I'm looking for access to financial data from Google services. I found this URL that gets the stock data for Microsoft. What are all the possible parameters that Google allows for this kind of HTTP request? I'd like to see all the different…
Josema
  • 4,248
  • 6
  • 20
  • 15
47
votes
6 answers

Download history stock prices automatically from yahoo finance in python

Is there a way to automatically download historical prices of stocks from yahoo finance or google finance (csv format)? Preferably in Python.
Bob
  • 9,535
  • 20
  • 81
  • 129
46
votes
4 answers

Download all stock symbol list of a market

I need to download in some way a list of all stock symbol of specified market. I've found in this link ho can I do it someway. It uses following link in order to retrieve stock list that statisfies some…
Jepessen
  • 9,377
  • 11
  • 64
  • 111
34
votes
2 answers

How to get the price of a stock at a particular date from Google Finance?

I want to get the price of a particular stock at a particular date in Google Sheets using the Google Finance forumula. I tried this formula: =GOOGLEFINANCE("GOOG","price",12/13/2013) But it didn't work. How can this be done?
user781486
  • 20,909
  • 45
  • 145
  • 253
32
votes
1 answer

Alternatives to the Yahoo Finance API?

Yahoo finance recently discontinued their API. I have been looking for alternatives. The ones I've found so far are Google Finance and Quandl. Google Finance was deprecated in 2011 but still appears to work somewhat. However, there is little to no…
Alex F
  • 1,633
  • 3
  • 22
  • 46
28
votes
8 answers

How to use GOOGLEFINANCE(("CURRENCY:EURAUD")) function

This function: GOOGLEFINANCE(("CURRENCY:EURAUD")) works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest I've got was this…
Ayyash
  • 3,769
  • 6
  • 34
  • 57
25
votes
5 answers

How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refresh itself every 1 minute? Thank you for your help.
user781486
  • 20,909
  • 45
  • 145
  • 253
18
votes
7 answers

fetch stock quotes from google finance, yahoo finance or the exchange itself

I am building a web based trading system where buy and sell signals would be generated by reading quotes from either Yahoo finance, google finance or the exchange(NSE of India) itself.My first preference would be to fetch data from this url: …
Amit Kumar Jha
  • 589
  • 2
  • 7
  • 18
17
votes
8 answers

How to create a stock quote fetching app in python

I'm quite new to programming in Python. I want to make an application which will fetch stock prices from google finance. One example is CSCO (Cisco Sytems). I would then use that data to warn the user when the stock reaches a certain value. It…
Alex
  • 1,649
  • 3
  • 13
  • 9
14
votes
6 answers

Get exchange rate on a specific date from GoogleFinance

I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR. Here is my formulae: =Finance!B4*GOOGLEFINANCE("CURRENCY:GBPEUR","price",date(2017,15,11)) Here is…
cala
  • 627
  • 2
  • 8
  • 24
14
votes
2 answers

way to access user's Google Finance portfolio?

I noticed that Google removed the Finance API for Google App Engine. All I want is a list of stock tickers that they have in their Google Finance portfolio. Is there any way to still pull this data from the end user's portfolio, given that the API…
gnychis
  • 6,335
  • 15
  • 69
  • 104
13
votes
2 answers

GoogleFinance often returns #N/A and internal error messages while getting stock quotes

Anyone know workarounds to make GoogleFinance actually work? It works for a while so it is not a problem with my formulas but then periodically the cells that were showing stock quotes suddenly show "#N/A" and if you hover over them it shows that…
stackonfire
  • 1,119
  • 3
  • 11
  • 21
12
votes
6 answers

Programmatic access to detailed historical financial data

I know that Yahoo has a great API for accessing detailed financial metrics about a company documented at http://www.gummy-stuff.org/Yahoo-data.htm. Yahoo also provides historical pricing data, documented at…
Joshua Hartman
  • 1,196
  • 1
  • 10
  • 18
12
votes
12 answers

Recommendations for a google finance-like interactive chart control

I need some sort of interactive chart control for my .NET-based web app. I have some wide XY charts, and the user should be able to interactively scroll and zoom into a specific window on the x axis. Something that acts similar to the google…
Chris Farmer
  • 23,314
  • 32
  • 110
  • 161
11
votes
4 answers

Google Finance Currency Converter

I am working on google currency converter and it's working fine for all currencies but not showing results of ZAR - BTC conversion. Google currency converter code :
Coffee
  • 470
  • 3
  • 17
1
2 3
…
22 23