Choose any 5 stocks from Yahoo finance and collect the past 5-year monthly data. Then, calculate their betas based on S&P 500 market index by excel. Posted on January 9, 2018 by Choose any 5 stocks from Yahoo finance and collect the past 5-year monthly data. Then, calculate their betas based on S&P 500 market index by excel.