Geomean on returns with negative values?
12 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
riccardo manfredi
il 22 Gen 2020
Commentato: riccardo manfredi
il 23 Gen 2020
Hi, i need to calculate the geometric mean of financial returns (for a Markowtiz example), but obviously it won't work cause my data contains negative numbers. How can i do? Is there another function or i have to do it manually? Thanks
0 Commenti
Risposta accettata
dpb
il 22 Gen 2020
Use
GR=100*(prod(1+R/100)^(1/numel(R))-1);
where R is the rate of return for the period.
Example:
>> R=[9 1 2 3 -1]; % sample rate of returns, %
>> GR=100*(prod(1+R/100)^(1/numel(R))-1) % geometric rate of return
GR =
2.7458
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Portfolio Optimization and Asset Allocation in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!