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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 7 » Difference between two Indicators

Difference between two Indicators Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
MarketReader
Posted : Tuesday, January 2, 2007 4:37:26 PM
Registered User
Joined: 10/7/2004
Posts: 40
 I have two indicators and I want to find the difference between the two in order to create a third indicator, which represents the difference in values.
The two Indicators are:
Price Percent Change Today
100 * (C-C1) / C1
Price Percent Change 26-Week
100 * (C-C126) / C126
Back to top
Bruce_L
Posted : Tuesday, January 2, 2007 5:00:11 PM


Worden Trainer

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

100 * (C / C1 - C / C126)

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
bustermu
Posted : Tuesday, January 2, 2007 8:16:59 PM
Registered User
Joined: 1/1/2005
Posts: 2,645
 MarketReader,

Consider the PCFs:

Price Percent Change 126 Day, Today
PCF1:
100*(C-C126)/C126

Price Percent Change 1 Day, Today
PCF2:
100*(C-C1)/C1

Price Percent Change 125 Day, Yesterday
PCF3:
100*(C1-C126)/C126

It will be shown that:

Price Percent Change 126 Day, Today
minus
Price Percent Change 1 Day, Today
is approximately
Price Percent Change 125 Day, Yesterday

i.e.,

PCF1 - PCF2 ~= PCF3.

Now,

PCF1 - PCF2
= 100*(C/C126-C/C1)
= (100+100*(C-C1)/C1)*(C1-C126)/C126
= (100+PCF2)*PCF3/100

Since the magnitude of PCF2 is small compared to 100, it follows that

PCF1 - PCF2 ~= PCF3

as was to be shown.

Thanks,
Jim Murphy
Back to top
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.