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
Remove axes from twoway with by()Hi, Any ideas on how to remove the x-axis from all panels in a twoway graph with the by-option? I h…
Correlations between two variables repeatedly measuredHi, I have a panel data of 30 subjects with 8 longitudinal observations each. I have measured 10 pl…
Merged dataset but converted date variables inaccurateHi I have two datasets, one is compustat data and the other is covenant violations (from Creditor C…
Inclusion of Instrumental Variables in a fixed effects regression.Hi. I am currently looking into the influence of natural disasters on human capital outcomes, throug…
Multiple Tasks in a MacroI know how to write simpel code of a macro to complete one task: e.g. drop obervations whose var1 va…
Subscribe to:
Post Comments (Atom)
0 Response to Cumulative return calculation
Post a Comment