Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Help with PCF's Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
SteadyEddy
Posted : Friday, April 27, 2007 11:59:06 AM
Registered User
Joined: 3/27/2005
Posts: 4
Need help with 2 simple formulae:
#1)a formula for 5 day mov.avg crossing up through the 10 day mov.avg. I am using (AVGC5.2/AVGC10.2)*100 I am getting stocks that crossed up several days ago instead of the last day or two.

#2) A formula for the price moving up through the 15 day exponential mov. avg.

Thanks for any help and a great program.
(email removed by moderator)
SteadyEddy
Bruce_L
Posted : Friday, April 27, 2007 12:07:30 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Please try the following:

5 day mov.avg crossing up through the 10 day mov.avg.:

Simple:

AVGC5 > AVGC10 AND AVGC5.1 <= AVGC10.1

Exponential:

XAVGC5 > XAVGC10 AND XAVGC5.1 <= XAVGC10.1

price moving up through the 15 day exponential mov. avg.:

C > XAVGC15 AND C1 <= XAVGC15.1

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Moving Average PCF Templates
Things to check if your moving averages don't "seem right" or "seem to match"
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
SteadyEddy
Posted : Friday, April 27, 2007 11:17:58 PM
Registered User
Joined: 3/27/2005
Posts: 4
Thanks Bruce for the prompt response. Both formulae work great.

SteadyEddy
vwendell
Posted : Saturday, April 28, 2007 11:41:04 AM
Registered User
Joined: 8/13/2006
Posts: 1
Why is so hard to find how to put a PCF into a tab? That's all I want to do.
Craig_S
Posted : Saturday, April 28, 2007 12:06:45 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Have you watched these videos yet?

How to create a Personal Criteria Forumula (PCF)

Customize the Information Displayed in the WatchList

- Craig
Here to Help!
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.