Ok, So my workbook contains 1 worksheet where user inputs 5 tickers and clicks button to download data. Each ticker received their own respective worksheet. How can I get a sheet to do side to side comparison of the 5 quotes (ending price) on the same worksheet after all 5 have already been downloaded?

My current code is:

Please Login or Register  to view this content.
I also have a button on the first worksheet which analyzes the data however it needs to be modified accordingly to my workbook because I received it from a co-worker. I need computation for mean, variance, and co-variance. I have mean and variance down however I am having difficulties with the co-variance. Any help of suggestions would be highly appreciated!

Here is my code for the computations:

Please Login or Register  to view this content.