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

PCF Help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thomasjenkinsjr
Posted : Saturday, February 4, 2017 1:32:43 PM
Registered User
Joined: 4/1/2011
Posts: 90

Hi Bruce,

I hope all is well. I need your help.

Part one: Can you write a PCF that will tell me the lowest value the stock went to when the below PCF% was true?

(STOC10.3 < 10) AND (STOC60.3<10) AND (XAVGC12-XAVGC26)-(XAVG(XAVGC12,9)-XAVG(XAVGC26,9)) < 10

For example, let&rsquo;s say the PCF% was true for 5 bars straight for a given stock, but that condition was true 20 bars ago. I want to know what was the lowest value that stock gone to when that PCF% was true.

Part two: I want to display that value in a column and only want it to change the next time the PCF% condition is true again. Is that possible?

 

Thanks in advance

Bruce_L
Posted : Monday, February 6, 2017 12:50:11 PM


Worden Trainer

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

Maybe something like the following (it will only work in TC2000 v17)?

MIN(IIF(STOC10.3 < 10 AND STOC60.3 < 10 AND XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < 10, L, 3.4028 * 10 ^ 38), 100)

The 100 at the end is the number of bars over which the formula is checked. If you set this value too high the formula won't have enough data to calculate. If you set this value too low then it may miss the "lowest value" if it was too many bars back (and also spike to a very high value if not true at all within the period). So you may want to play with this number to get it to what is optimal for you.

You can use this as a WatchList Column and it should update at the refresh rate of the WatchList Column.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Tuesday, February 7, 2017 8:28:53 AM
Registered User
Joined: 4/1/2011
Posts: 90

Hi Bruce,

Thanks for the PCF, it works perfectly.

Can you do the same with the below PCF%? I want to know what is the lowest value when this PCF was true.

((L - AVGC21) / 5 / SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 21 * AVGC21 ^ 2) / 21) + .5) > .1 AND ((L1 - AVGC21.1) / 5 / SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 + C21 ^ 2 - 21 * AVGC21.1 ^ 2) / 21) + .5) <= .1
 
Thanks in advance.
 
Bruce_L
Posted : Tuesday, February 7, 2017 6:57:18 PM


Worden Trainer

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

Please try the following Indicator Formula in TC2000 v17.

MIN(IIF(XUP((L - AVGC21) / STDDEV21,  -2), L, 3.4028 * 10 ^ 38), 100)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Wednesday, February 15, 2017 6:39:48 AM
Registered User
Joined: 4/1/2011
Posts: 90

Hi Bruce,

Thanks, this works perfectly. I appreciate all your help.

I have another question for you.

I've noticed most technical indicators only use price (C/H/L/O) and time (a number) in their PCF calculation. Besides Chaikin Money Flow and VWAP what other technical indicators uses volume (V), along with price and time in its PCF calculation?

 

Thanks in advance.

Bruce_L
Posted : Wednesday, February 15, 2017 9:55:45 AM


Worden Trainer

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

