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

NEED HELP ON THIS FORMULA Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
ufdn16
Posted : Wednesday, October 15, 2008 4:29:06 PM
Registered User
Joined: 1/16/2007
Posts: 11
I'm using the following formulas as an indicator (cross shows change in direction
(AVGC15 / AVGC50) 10 period .  Then I take a 10 moving average of it for further smoothing. I use monthly and get pretty good indicator. I want to screen for when the indicator moves above the 10 day moving average of itself.  I can get the scan to operate but it doesn't give me what I want. Can you help with the syntax?

Thanks, David
Bruce_L
Posted : Wednesday, October 15, 2008 4:35:41 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Is the Smoothing on the Custom Indicator Simple or Exponential?
Is the additional Moving Average Simple or Exponential?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bustermu
Posted : Thursday, October 16, 2008 7:40:58 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
QUOTE (Bruce_L)
Is the Smoothing on the Custom Indicator Simple or Exponential?
Is the additional Moving Average Simple or Exponential?


Bruce,

Are you going to write the PCF?

If EMA's are used, my guess is about 5000 C's will be required:

1)  (AVGC15 / AVGC50) requires 50 C's.
2)  EMA(X-EMA(X,10),10) requires about 5*10 X's
3)  The form in 2) is used twice for an upcrossing of zero.

50*(5*10)*2 = 5000

Do you see a shorter way?

Even if SMA's are used, I would not write it.

Thanks,
Jim Murphy 
ufdn16
Posted : Thursday, October 16, 2008 9:41:23 AM
Registered User
Joined: 1/16/2007
Posts: 11
I have been using simple smoothing.
Bruce_L
Posted : Thursday, October 16, 2008 11:45:08 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
bustermu,
The SMA version is quite long, but I've certainly provided longer formulas.

ufdn16,
Please try the folloing Personal Criteria Formula:

Warning: Long Personal Criteria Formulas can dramatically increase the time it takes to update your PCFs.

9 / (1 + (C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029) / (C + C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294)) + 8 / (1 + (C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050) / (C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315)) + 7 / (1 + (C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071) / (C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336)) + 6 / (1 + (C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092) / (C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357)) + 5 / (1 + (C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113) / (C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378)) + 4 / (1 + (C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134) / (C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399)) + 3 / (1 + (C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155) / (C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420)) + 2 / (1 + (C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176) / (C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441)) + 1 / (1 + (C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197) / (C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462)) > 9 / (1 + (C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239) / (C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504)) + 8 / (1 + (C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260) / (C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525)) + 7 / (1 + (C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281) / (C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546)) + 6 / (1 + (C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302) / (C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567)) + 5 / (1 + (C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323) / (C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588)) + 4 / (1 + (C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344) / (C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609)) + 3 / (1 + (C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365) / (C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630)) + 2 / (1 + (C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365 + C1386) / (C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651)) + 1 / (1 + (C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365 + C1386 + C1407) / (C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672)) AND 9 / (1 + (C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050) / (C21 + C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315)) + 8 / (1 + (C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071) / (C42 + C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336)) + 7 / (1 + (C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092) / (C63 + C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357)) + 6 / (1 + (C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113) / (C84 + C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378)) + 5 / (1 + (C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134) / (C105 + C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399)) + 4 / (1 + (C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155) / (C126 + C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420)) + 3 / (1 + (C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176) / (C147 + C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441)) + 2 / (1 + (C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197) / (C168 + C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462)) + 1 / (1 + (C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218) / (C189 + C210 + C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483)) <= 9 / (1 + (C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260) / (C231 + C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525)) + 8 / (1 + (C567 + C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281) / (C252 + C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546)) + 7 / (1 + (C588 + C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302) / (C273 + C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567)) + 6 / (1 + (C609 + C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323) / (C294 + C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588)) + 5 / (1 + (C630 + C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344) / (C315 + C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609)) + 4 / (1 + (C651 + C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365) / (C336 + C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630)) + 3 / (1 + (C672 + C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365 + C1386) / (C357 + C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651)) + 2 / (1 + (C693 + C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365 + C1386 + C1407) / (C378 + C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672)) + 1 / (1 + (C714 + C735 + C756 + C777 + C798 + C819 + C840 + C861 + C882 + C903 + C924 + C945 + C966 + C987 + C1008 + C1029 + C1050 + C1071 + C1092 + C1113 + C1134 + C1155 + C1176 + C1197 + C1218 + C1239 + C1260 + C1281 + C1302 + C1323 + C1344 + C1365 + C1386 + C1407 + C1428) / (C399 + C420 + C441 + C462 + C483 + C504 + C525 + C546 + C567 + C588 + C609 + C630 + C651 + C672 + C693))

