Yearly range analysis: results lack accuracy

Optuma Scripting
1

Hi, I want to know whether a stock closes Inside the previous Year’s range (high to Low) and I can’t get accurate results every time. See attached results of inconsistent data. It is working with other timeframes.

Thanks
Marc

Exported-Workbook-1.owb (227 KB)

2

Hi Marc,

Do you mean the last calendar year (2021) or the last year (12 months Sept 21 - Sep 22)?

The Yearly chart is based on yearly data, but your formula is using the last 12 months.

Note that to save resources and improve speed the watchlist only loads one year of data for each member of the list, from which the column values are calculated. Change the Date Range property in the watchlist to Last 5 Years and use the following to show those trading with 2021’s range:

L1 = LOW(Year(PERIODAMOUNT=1), OFFSET=1); 
H1 = HIGH(Year(PERIODAMOUNT=1), OFFSET=1); 
CLOSE()>L1 and CLOSE()<H1
3

Changing the date Range made it work indeed. I am interested in calendar year but I could not make it work (so I have tried with bar by bar)

Thank you
Marc