Registered User
Joined: 10/7/2004
Posts: 25
|
Using this Legacy formula from TC 2007: Money Stream 1 year
{100 * (MS-MIN(MS,250)) /( MAX(MS,250) -MIN(MS,250))} on a section of a weekly chart I have installed a simple 13 week moving average calculated from the results of that formula. My question is: is there any way that I can construct a PCF formula that will result in providing the difference between those two numbers?
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
There is no automated method of doing so, but it is possible to manually expand the Moving Average:
100 * (12 * (MS - MIN(MS,250)) / (MAX(MS,250) - MIN(MS,250)) - (MS1.1 - MIN(MS1.1,250)) / (MAX(MS1.1,250) - MIN(MS1.1,250)) - (MS1.2 - MIN(MS1.2,250)) / (MAX(MS1.2,250) - MIN(MS1.2,250)) - (MS1.3 - MIN(MS1.3,250)) / (MAX(MS1.3,250) - MIN(MS1.3,250)) - (MS1.4 - MIN(MS1.4,250)) / (MAX(MS1.4,250) - MIN(MS1.4,250)) - (MS1.5 - MIN(MS1.5,250)) / (MAX(MS1.5,250) - MIN(MS1.5,250)) - (MS1.6 - MIN(MS1.6,250)) / (MAX(MS1.6,250) - MIN(MS1.6,250)) - (MS1.7 - MIN(MS1.7,250)) / (MAX(MS1.7,250) - MIN(MS1.7,250)) - (MS1.8 - MIN(MS1.8,250)) / (MAX(MS1.8,250) - MIN(MS1.8,250)) - (MS1.9 - MIN(MS1.9,250)) / (MAX(MS1.9,250) - MIN(MS1.9,250)) - (MS1.10 - MIN(MS1.10,250)) / (MAX(MS1.10,250) - MIN(MS1.10,250)) - (MS1.11 - MIN(MS1.11,250)) / (MAX(MS1.11,250) - MIN(MS1.11,250)) - (MS1.12 - MIN(MS1.12,250)) / (MAX(MS1.12,250) - MIN(MS1.12,250))) / 13
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|