Hello Nicholas,
That does work…do an extent. However, in the case of charting a stock relative to the local price of the commodity, I cannot use the saved spread as an input reference for one of the relatives.
So, I could get a spread of AMS to XPTUSD. However, I cannot then use this to chart the relative of [AMS/XPTUSD] / [XPTUSD*USDZAR] –
or in simple terms, the price movement of Anglo American Platinum (AMS) relative to the Platinum price in South African Rand (ZAR). The formula would be AMS/(XPTUSD*USDZAR)
I cannot use a coefficient as the currency price is not fixed and constantly moves around. If there was a third (or more) stock code available, I could probably do this (BODMAS?). However, I cannot add a third one nor am I able to reference a personal spread already calculated.
Many thanks