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
Fuzzy identification using jarowinkler distanceHello, I have a dataset, with 2.800.000 observations and 10 variables, containing the information o…
t-test for subset of one variable against second variableI have a randomized control trial with treatment and control taking survey 1, then treatment watches…
Generate sum of multiple variable without including years when there are missing values I want to create sum of some variables but without including sum when there are missing values in o…
Negative coefficient interpretationDear Researchers, What I know about the interpretation of the negative coefficient of the regression…
Fractional multinational logit with fixed effectsHi, I have a panel data for 24 years. I want to see how state governments allocate total budget amo…
Subscribe to:
Post Comments (Atom)
0 Response to Panel data for for asset pricing models
Post a Comment