2. Download the relevant stock data you want to learn to execl.

3. Use execl to calculate their covariance and other statistics. If not, the easiest way is to draw their scatter charts automatically with execl to see if they are linearly related.

4. If you are skilled, you can get the above work in 10 minutes. I have studied many similar things. For example, the relationship between the US dollar index and CCB, oil and gold, Shanghai Stock Exchange and London Copper, and so on. It was fun.