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 |

formula problem Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
islandrover
Posted : Wednesday, January 11, 2006 3:11:03 PM
Registered User
Joined: 10/27/2004
Posts: 36
Hi -
I'm using the following formula and it is pulling up 'true' when the price has clearly extended beyond 10% of the 50dma.
C>=AVGC50 AND C<(AVGC50*1.1)
How do I best troubleshoot this?
The value for the AVGC50 is based on price, regardless of the timeframe in view, correct?
One question that comes to mind, but does not seem to be directly related to my results -
If you update TC2005 intraday, is C from yesterday's close or the update's close?

Thanks
Doug_H
Posted : Wednesday, January 11, 2006 3:24:06 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Check the things you find at this link to see if you can find the problem:

Things to check if your moving averages don't "seem right" or "seem to match"

If you update intraday today, C is the most recent intraday price you've downloaded. C1 is now yesterday's close.

- Doug
Teaching Online!
Craig_S
Posted : Wednesday, January 11, 2006 3:30:04 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Can you give us some tickers that are returning TRUE for you that appear to not fit the condition?

- Craig
Here to Help!
islandrover
Posted : Wednesday, January 11, 2006 3:46:21 PM
Registered User
Joined: 10/27/2004
Posts: 36
TRLG (may be due to lack of info, but why true?), ADES, TRAD, ANX, TEC, etc. I'm on the daily view.
Doug_H
Posted : Wednesday, January 11, 2006 3:48:17 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
Did you check the link? Is your moving average exponential?

- Doug
Teaching Online!
islandrover
Posted : Wednesday, January 11, 2006 3:49:23 PM
Registered User
Joined: 10/27/2004
Posts: 36
I have both simple and exp.
Doug_H
Posted : Wednesday, January 11, 2006 3:51:52 PM


Worden Trainer

Joined: 10/1/2004
Posts: 4,308
The PCF you wrote above is for a simple moving average. Add an X in front of each AVG if your 50 bar moving average is plotted as exponential.

- Doug
Teaching Online!
Craig_S
Posted : Wednesday, January 11, 2006 3:54:02 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Did you go through the checklist that Doug linked?

One of the items was to check the last time you updated your PCFs. I am willing to bet you last updated your PCFs on 12/30/05

TRLG is false today. Last time it was TRUE for your condition was 12/30/05

ADES (false today, true on 12/30/05)

TRAD (false today, true on 12/30/05)

ANX (false today, true on 12/30/05)

TEC (false today, true on 12/30/05)

I am not sure if you went through the checklist Doug linked above but I am sure if you calcualte your PCFs you will find your PCF will match the chart.

- Craig
Here to Help!
islandrover
Posted : Wednesday, January 11, 2006 4:03:24 PM
Registered User
Joined: 10/27/2004
Posts: 36
The update dialogue box lost the check for some reason.

I'm glad that I realized it wasn't updating so early in the year on one of those 'can't go too wrong' sort of rallies. The update box lost the check for some reason.

Thanks for all the rapid attention!
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.