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
|
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
|
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
|