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

But how to make the Previous 15 Bars? Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
sky22688
Posted : Wednesday, June 27, 2012 12:29:28 PM
Registered User
Joined: 2/10/2012
Posts: 67

 

I am using Platinum TC2000 Version 12.2

 

Any Easy Way to Create Scan for Balance of Power

~    Previous "15 Bars" in 5-Min Chart     and     All "15 Bars" Greater than 99

 

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I know that click on "Create Scan Condition" of Balance of Power

 

Greater Than: 99

Time Frame: 5 Minutes

 

 

 

But how to make the Previous 15 Bars?

 

 

Thank you!

 

JJ

Bruce_L
Posted : Wednesday, June 27, 2012 12:36:50 PM


Worden Trainer

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

- Create a Custom PCF % True Indicator.
-- Period: 15
-- Average Type: Simple
-- Boolean Formula: BOP > 99
- Click on the Custom PCF % True Indicator and select Create Scan Condition.
-- Set the Condition to Greater Than.
-- Set Greater Than to 99.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sky22688
Posted : Wednesday, June 27, 2012 12:46:51 PM
Registered User
Joined: 2/10/2012
Posts: 67

Thank you so much again!

 

You are a Professional.   Making complex things look  Easy & Simple ~

sky22688
Posted : Thursday, June 28, 2012 1:11:09 PM
Registered User
Joined: 2/10/2012
Posts: 67

Bruce,

 

 

I follow your instructions, but I cannot get any result.   I try to LOWER the conditions to Period=5 and BOP>50; Still cannot get any result.  Why?

 

 

You wrote:

- Create a Custom PCF % True Indicator.
-- Period: 15
-- Average Type: Simple
-- Boolean Formula: MS > 99  (Should be BOP >99, right? ? ?  If I want Balance of Power )
- Click on the Custom PCF % True Indicator and select Create Scan Condition.
-- Set the Condition to Greater Than.
-- Set Greater Than to 99.

Bruce_L
Posted : Thursday, June 28, 2012 1:26:55 PM


Worden Trainer

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

Yes, it should be BOP for Balance of Power instead of MS.

I do not know why it would not be working for you. I currently get 119 items on a 15-Minute Time Frame in my EasyScan when the List to Scan is set to US Common Stocks.

The number of items can change rather quickly.

Try right-clicking on the Custom PCF % True indicator and select Show Values in WatchList. Choose "& Sort" when adding the WatchList. Do any of the symbols return 100%?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sky22688
Posted : Monday, July 9, 2012 2:26:48 AM
Registered User
Joined: 2/10/2012
Posts: 67

Platinum TC2000 Version 12.2

 

In Custom PCF % True Indicator.

 

If I want Balance of Power > 99, the formula is pretty easy.    Boolean Formula: BOP > 99


 

How about if I want      Money Flow Index (14) > 50     And Wilder's RSI (14) > 50
 

Any way to look up those indicators formula?  Because asking too many questions may be embarrassing.

 

Thank you

 

Bruce_L
Posted : Monday, July 9, 2012 9:21:22 AM


Worden Trainer

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

The PCF Formula Descriptions topic contains a fairly comprehensive list of the syntax which is valid in the Personal Criteria Formula Language. That said, the Money Flow Index and a Wilder's Smoothed RSI are not represented. You could search the forums to try and find formulas.

Learn how to use the forums: post a new topic, reply, Search existing topics

A Condition Formula for a 14-Period Money Flow Index being greater than 50 could be written as:

