Question: how to calculate correlation coefficient of two stocks?
Answer: Select a Time Period. Begin by selecting a time period over which you will calculate the correlation between the two stocks. ... 
Calculate Mean and Deviation. Calculate the average price for each stock by adding up daily prices and dividing the sum by the number of days. ... 
Calculate the Coefficient. ... 
Use a Spreadsheet.