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 documentation.

Update for pandas >= 0.19:

The pandas.io.data module has been removed from pandas>=0.19 onwards. Instead, you should use the separate pandas-datareader package. Install with:

pip install pandas-datareader

And then you can do this in Python:

import pandas_datareader as pdr
from datetime import datetime

ibm = pdr.get_data_yahoo(symbols="IBM", start=datetime(2000, 1, 1), end=datetime(2012, 1, 1))
print(ibm['Adj Close'])

Downloading from Google Finance is also supported.

There’s more in the documentation of pandas-datareader.

More Related Contents:

  1. How do I melt a pandas dataframe?
  2. Pandas bar plot changes date format
  3. Make Pandas DataFrame apply() use all cores?
  4. Requirements for converting Spark dataframe to Pandas/R dataframe
  5. pandas reading CSV data formatted with comma for thousands separator
  6. How to create a table with clickable hyperlink in pandas & Jupyter Notebook
  7. Pandas: add a column to a multiindex column dataframe
  8. After rename column get keyerror
  9. (pandas) Create new column based on first element in groupby object
  10. Jupyter notebook display two pandas tables side by side
  11. Adding a column thats result of difference in consecutive rows in pandas
  12. collect() or toPandas() on a large DataFrame in pyspark/EMR
  13. Python/Pandas: counting the number of missing/NaN in each row
  14. Pandas: fill in NaN values with dictionary references another column
  15. pandas dataframe group and sort by weekday
  16. Standard implementation of vectorize_sequences
  17. Suppress output of object when plotting in IPython
  18. Pandas: convert date in month to the 1st day of next month
  19. Convert a spark DataFrame to pandas DF
  20. Getting Colorbar instance of scatter plot in pandas/matplotlib
  21. Yahoo Finance Historical data downloader url is not working
  22. Why are Pandas and GeoPandas able to read a database table using a DBAPI (psycopg2) connection but have to rely on SQLAlchemy to write one?
  23. How to remove levels from a multi-indexed dataframe?
  24. Pandas & AWS Lambda
  25. Scrape tables into dataframe with BeautifulSoup
  26. How to remove illegal characters so a dataframe can write to Excel
  27. Plot pandas dataframe containing NaNs
  28. Turn pandas dataframe into a file-like object in memory?
  29. use Featureunion in scikit-learn to combine two pandas columns for tfidf
  30. Convert dataframe with start and end date to daily data

Leave a Comment