New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
I am trying to create a scan using the PctChange function to get the percent change for the year of qqq etf going back to 2009 and then forward each year. the reason for the scan will be to put the % change for the qqq, a general scan and see how many etf"s beat the qqq in a specific year.
this is the scan I created:
// this scan has 1573 in the starting before the current trading day in that parameter
// or course if you run in tomorrow you would have to pull up the jan 4 2009 date in increase the number of days
//00 CHG MODEL %
[symbol starts with 'qqq ']
//&&&& PCT PARAM 1year = NUM DAYS-weeks PARM 2= % CHANGE
[weekly PctChange(52,close) < 0]
rank by weekly PctChange(52,close)
I used 52 in the weeks parameter because I want the scan to include the entire year of 2009
I had to use less than zero because I came up with a negative number for my results
if you do a performance chart the result should be around 48.27%
as you can see by the attached file this scan give a results of -33.88%
does any one have some ideas of what I am doing wrong.