| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 10/7/2004
Posts: 39
|
In reading Sir Rotates Article this morning i need help in creating the following PCF-s that will give me Percentage Rank Change for PCF/s
50 day price change
5 day price cahnge
Many thanks for your prompt help.
TT
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You will want to use the following Personal Criteria Formulas as EasyScan Conditions:
50-Day Price Change:
C - C50
5-Day Price Change:
C - C5
You can then adjust the Percentile Ranks as desired using the EasyScan Rangefinder. You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Handy PCF example formulas to help you learn the syntax of PCFs!
Definitions of all built in scanning and sorting criteria
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 39
|
Thanks Bruce for PCF-s
In his article he had
"Total Net Income" 46 - 49
Can you explain to me what that means from a Fundamental point of view if you can.
TT
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
From Definitions of all built in scanning and sorting criteria:
Latest Total Net Income - Includes all the operations (continuing and discontinued) AND all the other income or charges (extraordinary, accounting changes, tax loss carryforward, and other gains and losses).
I cannot provide information beyond what has actually been provided in the Worden Report as to why this was used with these percentile ranks.
You may send an email to Sir Rotate's attention at support@worden.com to get further clarification from the author. These emails are forwarded and you should receive a response (at least from us). All e-mail communication sent to support@worden.com during business hours (Monday through Friday 9AM-11PM and Saturday and Sunday 9AM-3PM ET) should be answered within 20 minutes of arrival.
After Mr. Worden publishes an article, many times other customers have questions that can only be answered by the author of the article. We do not give out anyone’s email address or other personal information, rather, we will just forward their email on to the appropriate person. The individual may or may not choose to respond directly to you.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (Twinkletoes) In reading Sir Rotates Article this morning i need help in creating the following PCF-s that will give me Percentage Rank Change for PCF/s
50 day price change
5 day price cahnge
TT,
Sir Rotate wrote:
b. 50 day price change...74 to 99
c. 5 day price change... 1 to 37
but likely did not intend what was written. He probably intended something like:
b. 50 day price percent change...74 to 99
c. 5 day price percent change... 1 to 37
PCFs for the latter are:
b. 100*(C-C50)/C50
c. 100*(C-C5)/C5
Thanks,
Jim Murphy
|
|
Registered User
Joined: 9/22/2005
Posts: 849
|
b. PCF for 50 day price percent change . . . 74 to 99 would be
100*(C - C50) / C50 >= 74
c. PCF for 5 day price percent change . . . 1 to 37 would be
100*(C - C5) / C5 >= 1 AND 100*(C - C5) / C5 <= 37
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (bcraig73450) b. PCF for 50 day price percent change . . . 74 to 99 would be
100*(C-C50)/C50 >= 74
c. PCF for 5 day price percent change . . . 1 to 37 would be
100*(C-C5)/C5 >= 1 AND 100*(C-C5)/C5 <= 37
bcraig73450,
The numbers given by Sir Rotate are percentile rankings and not values of any PCFs.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 9/22/2005
Posts: 849
|
I agree Jim.
Sir Rotate was quoting percentile ranks, but Twinkletoes is asking for a PCF to return a stock which matches a specific percentile.
100*(C-C50)/C50 is a percentile which can range from -100 to +100 and can be put into a PCF to return a stock which matches that percentile.
That is what I gave in my post.
|
|
Registered User
Joined: 1/1/2005
Posts: 2,645
|
QUOTE (bcraig73450) 100*(C-C50)/C50 is a percentile which can range from -100 to +100 and can be put into a PCF to return a stock which matches that percentile.
bcraig73450,
The PCF:
100*(C-C50)/C50
returns a percentage; not a percentile. It returns a value greater than -100 and is unbounded above. Percentiles are between 0 and 100.
If one wants PCFs which return TRUE for stocks satisfying:
b. 50 day price percent change...74 to 99
c. 5 day price percent change... 1 to 37
they are:
b. 100*(C-C50)/C50 > 6.56
c. 100*(C-C5)/C5 < (-2.147)
for 07/20/07. The numbers on the right have to be changed with each new update.
Thanks,
Jim Murphy
|
|
Registered User
Joined: 9/22/2005
Posts: 849
|
I stand corrected, bustermu. 100*(C-C50)/C50 is a percentage which is unbounded on the up side and not a percentile.
I put my mouth into gear before my brain was fully engaged and I apologize.
|
|
Registered User
Joined: 3/1/2006
Posts: 5
|
Bruce,
Where do you find Easyscan RangeFinder? I want to use it to adjust Sir Rotates' values. Thanks.
Tom
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Check out this video to learn how to use a Range Selector: Using EasyScan to find stocks that meet your own criteria
- Craig
Here to Help!
|
|
|
Guest-1 |