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 |

30 period volume standard deviation Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
Snooowman
Posted : Tuesday, March 10, 2015 9:06:11 AM
Registered User
Joined: 1/28/2014
Posts: 34

Hello, Could you please tell me the formula to create an indicator to show standard deviation over the past 30 bars (including the current bar). I'm using 5 min bars and looking for volume that is greater then 1.95 standard deviation based on the 30 bars.

If I have the standard deviation plotted on my chart then I can create a scan condition that plot to look for SD greater then 1.95.

Thanks

Bruce_L
Posted : Tuesday, March 10, 2015 10:01:05 AM


Worden Trainer

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

The 30-period standard deviation of volume can be written as follows.

SQR(ABS(V ^ 2 + V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 - 30 * AVGV30 ^ 2) / 30)

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Snooowman
Posted : Wednesday, March 11, 2015 12:53:29 AM
Registered User
Joined: 1/28/2014
Posts: 34

Thanks Bruce, I created the PCF indicator and there was one formula error for parenthisis so it was obvious I just added a bracket at the end after 30.

But I'm wondering about scaling because I get values in the range of 100 to 500 K. I was expecting a normal distribution on a scale of maybe -10 to +10. Do you know what I mean. I could create a mathmatical standard deviation chart with sample data to help explain. The scale just seems way out there and I tried the scaling under edit with no luck.

Thanks

Snooowman
Posted : Wednesday, March 11, 2015 1:15:12 AM
Registered User
Joined: 1/28/2014
Posts: 34

Bruce maybe an easier way to do this is plot a bollinger band on volume (set the Std Dev to 1.95 and period to 30) and then scan for volume crossing the top band.

I've done it and I can see when volume is crossing 1.95 std deviation but is there a formula that would return the actual std deviation  like 1.95, 2.3, 3.5 type of result? You see what I mean the actual standard dveiation some result like 500K

Thanks

Snooowman
Posted : Wednesday, March 11, 2015 1:16:10 AM
Registered User
Joined: 1/28/2014
Posts: 34

Opps I meant "not some result like 500K"

Bruce_L
Posted : Wednesday, March 11, 2015 9:46:13 AM


Worden Trainer

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

You could divide the standard deviation by the average volume to make it comparable between symbols.

SQR(ABS(V ^ 2 + V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 - 30 * AVGV30 ^ 2) / 30) / AVGV30

Your idea of using Bollinger Bands is probably the best option for what I suspect you really want. I would probably use above instead of crossing up though.

If you want to plot how many standard deviations volume is above or below its moving average, you could use something like the following.

(V - AVGV30) / SQR(ABS(V ^ 2 + V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 - 30 * AVGV30 ^ 2) / 30)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Snooowman
Posted : Saturday, March 14, 2015 6:11:18 PM
Registered User
Joined: 1/28/2014
Posts: 34

Thanks Bruce, Sounds good and the  formula is returning some good results I can use.

 

Snooowman
Posted : Wednesday, March 18, 2015 3:45:35 PM
Registered User
Joined: 1/28/2014
Posts: 34

HI Bruce, A bit a a simple question but how do I test if the current close is the max close for the Day. I wrote a Daily timeframe PCF (C=MaxC) but it doesn't work. It returns true all the time and just uses the current C value on both sides of the equation.

I just want to add a condition to check if the last 2 Min candle is reaching the Max C for the day.

 

I'm missing something simple.

Thanks

StockGuy
Posted : Wednesday, March 18, 2015 3:57:48 PM

Administration

Joined: 9/30/2004
Posts: 9,187

The maximum last/close price for the day would be the high, so C=H.

Snooowman
Posted : Thursday, March 19, 2015 12:29:27 AM
Registered User
Joined: 1/28/2014
Posts: 34

I don't think this will work becasue there could have been a high reached that is greater then the maximum close reached that day. So the maximum close would return FALSE. using C=H

I don't undertsand why the formula MAXC doesn't return the maximum close for the day. Shouldn't it. And then C=MAXC would return True if the close was the maximum reached so far that day.

Bruce_L
Posted : Thursday, March 19, 2015 9:38:29 AM


Worden Trainer

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

No, MAXC should not return the highest close of the day. The format of MAXC in the Personal Criteria Formula Language is as follows.

MAXCx.z -> Maximum of Close/Last Price

Where x is the Period of the Indicator or Function.
Where z is the number of Periods Ago.
- z can also be a date. May 3, 2007 would be (single quotes required): '05/03/07'

PCF Formula Descriptions

So MAXC ends up just being C because not specifying a period means it defaults to 1.

You can check for price being at its high of the day currently with the formula given by StockGuy.

C = H

But you cannot check for price being at or above all of the previous closing prices during the trading day without knowing how many bars have happened so far during the trading day.

So for example, if you are ten bars into the trading day, you could use the following.

