Hi, Im working on my masters thesis. I have unbalanced panel data, for about 1550 individial mutual funds (monthly data) from January 2000 until December 2020 (283,928 observations for each varaible). I have the following varibles:
ExcessReturn = mutual funds monthly excess return (return - risk free rate)
RMRF = Market return minus risk free rate
SMB, HML, MOM, CMA, RMA = Risk factors from the 3-4-5-factor models.
The mutual funds are seperates by ID code starting at 2761 until 51,250 (ID code skips hundreds of numbers at a time, not linear)
I want to run the regressions:
ExcessReturn = a + B(RMRF) + e
Excess Return = a +B(RMRF) + B(SMB) + B(HML) + e
Excess Return = a +B(RMRF) + B(SMB) + B(HML) +B(MOM)+ e
Excess Return = a +B(RMRF) + B(SMB) + B(HML) + B(CMA) + B(RMA) + e
I know how to run the regression for all the funds at once, my question is how can I loop the code to run a regression for each of the funds individually? So I would have an alpha, beta, etc for fund 100 and fund 101 and 103, etc.
Thanks for your time and help,
Logan
Related Posts with Panel data for for asset pricing models
Save t-statistic output for all observations (function statsby)Hi all, I would like to save all the t-statistics as output for all of my regression observations u…
How to plot differences in means for diff-in-diff common trend (from Bleakeley & Chin (2004))Dear Stata community, This is my first post on the forum. I'm struggling to recreate figure 1 from …
How to make a hbar which shows percentage of sum of one variable over groupsI have a dataset like this (part of it): Code: * Example generated by -dataex-. To install: ssc in…
aweight, pweight or fweight? What to use for WLS?Dear all, I would like to apply a weighted least squares model but I do not know which weight to us…
Dummy Variables OmmittedIn a study looking at the effect of foreign ownership, we have run into the issue that our variables…
Subscribe to:
Post Comments (Atom)
0 Response to Panel data for for asset pricing models
Post a Comment