Hi guys
Is it possible to build a composite plot of multiple historical periods with different start dates and project that over current data?
By way of example, I include a chart showing a series of years all starting 1 Jan and all ending in 8 (Eg 1) - the single plot I’d be interested in would be a daily average - in percent - calculated from the start dates defined.
Secondly, is there any way to calculate a correlation coefficient between two or more historical comparisons (Eg 2) that appear similar to one another?
Thanks
Andrew