Registered User
Joined: 11/10/2004
Posts: 21
|
I'm interested in a PCF that will look for stocks that rallied significantly in the last 90 days of each calender year. Defining a 'significant rally' is one variable to tweak, say starting with 300% over 90 to 120 day period. I'm having trouble slicing the MA's over the 240 day period prior, to compare with.
Thanks in Advance....
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
I would use the date format in a PCF
Find your range of dates from year to year and replace the dates I use below. Be sure you use only market days when you pick your dates.
Here is a PCF that returns the average return for the month of July for the last three years:
(((C'7/29/05'-C'7/1/05')/C'7/1/05') + ((C'7/31/03'-C'7/1/03')/C'7/1/03') + ((C'7/30/04'-C'7/1/04')/C'7/1/04'))/3*100
Pick your dates and using the above template you should have no trouble writing this PCF for any dates. You may also like how Doug uses Custom Date Sort in this video:
Industries With Consistent Performance over Specific Time Periods
- Craig
Here to Help!
|