Convert daily data into monthly data.

[Muriel Capucine]

Hi here (newbie here). For my university assignment, we need to estimate the CAPM model using STATA and analyse the result. We were given data from Yahoo Finance (including the price of the asset, risk free rate, market return, etc). However, the data is given daily and early on in the module the lecturer suggested using monthly data as they are less noisy. The lecturer is refusing to tell us how to convert the daily data into monthly data and I am struggling to find a solution. Any help will be much appreciated. Thanks, M.

[Nick Cox]

Being a teacher, I support yours. Please note our policy on assignments as expounded at #4 in https://www.statalist.org/forums/help#adviceextras