New 52 week highs and lows

Optuma Forums Optuma Scripting New 52 week highs and lows

This topic contains 1 reply, has 1 voice, and was last updated by Darren Darren 2 months, 1 week ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #46603
    Darren
    Darren
    • Topics: 28
    • Replies: 145
    • Posts: 173

    Use the HIGHESTHIGH() and LOWESTLOW() functions to scan for new highs and lows, for example over the last 52 weeks:

    For new closing highs nest CLOSE() in the highest high function:

    Similar for lowest lows, this time over 13 weeks:

    Closing lows:

    All-Time Closing Highs:

    Indicator Highs and Lows

    You can also scan for highest values of any indicator, such as RSI(14) over 13 weeks:

    Highest volume over the last month:

    Linking results to a watchlist

    If running a scan click on Export Results > Open Results As a watchlist and add columns, charts etc. That watchlist is now linked to the scan, so when the workbook is next opened the scan is run automatically and the list is updated with the latest results.

    Capture

    1 user thanked author for this post.
    #47847
    Darren
    Darren
    • Topics: 28
    • Replies: 145
    • Posts: 173

    To find a new high X days ago

    To find a high X days ago use the TIMESINCESIGNAL function. So to find a new 52 week high that occurred 2 days ago:

    • This reply was modified 2 months, 1 week ago by Darren Darren.
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

Pin It on Pinterest

Share This

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close