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

Worden Discussion Forum » Customer Training & Support » PCFs, EasyScan and Custom Indicators » PCFs for Sort By

PCFs for Sort By Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Winnie
Posted : Monday, September 11, 2006 9:57:24 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
 I’m working to determine the default PCFs for each Sort By for some of the more common indicators, below are 8 indicators with some PCFs already noted.
The default Sort By with the ?? are the ones I’m missing.


Default PCFs for Sort By for various Indicators
________________________________________
1: Simple SK STOC14,3:

A: Visual Value: Same as Actual Value
STOC14.3

B: Visual Change: Same as Net Change
(STOC14.3.0) - (STOC14.3.1)

C: Actual Value:
STOC14.3

D: Net Change: Net Change 1 Day
(STOC14.3.0) - (STOC14.3.1)

E: % Change:
??

________________________________________
2: Exponential RSI 8,7

A: Visual Value: Same as Actual Value
XAVG(RSI8.1.0,7)

Visual Change:
??

B: Visual Change
??

C: Actual Value:
XAVG(RSI8.1.0,7)

D: Net Change: Net Change 1 Day
XAVG(RSI8.1.0,7)- XAVG(RSI8.1.1,7)

E: % Change:
??

________________________________________
3: Exponential MACD12,26

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
(XAVGC12.0 - XAVGC26.0)

D: Net Change: Net Change 1 Day
(XAVGC12.0 - XAVGC26.0) - (XAVGC12.1 - XAVGC26.1)

E: % Change: 5 Day % Change
??
________________________________________
4: Simple OBV

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
OBV1

D: Net Change:
OBV1 - OBV1.1

E: % Change:
??

________________________________________
5: Simple BOP1

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
BOP1.0

D: Net Change:
BOP1.0-BOP1.1

E: % Change:
??

________________________________________
6: Simple MA20

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
AVGC20

D: Net Change: Net Change 1 Day
AVGC20 - AVGC20.1

E: % Change:
??

________________________________________
7: Volume

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
V

D: Net Change: Net Change 1 Day
V - V1

E: % Change:
??

________________________________________
8: Price

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
C

D: Net Change: Net Change 1 Day
C - C1

E: % Change:
??


Thanks
Winnie
Back to top
Craig_S
Posted : Tuesday, September 12, 2006 5:33:52 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
 Your visual sorts will depend on your zoom level. What zoom are you looking at these on?
- Craig
Here to Help!
Back to top
Winnie
Posted : Tuesday, September 12, 2006 8:49:58 AM
Registered User
Joined: 10/7/2004
Posts: 1,006
 Please use Zoom Level 4, most of the time I'm on that zoom level.
How do you calculate for a different zoom level?

Which Sortby PCFs are affected by the zoom level. Am I correct to presume the Visual Value and Visual Change are the only ones affected by the zoom level?

I fogot and also want to add MS and Simple TSV18.0

Thanks
Winnie
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 8:55:16 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 I'm going to reply to your post using multiple posts and I'm only going to answer one question per post. There's almost too much here to be confined to a single topic. You may wish to review the following:

How to create a Personal Criteria Forumula (PCF)
PCF TO RANK MUTUAL FUNDS USING LINEAR REGRESSION LINE
Linear Regression Visual Sorts from "n" days ago.
Dealing with OBV & MS in PCF's - how to interp their "values"
Handy PCF example formulas to help you learn the syntax of PCFs!
Personal Criteria Language Function List

QUOTE (Winnie)
1: Simple SK STOC14,3:

A: Visual Value: Same as Actual Value
STOC14.3

B: Visual Change: Same as Net Change
(STOC14.3.0) - (STOC14.3.1)

C: Actual Value:
STOC14.3

D: Net Change: Net Change 1 Day
(STOC14.3.0) - (STOC14.3.1)

E: % Change:
??

E: % Change Period: 1:
100 * STOC14.3 / STOC14.3.1 - 100
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 9:09:57 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
2: Exponential RSI 8,7

