Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 6/21/2005 Posts: 10
|
Hi, I'm new to Worden and hope you can help me with the following question: I would like to scan for stocks that are up (positive) X percent of the time, and are up x amount of cents on average for the prior x number of days. For example, this scan might produce the following list: 1. Out of the universe of stocks those with the most average days up in the last x days 2. From the list produced by number 1 show the top 20 stocks in decending order 3. with the average number of cents they were up So its possible that symbol XYZ was up 94% of time in the last 30 trading days, with an average of .17 increase each up day. This could be the number one stock-- followed by a list of the others stocks in decending order. I hope my explanation is clear enough to allow you to come up with a scan. I'll look forward to hearing from you
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
I think I can come up with something for you. Can you give me a time frame to work with (The X in X number of days)?
- Craig Here to Help!
|
|
Registered User Joined: 6/21/2005 Posts: 10
|
Craig,
Would it be possible to choose the number of days each time the scan is run? If this is possible, then the user can run various scans periods which would be very useful.
Thanks!
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
You would have to create a condition for every time frame.
What is one of your ideal time frames? I will work with that then you can adapt as needed.
- Craig Here to Help!
|
|
Registered User Joined: 6/21/2005 Posts: 10
|
OK, let's try 30 days.
Thanks again
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I'm going to provide three Personal Criteria Formulas for use in EasyScans and as Sorts. The first is just the percentage of the time the symbol was up over the last 30 Periods. The second is the total increase during up periods (I thought it might be useful) and the third is the average increase during up periods:
C>C1%True30: 100*((C>C1) +(C1>C2) +(C2>C3) +(C3>C4) +(C4>C5) +(C5>C6) +(C6>C7) +(C7>C8) +(C8>C9) +(C9>C10) +(C10>C11) +(C11>C12) +(C12>C13) +(C13>C14) +(C14>C15) +(C15>C16) +(C16>C17) +(C17>C18) +(C18>C19) +(C19>C20) +(C20>C21) +(C21>C22) +(C22>C23) +(C23>C24) +(C24>C25) +(C25>C26) +(C26>C27) +(C27>C28) +(C28>C29) +(C29>C30))/(-30)
C>C1Total$30: ((C>C1)*(C-C1) +(C1>C2)*(C1-C2) +(C2>C3)*(C2-C3) +(C3>C4)*(C3-C4) +(C4>C5)*(C4-C5) +(C5>C6)*(C5-C6) +(C6>C7)*(C6-C7) +(C7>C8)*(C7-C8) +(C8>C9)*(C8-C9) +(C9>C10)*(C9-C10) +(C10>C11)*(C10-C11) +(C11>C12)*(C11-C12) +(C12>C13)*(C12-C13) +(C13>C14)*(C13-C14) +(C14>C15)*(C14-C15) +(C15>C16)*(C15-C16) +(C16>C17)*(C16-C17) +(C17>C18)*(C17-C18) +(C18>C19)*(C18-C19) +(C19>C20)*(C19-C20) +(C20>C21)*(C20-C21) +(C21>C22)*(C21-C22) +(C22>C23)*(C22-C23) +(C23>C24)*(C23-C24) +(C24>C25)*(C24-C25) +(C25>C26)*(C25-C26) +(C26>C27)*(C26-C27) +(C27>C28)*(C27-C28) +(C28>C29)*(C28-C29) +(C29>C30)*(C29-C30))*(-1)
C>C1Average$30: ((C>C1)*(C-C1) +(C1>C2)*(C1-C2) +(C2>C3)*(C2-C3) +(C3>C4)*(C3-C4) +(C4>C5)*(C4-C5) +(C5>C6)*(C5-C6) +(C6>C7)*(C6-C7) +(C7>C8)*(C7-C8) +(C8>C9)*(C8-C9) +(C9>C10)*(C9-C10) +(C10>C11)*(C10-C11) +(C11>C12)*(C11-C12) +(C12>C13)*(C12-C13) +(C13>C14)*(C13-C14) +(C14>C15)*(C14-C15) +(C15>C16)*(C15-C16) +(C16>C17)*(C16-C17) +(C17>C18)*(C17-C18) +(C18>C19)*(C18-C19) +(C19>C20)*(C19-C20) +(C20>C21)*(C20-C21) +(C21>C22)*(C21-C22) +(C22>C23)*(C22-C23) +(C23>C24)*(C23-C24) +(C24>C25)*(C24-C25) +(C25>C26)*(C25-C26) +(C26>C27)*(C26-C27) +(C27>C28)*(C27-C28) +(C28>C29)*(C28-C29) +(C29>C30)*(C29-C30))/((C>C1) +(C1>C2) +(C2>C3) +(C3>C4) +(C4>C5) +(C5>C6) +(C6>C7) +(C7>C8) +(C8>C9) +(C9>C10) +(C10>C11) +(C11>C12) +(C12>C13) +(C13>C14) +(C14>C15) +(C15>C16) +(C16>C17) +(C17>C18) +(C18>C19) +(C19>C20) +(C20>C21) +(C21>C22) +(C22>C23) +(C23>C24) +(C24>C25) +(C25>C26) +(C26>C27) +(C27>C28) +(C28>C29) +(C29>C30))
You can add C>C1%True30 to your universe as an EasyScan and adjust the Rank or Value to get about twenty stocks and then sort by any of the three conditions. Alternately, you could sort your universe by C>C1%True30, flag the top twenty symbols and sort the All Flagged Items system Watchlist by the condition of your choice. You may want to watch the following videos:
How to create a Personal Criteria Forumula (PCF) Using EasyScan to find stocks that meet your own criteria Constructing more versatile and reusable Personal Criteria Formulas How to use the Flagging feature Create your own stock rankings using WatchLists and Sort conditions
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 6/21/2005 Posts: 10
|
Craig and Bruce,
Thank you! Just what I am looking for.
I put C>C1%True30 in the PCF and it worked perfectly. Being new to Worden I will view the list of suggested video's and work on the other two PCF's. Hopefully, I can figure the rest out.
|
|
Guest-1 |