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

Worden Discussion Forum » Customer Training & Support » Ask a Trainer - TC2000 version 12/18 » Volume question

Volume question Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
dhirenshah
Posted : Thursday, March 29, 2018 12:57:46 PM
Registered User
Joined: 3/10/2012
Posts: 465

Bruce 2 quick questions please

1) Need 2 standard deviation of 20 bar average volume in boolean formula so how to write that ?

 

2) this below pcf u did for somebody in forum and wanted to ask you what exactly the output of Value 63 being the highest and 8  ,10,31 etc signify for interpretation ??

IIF(XUP(IIF(V > 1.5 * AVGV30, IIF(C > C1 AND V > 1.5 * AVGV30, IIF(C1 < C2 AND V <= V1, 0, IIF(C2 < C3 AND V <= V2, 1, IIF(C3 < C4 AND V <= V3, 2, IIF(C4 < C5 AND V <= V4, 3, IIF(C5 < C6 AND V <= V5, 4, IIF(C6 < C7 AND V <= V6, 5, IIF(C7 < C8 AND V <= V7, 6, IIF(C8 < C9 AND V <= V8, 7, IIF(C9 < C10 AND V <= V9, 8, IIF(C10 < C11 AND V <= V10, 9, IIF(C11 < C12 AND V <= V11, 10, IIF(C12 < C13 AND V <= V12, 11, IIF(C13 < C14 AND V <= V13, 12, IIF(C14 < C15 AND V <= V14, 13, IIF(C15 < C16 AND V <= V15, 14, IIF(C16 < C17 AND V <= V16, 15, IIF(C17 < C18 AND V <= V17, 16, IIF(C18 < C19 AND V <= V18, 17, IIF(C19 < C20 AND V <= V19, 18, IIF(C20 < C21 AND V <= V20, 19, IIF(C21 < C22 AND V <= V21, 20, IIF(C22 < C23 AND V <= V22, 21, IIF(C23 < C24 AND V <= V23, 22, IIF(C24 < C25 AND V <= V24, 23, IIF(C25 < C26 AND V <= V25, 24, IIF(C26 < C27 AND V <= V26, 25, IIF(C27 < C28 AND V <= V27, 26, IIF(C28 < C29 AND V <= V28, 27, IIF(C29 < C30 AND V <= V29, 28, IIF(C30 < C31 AND V <= V30, 29, IIF(C31 < C32 AND V <= V31, 30, IIF(C32 < C33 AND V <= V32, 31, IIF(C33 < C34 AND V <= V33, 32, IIF(C34 < C35 AND V <= V34, 33, IIF(C35 < C36 AND V <= V35, 34, IIF(C36 < C37 AND V <= V36, 35, IIF(C37 < C38 AND V <= V37, 36, IIF(C38 < C39 AND V <= V38, 37, IIF(C39 < C40 AND V <= V39, 38, IIF(C40 < C41 AND V <= V40, 39, IIF(C41 < C42 AND V <= V41, 40, IIF(C42 < C43 AND V <= V42, 41, IIF(C43 < C44 AND V <= V43, 42, IIF(C44 < C45 AND V <= V44, 43, IIF(C45 < C46 AND V <= V45, 44, IIF(C46 < C47 AND V <= V46, 45, IIF(C47 < C48 AND V <= V47, 46, IIF(C48 < C49 AND V <= V48, 47, IIF(C49 < C50 AND V <= V49, 48, IIF(C50 < C51 AND V <= V50, 49, IIF(C51 < C52 AND V <= V51, 50, IIF(C52 < C53 AND V <= V52, 51, IIF(C53 < C54 AND V <= V53, 52, IIF(C54 < C55 AND V <= V54, 53, IIF(C55 < C56 AND V <= V55, 54, IIF(C56 < C57 AND V <= V56, 55, IIF(C57 < C58 AND V <= V57, 56, IIF(C58 < C59 AND V <= V58, 57, IIF(C59 < C60 AND V <= V59, 58, IIF(C60 < C61 AND V <= V60, 59, IIF(C61 < C62 AND V <= V61, 60, IIF(C62 < C63 AND V <= V62, 61, IIF(C63 < C64 AND V <= V63, 62, 63))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 0), 0), 1), IIF(V > 1.5 * AVGV30, IIF(C > C1 AND V > 1.5 * AVGV30, IIF(C1 < C2 AND V <= V1, 0, IIF(C2 < C3 AND V <= V2, 1, IIF(C3 < C4 AND V <= V3, 2, IIF(C4 < C5 AND V <= V4, 3, IIF(C5 < C6 AND V <= V5, 4, IIF(C6 < C7 AND V <= V6, 5, IIF(C7 < C8 AND V <= V7, 6, IIF(C8 < C9 AND V <= V8, 7, IIF(C9 < C10 AND V <= V9, 8, IIF(C10 < C11 AND V <= V10, 9, IIF(C11 < C12 AND V <= V11, 10, IIF(C12 < C13 AND V <= V12, 11, IIF(C13 < C14 AND V <= V13, 12, IIF(C14 < C15 AND V <= V14, 13, IIF(C15 < C16 AND V <= V15, 14, IIF(C16 < C17 AND V <= V16, 15, IIF(C17 < C18 AND V <= V17, 16, IIF(C18 < C19 AND V <= V18, 17, IIF(C19 < C20 AND V <= V19, 18, IIF(C20 < C21 AND V <= V20, 19, IIF(C21 < C22 AND V <= V21, 20, IIF(C22 < C23 AND V <= V22, 21, IIF(C23 < C24 AND V <= V23, 22, IIF(C24 < C25 AND V <= V24, 23, IIF(C25 < C26 AND V <= V25, 24, IIF(C26 < C27 AND V <= V26, 25, IIF(C27 < C28 AND V <= V27, 26, IIF(C28 < C29 AND V <= V28, 27, IIF(C29 < C30 AND V <= V29, 28, IIF(C30 < C31 AND V <= V30, 29, IIF(C31 < C32 AND V <= V31, 30, IIF(C32 < C33 AND V <= V32, 31, IIF(C33 < C34 AND V <= V33, 32, IIF(C34 < C35 AND V <= V34, 33, IIF(C35 < C36 AND V <= V35, 34, IIF(C36 < C37 AND V <= V36, 35, IIF(C37 < C38 AND V <= V37, 36, IIF(C38 < C39 AND V <= V38, 37, IIF(C39 < C40 AND V <= V39, 38, IIF(C40 < C41 AND V <= V40, 39, IIF(C41 < C42 AND V <= V41, 40, IIF(C42 < C43 AND V <= V42, 41, IIF(C43 < C44 AND V <= V43, 42, IIF(C44 < C45 AND V <= V44, 43, IIF(C45 < C46 AND V <= V45, 44, IIF(C46 < C47 AND V <= V46, 45, IIF(C47 < C48 AND V <= V47, 46, IIF(C48 < C49 AND V <= V48, 47, IIF(C49 < C50 AND V <= V49, 48, IIF(C50 < C51 AND V <= V50, 49, IIF(C51 < C52 AND V <= V51, 50, IIF(C52 < C53 AND V <= V52, 51, IIF(C53 < C54 AND V <= V53, 52, IIF(C54 < C55 AND V <= V54, 53, IIF(C55 < C56 AND V <= V55, 54, IIF(C56 < C57 AND V <= V56, 55, IIF(C57 < C58 AND V <= V57, 56, IIF(C58 < C59 AND V <= V58, 57, IIF(C59 < C60 AND V <= V59, 58, IIF(C60 < C61 AND V <= V60, 59, IIF(C61 < C62 AND V <= V61, 60, IIF(C62 < C63 AND V <= V62, 61, IIF(C63 < C64 AND V <= V63, 62, 63))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))), 0), 0), 0)
 
thanks 

Dhiren
 
Back to top
Bruce_L
Posted : Thursday, March 29, 2018 3:18:52 PM


Worden Trainer

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

I am not quite sure what you mean by the the "2 standard deviation of 20 bar average volume in boolean formula". 2 times the 20 period standard deviation of volume would be the following.

2 * SQR(ABS(SUM((V) ^ 2, 20) - 20 * AVG(V, 20) ^ 2) / 20)

And 2 times the 20 period standard devation of the 20 period simple moving average of volume would be the following.

2 * SQR(ABS(SUM((AVGV20) ^ 2, 20) - 20 * AVG(AVGV20, 20) ^ 2) / 20)

But neither is Boolean in that the formulas return numeric values instead of returning true or false. You need to compare the number values to something else to create a Boolean formula and nothing in your question would allow me to guess at what this comparison might entail.

I think the long formula in your post is from my Thursday, August 24, 2017 1:57:05 PM ET post in the PP Count on Vol topic. I can't actually give you interpretation advice, but if so, it is "Pocket Pivot PCF to indicate no Pocket Pivot yesterday and a Pocket Pivot today ... that included volume."

The value returned is the number of bars in row where all of the down volume was less than the volume of the current bar (which is both up and greater than 1.5 * AVGV30).


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Back to top
dhirenshah
Posted : Thursday, March 29, 2018 3:55:37 PM
Registered User
Joined: 3/10/2012
Posts: 465

Okay Bruce i got my answer from your above formula thanks 

have great weekend,,, 

Cheers
Back to top
neurollc
Posted : Monday, April 2, 2018 8:51:35 PM
Registered User
Joined: 11/30/2015
Posts: 3

Hi Bruce: I had posted on Apr 1 that most of the multiday candlestick chart viewing options within TC2000's software appear to be off when calculating when the beginning of the next new bar will be. Am I missing something or counting incorrectly? Take the 4day and 8 day for example and go back a few months. The dates with which new bars are found don't appear to be accurate.

If there has been in fact a software issue/mistake just uncovered, all TC2000 paying subscribers users should be notified with the problem remedied quickly. Hopefully I'm wrong here however and simply overlooking a settings adjustment, etc.

Thank you for looking into at your earliest convenience. Sincerely.
Back to top
Bruce_L
Posted : Monday, April 9, 2018 11:37:26 AM


Worden Trainer

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

The candles aren't rolling x day bars like they were in TC2000 v7 where the newest bar (and everything but the oldest bar) is always x bars long. The x bars spans start at an arbitrary date and just repeat over and over again based on the calendar. So the newest bar is not necessarily going to be x bars long.


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