Hi community,
The following is my code for determining correlation between 2 sets of points. Do you know how I would get this expression to work when either one of the data points is missing for a dimension value? It's the code for determining correlation between any two stocks and sometimes they arent traded on the same day and if this overlaps my selected time frame, I get no correlation line in the chart.
bottom
(rangecorrel(above((sum({$<Ticker*=Ticker3>}[Adj. Close])/count({$<Ticker*=Ticker3>}[Adj. Close])/
above(sum({$<Ticker*=Ticker3>}[Adj. Close])/count({$<Ticker*=Ticker3>}[Adj. Close]))-1),0,100),above((sum({$<Ticker*=Ticker2>}[Adj. Close])/count({$<Ticker*=Ticker2>}[Adj. Close])/
above(sum({$<Ticker*=Ticker2>}[Adj. Close])/count({$<Ticker*=Ticker2>}[Adj. Close]))-1),0,100)))