The calculations are proprietary (and I don't know them in any case), but I think Balance of Power (BOP), Cumulative MoneyStream (MS) and Time Segmented Volume (TSV) all use volume as part of the calculations.

The following may not be a complete list of all of the built in non-proprietary indicators carried by TC2000 utilizing volume, but I am pretty sure everything on this list does use volume in its calculations.

Chaikin Money Flow, Dollar Volume, Ease of Movement, Klinger Volume Oscillator, Klinger Volume Oscillator Histogram, Money Flow Index, Moving VWAP, Negative Volume Index, On Balance Volume, Percent Volume Oscillator, Positive Volume Index, Price Volume Trend, Volume, Volume at Price, Volume Rate of Change, Volume Rate of Change Percent, Volume Zone Oscillator, and VWAP



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
ogsol
Posted : Friday, March 3, 2017 4:44:40 PM
Registered User
Joined: 11/5/2013
Posts: 9

hi bruce 

could u nhelp with following pcf 

high of first candle (opening candle)on a 5 min chart is equal to high of yesterday on daily chart

Bruce_L
Posted : Friday, March 3, 2017 4:46:42 PM


Worden Trainer

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

There really isn't a way to write an automated formula for this. During the first 5 min bar of the trading day the formula on a 5-minute chart would be:

H = MAXH78.1

Druing the second 5 minute bar of the day the formula would be:

H1 = MAXH78.2

During the third 5 minute bar of the day of the formula would be:

H2 = MAXH78.3

Etc....

Help W PCF's



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Friday, September 8, 2017 2:06:24 PM
Registered User
Joined: 4/1/2011
Posts: 90

Hi Bruce,

Can you take each of these PCF's and express the value they produce as a percentage away from the current price? 

 

MIN(IIF(XUP((L - AVGC21) / STDDEV21,  -2), L, 3.4028 * 10 ^ 38), 100)

 

MIN(IIF(STOC10.3 < 10 AND STOC60.3 < 10 AND XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < 10, L, 3.4028 * 10 ^ 38), 100)

 

Thanks in advance 

Bruce_L
Posted : Friday, September 8, 2017 2:13:52 PM


Worden Trainer

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

For the first formula.

100 * (MIN(IIF(XUP((L - AVGC21) / STDDEV21, -2), L, 3.4028 * 10 ^ 38), 100) / C - 1)

For the second formula.

100 * (MIN(IIF(STOC10.3 < 10 AND STOC60.3 < 10 AND XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < 10, L, 3.4028 * 10 ^ 38), 100) / C - 1)

That said, some of the resulting values can be a bit strange.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Friday, September 8, 2017 3:03:50 PM
Registered User
Joined: 4/1/2011
Posts: 90

Thanks Bruce.

I got another question for you.

Using the value produced in these same two PCF's as my hard stop value, can you write a PCF for each that will tell me how many shares to purchase at the current price if I wanted to define my risk (or limit my loss) to $500?

 

Thanks in advance.

Bruce_L
Posted : Friday, September 8, 2017 3:11:16 PM


Worden Trainer

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

So something like?

500 / (C - MIN(IIF(XUP((L - AVGC21) / STDDEV21, -2), L, 3.4028 * 10 ^ 38), 100))

And:

500 / (C - MIN(IIF(STOC10.3 < 10 AND STOC60.3 < 10 AND XAVGC12 - XAVGC26 - XAVG(XAVGC12,9) + XAVG(XAVGC26,9) < 10, L, 3.4028 * 10 ^ 38), 100))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Friday, September 8, 2017 4:41:07 PM
Registered User
Joined: 4/1/2011
Posts: 90

Yes.

Thanks Bruce.

thomasjenkinsjr
Posted : Tuesday, July 17, 2018 4:12:22 PM
Registered User
Joined: 4/1/2011
Posts: 90

Hi Bruce, 

I need your help, along the same lines as above.

 

For the below PCF % true event:

(#1) Can you write a PCF that will tell me the LOWEST value the stock went to when the below PCF was true?

(#2) Can you take the results of (#1) and express the value as a percentage away from the current price?

PCF% true event:

L<L1 AND L1<C AND WSTOC12.3<10 AND (100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) < 30)

 

 

Also....

For the below PCF% true event:

(#3) Can you write a PCF that will tell me the HIGHEST value the stock went to when the below PCF was true?

(#4) Can you take the results of (#3) and express the value as a percentage away from the current price?

PCF% true event:

H > H1 AND C < C1 AND WSTOC12.3>80 AND (100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) > 80)

Thanks in advance.

thomasjenkinsjr
Posted : Tuesday, July 17, 2018 4:19:38 PM
Registered User
Joined: 4/1/2011
Posts: 90

i forgot to add....

i want to see the low / high of the most recent of these PCF% true events.  

Thanks

Bruce_L
Posted : Tuesday, July 17, 2018 4:35:40 PM


Worden Trainer

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

I seem to misunderstanding the request as the two most recent posts seem to be in conflict to some extent in my mind.

You mention the highest and lowest value when the the condition formula was true.

Then you mention "the most recent" of these events. If I am looking at the most recent event, what would be the "highest" or "lowest" about the event?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thomasjenkinsjr
Posted : Tuesday, July 17, 2018 4:39:59 PM
Registered User
Joined: 4/1/2011
Posts: 90

Sorry for the confusion..

so for (#1) i want to know the lowest value of the most recent time when that event was true.

and for (#3) i want to know the highest value of the most recent time when that event was true.

Thanks

thomasjenkinsjr
Posted : Tuesday, July 17, 2018 10:55:38 PM
Registered User
Joined: 4/1/2011
Posts: 90

Ok Bruce, So here is what i have so far...

For (#1):

MIN(IIF(L<L1 AND L1<C AND WSTOC12.3<10 AND (100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) < 30), L, 3.4028 * 10 ^ 38), 250)

Currently, this shows the lowest value when this event was true over the last 250 bars (regardless of how many times the event was true), I need it to show the lowest value the last (or most recent) time this was true within the last 250 bars.

For (#3):

MIN(IIF(H > H1 AND C < C1 AND WSTOC12.3>80 AND (100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) > 80), H, 3.4028 * 10 ^ 38),250)

Same for this one, i need it to show the highest value the last (or most recent) time this event was true within the last 250 bars.

Thanks in advance.

Bruce_L
Posted : Wednesday, July 18, 2018 10:00:50 AM


Worden Trainer

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

I can only write #1 in such a way that it looks back through the most recent 39 bars.

IIF(L < L1 AND L1 < C AND WSTOC12.3 < 10 AND 100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) < 30, L, IIF(L1 < L2 AND L2 < C1 AND WSTOC12.3.1 < 10 AND 100 * SUM(IIF(H1 + L1 + C1 > H2 + L2 + C2, (H1 + L1 + C1) * V1, 0), 12) / SUM((H1 + L1 + C1) * V1, 12) < 30, L1, IIF(L2 < L3 AND L3 < C2 AND WSTOC12.3.2 < 10 AND 100 * SUM(IIF(H2 + L2 + C2 > H3 + L3 + C3, (H2 + L2 + C2) * V2, 0), 12) / SUM((H2 + L2 + C2) * V2, 12) < 30, L2, IIF(L3 < L4 AND L4 < C3 AND WSTOC12.3.3 < 10 AND 100 * SUM(IIF(H3 + L3 + C3 > H4 + L4 + C4, (H3 + L3 + C3) * V3, 0), 12) / SUM((H3 + L3 + C3) * V3, 12) < 30, L3, IIF(L4 < L5 AND L5 < C4 AND WSTOC12.3.4 < 10 AND 100 * SUM(IIF(H4 + L4 + C4 > H5 + L5 + C5, (H4 + L4 + C4) * V4, 0), 12) / SUM((H4 + L4 + C4) * V4, 12) < 30, L4, IIF(L5 < L6 AND L6 < C5 AND WSTOC12.3.5 < 10 AND 100 * SUM(IIF(H5 + L5 + C5 > H6 + L6 + C6, (H5 + L5 + C5) * V5, 0), 12) / SUM((H5 + L5 + C5) * V5, 12) < 30, L5, IIF(L6 < L7 AND L7 < C6 AND WSTOC12.3.6 < 10 AND 100 * SUM(IIF(H6 + L6 + C6 > H7 + L7 + C7, (H6 + L6 + C6) * V6, 0), 12) / SUM((H6 + L6 + C6) * V6, 12) < 30, L6, IIF(L7 < L8 AND L8 < C7 AND WSTOC12.3.7 < 10 AND 100 * SUM(IIF(H7 + L7 + C7 > H8 + L8 + C8, (H7 + L7 + C7) * V7, 0), 12) / SUM((H7 + L7 + C7) * V7, 12) < 30, L7, IIF(L8 < L9 AND L9 < C8 AND WSTOC12.3.8 < 10 AND 100 * SUM(IIF(H8 + L8 + C8 > H9 + L9 + C9, (H8 + L8 + C8) * V8, 0), 12) / SUM((H8 + L8 + C8) * V8, 12) < 30, L8, IIF(L9 < L10 AND L10 < C9 AND WSTOC12.3.9 < 10 AND 100 * SUM(IIF(H9 + L9 + C9 > H10 + L10 + C10, (H9 + L9 + C9) * V9, 0), 12) / SUM((H9 + L9 + C9) * V9, 12) < 30, L9, IIF(L10 < L11 AND L11 < C10 AND WSTOC12.3.10 < 10 AND 100 * SUM(IIF(H10 + L10 + C10 > H11 + L11 + C11, (H10 + L10 + C10) * V10, 0), 12) / SUM((H10 + L10 + C10) * V10, 12) < 30, L10, IIF(L11 < L12 AND L12 < C11 AND WSTOC12.3.11 < 10 AND 100 * SUM(IIF(H11 + L11 + C11 > H12 + L12 + C12, (H11 + L11 + C11) * V11, 0), 12) / SUM((H11 + L11 + C11) * V11, 12) < 30, L11, IIF(L12 < L13 AND L13 < C12 AND WSTOC12.3.12 < 10 AND 100 * SUM(IIF(H12 + L12 + C12 > H13 + L13 + C13, (H12 + L12 + C12) * V12, 0), 12) / SUM((H12 + L12 + C12) * V12, 12) < 30, L12, IIF(L13 < L14 AND L14 < C13 AND WSTOC12.3.13 < 10 AND 100 * SUM(IIF(H13 + L13 + C13 > H14 + L14 + C14, (H13 + L13 + C13) * V13, 0), 12) / SUM((H13 + L13 + C13) * V13, 12) < 30, L13, IIF(L14 < L15 AND L15 < C14 AND WSTOC12.3.14 < 10 AND 100 * SUM(IIF(H14 + L14 + C14 > H15 + L15 + C15, (H14 + L14 + C14) * V14, 0), 12) / SUM((H14 + L14 + C14) * V14, 12) < 30, L14, IIF(L15 < L16 AND L16 < C15 AND WSTOC12.3.15 < 10 AND 100 * SUM(IIF(H15 + L15 + C15 > H16 + L16 + C16, (H15 + L15 + C15) * V15, 0), 12) / SUM((H15 + L15 + C15) * V15, 12) < 30, L15, IIF(L16 < L17 AND L17 < C16 AND WSTOC12.3.16 < 10 AND 100 * SUM(IIF(H16 + L16 + C16 > H17 + L17 + C17, (H16 + L16 + C16) * V16, 0), 12) / SUM((H16 + L16 + C16) * V16, 12) < 30, L16, IIF(L17 < L18 AND L18 < C17 AND WSTOC12.3.17 < 10 AND 100 * SUM(IIF(H17 + L17 + C17 > H18 + L18 + C18, (H17 + L17 + C17) * V17, 0), 12) / SUM((H17 + L17 + C17) * V17, 12) < 30, L17, IIF(L18 < L19 AND L19 < C18 AND WSTOC12.3.18 < 10 AND 100 * SUM(IIF(H18 + L18 + C18 > H19 + L19 + C19, (H18 + L18 + C18) * V18, 0), 12) / SUM((H18 + L18 + C18) * V18, 12) < 30, L18, IIF(L19 < L20 AND L20 < C19 AND WSTOC12.3.19 < 10 AND 100 * SUM(IIF(H19 + L19 + C19 > H20 + L20 + C20, (H19 + L19 + C19) * V19, 0), 12) / SUM((H19 + L19 + C19) * V19, 12) < 30, L19, IIF(L20 < L21 AND L21 < C20 AND WSTOC12.3.20 < 10 AND 100 * SUM(IIF(H20 + L20 + C20 > H21 + L21 + C21, (H20 + L20 + C20) * V20, 0), 12) / SUM((H20 + L20 + C20) * V20, 12) < 30, L20, IIF(L21 < L22 AND L22 < C21 AND WSTOC12.3.21 < 10 AND 100 * SUM(IIF(H21 + L21 + C21 > H22 + L22 + C22, (H21 + L21 + C21) * V21, 0), 12) / SUM((H21 + L21 + C21) * V21, 12) < 30, L21, IIF(L22 < L23 AND L23 < C22 AND WSTOC12.3.22 < 10 AND 100 * SUM(IIF(H22 + L22 + C22 > H23 + L23 + C23, (H22 + L22 + C22) * V22, 0), 12) / SUM((H22 + L22 + C22) * V22, 12) < 30, L22, IIF(L23 < L24 AND L24 < C23 AND WSTOC12.3.23 < 10 AND 100 * SUM(IIF(H23 + L23 + C23 > H24 + L24 + C24, (H23 + L23 + C23) * V23, 0), 12) / SUM((H23 + L23 + C23) * V23, 12) < 30, L23, IIF(L24 < L25 AND L25 < C24 AND WSTOC12.3.24 < 10 AND 100 * SUM(IIF(H24 + L24 + C24 > H25 + L25 + C25, (H24 + L24 + C24) * V24, 0), 12) / SUM((H24 + L24 + C24) * V24, 12) < 30, L24, IIF(L25 < L26 AND L26 < C25 AND WSTOC12.3.25 < 10 AND 100 * SUM(IIF(H25 + L25 + C25 > H26 + L26 + C26, (H25 + L25 + C25) * V25, 0), 12) / SUM((H25 + L25 + C25) * V25, 12) < 30, L25, IIF(L26 < L27 AND L27 < C26 AND WSTOC12.3.26 < 10 AND 100 * SUM(IIF(H26 + L26 + C26 > H27 + L27 + C27, (H26 + L26 + C26) * V26, 0), 12) / SUM((H26 + L26 + C26) * V26, 12) < 30, L26, IIF(L27 < L28 AND L28 < C27 AND WSTOC12.3.27 < 10 AND 100 * SUM(IIF(H27 + L27 + C27 > H28 + L28 + C28, (H27 + L27 + C27) * V27, 0), 12) / SUM((H27 + L27 + C27) * V27, 12) < 30, L27, IIF(L28 < L29 AND L29 < C28 AND WSTOC12.3.28 < 10 AND 100 * SUM(IIF(H28 + L28 + C28 > H29 + L29 + C29, (H28 + L28 + C28) * V28, 0), 12) / SUM((H28 + L28 + C28) * V28, 12) < 30, L28, IIF(L29 < L30 AND L30 < C29 AND WSTOC12.3.29 < 10 AND 100 * SUM(IIF(H29 + L29 + C29 > H30 + L30 + C30, (H29 + L29 + C29) * V29, 0), 12) / SUM((H29 + L29 + C29) * V29, 12) < 30, L29, IIF(L30 < L31 AND L31 < C30 AND WSTOC12.3.30 < 10 AND 100 * SUM(IIF(H30 + L30 + C30 > H31 + L31 + C31, (H30 + L30 + C30) * V30, 0), 12) / SUM((H30 + L30 + C30) * V30, 12) < 30, L30, IIF(L31 < L32 AND L32 < C31 AND WSTOC12.3.31 < 10 AND 100 * SUM(IIF(H31 + L31 + C31 > H32 + L32 + C32, (H31 + L31 + C31) * V31, 0), 12) / SUM((H31 + L31 + C31) * V31, 12) < 30, L31, IIF(L32 < L33 AND L33 < C32 AND WSTOC12.3.32 < 10 AND 100 * SUM(IIF(H32 + L32 + C32 > H33 + L33 + C33, (H32 + L32 + C32) * V32, 0), 12) / SUM((H32 + L32 + C32) * V32, 12) < 30, L32, IIF(L33 < L34 AND L34 < C33 AND WSTOC12.3.33 < 10 AND 100 * SUM(IIF(H33 + L33 + C33 > H34 + L34 + C34, (H33 + L33 + C33) * V33, 0), 12) / SUM((H33 + L33 + C33) * V33, 12) < 30, L33, IIF(L34 < L35 AND L35 < C34 AND WSTOC12.3.34 < 10 AND 100 * SUM(IIF(H34 + L34 + C34 > H35 + L35 + C35, (H34 + L34 + C34) * V34, 0), 12) / SUM((H34 + L34 + C34) * V34, 12) < 30, L34, IIF(L35 < L36 AND L36 < C35 AND WSTOC12.3.35 < 10 AND 100 * SUM(IIF(H35 + L35 + C35 > H36 + L36 + C36, (H35 + L35 + C35) * V35, 0), 12) / SUM((H35 + L35 + C35) * V35, 12) < 30, L35, IIF(L36 < L37 AND L37 < C36 AND WSTOC12.3.36 < 10 AND 100 * SUM(IIF(H36 + L36 + C36 > H37 + L37 + C37, (H36 + L36 + C36) * V36, 0), 12) / SUM((H36 + L36 + C36) * V36, 12) < 30, L36, IIF(L37 < L38 AND L38 < C37 AND WSTOC12.3.37 < 10 AND 100 * SUM(IIF(H37 + L37 + C37 > H38 + L38 + C38, (H37 + L37 + C37) * V37, 0), 12) / SUM((H37 + L37 + C37) * V37, 12) < 30, L37, IIF(L38 < L39 AND L39 < C38 AND WSTOC12.3.38 < 10 AND 100 * SUM(IIF(H38 + L38 + C38 > H39 + L39 + C39, (H38 + L38 + C38) * V38, 0), 12) / SUM((H38 + L38 + C38) * V38, 12) < 30, L38, 1 / 0)))))))))))))))))))))))))))))))))))))))

The same is true of #3.

IIF(H > H1 AND C1 < C AND WSTOC12.3 > 80 AND 100 * SUM(IIF(H + L + C > H1 + L1 + C1, (H + L + C) * V, 0), 12) / SUM((H + L + C) * V, 12) > 80, H, IIF(H1 > H2 AND C2 < C1 AND WSTOC12.3.1 > 80 AND 100 * SUM(IIF(H1 + L1 + C1 > H2 + L2 + C2, (H1 + L1 + C1) * V1, 0), 12) / SUM((H1 + L1 + C1) * V1, 12) > 80, H1, IIF(H2 > H3 AND C3 < C2 AND WSTOC12.3.2 > 80 AND 100 * SUM(IIF(H2 + L2 + C2 > H3 + L3 + C3, (H2 + L2 + C2) * V2, 0), 12) / SUM((H2 + L2 + C2) * V2, 12) > 80, H2, IIF(H3 > H4 AND C4 < C3 AND WSTOC12.3.3 > 80 AND 100 * SUM(IIF(H3 + L3 + C3 > H4 + L4 + C4, (H3 + L3 + C3) * V3, 0), 12) / SUM((H3 + L3 + C3) * V3, 12) > 80, H3, IIF(H4 > H5 AND C5 < C4 AND WSTOC12.3.4 > 80 AND 100 * SUM(IIF(H4 + L4 + C4 > H5 + L5 + C5, (H4 + L4 + C4) * V4, 0), 12) / SUM((H4 + L4 + C4) * V4, 12) > 80, H4, IIF(H5 > H6 AND C6 < C5 AND WSTOC12.3.5 > 80 AND 100 * SUM(IIF(H5 + L5 + C5 > H6 + L6 + C6, (H5 + L5 + C5) * V5, 0), 12) / SUM((H5 + L5 + C5) * V5, 12) > 80, H5, IIF(H6 > H7 AND C7 < C6 AND WSTOC12.3.6 > 80 AND 100 * SUM(IIF(H6 + L6 + C6 > H7 + L7 + C7, (H6 + L6 + C6) * V6, 0), 12) / SUM((H6 + L6 + C6) * V6, 12) > 80, H6, IIF(H7 > H8 AND C8 < C7 AND WSTOC12.3.7 > 80 AND 100 * SUM(IIF(H7 + L7 + C7 > H8 + L8 + C8, (H7 + L7 + C7) * V7, 0), 12) / SUM((H7 + L7 + C7) * V7, 12) > 80, H7, IIF(H8 > H9 AND C9 < C8 AND WSTOC12.3.8 > 80 AND 100 * SUM(IIF(H8 + L8 + C8 > H9 + L9 + C9, (H8 + L8 + C8) * V8, 0), 12) / SUM((H8 + L8 + C8) * V8, 12) > 80, H8, IIF(H9 > H10 AND C10 < C9 AND WSTOC12.3.9 > 80 AND 100 * SUM(IIF(H9 + L9 + C9 > H10 + L10 + C10, (H9 + L9 + C9) * V9, 0), 12) / SUM((H9 + L9 + C9) * V9, 12) > 80, H9, IIF(H10 > H11 AND C11 < C10 AND WSTOC12.3.10 > 80 AND 100 * SUM(IIF(H10 + L10 + C10 > H11 + L11 + C11, (H10 + L10 + C10) * V10, 0), 12) / SUM((H10 + L10 + C10) * V10, 12) > 80, H10, IIF(H11 > H12 AND C12 < C11 AND WSTOC12.3.11 > 80 AND 100 * SUM(IIF(H11 + L11 + C11 > H12 + L12 + C12, (H11 + L11 + C11) * V11, 0), 12) / SUM((H11 + L11 + C11) * V11, 12) > 80, H11, IIF(H12 > H13 AND C13 < C12 AND WSTOC12.3.12 > 80 AND 100 * SUM(IIF(H12 + L12 + C12 > H13 + L13 + C13, (H12 + L12 + C12) * V12, 0), 12) / SUM((H12 + L12 + C12) * V12, 12) > 80, H12, IIF(H13 > H14 AND C14 < C13 AND WSTOC12.3.13 > 80 AND 100 * SUM(IIF(H13 + L13 + C13 > H14 + L14 + C14, (H13 + L13 + C13) * V13, 0), 12) / SUM((H13 + L13 + C13) * V13, 12) > 80, H13, IIF(H14 > H15 AND C15 < C14 AND WSTOC12.3.14 > 80 AND 100 * SUM(IIF(H14 + L14 + C14 > H15 + L15 + C15, (H14 + L14 + C14) * V14, 0), 12) / SUM((H14 + L14 + C14) * V14, 12) > 80, H14, IIF(H15 > H16 AND C16 < C15 AND WSTOC12.3.15 > 80 AND 100 * SUM(IIF(H15 + L15 + C15 > H16 + L16 + C16, (H15 + L15 + C15) * V15, 0), 12) / SUM((H15 + L15 + C15) * V15, 12) > 80, H15, IIF(H16 > H17 AND C17 < C16 AND WSTOC12.3.16 > 80 AND 100 * SUM(IIF(H16 + L16 + C16 > H17 + L17 + C17, (H16 + L16 + C16) * V16, 0), 12) / SUM((H16 + L16 + C16) * V16, 12) > 80, H16, IIF(H17 > H18 AND C18 < C17 AND WSTOC12.3.17 > 80 AND 100 * SUM(IIF(H17 + L17 + C17 > H18 + L18 + C18, (H17 + L17 + C17) * V17, 0), 12) / SUM((H17 + L17 + C17) * V17, 12) > 80, H17, IIF(H18 > H19 AND C19 < C18 AND WSTOC12.3.18 > 80 AND 100 * SUM(IIF(H18 + L18 + C18 > H19 + L19 + C19, (H18 + L18 + C18) * V18, 0), 12) / SUM((H18 + L18 + C18) * V18, 12) > 80, H18, IIF(H19 > H20 AND C20 < C19 AND WSTOC12.3.19 > 80 AND 100 * SUM(IIF(H19 + L19 + C19 > H20 + L20 + C20, (H19 + L19 + C19) * V19, 0), 12) / SUM((H19 + L19 + C19) * V19, 12) > 80, H19, IIF(H20 > H21 AND C21 < C20 AND WSTOC12.3.20 > 80 AND 100 * SUM(IIF(H20 + L20 + C20 > H21 + L21 + C21, (H20 + L20 + C20) * V20, 0), 12) / SUM((H20 + L20 + C20) * V20, 12) > 80, H20, IIF(H21 > H22 AND C22 < C21 AND WSTOC12.3.21 > 80 AND 100 * SUM(IIF(H21 + L21 + C21 > H22 + L22 + C22, (H21 + L21 + C21) * V21, 0), 12) / SUM((H21 + L21 + C21) * V21, 12) > 80, H21, IIF(H22 > H23 AND C23 < C22 AND WSTOC12.3.22 > 80 AND 100 * SUM(IIF(H22 + L22 + C22 > H23 + L23 + C23, (H22 + L22 + C22) * V22, 0), 12) / SUM((H22 + L22 + C22) * V22, 12) > 80, H22, IIF(H23 > H24 AND C24 < C23 AND WSTOC12.3.23 > 80 AND 100 * SUM(IIF(H23 + L23 + C23 > H24 + L24 + C24, (H23 + L23 + C23) * V23, 0), 12) / SUM((H23 + L23 + C23) * V23, 12) > 80, H23, IIF(H24 > H25 AND C25 < C24 AND WSTOC12.3.24 > 80 AND 100 * SUM(IIF(H24 + L24 + C24 > H25 + L25 + C25, (H24 + L24 + C24) * V24, 0), 12) / SUM((H24 + L24 + C24) * V24, 12) > 80, H24, IIF(H25 > H26 AND C26 < C25 AND WSTOC12.3.25 > 80 AND 100 * SUM(IIF(H25 + L25 + C25 > H26 + L26 + C26, (H25 + L25 + C25) * V25, 0), 12) / SUM((H25 + L25 + C25) * V25, 12) > 80, H25, IIF(H26 > H27 AND C27 < C26 AND WSTOC12.3.26 > 80 AND 100 * SUM(IIF(H26 + L26 + C26 > H27 + L27 + C27, (H26 + L26 + C26) * V26, 0), 12) / SUM((H26 + L26 + C26) * V26, 12) > 80, H26, IIF(H27 > H28 AND C28 < C27 AND WSTOC12.3.27 > 80 AND 100 * SUM(IIF(H27 + L27 + C27 > H28 + L28 + C28, (H27 + L27 + C27) * V27, 0), 12) / SUM((H27 + L27 + C27) * V27, 12) > 80, H27, IIF(H28 > H29 AND C29 < C28 AND WSTOC12.3.28 > 80 AND 100 * SUM(IIF(H28 + L28 + C28 > H29 + L29 + C29, (H28 + L28 + C28) * V28, 0), 12) / SUM((H28 + L28 + C28) * V28, 12) > 80, H28, IIF(H29 > H30 AND C30 < C29 AND WSTOC12.3.29 > 80 AND 100 * SUM(IIF(H29 + L29 + C29 > H30 + L30 + C30, (H29 + L29 + C29) * V29, 0), 12) / SUM((H29 + L29 + C29) * V29, 12) > 80, H29, IIF(H30 > H31 AND C31 < C30 AND WSTOC12.3.30 > 80 AND 100 * SUM(IIF(H30 + L30 + C30 > H31 + L31 + C31, (H30 + L30 + C30) * V30, 0), 12) / SUM((H30 + L30 + C30) * V30, 12) > 80, H30, IIF(H31 > H32 AND C32 < C31 AND WSTOC12.3.31 > 80 AND 100 * SUM(IIF(H31 + L31 + C31 > H32 + L32 + C32, (H31 + L31 + C31) * V31, 0), 12) / SUM((H31 + L31 + C31) * V31, 12) > 80, H31, IIF(H32 > H33 AND C33 < C32 AND WSTOC12.3.32 > 80 AND 100 * SUM(IIF(H32 + L32 + C32 > H33 + L33 + C33, (H32 + L32 + C32) * V32, 0), 12) / SUM((H32 + L32 + C32) * V32, 12) > 80, H32, IIF(H33 > H34 AND C34 < C33 AND WSTOC12.3.33 > 80 AND 100 * SUM(IIF(H33 + L33 + C33 > H34 + L34 + C34, (H33 + L33 + C33) * V33, 0), 12) / SUM((H33 + L33 + C33) * V33, 12) > 80, H33, IIF(H34 > H35 AND C35 < C34 AND WSTOC12.3.34 > 80 AND 100 * SUM(IIF(H34 + L34 + C34 > H35 + L35 + C35, (H34 + L34 + C34) * V34, 0), 12) / SUM((H34 + L34 + C34) * V34, 12) > 80, H34, IIF(H35 > H36 AND C36 < C35 AND WSTOC12.3.35 > 80 AND 100 * SUM(IIF(H35 + L35 + C35 > H36 + L36 + C36, (H35 + L35 + C35) * V35, 0), 12) / SUM((H35 + L35 + C35) * V35, 12) > 80, H35, IIF(H36 > H37 AND C37 < C36 AND WSTOC12.3.36 > 80 AND 100 * SUM(IIF(H36 + L36 + C36 > H37 + L37 + C37, (H36 + L36 + C36) * V36, 0), 12) / SUM((H36 + L36 + C36) * V36, 12) > 80, H36, IIF(H37 > H38 AND C38 < C37 AND WSTOC12.3.37 > 80 AND 100 * SUM(IIF(H37 + L37 + C37 > H38 + L38 + C38, (H37 + L37 + C37) * V37, 0), 12) / SUM((H37 + L37 + C37) * V37, 12) > 80, H37, IIF(H38 > H39 AND C39 < C38 AND WSTOC12.3.38 > 80 AND 100 * SUM(IIF(H38 + L38 + C38 > H39 + L39 + C39, (H38 + L38 + C38) * V38, 0), 12) / SUM((H38 + L38 + C38) * V38, 12) > 80, H38, 1 / 0)))))))))))))))))))))))))))))))))))))))

You can place either of the above sections inside the following template to get a formula for how far these values are above or below the current price as a percentage.

100 * (Code From Above / C - 1)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
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.