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

Google spreadsheet googlefinance get specific attribute does not work

The googlefinance integration, documented here, in google spreadsheets does not seem to work for me: Example: GOOGLEFINANCE("GOOG","price",TODAY()-30,TODAY()) Google spreadsheets gives the cell a red corner and prints the following message: Fel…
David Karlsson
  • 9,396
  • 9
  • 58
  • 103
1
vote
1 answer

How do I retrieve Google Finance Historical data in Google Sheets using the API?

To reproduce this problem, create a new sheet. In cell A1, insert this formula: =GoogleFinance("AMZN", "all", "1/1/2018", "2/1/2018") The output (Formatting doesn't matter for this problem): Date Open High Low Close Volume 1/2/2018…
Andy
  • 842
  • 1
  • 12
  • 24
1
vote
3 answers

Python - Pulling from Google Finance with Pandas

I'm trying to pull data from Google Finance using Pandas and Pandas Datareader. Here is my code: #Importing libraries needed for pulls from Google from pandas_datareader import data import pandas as pd import datetime from datetime import…
MakoTheShark
  • 11
  • 1
  • 1
  • 3
1
vote
1 answer

Google apps script not returning data

I have a Google Apps Script pulling data from a Google Sheet, which gets data via GoogleFinance, (image attached) the price difference "=GOOGLEFINANCE(A2, "change")" works fine, but the close price which is called via "=INDEX(GOOGLEFINANCE((A3),…
Nick Clarkson
  • 11
  • 2
1
vote
1 answer

Pandas DataReader work-around for Google finance

I pull historical data for a large universe of stocks and ETFs daily. Quandl has pretty good free coverage of US Equities, but they do not have historical data for ETFs so I use the Google API as a backup for Quandl. The recent Google finance…
MJS
  • 1,573
  • 3
  • 17
  • 26
1
vote
0 answers

Issues on fetching stock data at specific time in google sheet

I want to fetch stock value at specific time(for example 10:00:00) in google sheet. I'm using the following function but it's not working for me. =GOOGLEFINANCE(A4,"price",time(10,00,00)) It shows an error as The query has returned no data Kindly…
magneto
  • 113
  • 2
  • 13
1
vote
1 answer

R download google finance data

I downloaded a script to download historical data from google, however, it only downloaded the data only for a year but I wanna download all the data, but the script has the start date for the data # Make sure data.table is…
Peter Chung
  • 1,010
  • 1
  • 13
  • 31
1
vote
0 answers

Is there a way to get more than one year stock data via Google finance

I used the code from this link to get Google stock data from Google finance, however, I was not able to get more than one year of historical data. Is there a way to get more data via Google finance? # Make sure data.table is…
mql4beginner
  • 2,193
  • 5
  • 34
  • 73
1
vote
1 answer

Stock Quote - Google Finance (changes after 6th Sept 2017)

I'm having issues getting my stock quote to work since Google did some changes at their end. I have read the information on this link google finance json stock quote stopped working but it didn't help. The earlier URL to fetch information was…
RLM
  • 21
  • 2
1
vote
0 answers

How do I get the cid of a stock for Google Finance?

While this question was asked beforehand in the following post: How to get cid from market and symbol from google finance The answer didn't actually answer the question. Since google finance no longer allows for historical prices beyond a year…
Earl Russell Almazan
  • 23
  • 5
1
vote
1 answer

google finance getprices URL works via browser but not programmatically from R

This URL https://finance.google.com/finance/getprices?i=60&p=1d&f=d,l,h&q=ALV returns expected one minute prices on ALV for a single day in…
Marc
  • 11
  • 3
1
vote
3 answers

GOOGLE Finance converter api is not responding

I have been trying to convert the currencies using google finance converter in PHP. I have used the following code. $amount = 100; $from_Currency = "INR"; $to_Currency = "BTC"; $amount = urlencode($amount); $from_Currency =…
Bip Inn
  • 31
  • 2
  • 10
1
vote
1 answer

Python Efficient Web Scraping?

I'm fairly new to Python and am trying to make a web parser for a stock app. I'm essentially using urllib to open the desired webpage for each stock in the argument list and reading the full contents of the html code for that page. Then I'm slicing…
user8599863
1
vote
2 answers

Get Stock Price with PHP & JSON Decode on Google FInance

I am trying to retreive the current stock price from Google Finance: http://finance.google.com/finance/info?client=ig&q=AAPL How can I extract just the price ("1")?
rainerbrunotte
  • 907
  • 1
  • 17
  • 37
1
vote
1 answer

Google Sheets Financial API - dates are wrong

I'm using Google Sheets for tracking my mutual funds portfolio, and I'm supposed to call the function below to get the timestamp of the most recent change of the VASIX fund share price: =GOOGLEFINANCE("VASIX", "date") The problem is that the date,…
HEKTO
  • 3,876
  • 2
  • 24
  • 45
1 2 3
…
27 28