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

Unable to use script to send email, when cell with complex GoogleFinance function changes

I have a formula in Google Spreadsheet (Cell G4): =AVERAGE(INDEX( GoogleFinance(B4 , "all" , WORKDAY( TODAY(), -50 ) , TODAY() ) , , 3)) where, B4=INDEXBOM:SENSEX I am trying to use following script to send email when cell value changes: function…
Non-programmer
  • 1
  • 2
0
votes
1 answer

Google Finance API Time Period

I am using a C# class to get the prices of a given stock from Google Finance. The communication between the class and the Web Service is working well. I am using the following url: http://www.google.com/finance/historical?output=csv&q=BBAS3 The…
Mad River
  • 11
  • 5
0
votes
4 answers

Looking for a free S&P 500 data feed

I am looking for a free S&P 500 data feed, preferably one with a REST API. It appears that Yahoo Finance & Google Finance have discontinued their feeds. For example, http://download.finance.yahoo.com/d/quotes.csv?s=GOOG+AAPL&f=snl1 returns, "It…
John DiFini
  • 96
  • 2
  • 6
0
votes
0 answers

Not able to download all available data from Google Finance

import datetime as dt import pandas_datareader.data as web start = dt.datetime(2007,1,3) end = dt.datetime(2017,10,30) df = web.DataReader('XCSE:OMX Stockholm PI', 'google', start,…
Chisq
  • 117
  • 1
  • 9
0
votes
1 answer

ggplot time series, error:Don't know how to automatically pick scale for object of type xts/zoo. Defaulting to continuous

I'm new to ggplot and, while this seems like a simple question, I'm baffled. I get the error message Don't know how to automatically pick scale for object of type xts/zoo. Defaulting to continuous. And I don't see a line on my graph. Here's…
S Novogoratz
  • 388
  • 2
  • 14
0
votes
1 answer

How to specify the currency for GoogleFinance historical data

I'm having a problem using Google Finance historical data. I need to know the price a particular stock had on a particular date (Usually within the last month). The problem is, when I use a URL such as…
Muc
  • 1,464
  • 2
  • 13
  • 31
0
votes
2 answers

Google Sheet, Finance: FILTER twice to get only one cell

I have a Google Sheet with some stock information. I'm using the formula GOOGLEFINANCE($B2, "price",TODAY()-15) to retrieve historical information about a stock (symbol named in $B2). That returns a 2x2 table: Date Close 8/25/2017…
Ivan Perez
  • 582
  • 2
  • 17
0
votes
1 answer

Google finance no longer work?

I used to get stock rate from google finance api by javascript with following url: http://www.google.com/finance/info?q=BOM:530355 but now it no longer work! I have search on the net but no luck. Any help would be great, Thank!
Mohammed Ali
  • 11
  • 4
0
votes
1 answer

Url for google finance unable to get data

I am using this link to get multiple quotes for my own app https://www.google.com/finance/info?infotype=infoquoteall&q=SGX:U11,ASX:TPM,ASX:WOW However, it stop working now. Any alternatives google api that can get data for multiple quotes at one…
lotteryman
  • 389
  • 1
  • 6
  • 21
0
votes
1 answer

google finance python package not working for some stocks

This is functional code for retrieving stock prices. from googlefinance import getQuotes import json import re def get_last_trade_price(TICKER): Asset = json.dumps(getQuotes(TICKER)) raw = (json.loads(Asset)[0]["LastTradePrice"]) raw =…
prashanth manohar
  • 531
  • 1
  • 13
  • 30
0
votes
2 answers

pandas-datareader doesn't work for Google Finance

I followed the example code from this link: https://pandas-datareader.readthedocs.io/en/latest/remote_data.html#google-finance, and it throws an error. This is the error: RemoteDataError: Unable to read URL:…
Allen L.
  • 21
  • 3
0
votes
0 answers

highstock with google finance api

i try to make a stockchart using Google Finance API. I'm using the demo like THIS I've try to change the link from $.getJSON('https://www.highcharts.com/samples/data/jsonp.php?filename=aapl-ohlcv.json&callback=?', function (data) to use google…
Takdir Saputro
  • 43
  • 6
0
votes
2 answers

Google App Script: Convert Currency, but keep value from moment of conversion

I've built myself a rather fancy finance tracking spreadsheet, but have run into the following problem: I track my expenses with two values: amount and currency. Then, in the next column, I use GOOGLEFINANCE() to convert those values to my native…
DTX
  • 192
  • 1
  • 12
0
votes
2 answers

How to get cid from market and symbol from google finance

I would like to fetch the historical data from google finance. Url should be like this, this is the link for Apple.…
whitebear
  • 11,200
  • 24
  • 114
  • 237
0
votes
3 answers

How can I apply a couple of functions to multiple tickers in a list? (Code improvement)

So I'm currently learning how to analyse financial data in python using numpy, pandas, etc... and I'm starting off with a small script that will hopefully rank some chosen equities by the price change between 2 chosen dates. My first script…
Louis Falconer-Flavin
  • 3
  • 6
1 2 3
…
27 28