Yearly range analysis: results lack accuracy

Optuma Forums Optuma Scripting Yearly range analysis: results lack accuracy

  • This topic has 2 replies, 2 voices, and was last updated 2 weeks ago by Marc.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #69329
    Marc
    • Topics: 21
    • Replies: 34
    • Posts: 55

    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

    #69333
    Darren
    • Topics: 71
    • Replies: 880
    • Posts: 951

    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:

    #69335
    Marc
    • Topics: 21
    • Replies: 34
    • Posts: 55

    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

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest