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

Average range of last 50 bars Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
unbias123
Posted : Tuesday, July 17, 2012 11:56:04 AM
Registered User
Joined: 3/30/2012
Posts: 21

Hi Bruce 

I would like to have PCF for following:

1. Average range of last 50 bars should be more than 3%. For example. Say on bar no.  50  the range is 2 and close on that is say 50 then range for 50th bar is 4%. Similarly range average percentage need to be calculated for 49th bar till 1st bar and then average range of all 50 bar need to added and then it need to devided by 50 and it should be more than 3%.

2. Similarly for more than 4%

 

Thanks

Regards

 

Bruce_L
Posted : Tuesday, July 17, 2012 12:10:10 PM


Worden Trainer

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

The easy way to do this would be to create the Custom PCF Indicator I already explained in the Range as % of Close topic, click on it to select Create Scan Condition and choose Greater Than and set the Greater Than value to 3 (or 4).

Creating Scan and Sort Conditions

The hard way to do this is to create a Condition Formula for it:

100 * ((H - L) / C + (H1 - L1) / C1 + (H2 - L2) / C2 + (H3 - L3) / C3 + (H4 - L4) / C4 + (H5 - L5) / C5 + (H6 - L6) / C6 + (H7 - L7) / C7 + (H8 - L8) / C8 + (H9 - L9) / C9 + (H10 - L10) / C10 + (H11 - L11) / C11 + (H12 - L12) / C12 + (H13 - L13) / C13 + (H14 - L14) / C14 + (H15 - L15) / C15 + (H16 - L16) / C16 + (H17 - L17) / C17 + (H18 - L18) / C18 + (H19 - L19) / C19 + (H20 - L20) / C20 + (H21 - L21) / C21 + (H22 - L22) / C22 + (H23 - L23) / C23 + (H24 - L24) / C24 + (H25 - L25) / C25 + (H26 - L26) / C26 + (H27 - L27) / C27 + (H28 - L28) / C28 + (H29 - L29) / C29 + (H30 - L30) / C30 + (H31 - L31) / C31 + (H32 - L32) / C32 + (H33 - L33) / C33 + (H34 - L34) / C34 + (H35 - L35) / C35 + (H36 - L36) / C36 + (H37 - L37) / C37 + (H38 - L38) / C38 + (H39 - L39) / C39 + (H40 - L40) / C40 + (H41 - L41) / C41 + (H42 - L42) / C42 + (H43 - L43) / C43 + (H44 - L44) / C44 + (H45 - L45) / C45 + (H46 - L46) / C46 + (H47 - L47) / C47 + (H48 - L48) / C48 + (H49 - L49) / C49) / 50 > 3

Change the > 3 at the end to > 4 to change percentage.

Personal Criteria Formula Conditions



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
unbias123
Posted : Tuesday, July 17, 2012 1:44:33 PM
Registered User
Joined: 3/30/2012
Posts: 21

Hi Bruce

Thank you.

You have given link for Range as % of Close (reply to my earlier post), there you have mentioned that 13 period, where can I find 13 period or 21 or 50 period. When we scroll down for the period it does not have choice of 13 or 21 or 50.

 

 

Bruce_L
Posted : Tuesday, July 17, 2012 1:52:44 PM


Worden Trainer

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

Three settings were specified in the Range as % of Close topic for the Custom PCF Indicator:

- Period: 13
- Average Type: Simple
- Formula: 100 * (H - L) / C

And it was mentioned that, "You can adjust the period to 21 and 50 as desired."

This was meant quite literally. All you need to do is change the Period setting in the Custom PCF Indicator to 21 instead 13 to get the 21-Period version or to 50 instead of 13 to get the 50-Period version.



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