# Notes on Portfolio Correlation

Questions about MultiCharts and user contributed studies.
danilo
Posts: 170
Joined: 02 Jan 2007
Location: Italy
Has thanked: 4 times
Been thanked: 9 times

### Notes on Portfolio Correlation

Hi Marina,

I have built a correlated equity curve portfolio simulator, to simulate the equity curve I have used 2 correlated random numbers draw from a standard normal distribution, and then used few portfolio statistics (%WinngTrade, AverageTrade, Profit factor) to build a equity curve (*). As you can see the best metric that describe the portfolio correlation is the correlation on Return(%). The correlation calculated is lower than the one used for generate the random numbers because in a strategy the are other factors that force a correlation (**).

To have some meaning the correlations must be calculated on a lot of samples, so I will suggest to add the weekly correlation and eventually remove the annual one (since will use very few samples).

I would you ask to check also the way that is using MC to calculate the correlation:

1) to be calculated correctly the equity curves must be in SYNC, the correlation must be calculated on the same number of days and the days must be the same ( Date1[10]=14-Nov-08 -> Date2[10]=14-Nov-08 ) the gap must be filled with the previous equity values.

2) The calculation of Return(%) can give wrong correlation results if the equity line is negative, please when perform the calculation make sure to put the Initial Capital equal to Max Drawdown.

Regards,
Danilo

Notes:

(*) The method proposed by J.Ehlers in the book "Cybernetic Analysis for stocks and futures" is wrong if you try to apply it, you don't recover back the AverageTrade amount.

(**) If we apply a strategy on 2 assets and the strategy has the same Profict Factor and %WinningTrade the 2 equity curve will be forced to be quite correlated.
Attachments
EquityCurve_simulator (Corr).zip
Equity Curve Simulator

Marina Pashkova
Posts: 2758
Joined: 27 Jul 2007
Dear Danilo,
I would you ask to check also the way that is using MC to calculate the correlation:

1) to be calculated correctly the equity curves must be in SYNC, the correlation must be calculated on the same number of days and the days must be the same ( Date1[10]=14-Nov-08 -> Date2[10]=14-Nov-08 ) the gap must be filled with the previous equity values.
In MC, correlation is based on Profit(\$) and not on equity curve. Periods are synchronized. If Profit is not available for a certain period, its value is taken as 0.
2) The calculation of Return(%) can give wrong correlation results if the equity line is negative, please when perform the calculation make sure to put the Initial Capital equal to Max Drawdown.

The DeltaFactor for the correlation is calculated as follows:

DeltaFactor = Profit/ MaxAbsValue;

Where MaxAbsValue is the maximum (abolute) profit over the period.

Correlation is calculated according to the standard correlation formula.

As for the weekly analysis, we will consider its implementation for future. We are also going to keep the annual correlation for now: mathematically, it is enough to have to variables to calculate it.

Regards.