Calculated the profitability of each sector using data from yahoo sites.finance and stocks. We used historical data on the adjusted closing price from 2002-01-01 to 01-10-2022. To calculate profitability, I used the growth rate(X1/X0 -1) as a percentage. Similarly, the growth rate for the S&P500 Index was estimated. https://docs.google.com/spreadsheets/d/1CfBo7frQd2tumJLt5e_zRNkTENx47XuU/edit#gid=1901038055 (list 'ETF yields')
Calculated the profitability of each sector using data from yahoo sites.finance and stocks. We used historical data on the adjusted closing price from 2002-01-01 to 01-10-2022. To calculate profitability, I used the growth rate(X1/X0 -1) as a percentage. Similarly, the growth rate for the S&P500 Index was estimated. https://docs.google.com/spreadsheets/d/1CfBo7frQd2tumJLt5e_zRNkTENx47XuU/edit#gid=1901038055 (list 'ETF yields')