Correlation Analysis

Discussion in 'Technical Analysis' started by ImamicPH, Jul 17, 2006.

  1. FWIW if I were trying to compare the prices evenly I would use Excel's PERCENTRANK function. Of course you'd want a large number (100+) of prices for each commodity/equity, for this method. As others have said, it's easier to compare the percent changes of the prices, and/or use CORREL. However with PERCENTRANK you would be able to draw some graphs and quickly visually tell if further investigation was warranted...
    #21     Jul 18, 2006
  2. AlexFX


    #22     Jul 18, 2006
  3. rosy


    a portfolio's correlation is obtained by taking the correlation between each pair in the portfolio and then averaging them. you can do it in a few seconds or pay someone a lot to do it for you.
    #23     Jul 18, 2006