Geomean on returns with negative values?

7 Ansichten (letzte 30 Tage)
riccardo manfredi
riccardo manfredi am 22 Jan. 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

Akzeptierte Antwort

dpb
dpb am 22 Jan. 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
  3 Kommentare
dpb
dpb am 23 Jan. 2020
Bearbeitet: dpb am 23 Jan. 2020
That's the definition for economic returns..."you can look it up" :)
riccardo manfredi
riccardo manfredi am 23 Jan. 2020
perfect, thanks again

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Portfolio Optimization and Asset Allocation finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by