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
4
votes
4 answers

page scraping to get prices from google finance

I am trying to get stock prices by scraping google finance pages, I am doing this in python, using urllib package and then using regex to get price data. When I leave my python script running, it works initially for some time (few minutes) and then…
user424060
  • 1,545
  • 3
  • 20
  • 29
4
votes
2 answers

Data Studio don't see Google Sheets formula results

I have a problem with Google Data Studio. I'm adding my sheet as a data source and. There's one column in this sheet based on this formula: =iferror(D2*index(query(GOOGLEFINANCE(CONCATENATE("CURRENCY:",C2,"PLN"),"price",B2-1, B2,"daily"),"select…
Filip Kapusta
  • 155
  • 1
  • 7
4
votes
2 answers

In google sheets, how do you use googlefinance to get the high price of a stock in a date range?

I wrote the following formula, and it only returns the high of the starting date and not the high of the entire date range: =INDEX(GoogleFinance(C7,"high", A7,B7,"DAILY"),2,2) where C7 is the google sheet cell that contains the stock symbol and A7…
Jeff Chen
  • 41
  • 1
  • 1
  • 2
4
votes
3 answers

Date parameters for Google Finance API not working

I am trying to pull over end-of-day share prices going back in time. The code below provides exactly what I need but it appears that that the year/month/day parameters do not work. import requests params={'q': 'NASDAQ:AAPL', 'expd': 10, 'expm': 3,…
GivenX
  • 495
  • 1
  • 8
  • 17
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…
Utkarsh Pandey
  • 51
  • 1
  • 3
4
votes
3 answers

Fixed income data online

I am looking for a resource to download fixed income data online, much like there is access to stock data from yahoo. At the very least I'd like the treasury bonds. I use python, but any help would be appreciated.
John Smith
  • 12,491
  • 18
  • 65
  • 111
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";…
Wen Hsiao
  • 631
  • 1
  • 7
  • 16
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
1 answer

Make Iferror and Googlefinance print "blank" cell if no value

Is there a way to make this formula print empty cells based on the "F" column having no value? I'm currently getting the cell to return "0" but I want it to be blank as I'm trying to combine this manual input with a supermetric query. The purpose is…
Filip
  • 33
  • 3
3
votes
2 answers

GoogleFinance: Get History By Month

I use GoogleFinance quite a bit, but from the documentation it seems the only formats to get historical data is by Day or Week. Is there any way to get the data by Month? I guess I could add an extra column, and find the end of each month date to…
maxhugen
  • 1,870
  • 4
  • 22
  • 44
3
votes
2 answers

=GOOGLEFINANCE("AAPL";"eps";TODAY(); today()-60)

I've found nice function =GOOGLEFINANCE("AAPL";"price";TODAY(); today()-60) that gives stock prices for defined date range - it works fine. I was trying to use it to get EPS or PE data. Is that possible to get EPS historical data using…
Krzysztof Gąsiorek
  • 39
  • 1
  • 2
3
votes
2 answers

Possible JavaScript memory leak when handling arrays?

I'm using Humble Finance to plot a series of data one point at a time to achieve a time-lapse effect. My code is below, but I'd like to explain it first: If you're not familiar with HF, its initialization function takes three JavaScript arrays…
user428517
  • 4,132
  • 1
  • 22
  • 39
3
votes
1 answer

Google Finance, how to get the JSON data streamed?

I tried to explain this earlier, but obviously failed! So, if you have a google finance graph open, for instance: http://www.google.com/finance?q=INDEXNASDAQ:.IXIC I would like to somehow use the (HttpWebRequest) object in C# so that I can grab the…
Jean
  • 721
  • 3
  • 9
  • 14
3
votes
1 answer

How to get Consumer Price Index(CPI) in Google Sheets?

Need to get Australia Consumer Price Index(CPI) and update all the prices in my sheet every quarter based on it. Tried to do that using GoogleFinance. Found that its possible to use exchange like ASX for that and indexes from the list. But CPI…
adelak
  • 647
  • 4
  • 11
  • 25
3
votes
3 answers

Getting stock news data from google in R

I can use quantmod to get historical data and close-to-realtime quotes for stocks. I can also use quantmod to get financials data from Google. Are there any existing R packages that would let me grab Google's news feed for a given stock? If not, is…
Zach
  • 29,791
  • 35
  • 142
  • 201
1 2 3
…
27 28