Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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
|
|
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
|
|
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).
|
|
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
|
|
Registered User Joined: 9/30/2011 Posts: 788
|
The right formula should be today = <10% compared to the close value
|
|
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
|
|
Registered User Joined: 9/30/2011 Posts: 788
|
Yes, losing must be less than 10% (varies by choice) than yesterday's closing
|
|
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
|
|
Registered User Joined: 9/30/2011 Posts: 788
|
Working on percentages all works, thank you!
Best regards.
|
|
Registered User Joined: 9/30/2011 Posts: 788
|
Signal => 10% compared to the opening value of yesterday, thank you in advance.
|
|
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
|
|
Registered User Joined: 9/30/2011 Posts: 788
|
Everything works smoothly, thank you!
Best regards
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |