Is it possible to get monthly historical stock prices in python?

python pandas quantitative-finance
Jeffrey Derose picture Jeffrey Derose · Jul 30, 2016 · Viewed 9.6k times · Source

I know using pandas this is how you normally get daily stock price quotes. But I'm wondering if its possible to get monthly or weekly quotes, is there maybe a parameter I can pass through to get monthly quotes?

    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'])

Answer

sk877 picture sk877 · Aug 8, 2016

Monthly closing prices from Yahoo! Finance... 

import pandas_datareader.data as web

data = web.get_data_yahoo('IBM','01/01/2015',interval='m')

where you can replace the interval input as required ('d', 'w', 'm', etc).

Related questions

ValueError: If using all scalar values, you must pass an index

Take the following code: import MySQLdb as mdb import pandas as pd con = mdb.connect(db_host, db_user, db_pass, db_name) query = """SELECT `TIME`.`BID-CLOSE` FROM `EUR-USD`.`tbl_EUR-USD_1-Day` WHERE TIME >= '2006-12-15 22:00:00' AND …

Read More
ValueError: ordinal must be >= 1

This Code, Takes 2 co-ordinates for a straight line from google finance and places 3rd point on the same line at some distance. import datetime as dt from datetime import timedelta as td import matplotlib.pyplot as plt from matplotlib import …

Read More
How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More