100 - 100 / (1 + ((H + L + C > H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 > H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 > H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 > H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 > H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 > H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 > H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 > H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 > H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 > H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 > H11 + L11 + C11) * (H10 + L10 + C10) * V10 + (H11 + L11 + C11 > H12 + L12 + C12) * (H11 + L11 + C11) * V11 + (H12 + L12 + C12 > H13 + L13 + C13) * (H12 + L12 + C12) * V12 + (H13 + L13 + C13 > H14 + L14 + C14) * (H13 + L13 + C13) * V13) / ((H + L + C < H1 + L1 + C1) * (H + L + C) * V + (H1 + L1 + C1 < H2 + L2 + C2) * (H1 + L1 + C1) * V1 + (H2 + L2 + C2 < H3 + L3 + C3) * (H2 + L2 + C2) * V2 + (H3 + L3 + C3 < H4 + L4 + C4) * (H3 + L3 + C3) * V3 + (H4 + L4 + C4 < H5 + L5 + C5) * (H4 + L4 + C4) * V4 + (H5 + L5 + C5 < H6 + L6 + C6) * (H5 + L5 + C5) * V5 + (H6 + L6 + C6 < H7 + L7 + C7) * (H6 + L6 + C6) * V6 + (H7 + L7 + C7 < H8 + L8 + C8) * (H7 + L7 + C7) * V7 + (H8 + L8 + C8 < H9 + L9 + C9) * (H8 + L8 + C8) * V8 + (H9 + L9 + C9 < H10 + L10 + C10) * (H9 + L9 + C9) * V9 + (H10 + L10 + C10 < H11 + L11 + C11) * (H10 + L10 + C10) * V10 + (H11 + L11 + C11 < H12 + L12 + C12) * (H11 + L11 + C11) * V11 + (H12 + L12 + C12 < H13 + L13 + C13) * (H12 + L12 + C12) * V12 + (H13 + L13 + C13 < H14 + L14 + C14) * (H13 + L13 + C13) * V13 - .00001)) > 50

A Condition Formula for a 14-Period Wilder's RSI being greater than 50 could be written as:

