Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 3/8/2008 Posts: 20
|
First one
1. Moneystream crossing below its 20 day mov avg and above its 20 day mov avg today and 5 days ago.
2. Tsv 23 crossing below and above it's 12 day mov avg today and 5 days ago and Tsv 23 crossing above 0 today and 5 days ago Tsv 23 crossing below 0 today and 5 days ago thank you.
|
|
Registered User Joined: 1/28/2005 Posts: 6,049
|
Are these simple or exp.?
Thanks
diceman
|
|
Registered User Joined: 3/8/2008 Posts: 20
|
SIMPLE
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
jboogz2000,
Please try one or more of the following:
MS xUp its own SMA20:
MS > MS20 AND MS1.1 <= MS20.1
MS xDn its own SMA20:
MS < MS20 AND MS1.1 >= MS20.1
MS crossing its own SMA20 (either direction):
SGN(MS - MS20) <> SGN(MS1.1 - MS20.1)
MS xUp its own SMA20/5-Periods Ago:
MS1.5 > MS20.5 AND MS1.6 <= MS20.6
MS xDn its own SMA20/5-Periods Ago:
MS1.5 < MS20.5 AND MS1.6 >= MS20.6
MS crossing its own SMA20/5-Periods Ago (either direction):
SGN(MS1.5 - MS20.5) <> SGN(MS1.6 - MS20.6)
Simple TSV23 xUp its own SMA12:
TSV23 > AVG(TSV23,12) AND TSV23.1 <= AVG(TSV23.1,12)
Simple TSV23 xDn its own SMA12:
TSV23 < AVG(TSV23,12) AND TSV23.1 >= AVG(TSV23.1,12)
Simple TSV23 crossing its own SMA12 (either direction):
SGN(TSV23 - AVG(TSV23,12)) <> SGN(TSV23.1 - AVG(TSV23.1,12))
Simple TSV23 xUp its own SMA12/5-Periods Ago:
TSV23.5 > AVG(TSV23.5,12) AND TSV23.6 <= AVG(TSV23.6,12)
Simple TSV23 xDn its own SMA12/5-Periods Ago:
TSV23.5 < AVG(TSV23.5,12) AND TSV23.6 >= AVG(TSV23.6,12)
Simple TSV23 crossing its own SMA12/5-Periods Ago (either direction):
SGN(TSV23.5 - AVG(TSV23.5,12)) <> SGN(TSV23.6 - AVG(TSV23.6,12))
Simple TSV23 xUp Zero:
TSV23 > 0 AND TSV23.1 <= 0
Simple TSV23 xDn Zero:
TSV23 < 0 AND TSV23.1 >= 0
Simple TSV23 crossing Zero (either direction):
SGN(TSV23) <> SGN(TSV23.1)
Simple TSV23 xUp Zero/5-Periods Ago:
TSV23.5 > 0 AND TSV23.6 <= 0
Simple TSV23 xDn Zero/5-Periods Ago:
TSV23.5 < 0 AND TSV23.6 >= 0
Simple TSV23 crossing Zero/5-Periods Ago (either direction):
SGN(TSV23.5) <> SGN(TSV23.6)
You may wish to review the following:
How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/8/2008 Posts: 20
|
thanks
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
jboogz2000,
You're welcome. Our pleasure.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 3/8/2008 Posts: 20
|
i need one more pcf
simple tsv 23 crossing below 0 today and has been above 0 last 10days
simple tsv38 crossing below 0 today and has been above 0 last 10 days
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
QUOTE (jboogz2000) simple tsv 23 crossing below 0 today and has been above 0 last 10days
TSV23 < 0 AND MIN(TSV23.1,10) > 0
QUOTE (jboogz2000) simple tsv38 crossing below 0 today and has been above 0 last 10 days
TSV38 < 0 AND MIN(TSV38.1,10) > 0
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |