I am right now trying to generate annual return volatility for each company using the following formula with the monthly returns. My data contains a single number for all months of a given year for each firm. In the formula y stands for year and m stands for month and i stands for a firm. The units for vola are percentage points. I am not sure how to get to an annual return per company, should I use a loop? I don't even have a clue how to start
Attached is my provided data, where I already generated the company_id for each company, monthly returns are given by ret, and risk-free rate (rf) = rf
How to begin? how do I not double count, how to use an efficient way to get the annual return for each company even though the data is monthly? jeeeesus...
Thank you so so so much for your help!!! Best
Array
Related Posts with Annual return from each company, wen having monthly data given
Reference category in mi estimate logisticDear all, I would like to do a logistic regression with multiple imputed data. My syntax is: mi es…
Poisson and Negative Binomial Distribution and Stata CodesDear Stata Forum, My question relates more with the theory of Poisson and Negative Binomial Poisson…
Help with long dataHi, I have previously posted here and received great help. Need help with one last area that I am r…
Defining value labels based on varlistDear all, I am writing a program which at the beginning I define a varlist: syntax varlist (min=3 n…
Weak instrument test for ivprobit with clustering?Hello, I am seeking advice about how to run a weak instrument test after estimating an ivprobit mode…
Subscribe to:
Post Comments (Atom)
0 Response to Annual return from each company, wen having monthly data given
Post a Comment