C = MAXC10

But also note that C doesn't become the close of the bar until the bar actually closes. Since we are not specifying a number of bars ago, this defaults to 0. This means it is looking at the current bar. Unless that bar is the last bar of the trading day and the market has closed, C is the current price and is subject to change until the bar closes. So prior to the end of the trading day, you would need to use C1 if you want to check for the actual closing price of the bar.

You would also need to increment the bars ago parameter in the MAXC section. So if you are interested in closing prices of intraday bars, you would need to use the following during the tenth bar of the trading day.

C1 = MAXC9.1

This would be checking for the close of the ninth bar to be at or above the closes of the previous 8 bars since only 9 bars will have actually finished forming.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Snooowman
Posted : Thursday, March 19, 2015 4:26:35 PM
Registered User
Joined: 1/28/2014
Posts: 34

Thanks Bruce and this is interesting that there is no way if your tracking 5 minutes bars to see if the last bar (C1) is the higest from all 5 min bars so far inthe day without specifying how many bars back. Too bad.

Thanks for clarifying.

tdlc007
Posted : Friday, March 27, 2015 6:57:25 PM
Registered User
Joined: 2/13/2014
Posts: 37

I'm using daily chart and looking for volume that is greater then 1.95 standard deviation based on the previous 150 bars. Is that possible and could you tell me how to write that?

 

Thanks

Bruce_L
Posted : Monday, March 30, 2015 11:53:34 AM


Worden Trainer

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

The following Condition Formula is for volume being greater than 1.95 times the standard deviation of volume ending 1 bar ago.

V > 1.95 * SQR(ABS(V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 + V30 ^ 2 + V31 ^ 2 + V32 ^ 2 + V33 ^ 2 + V34 ^ 2 + V35 ^ 2 + V36 ^ 2 + V37 ^ 2 + V38 ^ 2 + V39 ^ 2 + V40 ^ 2 + V41 ^ 2 + V42 ^ 2 + V43 ^ 2 + V44 ^ 2 + V45 ^ 2 + V46 ^ 2 + V47 ^ 2 + V48 ^ 2 + V49 ^ 2 + V50 ^ 2 + V51 ^ 2 + V52 ^ 2 + V53 ^ 2 + V54 ^ 2 + V55 ^ 2 + V56 ^ 2 + V57 ^ 2 + V58 ^ 2 + V59 ^ 2 + V60 ^ 2 + V61 ^ 2 + V62 ^ 2 + V63 ^ 2 + V64 ^ 2 + V65 ^ 2 + V66 ^ 2 + V67 ^ 2 + V68 ^ 2 + V69 ^ 2 + V70 ^ 2 + V71 ^ 2 + V72 ^ 2 + V73 ^ 2 + V74 ^ 2 + V75 ^ 2 + V76 ^ 2 + V77 ^ 2 + V78 ^ 2 + V79 ^ 2 + V80 ^ 2 + V81 ^ 2 + V82 ^ 2 + V83 ^ 2 + V84 ^ 2 + V85 ^ 2 + V86 ^ 2 + V87 ^ 2 + V88 ^ 2 + V89 ^ 2 + V90 ^ 2 + V91 ^ 2 + V92 ^ 2 + V93 ^ 2 + V94 ^ 2 + V95 ^ 2 + V96 ^ 2 + V97 ^ 2 + V98 ^ 2 + V99 ^ 2 + V100 ^ 2 + V101 ^ 2 + V102 ^ 2 + V103 ^ 2 + V104 ^ 2 + V105 ^ 2 + V106 ^ 2 + V107 ^ 2 + V108 ^ 2 + V109 ^ 2 + V110 ^ 2 + V111 ^ 2 + V112 ^ 2 + V113 ^ 2 + V114 ^ 2 + V115 ^ 2 + V116 ^ 2 + V117 ^ 2 + V118 ^ 2 + V119 ^ 2 + V120 ^ 2 + V121 ^ 2 + V122 ^ 2 + V123 ^ 2 + V124 ^ 2 + V125 ^ 2 + V126 ^ 2 + V127 ^ 2 + V128 ^ 2 + V129 ^ 2 + V130 ^ 2 + V131 ^ 2 + V132 ^ 2 + V133 ^ 2 + V134 ^ 2 + V135 ^ 2 + V136 ^ 2 + V137 ^ 2 + V138 ^ 2 + V139 ^ 2 + V140 ^ 2 + V141 ^ 2 + V142 ^ 2 + V143 ^ 2 + V144 ^ 2 + V145 ^ 2 + V146 ^ 2 + V147 ^ 2 + V148 ^ 2 + V149 ^ 2 + V150 ^ 2 - 150 * AVGV150.1 ^ 2) / 150)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdlc007
Posted : Friday, May 8, 2015 2:00:10 AM
Registered User
Joined: 2/13/2014
Posts: 37

