Bar offset

[Jon]

Hello,

Is it possible to offset indicators (CCI, RSI, etc) similar to how you can offset in high, low, close? ie CCI 1 bar ago is above CCI 2 bars ago.

[James]

Hi Jon, this is how I do offsets.

V1 = RSI(BARS=5); V2 = OFFSET(V1, OFFSET=1); V3 = OFFSET(V1, OFFSET=2); V2 > V3

1 2 3 4 5 6

V1 = RSI(BARS=5); V2 = OFFSET(V1, OFFSET=1); V3 = OFFSET(V1, OFFSET=2); V2 > V3

Attached is a file with the formulas.
I hope this what you are looking for, Jamie

Attachments:

You must be logged in to access attached files.

[Jon]

That worked thanks alot James

[Darren]

Another option is to use square brackets for the offset, so [1] is the previous bar’s value, [2] is two bars ago, etc. The following works the same as Jamie’s code above:

V1 = RSI(BARS=5); V1[1]>V1[2]

1 2 3 4

V1 = RSI(BARS=5); V1[1]>V1[2]

[Jon]

Thank Darren, So would this example be appropriate with the brackets, MA(CALC=High, BARS=10)[1] – MA(BARS=10, CALC=Low)[1] ?

[Darren]

Correct – that would calculate the difference between yesterday’s moving average values.

[Jon]

Thanks D!

[Author]

Posts