A: Visual Value: Same as Actual Value
XAVG(RSI8.1.0,7)

Visual Change:
??

B: Visual Change
??

C: Actual Value:
XAVG(RSI8.1.0,7)

D: Net Change: Net Change 1 Day
XAVG(RSI8.1.0,7)- XAVG(RSI8.1.1,7)

E: % Change:
??

B: Visual Change Period: 1:
XAVG(RSI8,7) - XAVG(RSI8.1.1,7)

E: % Change Period: 1:
100 * XAVG(RSI8,7) / XAVG(RSI8.1.1,7) - 100
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 9:37:15 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
4: Simple OBV

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
OBV1

D: Net Change:
OBV1 - OBV1.1

E: % Change:
??

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * (OBV - MIN(OBV,1125)) / (MAX(OBV,1125) - MIN(OBV,1125))

Zoom 1+ (750 or 749 Bars):
100 * (OBV - MIN(OBV,750)) / (MAX(OBV,750) - MIN(OBV,750))

Zoom 1 (500 or 499 Bars):
100 * (OBV - MIN(OBV,500)) / (MAX(OBV,500) - MIN(OBV,500))

Zoom 2 (333 or 332 Bars):
100 * (OBV - MIN(OBV,333)) / (MAX(OBV,333) - MIN(OBV,333))

Zoom 3 (222 or 221 Bars):
100 * (OBV - MIN(OBV,222)) / (MAX(OBV,222) - MIN(OBV,222))

Zoom 4 (148 or 147 Bars):
100 * (OBV - MIN(OBV,148)) / (MAX(OBV,148) - MIN(OBV,148))

Zoom 5 (99 or 98 Bars):
100 * (OBV - MIN(OBV,99)) / (MAX(OBV,99) - MIN(OBV,99))

Zoom 6 (66 or 65 Bars):
100 * (OBV - MIN(OBV,66)) / (MAX(OBV,66) - MIN(OBV,66))

Zoom 7 (44 or 43 Bars):
100 * (OBV - MIN(OBV,44)) / (MAX(OBV,44) - MIN(OBV,44))

Zoom 8 (29 or 28 Bars):
100 * (OBV - MIN(OBV,29)) / (MAX(OBV,29) - MIN(OBV,29))

Zoom 9 (20 or 19 Bars):
100 * (OBV - MIN(OBV,20)) / (MAX(OBV,20) - MIN(OBV,20))

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,1125) - MIN(OBV,1125))

Zoom 1+ (750 or 749 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,750) - MIN(OBV,750))

Zoom 1 (500 or 499 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,500) - MIN(OBV,500))

Zoom 2 (333 or 332 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,333) - MIN(OBV,333))

Zoom 3 (222 or 221 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,222) - MIN(OBV,222))

Zoom 4 (148 or 147 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,148) - MIN(OBV,148))

100 * (OBV - OBV1.1) / (MAX(OBV,99) - MIN(OBV,99))

Zoom 6 (66 or 65 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,66) - MIN(OBV,66))

Zoom 7 (44 or 43 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,44) - MIN(OBV,44))

Zoom 8 (29 or 28 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,29) - MIN(OBV,29))

Zoom 9 (20 or 19 Bars):
100 * (OBV - OBV1.1) / (MAX(OBV,20) - MIN(OBV,20))

