Good afternoon,
I need to populate a Correlation Table (for stock prices throughout time).Attachment 314526
Please see excel sheet below.
Good afternoon,
I need to populate a Correlation Table (for stock prices throughout time).Attachment 314526
Please see excel sheet below.
In B2:
=CORREL(OFFSET(Main!$C$1,MATCH($A2,Main!$A$2:$A$13,0),0,COUNTIF(Main!$A$2:$A$13,$A2)),OFFSET(Main!$C$1,MATCH(B$1,Main!$A$2:$A$13,0),0,COUNTIF(Main!$A$2:$A$13,B$1)))
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks