Buy Me a Coffee? Your support is much appreciated!
PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn
Source Code:
import time import datetime import pandas as pd tickers = ['TSLA', 'TWTR', 'MSFT', 'GOOG', 'AAPL'] interval = '1d' period1 = int(time.mktime(datetime.datetime(2021, 1, 1, 23, 59).timetuple())) period2 = int(time.mktime(datetime.datetime(2021, 6, 30, 23, 59).timetuple())) xlwriter = pd.ExcelWriter('historical prices.xlsx', engine='openpyxl') for ticker in tickers: query_string = f'https://query1.finance.yahoo.com/v7/finance/download/{ticker}?period1={period1}&period2={period2}&interval={interval}&events=history&includeAdjustedClose=true' df = pd.read_csv(query_string) df.to_excel(xlwriter, sheet_name=ticker, index=False) xlwriter.save()
Hi, tried to amend your code for the entire S&P500.
But it comes up with *HTTPError: HTTP Error 404: Not Found*.
Do you have any idea why that happened?
Cheers!
Bernd
import time
import datetime
import pandas as pd
ticker_list = pd.read_html(
‘https://en.wikipedia.org/wiki/List_of_S%26P_500_companies’)
df = ticker_list[0]
df.drop(columns = [‘SEC filings’], inplace = True)
df = df[‘Symbol’]
tickers = df.values.tolist()
interval = ‘1d’
period1 = int(time.mktime(datetime.datetime(2021, 1, 1, 23, 59).timetuple()))
period2 = int(time.mktime(datetime.datetime(2021, 6, 30, 23, 59).timetuple()))
xlwriter = pd.ExcelWriter(‘historical prices.xlsx’, engine=’openpyxl’)
for ticker in tickers:
query_string = f’https://query1.finance.yahoo.com/v7/finance/download/{ticker}?period1={period1}&period2={period2}&interval={interval}&events=history&includeAdjustedClose=true’
df1 = pd.read_csv(query_string)
df1.to_excel(xlwriter, sheet_name=ticker, index=False)
xlwriter.save()
I am pretty new to python, so ….