Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

stock positive x% of the time and up x% of the time over x number of days. Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
brandy05
Posted : Friday, July 15, 2005 1:30:10 PM
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
Craig_S
Posted : Friday, July 15, 2005 2:03:32 PM


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!
brandy05
Posted : Friday, July 15, 2005 10:29:21 PM
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!
Craig_S
Posted : Friday, July 15, 2005 10:32:24 PM


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!
brandy05
Posted : Friday, July 15, 2005 11:37:08 PM
Registered User
Joined: 6/21/2005
Posts: 10
OK, let's try 30 days.

Thanks again
Bruce_L
Posted : Saturday, July 16, 2005 3:18:23 PM


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
brandy05
Posted : Saturday, July 16, 2005 11:10:48 PM
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.

Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.