How do I join two series that have different scales?

You might want to  combine a series with another one that has a longer history, but unfortunately the scale of these two series is different. Joining two series can be done by using the following formulas:

JoinScaled(series1, series2)

JoinMoreHistoryScaled(series1, series2)

There is a difference between these two formulas regarding the order of the series in the expression.

JoinScaled will join ‘series2’ at the end of ‘series1’, while JoinMoreHIstoryScaled will add more history to “series1” using the values of “series2” that are before the start of “series1”.

For both of these formulas, a factor is applied to scale up the series:

JoinScaled: at the date of the junction, “series1” is scaled to be equal to the value of “series2”. The rest of the values of “series1” are then adjusted using the factor used at the date of the junction.

JoinMoreHistoryScaled: at the date of the junction, “series2” is scaled to be equal to the value of “series1”. The rest of the values of “series2” are then adjusted using the factor used at the date of the junction.