
In this ‘Product Insight’, we look at how correlation coefficients can potentially ‘break down’ during periods of extreme volatility. Refinitiv Datastream allows users to users to access a library of ‘functions’ which provide cloud-based calculations that are delivered instantly into either excel or charting environments. A library of approximately 85 functions span across categories including logical, mathematical, statistical, and technical to name a few. For correlation, we need to use the CORR# function: CORR#(Variable1,Variable2,Period/frequency). While straightforward to use within the product, interpreting the end output can be challenging depending on the inputs used. Certain considerations a user must consider include: