Hope you are well. I see some investors use a beta coefficient [Beta = correlation(STD of market/STD of index)], where the correlation and standard deviation is based on returns (close – close[1])/close[1]. I am interested in testing beta in a trading strategy but I need a correlation function with an index.
I don’t think this is possible. You can add another market or index to your chart visually but there is no way to make calculations with the second set of data.