Relative strength scan using RIC

Optuma Forums Optuma Scripting Relative strength scan using RIC

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #57583
    DarrenDarren
    • Topics: 66
    • Replies: 576
    • Posts: 642

    The Relative Index Comparison function RIC() was used in this tweet to scan for new relative 3 month highs in the S&P500 using the following script in a scan (change the comparison index to that of your market, eg XJO for Australia, FTSE for the UK, or NIFTY for India).

    When the RIC tool is placed on the chart it will be at its highest point over the last 3 months:

    Capture

    To link a watchlist to a scan and so that it automatically updates see this short video:

    https://www.optuma.com/videos/linking-a-watchlist-to-a-scan/

    #57585
    Avatardeepak
    • Topics: 41
    • Replies: 27
    • Posts: 68

    Hii sir

     

    ur tweet results are in percentage how ever when i am applying it in workbook its in true false may be because of below command.

    //Is latest RIC > last 3 months?
    R1 > H1

     

     

    #57587
    DarrenDarren
    • Topics: 66
    • Replies: 576
    • Posts: 642

    Thanks Deepak. The column in the tweet is a different measure and a different formula – it’s the performance relative to the SPX over the last 3 months:

    RIC(DATESEL=Last Quarter, ZEROBASED=True, INDEX=SPX:WI)/100

    • This reply was modified 1 year ago by DarrenDarren.
    #62215
    DarrenDarren
    • Topics: 66
    • Replies: 576
    • Posts: 642

    To change the RIC() lookback periods to something other than the default Last Month, Last Quarter, etc you can use this trick to set to something else.

    The first line finds the date 10 bars ago (2 trading weeks) which is then used in the second line for the Start_Date= field.

    You can use this script to build options for all the different time frames you were after by adjusting the value on the first line. So for 6 weeks you’d use a 30 bar (6 x 5 trading days) offset:

    $A = BARDATE()[30];

    The script can then be used in a Show View tool or Watchlist column:

    Capture

    1 user thanked author for this post.
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest

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