Registered User
Joined: 1/21/2006
Posts: 1
|
I was hoping to obtain some clarification in regards to the formula indicated for tab d. Each attempt I have made, has yeilded a syntax error. I am unsure at this point if I am misunderstanding the the instructions provided or am simply typing out something incorrectly. Thank you in advance.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Here's what I come up with when I follow the directions in the Friday, April 13, 2007 Worden Report:
Buy Tab A:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 > AVG(STOC2.1,2))
Buy Tab B:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 > AVG(STOC2.1,2)) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9))
Buy Tab C:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 > AVG(STOC2.1,2)) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9)) AND (C > AVGC12) AND (C < (MAXC50 * 0.94))
Buy Tab D:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC12.3 < 65) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 > AVG(STOC2.1,2)) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9)) AND (C > AVGC12) AND C > MAXC55.1)
Buy Tab E:
(STOC8.3 > AVG(STOC8.3,3)) AND (STOC12.3 > AVG(STOC12.3,3)) AND (STOC4.3 > AVG(STOC4.3,3)) AND (STOC2.1 > AVG(STOC2.1,2)) AND ((AVGC20.2 < AVGC20.1) AND (AVGC20.1 < AVGC20)) AND (STOC30.4 > AVG(STOC30.4,5)) AND (TSV17 > AVG(TSV17,9)) AND (C > AVGC12) AND (C < (MAXC50 * 0.94))
Sell Tab A:
(STOC4.3 < AVG(STOC4.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 77) AND (STOC2.1 < AVG(STOC2.1,2))
Sell Tab B:
(STOC4.3 < AVG(STOC4.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 77) AND (STOC2.1 < AVG(STOC2.1,2)) AND (C < AVGC12) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 78)
Sell Tab C:
(STOC4.3 < AVG(STOC4.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 77) AND (C < AVGC12) AND (STOC2.1 < AVG(STOC2.1,2)) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 78) AND (STOC60.10 < AVG(STOC60.10,10)) AND (STOC60.10 < 78)
Sell Tab D:
(STOC4.3 < AVG(STOC4.3,3)) AND (STOC12.3 < AVG(STOC12.3,3)) AND (STOC12.3 < 77) AND (C < AVGC12) AND (STOC2.1 < AVG(STOC2.1,2)) AND (STOC30.4 < AVG(STOC30.4,5)) AND (STOC30.4 < 78) AND (STOC60.10 < AVG(STOC60.10,10)) AND (STOC60.10 < 78) AND (TSV17 < AVG(TSV17,9))
You may send also an email to Sir Geologist'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.
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
Customize the Information Displayed in the WatchList
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 3/4/2005
Posts: 94
|
Bruce:
Would you create a backscan for Buy Tab C:
(STOC8.3 > AVG(STOC8.3,3)) AND
(STOC12.3 > AVG(STOC12.3,3)) AND
(STOC12.3 < 65) AND
(STOC4.3 > AVG(STOC4.3,3)) AND
(STOC2.1 > AVG(STOC2.1,2)) AND
((AVGC20.2 < AVGC20.1) AND (
AVGC20.1 < AVGC20)) AND (
STOC30.4 > AVG(STOC30.4,5)) AND
(TSV17 > AVG(TSV17,9)) AND
(C > AVGC12) AND
(C < (MAXC50 * 0.94))
Thanks in advance.
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
Here is a set of conditions based on what you gave above. Notice how I mostly combined conditions already in the Web Library. Make sure you review each condition to see how they are constructed.
Save it in the following folder:
\My Documents\Block Files\Tool Parts\BackScan Conditions
Once there, you can add it in your BackScan via the ADD CONDITION button and choosing MY COMPUTER.
Attachments:
VAbear condition set.scond - 34 KB, downloaded 683 time(s).
- Craig
Here to Help!
|
Registered User
Joined: 3/4/2005
Posts: 94
|
Craig:
Needless to say it worked well, thank you very much.
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
My pleasure
- Craig
Here to Help!
|