Registered User Joined: 12/22/2004 Posts: 4
|
Hi There,
I'm new to TC2000 and it's EasyScan/PCF functions and I'm trying to determine how much these can be customised. I've watched the tutorials I received on CD and have checked these forums and still have some questions. Thanks in advance for any guidance.
To make a long story short, a recent trading course pointed me to Reuters' Power Screener, which allows for a similar function to TC's EasyScans. However, now that I'm a TC user, I'm trying to setup the same formulas so that I only have to refer to TC.
I see that there are a number of built-in formulas for EPS and dozens of other criteria, but am not sure of the formula syntax which would allow me to customise my own. For example, if I want to have an EasyScan filter for the EPS Growth Rate over 3 years,.. or if I want the Sales Percent Change year over year...
Is there an advanced EasyScan/PCF tutorial or lists of syntax or examples? While I'm new to this, most of it will be over my head, but the screens that I'm familiar with (such as those I listed above) I am eager to continue using within TC, and these will then lead me into learning more advanced filters, etc.
Thanks much for any assistance.
Always in the pursuit of knowledge, Drew
|
|
Registered User Joined: 11/16/2004 Posts: 105
|
818767, Not sure if Reuters syntax funtions are convertible over to TC2000's PCF's. But I have found numerous formulas to a variety of screening applications in the Worden Notes archives.
http://orders.worden.com/knowledgebase/(rwihy22mimowp0f1xshsd145)/wb_login.aspx
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
At this time, fundamentals cannot be used in writing formulas. You should find that the fundamental criteria furnished in the program is quite vast.
- Craig Here to Help!
|
|
Registered User Joined: 12/22/2004 Posts: 4
|
Thanks for the link to those archives Bucket Shop,.. didn't know they existed, so I've got plenty of reading to do!
Also, while it's perhaps not the news I was after, thanks for clearing up the situation Craig... I'll stick with Reuters for those custom fundamental filters for now then... either way, TC covers just about everything else under the sun, enough to keep me learning for plenty of time!
Cheers! Drew
|
|
Registered User Joined: 12/30/2004 Posts: 1
|
How do you do a new Easyscan with 5% increase in price, 30% increase in value, stock just broke ema and mscd rsi upturn?
or
Is there a program that can help me with the Easyscan?
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 4,308
|
I'll need you to clarify a few things.
1. What do you mean by a 30% increase in value? 2. Which EMA are you interested in? 3. What does mscd stand for? Did you mean MACD? 4. You're looking for an upturn in both MACD and RSI?
- Doug Teaching Online!
|
|
Registered User Joined: 1/7/2005 Posts: 1
|
Gentlemen: I'm even newer than Drew. Know nothing other than using TC Easy Scan. Ok, I need a list of stocks that max. high over the last 60 days. Using PCFs? How to write it? Thanks in advance for sparing minuites for me. FFL
ps. Hope I can find my way back for the answer.
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 4,308
|
H = MAXH60
You can use the simple formula above in an EasyScan, or you can just use it to sort any watchlist. Any stock that returns a true will be a stock where today's high is a 60 day high.
- Doug Teaching Online!
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
I am looking for a way to make easy scan for a MACD crossover. (specifically for 8,17,9 but I think I can plug in the numbers) If you help me it will make my month! -Phillip
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
Phillip, are you looking for the MACD to cross zero or for the two lines of MACD to cross?
Your MACD crossing Zero: ((AVGC8 - AVGC17)>0 AND (AVGC8.1 - AVGC17.1)<0) or ((AVGC8 - AVGC17)<0 AND (AVGC8.1 - AVGC17.1)>0)
Your MACD crossing its moving average (or the histogram crossing 0). ((AVGC8 - AVGC17) > (AVG(AVGC8,9)-AVG(AVGC17,9)) AND (AVGC8.1 - AVGC17.1) < (AVG(AVGC8.1,9)-AVG(AVGC17.1,9))) or ((AVGC8 - AVGC17) < (AVG(AVGC8,9)-AVG(AVGC17,9)) AND (AVGC8.1 - AVGC17.1) > (AVG(AVGC8.1,9)-AVG(AVGC17.1,9)))
- Craig Here to Help!
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
How can I do that using a MACD for (5,34,1)?
Where would I place these number in the equation above? Also does the above formula let you see when MACD closes below the zero line or above it?
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
This is what I used but I keep getting a syntax error.
((AVGC5 - AVGC34) > (AVG(AVGC5,1)-AVG(AVGC34,1)) AND (AVGC5.1 - AVGC34.1) < (AVG(AVGC5.1,1)-AVG(AVGC34.1,1))) or ((AVGC5 - AVGC34) < (AVG(AVGC5,1)-AVG(AVGC34,1)) AND (AVGC5.1 - AVGC34.1) > (AVG(AVGC5.1,1)-AVG(AVGC34.1,1)))
Where I did go wrong? Also writing PCFs is really a unique feature for this program but are there any classes,books that teach you how to write equations? As when I look at the Formula examples from the help menu, I didn't see any reference to MACD equations nor did I see anything from the PCF Language Function List that could have helped me.
I believe that knowing how to write one's own PCF for what they are looking for is the key to unleasing this software's greatness.
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
AVG(AVGC5.1,1)
I don't understand this part of your formula. What are the exact MACD settings you are trying to find? Give me the exact settings from the chart and I will see what I can do.
There is not a MACD fuction in PCFs. MACD is only the difference of two moving averages, so it is easy to write forumlas for it.
Post your settings here so I can get you working.
- Craig Here to Help!
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
My MACD Settings is (5.34.1)
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
When you look at your MACD it shows as only one line, correct? With your period set to one, the average of MACD plots as the MACD.
The formula you are trying is looking for the MACD to cross its average. With an period of 1 there is nothing to cross.
What MACD pattern/action are you trying to uncover?
- Craig Here to Help!
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
Okay so using a period of 1 does not have anything to cross. How then could I write a formula for when MACD crosses over the zero line using a period of 1? Is it at all possible? Or should I use a MACD with a "fast" line & a "slow" line? And if so what kind of Average is consider a nominal period for a fast/slow line?
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
No problem!
Simple 5 34 1 crossing 0 ((AVGC5 - AVGC34)<0 AND (AVGC5.1 - AVGC34.1)>0) OR ((AVGC5 - AVGC34)>0 AND (AVGC5.1 - AVGC34.1)<0)
Exponential 5 34 1 crossing 0 ((XAVGC5 - XAVGC34)<0 AND (XAVGC5.1 - XAVGC34.1)>0) OR ((XAVGC5 - XAVGC34)>0 AND (XAVGC5.1 - XAVGC34.1)<0)
Try the one out that fits and let me know how it goes!
- Craig Here to Help!
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
Thanks. Your subheading, "Here to Help!" is realy an under rated statement.
|
|
Gold Customer
Joined: 12/19/2004 Posts: 108
|
Craig,
I've tried both the Simple & the Exponential. They both work nicely. I modified your Formula to show when it crosses up over the Zero Line and it works "perfectly" as to what I was looking for.
I thought I mentioned it to you.
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 18,819
|
- Craig Here to Help!
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
Hello Craig, Thank you for your help -this was usefull. I have still been trying to come up with MACD PCF and decided to have a question that was better crafted than last time before I asked you again. So here it goes.
I am looking for a PCF that shows a crossing upward on the histogram. I like this one (I don't remember where I got it - it may be from you):
(SGN((XAVGC8 - XAVGC17) - (XAVG(XAVGC8,9) - XAVG(XAVGC17,9))) + (SGN((XAVGC8.1 - XAVGC17.1) - (XAVG(XAVGC8.1,9) - XAVG(XAVGC17.1,9))) * - 1)) / 2 > 0
It works perfectly in so far as it goes. It shows that a upward crossover on the histograms happened since yesterday. Very handy.
Now First; I would like to add to this too, if you can help me (I, myself, am math stupid ) I am trying to show a upward cross on the Histogram not just since yesterday, but in the last 4 or 5 days and stayed above zero.
Second; It would be great to have a formula meeting the above conditions that also has maintaned momentum. In other words, the last line (day) on the histogram is no shorter than the previous one.
This may be a tall order and I would appreciate even part of it being filled.
Weather you can help me or not, I am gratefull for your efforts as well as the efforts all of you. You are all very GREAT - Phillip
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The following formula should only return True if the MACD8,17,9 Exponential Histogram is greater than or equal to yesterday, crossed up through zero four or five days ago, and stayed above zero since crossing up: XAVGC8-XAVGC17-XAVG(XAVGC8,9)+XAVG(XAVGC17,9)>=XAVGC8.1-XAVGC17.1-XAVG(XAVGC8.1,9)+XAVG(XAVGC17.1,9) AND XAVGC8.1-XAVGC17.1-XAVG(XAVGC8.1,9)+XAVG(XAVGC17.1,9)>0 AND XAVGC8.2-XAVGC17.2-XAVG(XAVGC8.2,9)+XAVG(XAVGC17.2,9)>0 AND XAVGC8.3-XAVGC17.3-XAVG(XAVGC8.3,9)+XAVG(XAVGC17.3,9)>0 AND (XAVGC8.4-XAVGC17.4-XAVG(XAVGC8.4,9)+XAVG(XAVGC17.4,9)<=0 OR XAVGC8.5-XAVGC17.5-XAVG(XAVGC8.5,9)+XAVG(XAVGC17.5,9)<=0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
WOW. Works perfectly- Thanks You are amazing Bruce. -Phillip
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
Actually I am confused by this- your formula didn't test positive on symbol "HRB" on after closing today, FEB 15th. But it crossed over on the histogram today. Why do you think this is?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The formula looks for items that crossed up four or five days ago and stayed up, not items that crossed up today or yesterday. Maybe I misunderstood what you were looking for.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
Yea , I can see how I wasn't clear. I am looking for something that didn't just cross over 4 or 5 days ago but 1, 2, 3, 4, or 5 days ago. My wording was bad- sorry. I know it shouldn't be hard for me to plug 1, 2 and 3 days ago, but I am not too good with these formulas. I am trying to plug in the right numbers to make it return true for cross on the histogram either 1, 2 or 3 days ago as well as 4 or 5 days ago. I am still using symbol HRB to test. I have tried it myself but it is still returning FALSE. Would you mind showing me how to append the formula you gave me to include a crossover either 1, 2, 3, 4 or 5 days ago, as well? Thank you, -Phillip
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The following formula should only return True if the MACD8,17,9 Exponential Histogram for today is greater than zero, greater than or equal to yesterday and crossed up through zero during the last five days:
XAVGC8-XAVGC17-XAVG(XAVGC8,9)+XAVG(XAVGC17,9)>=XAVGC8.1-XAVGC17.1-XAVG(XAVGC8.1,9)+XAVG(XAVGC17.1,9) AND XAVGC8-XAVGC17-XAVG(XAVGC8,9)+XAVG(XAVGC17,9)>0 AND (XAVGC8.1-XAVGC17.1-XAVG(XAVGC8.1,9)+XAVG(XAVGC17.1,9)<0 OR XAVGC8.2-XAVGC17.2-XAVG(XAVGC8.2,9)+XAVG(XAVGC17.2,9)<0 OR XAVGC8.3-XAVGC17.3-XAVG(XAVGC8.3,9)+XAVG(XAVGC17.3,9)<0 OR XAVGC8.4-XAVGC17.4-XAVG(XAVGC8.4,9)+XAVG(XAVGC17.4,9)<0 OR XAVGC8.5-XAVGC17.5-XAVG(XAVGC8.5,9)+XAVG(XAVGC17.5,9)<0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 1/15/2005 Posts: 13
|
Thank you very much Bruce, you guys are great! -Phillip
|
|
Registered User Joined: 2/1/2005 Posts: 78
|
Doug H,
Appreciate the answer yesterday concerning the formula for scanning new period closing lows, which you provided C=MINL21.
I could't get it to work and got a syntex error. Was I supposed to use bracket or parenthesis?
Is there a formula that I can scan for 2 periods (days) or more than have progressively closed lower, culminating "today" with a big negative change ($1 or more) in the price and on noticable heavy volume?
Will the formula I'm asking about also work if the period were to become an intraday period?
If there is a formula you can suggest, please tell me how I plug it into personal criteria and get it to work? Thanks, BuddhaBill
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 4,308
|
C=MINL21 should not give you a syntax error. Highlight it here and press CTRL-C to copy it. Then in your new PCF window, press CTRL-V to paste it into the window. Click the test button, and you should get a result of either TRUE or FALSE. If instead you get a syntax error, you'll need to contact our technical support department via email at support@worden.com or by phone at (919) 408-0542.
The new formula you are asking for will actually be an EasyScan. It will have the following conditions:
Condition 1: This will need to be a PCF. Call it Down Three Days Straight. The formula would be (C<C1) AND (C1<C2) AND (C2<C3). Use it in an EasyScan as a True/False condition.
Condition 2: This will need to be a PCF. Call it Net Change. The formula would be (C1-C)>=1. Use it in your EasyScan as a True/False Condition.
Condition 3: Use the built in condition Volume Surge Today as another scan condition. Set the Range Selector to a Rank of maybe 90 to MAX.
If you need instruction as to how to set up PCF's and Easy scans, you should watch the following two training videos:
Using EasyScan to find stocks that meet your own criteria How to create a Personal Criteria Forumula (PCF)
- Doug Teaching Online!
|
|
Worden Trainer
Joined: 10/1/2004 Posts: 4,308
|
This topic is being locked by the moderator. It has become a catch-all for PCF questions, and as a result, is less helpful than if each original PCF question had its own topic.
If you have a PCF question, or if you need help constructing a PCF, please go to the top of this link and click New Topic. Give the topic a descriptive name, and then post your question. Thanks!
- Doug Teaching Online!
|
|
Guest-1 |