The Honest Guide To Stock Trading - Creating A Correlation Matrix In Excel

In this video you will learn how to build your own correlation matrix in Excel with no previous Excel skills required. Your correlation matrix will help you to avoid a portfolio that has a high concentration of risk and to help keep your portfolio well diversified.

Downloads

  • Update June 2017....Yahoo Finance have discontinued their Free data API.
    Update June 2017....Yahoo Finance have discontinued their Free data API.

    Because Yahoo Finance have recently discontinued their free historical data API the Yahoo Finance ADD-IN no longer works. This means that you will currently have to manually import the data before refreshing the correlation matrix.

    I am currently working on a fix for the spreadsheet, but in the mean-time you are welcome to email me if you'd access to my correlation matrix formula for Amibroker.

All Videos

* Denotes Required Field