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 |

Request PCF Formula signal P% Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Thursday, June 22, 2017 11:02:41 AM
Registered User
Joined: 9/30/2011
Posts: 788
I would like to have a PCF Formula with signal = <40% compared to yesterday's closing value.
 
Thank you and goodbye.
Raider45
Bruce_L
Posted : Thursday, June 22, 2017 11:22:48 AM


Worden Trainer

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

I really have no idea what is being requested. What signal? Is P% just some sort of percent change or is it part of an indicator?

If you mean price is 40% below the price of the previous bar, that is going to be a pretty significant percent change.

100 * C <= 60 * C1

If you mean price is only 40% of the previous price that would be an even larger percent change.

100 * C <= 40 * C1

If you mean price is below 40% from the bottom of the range of the previous bar.

100 * C <= 40 * H1 + 60 * L1

If you mean price is at least 40% of the range of the previous bar below the close of the previous bar.

100 * C <= 100 * C1 - 40 * (H1 - L1)

If you mean something else, we would need further clarification as to the actual intent of the question.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, June 22, 2017 11:31:33 AM
Registered User
Joined: 9/30/2011
Posts: 788

I made a mistake, today the formula must generate the signal = <of 40% of the sum between the minimum value and yesterday's closing value (signal = <40% of yesterday's candle, from min to close).

Bruce_L
Posted : Thursday, June 22, 2017 11:38:04 AM


Worden Trainer

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

So we must generate a signal if the current price is less the 40% up from the low to the close of the previous bar?

100 * C <= 60 * L1 + 40 * C1

Or the previous bar had the close in the bottom 40% of the bar?

STOC1.1.1 <= 40



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, June 22, 2017 11:46:39 AM
Registered User
Joined: 9/30/2011
Posts: 788

The right formula should be today = <10% compared to the close value

Bruce_L
Posted : Thursday, June 22, 2017 12:14:05 PM


Worden Trainer

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

Nothing about the low anymore? 10% of the previous close is just:

C1 / 10

So if today's price is less than or equal to 10% of the previous close.

C <= C1 / 10

If price just needs to have gone down by 10%:

C <= 9 * C1 / 10

But if we are back to less than 10% of the bottom of the range between the previous low and close.

10 * C <= 9 * L1 + C1

But if you mean below 10% from of the top of the range between the previous low and close.

10 * C <= L1 + 9 * C1

But seriously, if none of these are right, I've made 11 guesses so far. I'm not making any more without a better description. I have absolutely no idea what is being requested.

What exactly is the basis being used for the 10%? Is it the close? The range of the previous bar? The distance between the previous low and the previous close? Something else?

Does price need to be below 10% of the basis or does it need to be below some value (such as the previous close) minus the 10%? Or maybe it needs to be within 10% of something instead? Or something else entirely?



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, June 22, 2017 12:21:03 PM
Registered User
Joined: 9/30/2011
Posts: 788

Yes, losing must be less than 10% (varies by choice) than yesterday's closing

Bruce_L
Posted : Thursday, June 22, 2017 12:50:40 PM


Worden Trainer

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

So price is down, but by less than 10% of the close?

9 * C1 <= 10 * C AND C < C1

Or maybe price is down but by less than 10% of the distance between yesterday's close and low?

10 * C1 - H1 + L1 <= 10 * C AND C < C1

If neither of these is correct, then maybe we should start from the very beginning with a full and complete description of exactly what you want.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, June 22, 2017 1:06:33 PM
Registered User
Joined: 9/30/2011
Posts: 788
Working on percentages all works, thank you!
Best regards.
raider45
Posted : Thursday, June 22, 2017 1:32:57 PM
Registered User
Joined: 9/30/2011
Posts: 788

Signal => 10% compared to the opening value of yesterday, thank you in advance.

Bruce_L
Posted : Thursday, June 22, 2017 1:42:21 PM


Worden Trainer

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

I don't know which formula actually worked for you, so I'll guess price is up but by less than 10% from the previous open?

O1 < C AND 10 * C <= 11 * O1



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Thursday, June 22, 2017 2:16:10 PM
Registered User
Joined: 9/30/2011
Posts: 788
Everything works smoothly, thank you!
Best regards
Bruce_L
Posted : Thursday, June 22, 2017 2:16:30 PM


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.