- This topic has 4 replies, 2 voices, and was last updated 3 days ago by .
- You must be logged in to reply to this topic.
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()) / (CLOSE()) * 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,
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).
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,
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:
Thank you Darren.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
|cname||14 days||This cookie is set by Optuma. The cookies is used to store the users campaign selection for selecting the correct version of Optuma to trial and is "Necessary".|
|cookielawinfo-checbox-analytics||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".|
|cookielawinfo-checbox-functional||11 months||The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".|
|cookielawinfo-checbox-others||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.|
|cookielawinfo-checkbox-necessary||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".|
|cookielawinfo-checkbox-performance||11 months||This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".|
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.