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 |

PP Count on Vol Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
thnkbigr
Posted : Tuesday, August 22, 2017 8:33:38 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce 

I use the PCF below to plot the PP Count. Is it possible to make the indicator plot only if Vol surge is > by 1.5 times the 30 day avg 

If V / AVGV30 > 1.5 Then plot below 

 

IIF(C > C1, 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)
 
Bruce_L
Posted : Wednesday, August 23, 2017 9:12:21 AM


Worden Trainer

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

You could just put that whole fomula between the commas in the following.

IIF(V > 1.5 * AVGV30, , 0)

To get:

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Wednesday, August 23, 2017 3:17:59 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

PP Count?

Al_Gorithm
Posted : Wednesday, August 23, 2017 3:25:13 PM

Registered User
Joined: 6/30/2017
Posts: 1,227

My money is on Pocket Pivots. 

Al_Gorithm
Posted : Wednesday, August 23, 2017 3:32:48 PM

Registered User
Joined: 6/30/2017
Posts: 1,227

Just thought of a new game ... post a PCF and have folks figure out what it does. LOL.

Barista!

Al_Gorithm
Posted : Wednesday, August 23, 2017 3:37:19 PM

Registered User
Joined: 6/30/2017
Posts: 1,227

Never heard of Pocket Pivots, but Googling...

Bruce, tell me what I've won!

Bruce_L
Posted : Wednesday, August 23, 2017 3:48:24 PM


Worden Trainer

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

Yes, the PP in this case stands for Pocket Pivot.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Al_Gorithm
Posted : Wednesday, August 23, 2017 3:50:37 PM

Registered User
Joined: 6/30/2017
Posts: 1,227

Not bad considering I never heard of Pocket Pivots a half-hour ago. 

Barista ... make it a double!

thnkbigr
Posted : Wednesday, August 23, 2017 7:03:16 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

PP are great buy points in leading uptrending stocks. 

They offer a lower entry level as the stcoks is resuming higher after a consolidation phase. You don;t have to wait for a breakout to a new high like CANSLIM and also it offers a lower risk entry level in case the signal fails. 

Of course since you are buying at the earliest sign of resumption of accumulation yo may exprience more failures then waiting to see multiple high volume accumulation days on the right side of the base which is what O'Neil suggest as more confirmation of buying by the big players

But in my opinion the standrad base breakouts have been failing in the last few years so PP are far better 

thnkbigr
Posted : Wednesday, August 23, 2017 7:11:02 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce 

If I have multiple indicatprs in the same pane in TC how do I make one be the front and be on top of all others 

In SF we can right click and select bring to the front so if two indicators are overlapping each other the one in front will show

In this case I actually want to make Price be the front in TC. Is that possible

thanks   

Bruce_L
Posted : Thursday, August 24, 2017 8:44:18 AM


Worden Trainer

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

TC2000 just plots the indicators on the chart going from left to right with each indicator plotting overtop all of the previous indicators.

There isn't a built in way to shift the indicators left and right besides removing and re-adding indicators.

If what you want is price to be on top, you would generally need to do this by adding a second price plot to the same pane and scale as the main price indicator.

- Click on the name of one of the indicators in the price pane.
- Select Add Plot Here...
- Choose Symbols and add a Symbol (doesn't matter what symbol).
- When Scaling Options appears, choose to Scale with the existing symbol (price history - not by itself).
- Click on the name of the new symbol and select Edit.
- Change the Symbol setting to Main Chart Symbol and adjust the other settings as desired.


-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Thursday, August 24, 2017 1:38:54 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

Re: Pocket Pivots, let's take a look at an amazing performer over the last year, the biotech stock IMMU. 

Five days ago on August 17, 2017, IMMU shows a Pocket Pivot and continues with Pocket Pivots on each subsequent days thru today.

Had one entered on the Close on August 17, the return thru now (10:21 EST) would be 28.57 percent.

My request Bruce...

Please tweet the Pocket Pivot PCF to indicate no Pocket Pivot yesterday and a Pocket Pivot today.

 

 

 

 

 

traderlady
Posted : Thursday, August 24, 2017 1:39:51 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

Forgot to say, I used the Pocket Pivot that included volume.  See below:

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)

Bruce_L
Posted : Thursday, August 24, 2017 1:57:05 PM


Worden Trainer

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

Please try the following.

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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Tuesday, August 29, 2017 12:47:44 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

I am using the Pocket Pivot PCF without volume as below:

