The Excel sheet lines up the Shanghai index date with Gold price in US$ date first by using the average of neighbor days for USA holidays, and then calculates the bi-weekly Pearson covariance, as well as Steed upper and down semi-covariance, over 20 years between 2019 and 1999, the grap...