## New version 18 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 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
Registered User
Joined: 9/30/2011
Posts: 596
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

Joined: 9/30/2004
Posts: 9,036

((H1/C1) -1) * 100

raider45
 Posted : Tuesday, September 12, 2017 9:22:58 AM
Registered User
Joined: 9/30/2011
Posts: 596
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: 62,989

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
Registered User
Joined: 9/30/2011
Posts: 596
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: 62,989

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
Registered User
Joined: 9/30/2011
Posts: 596

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
Registered User
Joined: 9/30/2011
Posts: 596

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: 62,989

You're welcome.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
Users browsing this topic
Guest-1

 Forum Jump Customer Training & Support - Ask a Trainer - TC2000 version 12/18 - Ask a Trainer - TC2000 version 7 - Ask a Trainer - StockFinder 5.0 - PCFs, EasyScan and Custom Indicators General Discussions - Stock and Market Talk - TC2000 version 12 or 18 - TC2000 version 7 - StockFinder 5.0 - RealCode for StockFinder 5.0 Tutorial Videos - TC2000 version 12 tutorial videos - TC2000 version 7 tutorial videos 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.