Hey all,
Our dataset consists of monthly stockprices and returns of approximately 1700 firms between 1989 and 2019. We would like to calculate the cumulative return per month per company and many websites online tell us to use log returns. However, since returns are bound to be negative between some months as well, we can't take the log of these numbers resulting in missing data. What would be the best way to calculate the cumulative returns in this scenario?
Related Posts with Cumulative return calculation
Help with Longitudinal SEM - (Missing Means in Output)Hello! I'm having trouble running SEM on longitudinal data (4 waves - (same group followed over tim…
Dummy VariableHow do I create a dummy variable which takes the value 1 in a household when first two children are …
Create a new variable based on two other variablesHi Statalist. I would like to create a variable (total household assets) based on the values of tot…
Question about Mixed effect modelDear all. I am looking for wise advice on what happened to my mixed effect model from the STATA expe…
Help create a person ID for panel dataDear Statalisters, I would like to ask for advice regarding creating person ID variables from a hou…
Subscribe to:
Post Comments (Atom)
0 Response to Cumulative return calculation
Post a Comment