| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
 Gold Customer
Joined: 3/14/2005
Posts: 2
|
Please proivde formulas for the following:
1) 1 day price increase of at least 5% on all optional stocks
2) Same for 2-5 days with no decline in stock price during any days in the period
3) 1 day decrease of at least 5% on all optionable stocks
4) Same for 2-5 days with no increase in stock price during any of the days in the period
5) scan for any stock that both rose and fell a minimum of 3% in the same trading day
Your assistance is greatly appreciated
Rick Selimos
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Welcome to the forums. A very good foundation for learning how to use TeleChart can be gained by reviewing the following:
If you are new to TeleChart READ THIS FIRST!
The Personal Criteria Formula Language does not have syntax for referencing fundamentals such as if a stock is or is not Optionable. The Optionable portion of your requests must be done by using the built in Optionable Stocks Fundamental System Criteria as an EasyScan Condition.
Using EasyScan to find stocks that meet your own criteria
Definitions of all built in scanning and sorting criteria
QUOTE (rselimos) 1 day price increase of at least 5%...
Please try the following Personal Criteria Formula:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
C >= C1 * 1.05
QUOTE (rselimos) Same for 2-5 days with no decline in stock price during any days in the period
Please try the following Personal Criteria Formula:
(C >= C2 * 1.05 AND C >= C1 AND C1 >= C2) OR (C >= C3 * 1.05 AND C >= C1 AND C1 >= C2 AND C2 >= C3) OR (C >= C4 * 1.05 AND C >= C1 AND C1 >= C2 AND C2 >= C3 AND C3 >= C4) OR (C >= C5 * 1.05 AND C >= C1 AND C1 >= C2 AND C2 >= C3 AND C3 >= C4 AND C4 >= C5)
QUOTE (rselimos) 1 day decrease of at least 5%...
Please try the following Personal Criteria Formula:
C <= C1 * .95
QUOTE (rselimos) Same for 2-5 days with no increase in stock price during any of the days in the period
Please try the following Personal Criteria Formula:
(C <= C2 * .95 AND C <= C1 AND C1 <= C2) OR (C <= C3 * .95 AND C <= C1 AND C1 <= C2 AND C2 <= C3) OR (C <= C4 * .95 AND C <= C1 AND C1 <= C2 AND C2 <= C3 AND C3 <= C4) OR (C <= C5 * .95 AND C <= C1 AND C1 <= C2 AND C2 <= C3 AND C3 <= C4 AND C4 <= C5)
QUOTE (rselimos) scan for any stock that both rose and fell a minimum of 3% in the same trading day
Please try one of the following Personal Criteria Formulas:
Price Range of at least 3%:
H / L >= 1.03
High above and Low below Open by at least 3%:
H / O >= 1.03 AND L / O <= .97
High above and Low below previous Close by at least 3%:
H / C1 >= 1.03 AND L / C1 <= .97
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 3/24/2005
Posts: 40
|
Bruce - How can I write a negative boolean formula in TC? I haven't written one in a while and can't recall.
e.g. C<-.5 will give me an error if I try to do a % true indicator.
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
dmk112,
Put the negative number inside parentheses.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Gold Customer
Joined: 3/14/2005
Posts: 2
|
Bruce:
When I try to test any of the formulas provided the result comes up false with the market criterion i.e the one day increase of 5% the market criterion exception states "market days needed to calculate criterion 2"., for five days the market criterion required is 6. Not sure what to do to correct can you assist?
Thanks
Rick
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
rselimos,
Both messages are informative and not error messages. False simply means the formula is not True for the test symbol. The number of market days required is provided to let you know the formula will not calculate for symbols with less data than indicated.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |