google-finance

How to use GOOGLEFINANCE((“CURRENCY:EURAUD”)) function

by

The specific instructions for what you are looking for are in here: https://support.google.com/docs/answer/3093281 Remember your Google Spreadsheets Formulas might use semicolon (;) instead of comma (,) depending on Regional Settings. Once made the replacement on some examples would look like this: =GoogleFinance(“CURRENCY:USDEUR”) =INDEX(GoogleFinance(“USDEUR”,”price”,today()-30,TODAY()),2,2) =SPARKLINE(GoogleFinance(“USDEUR”,”price”,today()-30,today())) Those 3 cells would result in something like this (the second … Read more

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

by

you can either use alternative to GOOGLEFINANCE (depends on what exactly are you up to) or if you want to stick with it you can wrap it into IFERROR: =IFERROR(GOOGLEFINANCE(your_formula_here), GOOGLEFINANCE(same_formula_here)) or even: =IFERROR(IFERROR( GOOGLEFINANCE(your_formula_here), GOOGLEFINANCE(same_formula_here)), GOOGLEFINANCE(same_formula_here))

Download history stock prices automatically from yahoo finance in python

by

When you’re going to work with such time series in Python, pandas is indispensable. And here’s the good news: it comes with a historical data downloader for Yahoo: pandas.io.data.DataReader. from pandas.io.data import DataReader from datetime import datetime ibm = DataReader(‘IBM’, ‘yahoo’, datetime(2000, 1, 1), datetime(2012, 1, 1)) print(ibm[‘Adj Close’]) Here’s an example from the pandas … Read more

Download all stock symbol list of a market [closed]

by

Exchanges will usually publish an up-to-date list of securities on their web pages. For example, these pages offer CSV downloads: http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NASDAQ&render=download http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NYSE&render=download http://www.asx.com.au/asx/research/ASXListedCompanies.csv NASDAQ Updated their site, so you will have to modify the URLS: NASDAQ https://old.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=nasdaq&render=download AMEX https://old.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=amex&render=download NYSE https://old.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=nyse&render=download Depending on your requirement, you could create the map of these URLs by exchange … Read more

How can I get stock quotes using Google Finance API?

by

The Google Finance Gadget API has been officially deprecated since October 2012, but as of April 2014, it’s still active. It is completely dead as of March 2022. http://www.google.com/finance/info?q=NASDAQ:GOOG http://www.google.com/finance/info?q=CURRENCY:GBPUSD http://finance.google.com/finance/info?client=ig&q=AAPL,YHOO You can also get charts: https://www.google.com/finance/getchart?q=YELP Note that if your application is for public consumption, using the Google Finance API is against Google’s terms … Read more