New version 17 available now


Download software Tutorial videos
Subscription & data-feed pricing Class schedule


New account application Trading resources
Margin rates Stock & option commissions

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

Request PCF Formula Percentage Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Tuesday, September 12, 2017 7:40:24 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 378
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
StockGuy
Posted : Tuesday, September 12, 2017 8:06:07 AM

Administration

Joined: 9/30/2004
Posts: 8,848

((H1/C1) -1) * 100

raider45
Posted : Tuesday, September 12, 2017 9:22:58 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 378
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
Bruce_L
Posted : Tuesday, September 12, 2017 9:27:08 AM


Worden Trainer

Joined: 10/7/2004
Posts: 60,346

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
raider45
Posted : Tuesday, September 12, 2017 9:38:24 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 378
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?
Bruce_L
Posted : Tuesday, September 12, 2017 9:50:14 AM


Worden Trainer

Joined: 10/7/2004
Posts: 60,346

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
raider45
Posted : Tuesday, September 12, 2017 10:06:28 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 378

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.

raider45
Posted : Wednesday, September 13, 2017 4:27:18 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 378

The formula works fine, compliments and thanks!

100 * (H / C - 1)

Best regards !

Bruce_L
Posted : Wednesday, September 13, 2017 9:29:36 AM


Worden Trainer

Joined: 10/7/2004
Posts: 60,346

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.