C: Actual Value: (I'm not sure why you would do this for OBV):

E: % Change Period: 1: (I'm not sure why you would do this for OBV):
100 * (OBV - OBV1.1) / ABS(OBV1.1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 10:05:39 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
5: Simple BOP1

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
BOP1.0

D: Net Change:
BOP1.0-BOP1.1

E: % Change:
??

A: Visual Value:
(BOP + 100) / 2

B: Visual Change Period: 1:
(BOP - BOP1.1) / 2

E: % Change Period: 1: (I'm not sure why you would do this for BOP):
100 * (BOP - BOP1.1) / ABS(BOP1.1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 10:25:39 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
6: Simple MA20

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
AVGC20

D: Net Change: Net Change 1 Day
AVGC20 - AVGC20.1

E: % Change:
??

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * (AVGC20 - MINL1125) / (MAXH1125 - MINL1125)

Zoom 1+ (750 or 749 Bars):
100 * (AVGC20 - MINL750) / (MAXH750 - MINL750)

Zoom 1 (500 or 499 Bars):
100 * (AVGC20 - MINL500) / (MAXH500 - MINL500)

Zoom 2 (333 or 332 Bars):
100 * (AVGC20 - MINL333) / (MAXH333 - MINL333)

Zoom 3 (222 or 221 Bars):
100 * (AVGC20 - MINL222) / (MAXH222 - MINL222)

Zoom 4 (148 or 147 Bars):
100 * (AVGC20 - MINL148) / (MAXH148 - MINL148)

Zoom 5 (99 or 98 Bars):
100 * (AVGC20 - MINL99) / (MAXH99 - MINL99)

Zoom 6 (66 or 65 Bars):
100 * (AVGC20 - MINL66) / (MAXH66 - MINL66)

Zoom 7 (44 or 43 Bars):
100 * (AVGC20 - MINL44) / (MAXH44 - MINL44)

Zoom 8 (29 or 28 Bars):
100 * (AVGC20 - MINL29) / (MAXH29 - MINL29)

Zoom 9 (20 or 19 Bars):
100 * (AVGC20 - MINL20) / (MAXH20 - MINL20)

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH1125 - MINL1125)

Zoom 1+ (750 or 749 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH750 - MINL750)

Zoom 1 (500 or 499 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH500 - MINL500)

Zoom 2 (333 or 332 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH333 - MINL333)

Zoom 3 (222 or 221 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH222 - MINL222)

Zoom 4 (148 or 147 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH148 - MINL148)

Zoom 5 (99 or 98 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH99 - MINL99)

Zoom 6 (66 or 65 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH66 - MINL66)

Zoom 7 (44 or 43 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH44 - MINL44)

Zoom 8 (29 or 28 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH29 - MINL29)

Zoom 9 (20 or 19 Bars):
100 * (AVGC20 - AVGC20.1) / (MAXH20 - MINL20)

E: % Change:
100 * AVGC20 / AVGC20.1 - 100
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 11:12:20 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
7: Volume

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
V

D: Net Change: Net Change 1 Day
V - V1

E: % Change:
??

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * V / MAXV1125

Zoom 1+ (750 or 749 Bars):
100 * V / MAXV750

Zoom 1 (500 or 499 Bars):
100 * V / MAXV500

Zoom 2 (333 or 332 Bars):
100 * V / MAXV333

Zoom 3 (222 or 221 Bars):
100 * V / MAXV222

Zoom 4 (148 or 147 Bars):
100 * V / MAXV148

Zoom 5 (99 or 98 Bars):
100 * V / MAXV99

Zoom 6 (66 or 65 Bars):
100 * V / MAXV66

Zoom 7 (44 or 43 Bars):
100 * V / MAXV44

Zoom 8 (29 or 28 Bars):
100 * V / MAXV29

Zoom 9 (20 or 19 Bars):
100 * V / MAXV20

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (V - V1) / MAXV1125

Zoom 1+ (750 or 749 Bars):
100 * (V - V1) / MAXV750

Zoom 1 (500 or 499 Bars):
100 * (V - V1) / MAXV500

Zoom 2 (333 or 332 Bars):
100 * (V - V1) / MAXV333

Zoom 3 (222 or 221 Bars):
100 * (V - V1) / MAXV222

Zoom 4 (148 or 147 Bars):
100 * (V - V1) / MAXV148

Zoom 5 (99 or 98 Bars):
100 * (V - V1) / MAXV99

Zoom 6 (66 or 65 Bars):
100 * (V - V1) / MAXV66

Zoom 7 (44 or 43 Bars):
100 * (V - V1) / MAXV44

Zoom 8 (29 or 28 Bars):
100 * (V - V1) / MAXV29

Zoom 9 (20 or 19 Bars):
100 * (V - V1) / MAXV20

E: % Change Period: 1:
100 * V / V1 - 100

The above Personal Criteria Formulas are for when Tools | Chart Display Options | Truncate tops of Volume Bars on spikes greater than average volume: is unchecked.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 4:03:40 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
8: Price

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
C

D: Net Change: Net Change 1 Day
C - C1

E: % Change:
??

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * (C - MINL1125) / (MAXH1125 - MINL1125)

Zoom 1+ (750 or 749 Bars):
100 * (C - MINL750) / (MAXH750 - MINL750)

Zoom 1 (500 or 499 Bars):
100 * (C - MINL500) / (MAXH500 - MINL500)

Zoom 2 (333 or 332 Bars):
100 * (C - MINL333) / (MAXH333 - MINL333)

Zoom 3 (222 or 221 Bars):
100 * (C - MINL222) / (MAXH222 - MINL222)

Zoom 4 (148 or 147 Bars):
100 * (C - MINL148) / (MAXH148 - MINL148)

Zoom 5 (99 or 98 Bars):
100 * (C - MINL99) / (MAXH99 - MINL99)

Zoom 6 (66 or 65 Bars):
100 * (C - MINL66) / (MAXH66 - MINL66)

Zoom 7 (44 or 43 Bars):
100 * (C - MINL44) / (MAXH44 - MINL44)

Zoom 8 (29 or 28 Bars):
100 * (C - MINL29) / (MAXH29 - MINL29)

Zoom 9 (20 or 19 Bars):
100 * (C - MINL20) / (MAXH20 - MINL20)

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (C - C1) / (MAXH1125 - MINL1125)

Zoom 1+ (750 or 749 Bars):
100 * (C - C1) / (MAXH750 - MINL750)

Zoom 1 (500 or 499 Bars):
100 * (C - C1) / (MAXH500 - MINL500)

Zoom 2 (333 or 332 Bars):
100 * (C - C1) / (MAXH333 - MINL333)

Zoom 3 (222 or 221 Bars):
100 * (C - C1) / (MAXH222 - MINL222)

Zoom 4 (148 or 147 Bars):
100 * (C - C1) / (MAXH148 - MINL148)

Zoom 5 (99 or 98 Bars):
100 * (C - C1) / (MAXH99 - MINL99)

Zoom 6 (66 or 65 Bars):
100 * (C - C1) / (MAXH66 - MINL66)

Zoom 7 (44 or 43 Bars):
100 * (C - C1) / (MAXH44 - MINL44)

Zoom 8 (29 or 28 Bars):
100 * (C - C1) / (MAXH29 - MINL29)

Zoom 9 (20 or 19 Bars):
100 * (C - C1) / (MAXH20 - MINL20)

E: % Change:
100 * C / C1 - 100
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 4:19:33 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
3: Exponential MACD12,26

A: Visual Value:
??

B: Visual Change:
??

C: Actual Value:
(XAVGC12.0 - XAVGC26.0)

D: Net Change: Net Change 1 Day
(XAVGC12.0 - XAVGC26.0) - (XAVGC12.1 - XAVGC26.1)

E: % Change: 5 Day % Change
??

A: Visual Value:
Not practical.

B: Visual Change Period: 1:
Not practical.

E: % Change Period: 1: (I'm not sure why you would do this for MACD):
100 * (XAVGC12 - XAVGC26) - XAVGC12.1 + XAVGC26.1) / ABS(XAVGC12.1 - XAVGC26.1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 5:08:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
Which Sortby PCFs are affected by the zoom level?

Indicator Sorts with Visual in the name are affected by Zoom.

QUOTE (Winnie)
How do you calculate for a different zoom level?

Each Zoom has a different number of Bars:

Zoom 1++: 1125 Bars
Zoom 1+: 750 Bars
Zoom 1: 500 Bars
Zoom 2: 333 Bars
Zoom 3: 222 Bars
Zoom 4: 148 Bars
Zoom 5: 99 Bars
Zoom 6: 66 Bars
Zoom 7: 44 Bars
Zoom 8: 29 Bars
Zoom 9: 20 Bars

To calculate Visual Value:

100 * (Current - MinDisplayZoom) / (MaxDisplayZoom - MinDisplayZoom)

To calculate Visual Change:

100 * (Current - Previous) / (MaxDisplayZoom - MinDisplayZoom)

Where:

Actual is the Indicator Value
MinDisplayZoom is the Minimum value displayed on the Scale used for the Indicator.
MaxDisplayZoom is the Maximum value displayed on the Scale used for the Indicator.

MinDisplayedZoom and MaxDisplayed Zoom are the actual Minimum and Maximum values for the Indicator over the Zoom if the Indicator is displayed on its own auto scale.
MinDisplayedZoom and MaxDisplayed Zoom are the negative and positive versions of the Minimum or Maximum value furthest from zero for the Indicator over the Zoom if the Indicator is on an auto zero centered scale.
MinDisplayedZoom and MaxDisplayed Zoom are the Minimum Low and Maximum High values for Price over the Zoom if the Indicator is displayed on the Price scale.
MinDisplayedZoom and MaxDisplayed Zoom are usually something like 0 and 100 or -100 and 100 if the Indicator is displayed on a fixed scale.

QUOTE (Winnie)
I fogot and also want to add MS and Simple TSV18.0

OK. You might wish to review the materials referenced in my first reply in this topic however. Some of the formulas that have been provided or requested are meaningless (percentage changes of Indicators returning both positive and negative results and the actual values of Cumulative Indicators for example).
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Winnie
Posted : Tuesday, September 12, 2006 5:11:27 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
 Bruce, thanks so much for your time and work. After seeing in detail the PCF for each Zoom Level, I understand why and now can modify other Indicators. Unfortunately TC2007 does not do this automatically. Will SnapSheets do this differently?

I see you just posted the MACD.
Indicators as the MACD and TSV with a center 0 line, is there a standard formula that will do the % Change, due to the fact that the Indicator crosses up and down the 0 line with + and - values?

Your question why would you do this for MACD, I just want to see if it could be useful.


Thanks
Winnie
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 5:20:00 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 9: MS

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * (MS - MIN(MS,1125)) / (MAX(MS,1125) - MIN(MS,1125))

Zoom 1+ (750 or 749 Bars):
100 * (MS - MIN(MS,750)) / (MAX(MS,750) - MIN(MS,750))

Zoom 1 (500 or 499 Bars):
100 * (MS - MIN(MS,500)) / (MAX(MS,500) - MIN(MS,500))

Zoom 2 (333 or 332 Bars):
100 * (MS - MIN(MS,333)) / (MAX(MS,333) - MIN(MS,333))

Zoom 3 (222 or 221 Bars):
100 * (MS - MIN(MS,222)) / (MAX(MS,222) - MIN(MS,222))

Zoom 4 (148 or 147 Bars):
100 * (MS - MIN(MS,148)) / (MAX(MS,148) - MIN(MS,148))

Zoom 5 (99 or 98 Bars):
100 * (MS - MIN(MS,99)) / (MAX(MS,99) - MIN(MS,99))

Zoom 6 (66 or 65 Bars):
100 * (MS - MIN(MS,66)) / (MAX(MS,66) - MIN(MS,66))

Zoom 7 (44 or 43 Bars):
100 * (MS - MIN(MS,44)) / (MAX(MS,44) - MIN(MS,44))

Zoom 8 (29 or 28 Bars):
100 * (MS - MIN(MS,29)) / (MAX(MS,29) - MIN(MS,29))

Zoom 9 (20 or 19 Bars):
100 * (MS - MIN(MS,20)) / (MAX(MS,20) - MIN(MS,20))

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (MS - MS1.1) / (MAX(MS,1125) - MIN(MS,1125))

Zoom 1+ (750 or 749 Bars):
100 * (MS - MS1.1) / (MAX(MS,750) - MIN(MS,750))

Zoom 1 (500 or 499 Bars):
100 * (MS - MS1.1) / (MAX(MS,500) - MIN(MS,500))

Zoom 2 (333 or 332 Bars):
100 * (MS - MS1.1) / (MAX(MS,333) - MIN(MS,333))

Zoom 3 (222 or 221 Bars):
100 * (MS - MS1.1) / (MAX(MS,222) - MIN(MS,222))

Zoom 4 (148 or 147 Bars):
100 * (MS - MS1.1) / (MAX(MS,148) - MIN(MS,148))

100 * (MS - MS1.1) / (MAX(MS,99) - MIN(MS,99))

Zoom 6 (66 or 65 Bars):
100 * (MS - MS1.1) / (MAX(MS,66) - MIN(MS,66))

Zoom 7 (44 or 43 Bars):
100 * (MS - MS1.1) / (MAX(MS,44) - MIN(MS,44))

Zoom 8 (29 or 28 Bars):
100 * (MS - MS1.1) / (MAX(MS,29) - MIN(MS,29))

Zoom 9 (20 or 19 Bars):
100 * (MS - MS1.1) / (MAX(MS,20) - MIN(MS,20))

C: Actual Value: (I'm not sure why you would do this for MS):
MS

D: Net Change Period: 1
MS - MS1

E: % Change Period: 1: (I'm not sure why you would do this for MS):
100 * (MS - MS1) / ABS(MS1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 5:56:41 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 9: TSV18

A: Visual Value:
Zoom 1++ (1125 or 1124 Bars):
100 * TSV18 / (MAX(TSV18,1125) + ABS(MIN(TSV18,1125)) + ABS(MAX(TSV18,1125) - ABS(MIN(TSV18,1125)))) + 50

Zoom 1+ (750 or 749 Bars):
100 * TSV18 / (MAX(TSV18,750) + ABS(MIN(TSV18,750)) + ABS(MAX(TSV18,750) - ABS(MIN(TSV18,750)))) + 50

Zoom 1 (500 or 499 Bars):
100 * TSV18 / (MAX(TSV18,500) + ABS(MIN(TSV18,500)) + ABS(MAX(TSV18,500) - ABS(MIN(TSV18,500)))) + 50

Zoom 2 (333 or 332 Bars):
100 * TSV18 / (MAX(TSV18,333) + ABS(MIN(TSV18,333)) + ABS(MAX(TSV18,333) - ABS(MIN(TSV18,333)))) + 50

Zoom 3 (222 or 221 Bars):
100 * TSV18 / (MAX(TSV18,222) + ABS(MIN(TSV18,222)) + ABS(MAX(TSV18,222) - ABS(MIN(TSV18,222)))) + 50

Zoom 4 (148 or 147 Bars):
100 * TSV18 / (MAX(TSV18,148) + ABS(MIN(TSV18,148)) + ABS(MAX(TSV18,148) - ABS(MIN(TSV18,148)))) + 50

Zoom 5 (99 or 98 Bars):
100 * TSV18 / (MAX(TSV18,99) + ABS(MIN(TSV18,99)) + ABS(MAX(TSV18,99) - ABS(MIN(TSV18,99)))) + 50

Zoom 6 (66 or 65 Bars):
100 * TSV18 / (MAX(TSV18,66) + ABS(MIN(TSV18,66)) + ABS(MAX(TSV18,66) - ABS(MIN(TSV18,66)))) + 50

Zoom 7 (44 or 43 Bars):
100 * TSV18 / (MAX(TSV18,44) + ABS(MIN(TSV18,44)) + ABS(MAX(TSV18,44) - ABS(MIN(TSV18,44)))) + 50

Zoom 8 (29 or 28 Bars):
100 * TSV18 / (MAX(TSV18,29) + ABS(MIN(TSV18,29)) + ABS(MAX(TSV18,29) - ABS(MIN(TSV18,29)))) + 50

Zoom 9 (20 or 19 Bars):
100 * TSV18 / (MAX(TSV18,20) + ABS(MIN(TSV18,20)) + ABS(MAX(TSV18,20) - ABS(MIN(TSV18,20)))) + 50

B: Visual Change Period: 1:
Zoom 1++ (1125 or 1124 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,1125) + ABS(MIN(TSV18,1125)) + ABS(MAX(TSV18,1125) - ABS(MIN(TSV18,1125))))

Zoom 1+ (750 or 749 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,750) + ABS(MIN(TSV18,750)) + ABS(MAX(TSV18,750) - ABS(MIN(TSV18,750))))

Zoom 1 (750 or 499 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,750) + ABS(MIN(TSV18,750)) + ABS(MAX(TSV18,750) - ABS(MIN(TSV18,750))))

Zoom 2 (333 or 332 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,333) + ABS(MIN(TSV18,333)) + ABS(MAX(TSV18,333) - ABS(MIN(TSV18,333))))

Zoom 3 (222 or 221 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,222) + ABS(MIN(TSV18,222)) + ABS(MAX(TSV18,222) - ABS(MIN(TSV18,222))))

Zoom 4 (148 or 147 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,148) + ABS(MIN(TSV18,148)) + ABS(MAX(TSV18,148) - ABS(MIN(TSV18,148))))

Zoom 5 (99 or 98 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,99) + ABS(MIN(TSV18,99)) + ABS(MAX(TSV18,99) - ABS(MIN(TSV18,99))))

Zoom 6 (66 or 65 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,66) + ABS(MIN(TSV18,66)) + ABS(MAX(TSV18,66) - ABS(MIN(TSV18,66))))