50 * (C - XAVGC27.1) / 14 / (.071435345156143 * (ABS(C - C1) + 13 / 14 * (ABS(C1 - C2) + 13 / 14 * (ABS(C2 - C3) + 13 / 14 * (ABS(C3 - C4) + 13 / 14 * (ABS(C4 - C5) + 13 / 14 * (ABS(C5 - C6) + 13 / 14 * (ABS(C6 - C7) + 13 / 14 * (ABS(C7 - C8) + 13 / 14 * (ABS(C8 - C9) + 13 / 14 * (ABS(C9 - C10) + 13 / 14 * (ABS(C10 - C11) + 13 / 14 * (ABS(C11 - C12) + 13 / 14 * (ABS(C12 - C13) + 13 / 14 * (ABS(C13 - C14) + 13 / 14 * (ABS(C14 - C15) + 13 / 14 * (ABS(C15 - C16) + 13 / 14 * (ABS(C16 - C17) + 13 / 14 * (ABS(C17 - C18) + 13 / 14 * (ABS(C18 - C19) + 13 / 14 * (ABS(C19 - C20) + 13 / 14 * (ABS(C20 - C21) + 13 / 14 * (ABS(C21 - C22) + 13 / 14 * (ABS(C22 - C23) + 13 / 14 * (ABS(C23 - C24) + 13 / 14 * (ABS(C24 - C25) + 13 / 14 * (ABS(C25 - C26) + 13 / 14 * (ABS(C26 - C27) + 13 / 14 * (ABS(C27 - C28) + 13 / 14 * (ABS(C28 - C29) + 13 / 14 * (ABS(C29 - C30) + 13 / 14 * (ABS(C30 - C31) + 13 / 14 * (ABS(C31 - C32) + 13 / 14 * (ABS(C32 - C33) + 13 / 14 * (ABS(C33 - C34) + 13 / 14 * (ABS(C34 - C35) + 13 / 14 * (ABS(C35 - C36) + 13 / 14 * (ABS(C36 - C37) + 13 / 14 * (ABS(C37 - C38) + 13 / 14 * (ABS(C38 - C39) + 13 / 14 * (ABS(C39 - C40) + 13 / 14 * (ABS(C40 - C41) + 13 / 14 * (ABS(C41 - C42) + 13 / 14 * (ABS(C42 - C43) + 13 / 14 * (ABS(C43 - C44) + 13 / 14 * (ABS(C44 - C45) + 13 / 14 * (ABS(C45 - C46) + 13 / 14 * (ABS(C46 - C47) + 13 / 14 * (ABS(C47 - C48) + 13 / 14 * (ABS(C48 - C49) + 13 / 14 * (ABS(C49 - C50) + 13 / 14 * (ABS(C50 - C51) + 13 / 14 * (ABS(C51 - C52) + 13 / 14 * (ABS(C52 - C53) + 13 / 14 * (ABS(C53 - C54) + 13 / 14 * (ABS(C54 - C55) + 13 / 14 * (ABS(C55 - C56) + 13 / 14 * (ABS(C56 - C57) + 13 / 14 * (ABS(C57 - C58) + 13 / 14 * (ABS(C58 - C59) + 13 / 14 * (ABS(C59 - C60) + 13 / 14 * (ABS(C60 - C61) + 13 / 14 * (ABS(C61 - C62) + 13 / 14 * (ABS(C62 - C63) + 13 / 14 * (ABS(C63 - C64) + 13 / 14 * (ABS(C64 - C65) + 13 / 14 * (ABS(C65 - C66) + 13 / 14 * (ABS(C66 - C67) + 13 / 14 * (ABS(C67 - C68) + 13 / 14 * (ABS(C68 - C69) + 13 / 14 * (ABS(C69 - C70) + 13 / 14 * (ABS(C70 - C71) + 13 / 14 * (ABS(C71 - C72) + 13 / 14 * (ABS(C72 - C73) + 13 / 14 * (ABS(C73 - C74) + 13 / 14 * (ABS(C74 - C75) + 13 / 14 * (ABS(C75 - C76) + 13 / 14 * (ABS(C76 - C77) + 13 / 14 * (ABS(C77 - C78) + 13 / 14 * (ABS(C78 - C79) + 13 / 14 * (ABS(C79 - C80) + 13 / 14 * (ABS(C80 - C81) + 13 / 14 * (ABS(C81 - C82) + 13 / 14 * (ABS(C82 - C83) + 13 / 14 * (ABS(C83 - C84) + 13 / 14 * (ABS(C84 - C85) + 13 / 14 * (ABS(C85 - C86) + 13 / 14 * (ABS(C86 - C87) + 13 / 14 * (ABS(C87 - C88) + 13 / 14 * (ABS(C88 - C89) + 13 / 14 * (ABS(C89 - C90) + 13 / 14 * (ABS(C90 - C91) + 13 / 14 * (ABS(C91 - C92) + 13 / 14 * (ABS(C92 - C93) + 13 / 14 * (ABS(C93 - C94) + 13 / 14 * (ABS(C94 - C95) + 13 / 14 * (ABS(C95 - C96) + 13 / 14 * (ABS(C96 - C97) + 13 / 14 * (ABS(C97 - C98) + 13 / 14 * (ABS(C98 - C99) + 13 / 14 * (ABS(C99 - C100) + 13 / 14 * (ABS(C100 - C101) + 13 / 14 * (ABS(C101 - C102) + 13 / 14 * (ABS(C102 - C103) + 13 / 14 * (ABS(C103 - C104) + 13 / 14 * (ABS(C104 - C105) + 13 / 14 * (ABS(C105 - C106) + 13 / 14 * (ABS(C106 - C107) + 13 / 14 * (ABS(C107 - C108) + 13 / 14 * (ABS(C108 - C109) + 13 / 14 * (ABS(C109 - C110) + 13 / 14 * (ABS(C110 - C111) + 13 / 14 * (ABS(C111 - C112) + 13 / 14 * (ABS(C112 - C113) + 13 / 14 * (ABS(C113 - C114) + 13 / 14 * (ABS(C114 - C115) + 13 / 14 * (ABS(C115 - C116) + 13 / 14 * (ABS(C116 - C117) + 13 / 14 * (ABS(C117 - C118) + 13 / 14 * (ABS(C118 - C119) + 13 / 14 * (ABS(C119 - C120) + 13 / 14 * (ABS(C120 - C121) + 13 / 14 * (ABS(C121 - C122) + 13 / 14 * (ABS(C122 - C123) + 13 / 14 * (ABS(C123 - C124) + 13 / 14 * (ABS(C124 - C125))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) + 50 > 50

Actually being greater than 50 is a special case for Wilder's RSI. You would need the entire formula to test against any other value, but you should be able to shorten the versus 50 case significantly to:

C > XAVGC27.1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
sky22688
Posted : Tuesday, July 10, 2012 11:37:47 AM
Registered User
Joined: 2/10/2012
Posts: 67

Thank you Bruce!

 

 

You are amazing~

Bruce_L
Posted : Tuesday, July 10, 2012 11:39:07 AM


Worden Trainer

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

You're welcome.



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