You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
bustermu
Posted : Thursday, October 16, 2008 12:38:06 PM
Registered User
Joined: 1/1/2005
Posts: 2,645

A word of caution for those new to Technical Analysis.

The Indicator here is based on a chart of closing prices using Arithmetic Scale.  It is not possible to construct the Indicator on the chart without knowing the scale.  Those in Technical Analysis generally find this unacceptable for such an indicator.

This behavior is caused by putting a moving average on the ratio:

AVGC15 / AVGC50

If the moving average was instead placed the difference

AVGC15 - AVGC50

at least the behavior mentioned above would no longer be present.

Thanks,
Jim Murphy

ufdn16
Posted : Friday, October 17, 2008 10:00:57 AM
Registered User
Joined: 1/16/2007
Posts: 11
Jim, I'm sorry that Bruce spent so much time on the formula he provided. I tried it and it didn't work. Let me start from the beginning of my request again.  I set up a pcf defined as AVGC15 / AVGC50 and took it to period 10 sma.  Then I edited this line by taking a 10 period ma of AVGC15 / AVGC50 to period 10.  What I get is to very smooth lines crossing from time to time revealing pretty good buy and sell points.  So, the results are quite satisfactory.  Now I want to scan for stocks that have recently crossed.  I would think a simple syntax would be available.  Maybe not. David
Bruce_L
Posted : Friday, October 17, 2008 10:15:42 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
ufdn16,
When you say it doesn't work, can you provide some examples of what you mean?

When I use it as a Personal Criteria Formula on my computer it definitely returns True when the following Custom Indicator crosses up through its own 10-Period Simple Moving Average on a Monthly Chart:

- Center Zero Line: Unchecked
- Plot using price scale: Unchecked
- Smoothing Average: 10
- Average Type: Simple
- Indicator Formula: AVGC15 / AVGC50

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ufdn16
Posted : Friday, October 17, 2008 2:31:43 PM
Registered User
Joined: 1/16/2007
Posts: 11
I must be missing something.  I copied your formula and pasted it to a new pcf.

I opened a new graph then edited to select indicator. I selected the new pcf(with your formula)

I then received an a message "formula error:must not be boolean"

Also, I used your formula as a scan to find stocks that cross. That didn't work.

I know that avgc15/avgc50:10 period gives me a very smooth line.  And, when add its own 10 day moving avg I get another very smooth line that I can use to cross.  Isn't the scan simply shown as :

the 10 day moving average of (avgc15/avgc50:10 period) being lower today and higher yesterday?

Is there proper syntax to accomplsh this without writing a long formula?
David
Bruce_L
Posted : Friday, October 17, 2008 2:41:21 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
ufdn16,
If you are getting a formula error:must not be boolean message, it reads like you are attempting to use the formula as a Custom Indicator. It needs to be used as a Personal Criteria Formula.

- Select New | New Personal Criteria Formula.
- Give the PCF a name and select OK.
- Paste the PCF into the Editing Formula window and select Save.
- Select Databank | Personal Criteria Formulas | Update All Criteria.

How to create a PCF is explained in more detail in the very first topic referenced in my Thursday, October 16, 2008 11:45:08 AM ET post providing the formula (How to create a Personal Criteria Forumula (PCF)).

If I knew of significantly shorter syntax I would have provided it. The length is primarily the result of the Time Frame being Monthly. PCFs are always based on the twenty-minute delayed Daily data. This means a Monthly PCF must be manually constructed using the Daily data.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ufdn16
Posted : Friday, October 17, 2008 3:02:25 PM
Registered User
Joined: 1/16/2007
Posts: 11
oh ...........................Well, why didn't you just say so.   that's a little joke. real little. very tiny. goodbye..........................................for now.
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.