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.

Filter by
Sorted by
Tagged with
123votes
13answers
308kviews

How can I get stock quotes using Google Finance API?

I'm looking for access to financial data from Google services. I found this URL that gets the stock data for Microsoft. What are all the possible parameters that Google allows for this kind of HTTP ...
user avatar
  • 4,398
53votes
4answers
128kviews

Download all stock symbol list of a market [closed]

I need to download in some way a list of all stock symbol of specified market. I've found in this link ho can I do it someway. It uses following link in order to retrieve stock list that statisfies ...
user avatar
  • 10.2k
48votes
6answers
130kviews

Download history stock prices automatically from yahoo finance in python

Is there a way to automatically download historical prices of stocks from yahoo finance or google finance (csv format)? Preferably in Python.
user avatar
  • 10.1k
46votes
2answers
72kviews

How to get the price of a stock at a particular date from Google Finance?

I want to get the price of a particular stock at a particular date in Google Sheets using the Google Finance forumula. I tried this formula: =GOOGLEFINANCE("GOOG","price",12/13/...
user avatar
  • 23.4k
32votes
1answer
32kviews

Alternatives to the Yahoo Finance API? [closed]

Yahoo finance recently discontinued their API. I have been looking for alternatives. The ones I've found so far are Google Finance and Quandl. Google Finance was deprecated in 2011 but still appears ...
user avatar
  • 1,869
30votes
8answers
140kviews

How to use GOOGLEFINANCE(("CURRENCY:EURAUD")) function

This function: GOOGLEFINANCE(("CURRENCY:EURAUD")) works well in Google Sheets, I have searched the web up and down for some documentation regarding this function and how it is used, the closest I've ...
user avatar
  • 4,009
27votes
5answers
129kviews

How to make google spreadsheet refresh itself every 1 minute?

My google spreadsheet is using GOOGLEFINANCE('symbol','price) function to retrieve stock prices of my portfolio. Unfortunately, I have to refresh manually now. How can I make the spreadsheet refresh ...
user avatar
  • 23.4k
24votes
2answers
21kviews

GoogleFinance often returns #N/A and internal error messages while getting stock quotes

Anyone know workarounds to make GoogleFinance actually work? It works for a while so it is not a problem with my formulas but then periodically the cells that were showing stock quotes suddenly show "...
user avatar
  • 1,289
18votes
7answers
40kviews

fetch stock quotes from google finance, yahoo finance or the exchange itself

I am building a web based trading system where buy and sell signals would be generated by reading quotes from either Yahoo finance, google finance or the exchange(NSE of India) itself.My first ...
user avatar
17votes
7answers
23kviews

Get exchange rate on a specific date from GoogleFinance

I'm having trouble stopping the googlefinance function on a specific date to use "that" specific exchange rate to convert currency from GBP to EUR. Here is my formulae: =Finance!B4*GOOGLEFINANCE("...
user avatar
  • 667
17votes
8answers
67kviews

How to create a stock quote fetching app in python

I'm quite new to programming in Python. I want to make an application which will fetch stock prices from google finance. One example is CSCO (Cisco Sytems). I would then use that data to warn the ...
user avatar
  • 1,789
14votes
2answers
5kviews

way to access user's Google Finance portfolio?

I noticed that Google removed the Finance API for Google App Engine. All I want is a list of stock tickers that they have in their Google Finance portfolio. Is there any way to still pull this data ...
user avatar
  • 6,719
12votes
12answers
18kviews

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. ...
user avatar
  • 24.3k
12votes
6answers
20kviews

Programmatic access to detailed historical financial data [closed]

I know that Yahoo has a great API for accessing detailed financial metrics about a company documented at http://www.gummy-stuff.org/Yahoo-data.htm. Yahoo also provides historical pricing data, ...
user avatar
11votes
4answers
3kviews

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 : <?php function ...
user avatar
10votes
3answers
23kviews

Get BTC prices on Google Sheets from Google Finance

I'm trying to get data from Google Finance in Google Sheets with this formula: =GoogleFinance("CURRENCY:BTC") But I'm getting this error: GOOGLEFINANCE, the query for the symbol: 'CURRENCY:BTC' ...
user avatar
10votes
0answers
12kviews

How to fetch the ETF's data into a Google Spreadsheet?

Following this post, where I had listed some of the interesting ETF1s I had found on some of the relevant forums, I received some valuable criticism. Now I want to use a Google spreadsheet to get the ...
user avatar
9votes
2answers
22kviews

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),"...
user avatar
9votes
2answers
7kviews

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 ...
user avatar
  • 615
9votes
1answer
15kviews

Is there a source to find a list of symbols? [closed]

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 ).
user avatar
  • 787
9votes
0answers
6kviews

Pulling google finance data with ISIN as an identifier [closed]

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
user avatar
8votes
2answers
16kviews

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.
user avatar
  • 578
8votes
1answer
2kviews

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, ...
user avatar
  • 28.4k
7votes
2answers
8kviews

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. ...
user avatar
  • 2,119
7votes
3answers
30kviews

How to work with Google Finance?

I want to develop a small application to get stock price from Google Finance automatically and store it in my local machine for future analysis. Can anyone give me some clue how to get started? I ...
user avatar
  • 1,291
