Finding a Watch List of stocks that have risen 20% per year for 5 Years

Optuma Forums Optuma Scripting Finding a Watch List of stocks that have risen 20% per year for 5 Years

Tagged: 

  • This topic has 4 replies, 2 voices, and was last updated 3 days ago by Brad.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #64869
    Brad
    • Topics: 7
    • Replies: 16
    • Posts: 23

    Hello,
    I have been trying to generate a list of strongly trending Stocks from ie Nasdaq 100 or ASX100 that have risen by greater than an average of 20% per year for the last 5 Years, or greater than 100% total over the last 5 years but are thinking there might be a better way to do it.

    This criteria may need to be altered, depending on the Index used.

    The Script I have been using is as follows –
    ((CLOSE() – CLOSE()[2530]) / (CLOSE()[2530]) * 100) > 400

    I have created this scan in the Scanning Manager, using the current date, selecting Nasdaq 100, Historical, Time Frame = 1 day.

    Am I on the right track here or is there a better way to do this?

    Thanks for your help,

    Brad

    #64883
    Darren
    • Topics: 66
    • Replies: 617
    • Posts: 683

    Hi Brad,

    You can use the ARR() function to calculate the Annual Rate of Return. For 5 years use ARR(PERIODAMT=5).

    NOTE: because the default watchlist only loads one year of data you will need to change the Date Range in the Properties to 10 years so enough data is available for the calculation to be made.

    In this ASX100 list, XRO has gained an average of 48% per year over the last 5 years. Note this doesn’t mean every year has been +20%, only the compounded gain has averaged 20% (if you wanted to look for every year +20% you can use the same concept to calculate quarterly performance described here).

    Capture

    #64911
    Brad
    • Topics: 7
    • Replies: 16
    • Posts: 23

    Thank you for your reply Darren.

    Would it be possible to find say just the 20 strongest percentage gain stocks of an Index ie ASX100 over the last 5 years, using ARR() or another method.
    I have no idea how to code this.

    Thanks again for your help,

    Brad

    #64961
    Darren
    • Topics: 66
    • Replies: 617
    • Posts: 683

    Hi Brad,

    If you just need the top % performers over the last 5 years use this:

    Click on the text in the script editor window to change the parameters. Sign in here for an Introduction to scripting course to help you get started:

    https://learn.optuma.com/course/introduction-to-scripting/

    #64967
    Brad
    • Topics: 7
    • Replies: 16
    • Posts: 23

    Thank you Darren.

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

Pin It on Pinterest