IIF(C > C1, 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)
 

When I add Pocket Pivot as a Column, I'm using a 5-minute Timeframe which matches the minimum 5-minute Refresh Rate.

The Column produces either zeros or numerical values which can vary from one stock to another.

Please explain the meaning of these numerical values, Bruce.

 

Bruce_L
Posted : Tuesday, August 29, 2017 2:03:51 PM


Worden Trainer

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

A Pocket Pivot is an up day with higher volume than all of the down days over the previous 10 bars.

You could define the Pocket Pivot as an upday with higher volume than all of the down days over the previous x bars instead.

The PP Count indicator is designed to return x.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Tuesday, August 29, 2017 2:12:04 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

The highest Pocket Pivot value I have on an Easy Scan is URI at 37.  If the PP formula is looking back over ten days, then why would a value such as 37 for URI, exceed 10?

Bruce_L
Posted : Tuesday, August 29, 2017 2:16:17 PM


Worden Trainer

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

Because it is using the alternate definition where it is looking at x days instead of 10 days and returning x.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
traderlady
Posted : Tuesday, August 29, 2017 2:27:23 PM
Registered User
Joined: 10/7/2004
Posts: 1,178

So, it's looking at 63 days?

 

Bruce_L
Posted : Tuesday, August 29, 2017 2:48:10 PM


Worden Trainer

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

Yes, it maxes out at 63 bars.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Tuesday, August 29, 2017 4:08:23 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce

What the diff between your original PCF on the PP vs teh one you posted on Thursday, August 24, 2017 1:57:05 PM for Traderlady 

Bruce_L
Posted : Tuesday, August 29, 2017 4:17:39 PM


Worden Trainer

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

It checked for there being a PP today and not being a PP yesterday. Otherwise it returns zero.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Tuesday, August 29, 2017 4:48:26 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

I see thx

thnkbigr
Posted : Thursday, August 31, 2017 7:48:27 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

In TC is there anyway I can plot the last value in a diff color than the scale itself? 

I plot the PP count on its own scale overlayed with Price so the indicator has its own scale in white and the last value is in while as well. I like to change that

 
 
Bruce_L
Posted : Friday, September 1, 2017 9:42:21 AM


Worden Trainer

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

No, there isn't a way to change it like in StockFinder.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Friday, September 1, 2017 10:45:06 AM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

ok thx

Is this a shorter version of PP PCF which all i need to do is to change the last vlaue of 10 for diff period PP 

(C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10))

originally you wrote as this 

C > C1 AND V > ABS(C1 < C2) * V1 AND V > ABS(C2 < C3) * V2 AND V > ABS(C3 < C4) * V3 AND V > ABS(C4 < C5) * V4 AND V > ABS(C5 < C6) * V5 AND V > ABS(C6 < C7) * V6 AND V > ABS(C7 < C8) * V7 AND V > ABS(C8 < C9) * V8 AND V > ABS(C9 < C10) * V9 AND V > ABS(C10 < C11) * V10

Bruce_L
Posted : Friday, September 1, 2017 10:48:30 AM


Worden Trainer

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

The short versions only works in TC2000 v17 and is a shorter version of the longer formula which will work in earlier versions as well.

You can just change the 10 in the shorter formula to adjust how many bars it looks back to confirm it as a Pocket Pivot.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Friday, September 1, 2017 12:13:18 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Got it thx

I would love to see them add a Volatility Stop as VST or something in PCF so we can just reference it in a formula

Just like ATR now calculates ATR and you donlt need to write the entire formula they should add other indicators as well  

Bruce_L
Posted : Friday, September 1, 2017 12:21:10 PM


Worden Trainer

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

Thank you for your suggestion.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Wednesday, November 1, 2017 7:07:38 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce,

Below is the PP PCF I have 

L / ABS(C > C1 AND V > MAX(ABS(C1 < C2) * V1, 10))

Now I like to add a few more pieces 