Zoom 7 (44 or 43 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,44) + ABS(MIN(TSV18,44)) + ABS(MAX(TSV18,44) - ABS(MIN(TSV18,44))))

Zoom 8 (29 or 28 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,29) + ABS(MIN(TSV18,29)) + ABS(MAX(TSV18,29) - ABS(MIN(TSV18,29))))

Zoom 9 (20 or 19 Bars):
100 * (TSV18 - TSV18.1) / (MAX(TSV18,20) + ABS(MIN(TSV18,20)) + ABS(MAX(TSV18,20) - ABS(MIN(TSV18,20))))

C: Actual Value:
TSV18

D: Net Change Period: 1
TSV18 - TSV18.1

E: % Change Period: 1: (I'm not sure why you would do this for TSV):
100 * (TSV18 - TSV18.1) / ABS(TSV18.1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
diceman
Posted : Tuesday, September 12, 2006 6:03:49 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
 Winnie

Quote:"Your question why would you do this for MACD, I just want to see if it could be useful."


I could see percent changes relative to MACD being useful. It would
compensate for different priced stocks. You would be able to discern
the spread or contraction of 2 moving averages and (since they are
based on price) have it normalized to stock price.


Things like OBV,TSV,MS,BOP are much less useful since they probably
have volume components that would be all over the map.



Thanks
diceman
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 6:21:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (Winnie)
After seeing in detail the PCF for each Zoom Level, I understand why and now can modify other Indicators. Unfortunately TC2007 does not do this automatically.

Actually, it does. That's what an Indicator Sort is in the first place. You are trying to emulate this built in functionality using a Personal Criteria Formula. PCFs are based entirely on actual values.

QUOTE (Winnie)
Will SnapSheets do this differently?

I really can't say. SnapSheets has a continuously variable Zoom and does not currently have any built in Visual Sorting.

QUOTE (Winnie)
Indicators as the MACD and TSV with a center 0 line, is there a standard formula that will do the % Change, due to the fact that the Indicator crosses up and down the 0 line with + and - values? Your question why would you do this for MACD, I just want to see if it could be useful.

TeleChart generally uses:

100 * (Current - Previous) / ABS(Previous)

The ABS() function forces the "Percent Change" to the more intuitive sign. That said, it is not a percentage if the indicator crosses the zero line. The trainers cannot give settings, interpretation or investment advice, so when I say something is meaningless, it means something besides not being useful when making investment decisions. I mean it is meaningless mathematically, like the crosses of indicators plotted on different scales, the "angles" of indicator lines or the values of cumulative indicators.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 6:28:29 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (diceman)
I could see percent changes relative to MACD being useful. It would compensate for different priced stocks. You would be able to discern the spread or contraction of 2 moving averages and (since they are based on price) have it normalized to stock price.

Normalizing is one thing. The Visual Change sort does this to some extent. Dividing by Price or Average Price is another possible method that could be used with MACD. Doing a "Percent Change" on an indicator that crosses the zero line is something else entirely.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
diceman
Posted : Tuesday, September 12, 2006 6:37:54 PM
Registered User
Joined: 1/28/2005
Posts: 6,049
 Quote:"Doing a "Percent Change" on an indicator that crosses the zero line is something else entirely."


Correct.

I was thinking of something not crossing zero.


Thanks
diceman
Back to top
Winnie
Posted : Tuesday, September 12, 2006 9:26:59 PM
Registered User
Joined: 10/7/2004
Posts: 1,006
 Bruce, the sort values are a lot clearer and hope other users will benefit from this post. If I had known what is involved with the zoom level, I probably would have thought twice, but you came through like always.

Many Thanks
Winnie
Back to top
Bruce_L
Posted : Tuesday, September 12, 2006 9:48:11 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
investalert
Posted : Tuesday, July 27, 2010 11:15:31 PM
Registered User
Joined: 4/29/2006
Posts: 75

Hi Bruce,

How would I write a PCF that would return the visual value of Dr Elder's Force Index? Specifically, I use the following formulas and criteria in separate indicators and would like a PCF for each:

(C - C1) * V, zero centerline, smothing average 2, exponential

and

(C - C1) * V, zero centerline, smothing average 13, exponential

I want to be able to include PCFs for these indicators in my easy scans to find stocks where the values are near the top or bottom (0 or 100) without using the "sort by" method. I use zoom 4, 5 and 6 if that is important.

Thanks, Richard
Back to top
Bruce_L
Posted : Wednesday, July 28, 2010 9:02:37 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QUOTE (InvestAlert)
I use zoom 4, 5 and 6 if that is important.

It is important as I have developed a technique for getting Minimums and Maximums for up to 32 terms and presented it in Min Max PCFs, but I am not going to expand this technique beyond those 32 terms as the formulas become too long to be practical. This would limit you to Zooms 8 or 9.

QUOTE (InvestAlert)
How would I write a PCF that would return the visual value of Dr Elder's Force Index? Specifically, I use the following formulas and criteria in separate indicators and would like a PCF for each:

(C - C1) * V, zero centerline, smothing average 2, exponential

and

(C - C1) * V, zero centerline, smothing average 13, exponential

I want to be able to include PCFs for these indicators in my easy scans to find stocks where the values are near the top or bottom (0 or 100) without using the "sort by" method.

It's not happening. The fact that there are Exponential Moving Averages applied to these formulas means the results would be too long to be practical for even Zooms 8 and 9 using the techniques already referenced as these Moving Averages would need to be manually expanded using the techniques given in Cascades of Moving Averages.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
investalert
Posted : Wednesday, July 28, 2010 9:17:09 AM
Registered User
Joined: 4/29/2006
Posts: 75
 Got it! Thanks Bruce
Back to top
Bruce_L
Posted : Wednesday, July 28, 2010 9:36:13 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
 InvestAlert,
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.