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
votes
1 answer

Issue regarding getting dividend yield in google sheets from google finance

I am having an issue with getting dividend yield from google finance in google sheets. I am using this formula =GOOGLEFINANCE("MSFT","yieldpct") ,but this returns a error "Formula parse error" Am I missing something here ? Is there a need for…
Adrian Totolici
  • 13
  • 7
-1
votes
1 answer

Googlesheet formulas for Crypto Coins

I am trying to create a google sheet showing various crypto prices for a few set times (but lets just use BTC-USD for the moment). The sheet would show BTCUSD Current Price, Previous Close, Close 5 days ago and Close 31 days ago I have…
user2126062
  • 111
  • 11
-1
votes
1 answer

Get 1 Month low price of a stock with Google Finance using Google Sheets

For 1 Month low: I tried this Code in Google Sheet does not working enter code here =MIN(INDEX(GOOGLEFINANCE("NYSE:UBER","price",DATE(MONTH(TODAY()-30,MONTH(TODAY()),DAY(TODAY())), TODAY()),0,2)) Does not returning any value
Analytics f
  • 1
-1
votes
1 answer

Have a cell static after 1st dynamic update

I am using Google Sheet and fetching data from Google Finance. On checking for a condition 1st time, if it is true, I am filling a cell with "EXIT" and I want this to remain static after 1st fill. However, since the google finance data is dynamic…
Rinku
  • 81
  • 2
  • 14
-1
votes
2 answers

How do I prevent GoogleFinance from rounding stock prices?

I am trying to make a stock portfolio in Google Sheets to track my stonks. However, I have some penny stocks that are less than 1 penny, and GoogleFinance rounds them down to 0, making it impossible to calculate % of the portfolio. The code I use…
DanielZou0809
  • 1
-1
votes
1 answer

GoogleFinance Beta on a specific date?

How can I get the Beta for a stock on a specific date? I can get the current day's beta using the following =GoogleFinance("BB","beta") however, this formula does not work on specific dates =GoogleFinance(B2,"beta", "2020/12/17") Note: I'm open to…
Mauro
  • 307
  • 4
  • 8
-1
votes
1 answer

Google Finance Historical Data Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($N$2)),TODAY(),"DAILY") The above code returns OHLC data for specified days with the date column. What I want are only high, low and close columns. =GOOGLEFINANCE("NSE:"&A2, ("high", "low",…
Bhavesh Pamecha
  • 27
  • 6
-1
votes
1 answer

Google Sheet getValue() returns #N/A for cell containing Googlefinance() data

I have a simple Google sheet retrieving Stock Data using =Googlefinance(ticker,"close",today()-7,today()) in cell A2 (and the ajacent range). When I try to read the retrieved data in a script using sheet.range("A2").getValue() the script returns…
Jean Verschueren
  • 1
-1
votes
1 answer

C# .net WebRequest google finance

I'm using google finance to convert a currency to another. The code that I'm using is shown below which was working fine. However, today, I'm facing the IndexOutofrange exception and getting a result of -1 for the indexes searched below (which means…
Nassif Bousaba
  • 386
  • 1
  • 4
  • 22
-1
votes
2 answers

Google Finance: How big is a normal delay for historical stock data or is something broken?

I tried to download historical data from Google with this code: import pandas_datareader.data as wb import datetime web_df = wb.DataReader("ETR:DAI", 'google', datetime.date(2017,9,1), …
M14
  • 444
  • 6
  • 8
-1
votes
1 answer

Yahoo finance or google finance will block if i will subscribe all stocks?

I want to retrieve all stocks from few exchanges - by retrieve the stocks that inside those exchanges (by taking from http://www.nasdaq.com/screening/company-list.aspx). And then I will quote for all stocks from google or Yahoo. My question is if I…
David Michaeli
  • 367
  • 5
  • 26
-1
votes
1 answer

Calculator input change to unrounded result

Having this currency calculator, when a natural value is inserted user gets relevant currency well, however when inserted a number such as 8.5 or 4.3 etc... You get a rounded result. how do I change this and show accurate result (2 digits after…
eyalix
  • 133
  • 1
  • 2
  • 18
-1
votes
1 answer

Using file_get_contents() / cURL or API to get financial data?

I'm fetching market data from both Google Finance and Yahoo Finance but struggeling with an issue. Google Finance http://www.google.com/finance/info?q=NASDAQ:GOOG Yahoo…
Treps
  • 780
  • 3
  • 12
  • 28
-1
votes
2 answers

Can't parse Google Finance html

I'm trying to scrape some stock prices, and variations, from Google Finance using python3 but I just can't figure out if there's something wrong with the page, or my regex. I'm thinking that either the svg graphic or the many script tags throughout…
Slpk
  • 23
  • 7
-1
votes
2 answers

Google Finance Lock Out - Robot

So I have run into the issue of getting data from Google Finance. They have an html access system that you can use to access webpages that give stock data in simple text format (ideal for minimizing parsing). However, if you access this service too…
user3142330
  • 63
  • 1
  • 4
1 2 3
…
27
28