(Price needs to close up 0.33 * ATR22 and also 0.33%

and

Volume surge > AvgV30 

L / ABS(C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.033 AND V > AVGV30 AND V > MAX(ABS(C1 < C2) * V1, 10))

Am I correct here 

Bruce_L
Posted : Thursday, November 2, 2017 8:58:05 AM


Worden Trainer

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

The 1.033 in your formula is 3.3%. If you want 0.33%, you would want to use 1.0033 instead.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Thursday, November 2, 2017 10:06:00 AM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Oh yea thanks 

 

thnkbigr
Posted : Thursday, November 2, 2017 10:25:52 AM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce I also like to add C >= L + 0.50 * ATR22 AND C / L >= 1.0050 so the stock will screen through if Either one of these two are correct in the PP PCF

C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.0033

OR 

C >= L + 0.50 * ATR22 AND C / L >= 1.0050 

Am I correct on below 

L / ABS((C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.0033 OR C >= L + 0.50 * ATR22 AND C / L >= 1.0050) AND V > AVGV30 AND V > MAX(ABS(C1 < C2) * V1, 10))

Either price is up from yesterday's close by 0.33 ATR and 0.33% or price is up from todays low by 0.5 ATR and 0.5%  

Bruce_L
Posted : Thursday, November 2, 2017 10:28:32 AM


Worden Trainer

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

You need more parentheses because OR comes before AND in the order of operations.

L / ABS(((C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.0033) OR (C >= L + 0.50 * ATR22 AND C / L >= 1.0050)) AND V > AVGV30 AND V > MAX(ABS(C1 < C2) * V1, 10))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Thursday, November 2, 2017 11:12:19 AM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

ok thanks 

How do I adjust the PP Count PCF below that you wrote to make all the changes that we made above 

IIF(C > C1, 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)
 
Bruce_L
Posted : Thursday, November 2, 2017 11:30:54 AM


Worden Trainer

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

Maybe the following?

IIF(((C >= C1 + .33 * ATR22 AND C >= 1.0033 * C1) OR (C >= L + .5 * ATR22 AND C >= 1.005 * L)) AND V > 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)



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Thursday, November 2, 2017 2:44:31 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Thanks 

I tried to create a condition with the PCF below and it say the pcf doesn't return a boolean result 

My goal is to screen for stocks or use it as a wacthlist column so it would show a checl mark when the condition is true  

L / ABS(((C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.0033) OR (C >= L + 0.50 * ATR22 AND C / L >= 1.0050)) AND V > AVGV30 AND V > MAX(ABS(C1 < C2) * V1, 10))

Bruce_L
Posted : Thursday, November 2, 2017 2:48:39 PM


Worden Trainer

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

The Boolean portion is inside the ABS() function.

(C >= C1 + 0.33 * ATR22 AND C / C1 >= 1.0033) OR (C >= L + 0.50 * ATR22 AND C / L >= 1.0050)) AND V > AVGV30 AND V > MAX(ABS(C1 < C2) * V1, 10)

The rest of the formula is just there to get it to plot a dot at L.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
thnkbigr
Posted : Thursday, January 4, 2018 5:30:56 PM
Platinum Customer Platinum Customer

Joined: 3/31/2006
Posts: 3,207

Bruce, 

Just like the PP count indicator above I need a pcf that plots the count of the number of days that today's volume is higher than in the last 63 days 

The pcf needs to plot it only on up days and if todays vol is higer than all volume days (Up and Down Days) in the last 25 then the indicator will plot 25 if higher than last 42 then it will plot 42. Just like the PP Count indicator it should go up to 63 

The current PP Count is comparing the today's vol vs the vol of the down days. this new pcf should compare todays vol vs all days 

thx 

Bruce_L
Posted : Friday, January 5, 2018 9:01:58 AM


Worden Trainer

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

Please try the following.

IIF(C > C1, ABS(V > V1) - (V > V2) - (V > V3) - (V > V4) - (V > V5) - (V > V6) - (V > V7) - (V > V8) - (V > V9) - (V > V10) - (V > V11) - (V > V12) - (V > V13) - (V > V14) - (V > V15) - (V > V16) - (V > V17) - (V > V18) - (V > V19) - (V > V20) - (V > V21) - (V > V22) - (V > V23) - (V > V24) - (V > V25) - (V > V26) - (V > V27) - (V > V28) - (V > V29) - (V > V30) - (V > V31) - (V > V32) - (V > V33) - (V > V34) - (V > V35) - (V > V36) - (V > V37) - (V > V38) - (V > V39) - (V > V40) - (V > V41) - (V > V42) - (V > V43) - (V > V44) - (V > V45) - (V > V46) - (V > V47) - (V > V48) - (V > V49) - (V > V50) - (V > V51) - (V > V52) - (V > V53) - (V > V54) - (V > V55) - (V > V56) - (V > V57) - (V > V58) - (V > V59) - (V > V60) - (V > V61) - (V > V62) - (V > V63), 1 / 0)



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