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
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
Just surround the date by quotation marks: =GOOGLEFINANCE(“GOOG”,”price”,”12/13/2013″) Also, if you want only the number, wrap it in INDEX formula =INDEX(GOOGLEFINANCE(“GOOG”,”price”,”12/13/2013″),2,2)
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