Calculating the correlation....

Y

yk

Good day,

I was wondering if someone could point me out a resource that will give me the correlation between a stock and an index, stock and a stock, or vice versa.

There was an application on this board that someone uploaded, but it doesnt seem to be working.


Thanks...
 
Hitman,

I've just checked and Yahoo stills supplies historical quotes. I've down-loaded them many times into an excel spreadsheet and used the correlation function in excel to get a correlation coefficient. It's somewhat time consuming, but it's the only way I've run across.
 
Can you give me the link for historical quotes? I will update my macro. Also I need to take out the damn dividend crap.
 
You must log in or register to reply here.
Back
Top