| 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 the calculation of the percentage between the maximum and the closing of the candle yesterday.
Example: SYMX - H 0.59 - C 0.52 - P% 13.46
MARK - H 3.69 - C 3.43 - P% 7.58
Thank you in advance and greeting.
Raider45
|
|
Administration
Joined: 9/30/2004
Posts: 9,187
|
((H1/C1) -1) * 100
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
Maybe I did wrong the question!
Values do not match those in the example.
The Formula PCF must calculate the performance in P%, between close and maximum of yesterday
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
September 11, 2017 isn't "yesterday" as far as the formulas are concerned until the market actually opens. As far as the formulas are concerned, 9/11 is still "today".
If you want the values for today instead of yesterday.
100 * (H / C - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The question is:
Today, before the opening of the markets, I need to see the percentage values matched on yesterday's candles, calculated between the closing and the maximum recorded, so how should the right formula be?
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
Before the market opens (when you wrote your first email for example).
100 * (H / C - 1)
After the market opens (when you wrote your second email for example).
100 * (H1 / C1 - 1)
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The formula should be this: 100 * (H / C - 1) Tomorrow before the opening of the Markets I will verify it with some manual calculations, in the expectation thanks and greetings.
|
|
Registered User
Joined: 9/30/2011
Posts: 788
|
The formula works fine, compliments and thanks!
100 * (H / C - 1)
Best regards !
|
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
|
|
Guest-1 |