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
12
votes
2 answers

Issue with Google Finance in Google Sheets for Currency Exchange Rates

I am using the GOOGLEFINANCE() function in google sheets to get an exchange rate for expenses I am entering in for accounting. The issue is that sometimes I get an #N/A error with the message When evaluating GOOGLEFINANCE, the query for the symbol:…
Catu
  • 715
  • 1
  • 6
  • 13
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
  • 24,974
  • 34
  • 121
  • 164
11
votes
2 answers

Google finance as an argument for ArrayFormula

=ARRAYFORMULA(IF(ROW(B:B)=1, "Share Price", IF(ISBLANK(B:B), "", googlefinance(B:B, "price")))) I am trying to make row 1 (my header row) have a name, and then below that, if a valid ticker symbol is an input in column B, have google finance fetch…
Warstolrem
  • 131
  • 1
  • 12
11
votes
3 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 :
Syed Saqlain
  • 544
  • 4
  • 21
10
votes
1 answer

How to locally cache GOOGLEFINANCE results?

I use GOOGLEFINANCE() to query the historical USD/GBP exchange rate at a set of fixed dates. This works fine, except sometimes GOOGLEFINANCE returns #N/A, for whatever temporary upstream reason. When this happens, my spreadsheet becomes filled with…
SuperElectric
  • 17,548
  • 10
  • 52
  • 69
10
votes
0 answers

Pulling google finance data with ISIN as an identifier

I would like to pull intraday data of any stocj in google finance just by asking for its ISIN number (not the google symbol). Is there is a way to do so using the python API googlefinance ? Thanks
Prou Prou Tyu
  • 409
  • 1
  • 6
  • 16
10
votes
2 answers

Google finance 200 day moving average is getting as #NA in Apps Script

I'm calculating Google finance 200 day moving average formula in google sheet using formula =average(query(sort(GoogleFinance("GOOG","price", TODAY()-320, TODAY()),1,0),"select Col2 limit 200")) Then in google app script I'm getting the above cell…
Syed Mohammed Mehdi
  • 183
  • 2
  • 5
  • 15
9
votes
1 answer

Is there a source to find a list of symbols?

I'm using the data of alpha vantage for a stock market analysis site. But I cannot find a complete list of symbols available ( to be used in a selection drop down ).
Christian
  • 848
  • 1
  • 11
  • 23
8
votes
2 answers

Finance historical options data (with strikes etc) on google finance API

Can anyone provide how to get historical options data with strikes by Google Finance API? Mbe Yahoo API can do it? Thx.
0dd_b1t
  • 568
  • 3
  • 15
  • 29
8
votes
1 answer

Pulling Google Finance portfolios into R

I want to access data from my google finance portfolio in R. I am trying to do this by reading the Google Finance API documentation and following the lead of RGoogleDocs. I've made some progress, but I'm having a lot of trouble parsing the XML…
Zach
  • 29,791
  • 35
  • 142
  • 201
7
votes
2 answers

stocks splitting api google or yahoo

I am looking for a way to get stock splitting information. Using the yahoo stock API I can get all types of info on any symbol but I don't think I can get the split ratio or even whether it split. Does anyone know of a way of getting this info?
milan
  • 2,179
  • 9
  • 24
  • 34
7
votes
3 answers

HTTP Error 404 from googlefinance in python 2.7

In python 2.7 shell I ran the follwoings: $from googlefinance import getQuotes $import json $from urllib2 import urlopen $print json.dumps(getQuotes('AAPL'), indent=2) Got error message on the 4th command as follows: Traceback (most recent call…
Polta Lashka
  • 105
  • 1
  • 12
7
votes
1 answer

Google Finance API for getting quote has stopped working today. Is there an alternate to get quote every minute?

Below URL has stopped working from today. Any alternate ? Get Quote from Google Finance
Amit
  • 1,642
  • 2
  • 13
  • 22
7
votes
3 answers

Python: using Google Finance to download index data

I've been successful at downloading stock data from Google Finance, like so: import pandas as pd from pandas_datareader import data as web import datetime start = datetime.datetime(2016,1,1) end = datetime.date.today() apple =…
trob
  • 387
  • 1
  • 5
  • 15
7
votes
4 answers

Stock symbol auto-complete API

I am looking for some stock symbol look-up API. I could able to query yahoo finance with a symbol & could able to retrieve the stock price & other details. I am looking for some auto-complete stock look-up API like if i query fo "Go*" ... how can i…
Satish
  • 203
  • 5
  • 9
1
2
3
…
27 28