QUOTE (Bruce_L)

The 30-period standard deviation of volume can be written as follows.

SQR(ABS(V ^ 2 + V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 - 30 * AVGV30 ^ 2) / 30)

Modelling Bollinger Bands (& Standard Deviation) in a TC PCF

Can you tell me how to write the 30 period standard deviation of price rather than volume?

 

thanks

Bruce_L
Posted : Friday, May 8, 2015 8:49:59 AM


Worden Trainer

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

Just substitute C for all instances of V in the formula.

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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AVGC30 ^ 2) / 30)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdlc007
Posted : Friday, May 8, 2015 9:15:31 AM
Registered User
Joined: 2/13/2014
Posts: 37

QUOTE (Bruce_L)

Just substitute C for all instances of V in the formula.

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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

 

Thanks Bruce...now if I wanted to incorporate the absolute value of open- close of the current candle with this 30 period standard deviation of price, how would I write that?

Bruce_L
Posted : Friday, May 8, 2015 9:17:45 AM


Worden Trainer

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

In what way? Do you want to add it?

ABS(O - C) + 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Take the ratio?

ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Something else?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdlc007
Posted : Friday, May 8, 2015 9:25:40 AM
Registered User
Joined: 2/13/2014
Posts: 37

QUOTE (Bruce_L)

In what way? Do you want to add it?

ABS(O - C) + 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Take the ratio?

ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Something else?

 

Perfect It was the ratio I was looking for..Thanks Bruce

tdlc007
Posted : Sunday, May 17, 2015 4:41:04 PM
Registered User
Joined: 2/13/2014
Posts: 37

Hi 

I am now looking to plot this:

 

ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

 

on either the high or low of the candle whenever the value returns equal to or higher than 1.95...Is that possible?

 

Thanks

 

QUOTE (tdlc007)

QUOTE (Bruce_L)

In what way? Do you want to add it?

ABS(O - C) + 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Take the ratio?

ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30)

Something else?

 

Perfect It was the ratio I was looking for..Thanks Bruce

Bruce_L
Posted : Tuesday, May 19, 2015 10:58:01 AM


Worden Trainer

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

So maybe something like the following plotted as a Custom PCF Indicator set to the Dot Plot Style?

H * ABS(ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30) > 1.95)

Or would is there some requirement as to when you choose the high vs the low instead of just plotting a dot on the high?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
tdlc007
Posted : Wednesday, May 20, 2015 9:23:16 AM
Registered User
Joined: 2/13/2014
Posts: 37

QUOTE (Bruce_L)

So maybe something like the following plotted as a Custom PCF Indicator set to the Dot Plot Style?

H * ABS(ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * ACGC30 ^ 2) / 30) > 1.95)

Or would is there some requirement as to when you choose the high vs the low instead of just plotting a dot on the high?

 

Thanks Bruce

 

Now if I wanted to look for this pcf indicator below but for the Previous 1 candle before it, how would I write this

 

h * ABS(ABS(O - C) / 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 + C21 ^ 2 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 - 30 * AvGC30 ^ 2) / 30) > 1.95 and  (V - AVGV30)/ SQR(ABS(V ^ 2 + V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 - 30 * AVGV30 ^ 2) / 30) > 1.95) 

 

Thanks

Bruce_L
Posted : Wednesday, May 20, 2015 9:50:16 AM


Worden Trainer

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

You would need to add 1 to all of the bars ago parameter is the formula. If you still want it to plot at the high of the current bar instead of plotting the high of the previous bar on the current bar you would need to change the H1 at the beginning of the following formula to an H instead.

H1 * ABS(ABS(O1 - C1) / SQR(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 + C22 ^ 2 + C23 ^ 2 + C24 ^ 2 + C25 ^ 2 + C26 ^ 2 + C27 ^ 2 + C28 ^ 2 + C29 ^ 2 + C30 ^ 2 - 30 * AVGC30.1 ^ 2) / 30) > 1.95 AND (V1 - AVGV30.1)/ SQR(ABS(V1 ^ 2 + V2 ^ 2 + V3 ^ 2 + V4 ^ 2 + V5 ^ 2 + V6 ^ 2 + V7 ^ 2 + V8 ^ 2 + V9 ^ 2 + V10 ^ 2 + V11 ^ 2 + V12 ^ 2 + V13 ^ 2 + V14 ^ 2 + V15 ^ 2 + V16 ^ 2 + V17 ^ 2 + V18 ^ 2 + V19 ^ 2 + V20 ^ 2 + V21 ^ 2 + V22 ^ 2 + V23 ^ 2 + V24 ^ 2 + V25 ^ 2 + V26 ^ 2 + V27 ^ 2 + V28 ^ 2 + V29 ^ 2 + V30 ^ 2 - 30 * AVGV30.1 ^ 2) / 30) > 1.95)



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