Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

pcf for price crossing mov avg Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
grantgoode
Posted : Wednesday, October 1, 2008 9:40:20 PM
Registered User
Joined: 2/6/2007
Posts: 9
I want to create a pcf for an easy scan that will detect when the closing price crosses the moving average from below the ma to above the ma...and then visa versa
Bruce_L
Posted : Thursday, October 2, 2008 8:14:43 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
The formula would depend on the Moving Average Period and Type. We can help you write the formula if you provide this information. The following topics might help you write the formula on your own:

Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
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
grantgoode
Posted : Sunday, October 5, 2008 12:58:35 PM
Registered User
Joined: 2/6/2007
Posts: 9

Hi Bruce...I posted this again...sorry...I had not read your response...let me work on it and see where I get...thanks..

grantgoode
Posted : Sunday, October 5, 2008 1:34:25 PM
Registered User
Joined: 2/6/2007
Posts: 9
Hi Bruce...I created one just using the examples...

C>XAVGC30  I am wanting to use this on a monthly chart...when I use it, it is not working properly...I assume there is something I need to change to utilize this with a monthly chart
Bruce_L
Posted : Monday, October 6, 2008 8:43:13 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
C > XAVGC30 would be a Personal Criteria Formula for the Daily Price being above (not crossing up through) its own 30-Period Exponential Moving Average. You can use it directly on a Monhtly Chart using a Custom Percent True Indicator. You can Sort (but not Filter) a Watchlist using Indicator Sorts based on this Custom Percent True Indicator (with the Time Frame set to Monthly).

Visually Backtesting Specific Symbols
Sorting price and indicators by their Actual Value

It can't be used directly to evaluate Monthly Charts using a PCF because PCFs and EasyScans are always based on the twenty minute delayed Daily data. This means the PCF needs to be re-written to calculate a Monthly value based on Daily values.

C > .0645789155461771 * (C + 29 / 31 * (C21 + 29 / 31 * (C42 + 29 / 31 * (C63 + 29 / 31 * (C84 + 29 / 31 * (C105 + 29 / 31 * (C126 + 29 / 31 * (C147 + 29 / 31 * (C168 + 29 / 31 * (C189 + 29 / 31 * (C210 + 29 / 31 * (C231 + 29 / 31 * (C252 + 29 / 31 * (C273 + 29 / 31 * (C294 + 29 / 31 * (C315 + 29 / 31 * (C336 + 29 / 31 * (C357 + 29 / 31 * (C378 + 29 / 31 * (C399 + 29 / 31 * (C420 + 29 / 31 * (C441 + 29 / 31 * (C462 + 29 / 31 * (C483 + 29 / 31 * (C504 + 29 / 31 * (C525 + 29 / 31 * (C546 + 29 / 31 * (C567 + 29 / 31 * (C588 + 29 / 31 * (C609 + 29 / 31 * (C630 + 29 / 31 * (C651 + 29 / 31 * (C672 + 29 / 31 * (C693 + 29 / 31 * (C714 + 29 / 31 * (C735 + 29 / 31 * (C756 + 29 / 31 * (C777 + 29 / 31 * (C798 + 29 / 31 * (C819 + 29 / 31 * (C840 + 29 / 31 * (C861 + 29 / 31 * (C882 + 29 / 31 * (C903 + 29 / 31 * (C924 + 29 / 31 * (C945 + 29 / 31 * (C966 + 29 / 31 * (C987 + 29 / 31 * (C1008 + 29 / 31 * (C1029 + 29 / 31 * (C1050 + 29 / 31 * (C1071 + 29 / 31 * (C1092 + 29 / 31 * (C1113 + 29 / 31 * (C1134 + 29 / 31 * (C1155 + 29 / 31 * (C1176 + 29 / 31 * (C1197 + 29 / 31 * (C1218 + 29 / 31 * (C1239 + 29 / 31 * (C1260 + 29 / 31 * (C1281 + 29 / 31 * (C1302 + 29 / 31 * (C1323 + 29 / 31 * (C1344 + 29 / 31 * (C1365 + 29 / 31 * (C1386 + 29 / 31 * (C1407 + 29 / 31 * (C1428 + 29 / 31 * (C1449 + 29 / 31 * (C1470 + 29 / 31 * (C1491 + 29 / 31 * (C1512 + 29 / 31 * (C1533 + 29 / 31 * (C1554 + 29 / 31 * (C1575 + 29 / 31 * (C1596 + 29 / 31 * (C1617 + 29 / 31 * (C1638 + 29 / 31 * (C1659 + 29 / 31 * (C1680 + 29 / 31 * (C1701 + 29 / 31 * (C1722 + 29 / 31 * (C1743 + 29 / 31 * (C1764 + 29 / 31 * (C1785 + 29 / 31 * (C1806 + 29 / 31 * (C1827 + 29 / 31 * (C1848 + 29 / 31 * (C1869 + 29 / 31 * (C1890 + 29 / 31 * (C1911 + 29 / 31 * (C1932 + 29 / 31 * (C1953 + 29 / 31 * (C1974 + 29 / 31 * (C1995 + 29 / 31 * (C2016 + 29 / 31 * (C2037 + 29 / 31 * (C2058 + 29 / 31 * (C2079 + 29 / 31 * (C2100 + 29 / 31 * (C2121 + 29 / 31 * (C2142 + 29 / 31 * (C2163))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

You may wish to review the following:

Cascades of Moving Averages

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.