Current location - Trademark Inquiry Complete Network - Futures platform - How to calculate the correlation between futures and stocks? Is there any calculation formula? thank you
How to calculate the correlation between futures and stocks? Is there any calculation formula? thank you
1. Download futures data to execl.

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.