Formula Help

[rsrobinson]

Could anyone help me with a formula please.
I'm hoping it should be quite easy.

I want the explorer to search for an all time high.(or highest high in loaded data)
I then want to check if the current closing price is near %50 of this all time high.
(say within 5% of it)

I also want to find the all time low (or lowest low in loaded data) as well as the all time hiigh or highest high in loaded data)
I then need to find the point 50% between these two values (highest high and lowest low) and check if the closing price is near this value (say withing 5% of it)

These should equate the the Gann G1 level and Gann G2 level

Any help would be much apprecieted

 

[ugkash]

close price within range of high / low prices

hello rsrobinson
These 3 queries you can run
1. to find highest high and close within 5% of this value

you may name the query as --try high

COLA
CLOSE
COLB
HHV(HIGH,260)

FILTER
When(colA>(colB-colB*.05))

2. to find LOWEST LOW and close within 5% of this value

you may name the query as --try low

COLA
CLOSE
COLB
LLV(LOW,260)

FILTER
When(colA<(colB+colB*.05))

3. To find 50% of high-low and then close within 5% of this value
you may name the query as Highlow

COLA
CLOSE
COLB
HHV(HIGH,260)
COLC
LLV(LOW,260)

FILTER
When(colA>((colB-colC)/2)*.05) OR When(colA<((colB-colC)/2)*.05)

I have chosen 260 days factor to find yearly high. You can replace it with actual number of days in your loaded data.

I hope this solves your query

 

[rsrobinson]

Gann

Thats perfect.
I can adapt this code to be exactly what i want

thank you very much