Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Calculate CAPM beta in Stata

    Hey guys,

    We need to rebuild the paper "betting against beta" of A. Frazzini and L.H. Pedersen. We got our data from Thomson Reuters for about 500 US stocks depending equity and use the MSCI USA index as benchmark.
    We need to form portfolios with the stocks. At the beginning of each calender month, all stocks are assigned to one of two portfolios: low beta and high beta. The low (high-) beta portfolio i composed of all stocks with a beta below (above) it's country median. Stocks are weighted by the raqnked betas and the portfolios are rebalanced every calender month. Both portfolios are rescaled to have a beta of one at portfolio formation.
    Our next step is to calculate the beta of each stock. We have data from 31.12.1991 to 31.12.2016.
    Can someone tell us how to calculate the beta over time for each stock? And also, does someone know how to rebalance these portfolios every calender month?

    We are beginners with stata, so you would help us a lot!!!
    Thanks in advance!
    Click image for larger version

Name:	stata.PNG
Views:	1
Size:	162.6 KB
ID:	1379268
    Click image for larger version

Name:	stata1.PNG
Views:	1
Size:	22.6 KB
ID:	1379269

  • #2
    "Seminar Finance": We ask for full real names here, meaning personal names. We also ask for full references of papers. We also advise against posting data examples as images. So, someone may want to answer this, but your chances would be boosted by paying attention to FAQ Advice #12, #6. #13.

    http://www.statalist.org/forums/help

    Comment

    Working...
    X