| Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User
Joined: 12/17/2004
Posts: 10
|
Is it possible to construct PCF's for an EMA crossover Easy Scan?
I wish to write an Easy Scan for a crossober of 3o and 60 day EMS's.
|
|
Worden Trainer
Joined: 10/1/2004
Posts: 18,819
|
This should work:
XAVGC30>XAVGC60 AND XAVGC30.1<XAVGC60.1
Here are some videos to check out:
How to create a Personal Criteria Forumula (PCF)
Using EasyScan to find stocks that meet your own criteria
Understanding Moving Averages - Part I, The Basics
Understanding Moving Averages - Part II, Using Multiple Averages
Create PCFs and EasyScans to find moving average crossovers
Comparing indicators using Visual Difference sorts
- Craig
Here to Help!
|
|
 Gold Customer
Joined: 3/3/2013
Posts: 57
|
Hi Bruce,
I wanted to construct a crossover from either direction for the 50 eMA X the 100 ema. The formula I used marks ture for the S&P (& all the other stocks in my watchlist) but in reality, the 50 is not crossing the 100. Please post a good formula - one that is corriect. Thanks in advance.
SGN (XAVGC50 > XAVGC100) <> SGN (XAVGC50.1 - XAVGC100.1)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The Condition Formula needs to be written as:
SGN(XAVGC50 - XAVGC100) <> SGN(XAVGC50.1 - XAVGC100.1)
Note that there are not any spaces between the SGN and the ( and that the first > in your formula should in fact have been a - sign.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
I am looking for a simple PCF and for some reason the results are incorrect. 5dma< 10dma and c>200dma AvgC5< AvgC10 and C> AvgC200 what am I doing wrong? I know that there will be few instances but I am getting candidates wher 5dma < 10 dma but C>200dma which is not according to PCF inputs TY in advance!
|
|
Registered User
Joined: 10/7/2004
Posts: 794
|
Disregard previous request ...my bad
|
|
Gold Customer
Joined: 3/3/2013
Posts: 57
|
Thank you Bruce for straightening out the previous PCF.
2nd question: Trying to write a WEEKLY formula where the 5 moving avg crosses the eMA 10 during the last bar/week. Here's what I wrote but it doesn't jibe w/ my "Create Scan Conditon" command:
SGN(AVGC5.5 - XAVGC10.5) <> SGN(AVGC5.10 - XAVGC10.10)
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
In TC2000 version 12.3 or the TC2000 version 12.4 beta, you can just set the Time Frame drop-down to Weekly when creating or editing the following Condition Formula to check for a cross in either direction between the previous bar and current bar:
SGN(AVGC5 - XAVGC10) <> SGN(AVGC5.1 - XAVGC10.1)
You could also use this as a Percent True Indicator on a Weekly chart in TC2000 version 7 and even sort by the Percent True Indicator if desired.
Visually Backtesting Specific Symbols
Sorting price and indicators by their Actual Value
But if you wanted to do this as a Personal Criteria Formula in TC2000 version 7, you would need to create the weekly data using a daily time frame.
SGN((C + C5 + C10 + C15 + C20) / 5 - .1819803 * (C + 9 / 11 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170)))))))))))))))))))))))))))))))))))) <> SGN((C5 + C10 + C15 + C20 + C25) / 5 - .1819803 * (C5 + 9 / 11 * (C10 + 9 / 11 * (C15 + 9 / 11 * (C20 + 9 / 11 * (C25 + 9 / 11 * (C30 + 9 / 11 * (C35 + 9 / 11 * (C40 + 9 / 11 * (C45 + 9 / 11 * (C50 + 9 / 11 * (C55 + 9 / 11 * (C60 + 9 / 11 * (C65 + 9 / 11 * (C70 + 9 / 11 * (C75 + 9 / 11 * (C80 + 9 / 11 * (C85 + 9 / 11 * (C90 + 9 / 11 * (C95 + 9 / 11 * (C100 + 9 / 11 * (C105 + 9 / 11 * (C110 + 9 / 11 * (C115 + 9 / 11 * (C120 + 9 / 11 * (C125 + 9 / 11 * (C130 + 9 / 11 * (C135 + 9 / 11 * (C140 + 9 / 11 * (C145 + 9 / 11 * (C150 + 9 / 11 * (C155 + 9 / 11 * (C160 + 9 / 11 * (C165 + 9 / 11 * (C170 + 9 / 11 * (C175))))))))))))))))))))))))))))))))))))
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |