Building formulas for ichimoku on pi

For ICHIMOKU, I need the values for Past, Present and Future:

Pl help me with the following:

HHV(9) gives me highest high of 9 periods

Now, I need the go back 26 periods … say REF(Close,26) … and need Highest high of 9 periods from this point … Basically Highest High between 35 period and 26 period …

Many Thanks,


As per the above condition you can use


Many thanks for the quick response.