HomeKnowledge Base

How to chart spreads?

To create a spread chart (and other multi-security indicators / statistics etc.) one can use FOREIGN function which allows to refer to other symbols than currently selected:

It’s necessary to do the following:
– Analysis -> Formula Editor
– enter the formula:

spread Foreign"ticker1""C") - Foreign"ticker2""C");

– Tools -> Apply Indicator
(replace ticker1, ticker2 with actual symbol names)

One Response to “How to chart spreads?”

  1. Rick Rogers
    April 25th, 2007 | 11:28 am

    Could you please provide an example of taking this spread one step further?
    With a 5 second database, how would I display in a one minute chart H,L,C bars of the spread utilizing the highest high and lowest low of the spread calculated in the base timeframe within the 1 minute bars? In other words I don’t want the one minute high of ticker1 – the one minute high of ticker2, etc.

    thank you