## New version 18 available now

Subscription & data-feed pricing Class schedule

Margin rates Stock & option commissions

 PCF request Negative percentage formula Rate this Topic:
 Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
 Posted : Sunday, February 11, 2018 7:59:48 AM
Registered User
Joined: 9/30/2011
Posts: 786
I would like a PCF Formula with the signal on the titles with a negative performance of <5% to <99%

Thank you and goodbye.

Raider45
Bruce_L
 Posted : Monday, February 12, 2018 10:34:42 AM

Worden Trainer

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

I am going to guess this means you want a formula which returns true when the 1 period price percent change is between -99% and -5%.

`-99 < 100 * (C / C1 - 1) AND 100 * (C / C1 - 1) < -5`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Monday, February 12, 2018 10:48:01 AM
Registered User
Joined: 9/30/2011
Posts: 786
Congratulations, thank you !

Best regards !
raider45
 Posted : Tuesday, March 13, 2018 1:44:38 PM
Registered User
Joined: 9/30/2011
Posts: 786
I ask for a formula with the signal on the Securities with the current quotation = <2% from the closing value of yesterday.

Thank you and goodbye.

Raider45
Bruce_L
 Posted : Tuesday, March 13, 2018 2:08:40 PM

Worden Trainer

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

So you want price percent change to be negative but within 2%?

`98 * C1 <= 100 * C AND C < C1`

Or just within 2% no matter if the percent change is positive or negative?

`100 * (C / C1 - 1) <= 2`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Tuesday, March 13, 2018 2:13:10 PM
Registered User
Joined: 9/30/2011
Posts: 786

No, the price must be less than 2% and above, so the signal will start from 2% down, not within 2% !

Bruce_L
 Posted : Tuesday, March 13, 2018 2:19:47 PM

Worden Trainer

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

So you want price to be at least 2% down?

`100 * C <= .98 * C1`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Tuesday, March 13, 2018 3:00:50 PM
Registered User
Joined: 9/30/2011
Posts: 786
After changes, this is the desired formula.

-98 <100 * (C / C1 - 1) AND 100 * (C / C1 - 1) <-2

Thank you for your attention and cooperation !

Best regards !
Bruce_L
 Posted : Tuesday, March 13, 2018 3:06:40 PM

Worden Trainer

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

I am happy to read you were able to figure out the formula on your own.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Wednesday, March 14, 2018 5:32:32 AM
Registered User
Joined: 9/30/2011
Posts: 786
I would like a PCF Formula with the following parameter:

The signal on the Securities with today's positive performance is between => 1% and = <3% from yesterday's high

I thank and cordially greet.

Raider45
Bruce_L
 Posted : Wednesday, March 14, 2018 9:10:31 AM

Worden Trainer

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

`101 * H1 <= 100 * C AND 100 * C <= 103 * H1`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Wednesday, March 14, 2018 9:27:15 AM
Registered User
Joined: 9/30/2011
Posts: 786
Congratulations, thank you !

Best regards !
raider45
 Posted : Friday, March 16, 2018 7:02:58 AM
Registered User
Joined: 9/30/2011
Posts: 786
I would like a PCF Formula with the following parameter:

The signal on today's securities with the quotation included between => 2% from closing and lower than 2% from yesterday's maximum.

Thank you and goodbye.
Raider45
Bruce_L
 Posted : Friday, March 16, 2018 9:11:31 AM

Worden Trainer

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

`102 * C1 <= 100 * C AND 100 * C < 102 * H1`

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
 Posted : Friday, March 16, 2018 9:26:54 AM
Registered User
Joined: 9/30/2011
Posts: 786

Congratulations, thank you !

Bruce_L
 Posted : Friday, March 16, 2018 9:29:16 AM

Worden Trainer

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

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.