Get Historical Data
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv('asx.csv')
df.head()
# download data
from pandas_datareader import data as yh
from datetime import datetime
from tqdm.notebook import tqdm
for stock_id in tqdm(df.code.values):
list_date = df.set_index('code').loc[stock_id, 'listing_date']
stock_id = stock_id + '.AX'
today = datetime.today().strftime("%Y-%m-%d")
try:
df_result = yh.get_data_yahoo(stock_id, start=list_date, end=today)
df_result.to_csv(f'{stock_id}.csv', index=True)
except:
continue