Incorrect Level 1 values

[Kasper]

Hello,

Can you check if Range% values for Day/52W are correct in columns? They seem too high for Day and too low for 52 week.

Thanks.

Edited December 18, 2022 by Kasper

[Jerry Medved]

That's just a computation based on the corresponding high,low and last. What values are shown and what data feed are you using

[Kasper]

The calculation is slightly different with each data feed, but that's due to it's feed's speed.

Here's actual example with IB:

Symbol    AAPL  Last    136.50 Low  133.73    High 137.65        Rng    3.92    Rng % 70.66326531

I calculated below for same data feed.

SetScanResultColumnName(0,"Range%");
SetScanResult(0,((SymbolData.High - SymbolData.Low) * 100 / SymbolData.Last));

Range%    2.871795

[Jerry Medved]

Your formula is wrong. Should be 

( last - low) / (high - low)

[Kasper]

Thanks for clarifying your formula. Mine was based on my understanding of description of this column in MT help docs. i.e. Range as % of price.

The formula you shared is similar to IV rank formula, but for price.