7votes
4answers
4kviews

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-...
user avatar
  • 203
7votes
3answers
5kviews

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 ...
user avatar
  • 367
7votes
1answer
2kviews

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

Below URL has stopped working from today. Any alternate ? Get Quote from Google Finance
user avatar
  • 1,582
6votes
3answers
8kviews

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 ...
user avatar
6votes
2answers
6kviews

How can I trigger an event when this span value changes?

I'm trying to get a console log when the price of the current page's stock changes. page: https://www.google.com/finance?q=NASDAQ%3AGOOG&ei=yvbRVbHSCcKgmAGyu7CoDA Element ID: #price-panel > div >...
user avatar
  • 30.4k
6votes
1answer
3kviews

Improving a function to get stock news data from google in R

I've written a function to grab and parse news data from Google for a given stock symbol, but I'm sure there are ways it could be improved. For starters, my function returns an object in the GMT ...
user avatar
  • 28.4k
6votes
2answers
7kviews

Highstock vs Google Charts in Performance

A) I'm using the Highstock charting library for a finance project of mine. However, I'm getting bogged down in performance issues. My working implementation of Highstock has i) 5 graphs in a chart ii) ...
user avatar
6votes
1answer
3kviews

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 ...
user avatar
6votes
4answers
3kviews

Possible to use Google Spreadsheet functions in Google App Script?

I just discovered Google App Scripts, and I'm stumped on something already... I am trying to write a script for a Google Spreadsheet which finds certain historical stock prices. I found that the ...
user avatar
  • 63
5votes
2answers
4kviews

Leading slashes in JSON from Google Finance API call

I've been using the Google Finance API to successfully gather some stock info. The problem is that after a call to http://www.google.com/finance/info?infotype=infoquoteall&q=[$tickerSymbol], the ...
user avatar
  • 4,407
5votes
3answers
5kviews

Obtaining financial data from Google Finance which is outside the scope of the API

Google's finance API is incomplete -- many of the figures on a page such as: http://www.google.com/finance?fstype=ii&q=NYSE:GE are not available via the API. I need this data to rank ...
user avatar
  • 245
5votes
1answer
9kviews

Finance API for Android

I am trying to make a new application and I would like to get stock updates, currency exchange updates etc. Can you please suggest some free API for getting these updates? I have already tried : 1) ...
user avatar
  • 3,608
5votes
0answers
8kviews

Google Finance API address has changed

Until yesterday the following URL (Google Finance API) https://www.google.com/finance/getprices?q=TSLA&x=NASDAQ&i=3600&p=5d&f=d,o,h,l,c,v would lead to a nice comma delimited data ...
user avatar
5votes
1answer
436views

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 ...
user avatar
4votes
4answers
14kviews

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 ...
user avatar
  • 1,505
4votes
2answers
16kviews

Documentation for ticker symbols supported by googlefinance function in Google Sheets

The GOOGLEFINANCE function in Google Sheets allows you to lookup the price (or other attribute) of a stock or instrument. https://support.google.com/docs/answer/3093281?hl=en However, the ...
user avatar
  • 2,404
4votes
2answers
5kviews

How to get China Stock Market Index (SSE) in Google Sheets using GOOGLEFINANCE?

I have searched everywhere but didn't find a way for this. It's for =Googlefinance("ticker"), Is china's SSE index available as a ticker for google finance, to be used in google sheets?
user avatar
4votes
3answers
698views

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 ...
user avatar
  • 443
4votes
3answers
840views

'Access-Control-Allow-Origin' Google finance converter gives an error javascript/jquery

I'm working with one project module, where I want to get converted price from Google finance converter based on from currency code and amount. Here is my code: $('.actual-price').tooltip({ ...
user avatar
4votes
2answers
2kviews

ArrayFormula with GoogleFinance dynamic date

First of all, i'm not a powerful sheets user :) I'm trying to use GOOGLEFINANCE to calculate amounts in multiple currencies. I use this formula: =IF($A2; IF( $C2:C; $C2:C; IF( $D2:D; $D2:D*...
user avatar
4votes
3answers
3kviews

Fixed income data online [closed]

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 ...
user avatar
  • 11.9k
4votes
2answers
574views

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("...
user avatar
3votes
5answers
12kviews

GoogleFinance function to calculate Exponential moving average in google sheets

I am using google sheets and GoogleFinance functions to get stock data. I am able to calculate a simple moving average with the below formula. I am trying to get an Exponential moving average for ...
user avatar
  • 7,073
3votes
3answers
14kviews

issues downloading stock data from google finance using panda datareader

Things used to work great until several days ago. Now when I run the following: from pandas_datareader import data symbol = 'AMZN' data_source='google' start_date = '2010-01-01' end_date = '2016-01-...
user avatar
  • 33
3votes
3answers
9kviews

How to fix mpl_finance package for MatPlotLib?

Getting this error message: MatplotlibDeprecationWarning: The finance module has been deprecated in mpl 2.0 and will be removed in mpl 2.2. Please use the module mpl_finance instead. How do I put in ...
user avatar
  • 2,790

15 30 50 per page
1
2 3 4 5
8