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