compare2df

compare2df_sof_quest.py

import pandas as pd
from datetime import datetime
from datetime import timedelta
from yahoo_earnings_calendar import YahooEarningsCalendar
#import dateutil.parser

#setting the report date

report_date = datetime.now().date()

#downloading the earnings calendar

yec = YahooEarningsCalendar()
earnings_list = yec.earnings_on(report_date)

#saving the data in a pandas DataFrame

earnings_df = pd.DataFrame(earnings_list)

table=pd.read_html('https://en.wikipedia.org/wiki/List_of_S%26P_500_companies')
snp = table[0]
snp= snp['Symbol']
print(snp)




tickers_in_snp=earnings_df[earnings_df['ticker'].isin(snp)]