Archibald112
New Member
Hi everyone,
I was trying to find some neat functions on excel to point out least correlated portfolio for investment.
I am attaching small excel file. Instruments are correlated... from investment point of view one wants least correlated markets in a portfolio. I can pick one by one and use the trial/error approach...
But there has to be a way using Excel to find scientific way to do it. Let's say I want to pick 3 least correlated instruments. How to do that in a scientific way on excel?
Any help is appreciated!
BR,
Archibald112
I was trying to find some neat functions on excel to point out least correlated portfolio for investment.
I am attaching small excel file. Instruments are correlated... from investment point of view one wants least correlated markets in a portfolio. I can pick one by one and use the trial/error approach...
But there has to be a way using Excel to find scientific way to do it. Let's say I want to pick 3 least correlated instruments. How to do that in a scientific way on excel?
Any help is appreciated!
BR,
Archibald112