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 |

Transformation Request Gappers Formula Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
raider45
Posted : Monday, November 13, 2017 11:55:09 AM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 422
Support has sent me the following message:
There is no way to show the Gap Up or Gap Down in the same column in different colors. It does not return a positive or negative value so it will always display both in whatever the Zero color is set to.
 
As a work around you could add this formula as a column using the Daily time frame. It returns +1 when the symbol has gapped up and -1 when it gapped down.
 
IIF(L > H1, 1, IIF(H < L1, -1, 0))
 
You can then set the color of the number to Green when positive and Red when Negative and the color of the 1 or -1 will alert you if it is gapped up or gapped down today.
 
To add the column click on the next column and then choose Write New Formula.
 
Paste or type in the above formula and set the Time Frame to daily.
 
That's probably the closest option to color coordinate the Gappers to be red when down and Green when up.
 
Thanks for using TC2000.
 
I would like to transform the following formula into PCF Formula to get Green and Red Gap Up Down.
 
Thank you and goodbye.
Raider45
Bruce_L
Posted : Monday, November 13, 2017 12:20:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,012

You can't make the WatchList Column say Gap Up and Gap Down and have it display the colors you want.

The only way to get the colors you want is if it displays 1 for gap up, -1 for gap down and 0 when there isn't a gap.

How to Edit Positive, Zero, and Negative Colors in a Column



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Monday, November 13, 2017 12:58:26 PM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 422

Formula Error: Expected ( At position 3

Bruce_L
Posted : Monday, November 13, 2017 1:09:56 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,012

Please make sure you don't have any spaces between the function and its opening parenthesis (this is always something to check BTW).

IIF(L > H1, 1, IIF(H < L1, -1, 0))



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
raider45
Posted : Monday, November 13, 2017 1:21:53 PM
Gold Customer Gold Customer

Joined: 9/30/2011
Posts: 422
Congratulations, thank you!
 
Best regards !
Bruce_L
Posted : Monday, November 13, 2017 1:29:20 PM


Worden Trainer

Joined: 10/7/2004
Posts: 61,012

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.