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


New account application Trading resources
Margin rates Stock & option commissions

Attention: Discussion forums are read-only for extended maintenance until further notice.
Welcome Guest, please sign in to participate in a discussion. Search | Active Topics |

Looking for a watchlist column that picks up a condition that happened yesterday Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
yifense86
Posted : Tuesday, March 21, 2017 2:49:43 PM
Registered User
Joined: 10/13/2011
Posts: 38

Hi,

How would I program a watchlist column to show if the following condition occured yesterday:

(H+.15) / ABS(C > C1 AND V < MINV2.1   AND V < AVGV50)

Thanks!

Yi

Bruce_L
Posted : Tuesday, March 21, 2017 2:59:04 PM


Worden Trainer

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

You only need the Condition Formula portion of this. If we re-write that for 1 bar ago, we would get the following.

C1 > C2 AND V1 < MINV2.2 AND V1 < AVGV50.1

The rest of the formula is just there to plot the dot above the high in a Custom PCF Indicator when the condition portion is true.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yifense86
Posted : Tuesday, March 21, 2017 3:16:01 PM
Registered User
Joined: 10/13/2011
Posts: 38

Thanks Bruce, what about this formula?

C < C1 AND V < MINV2.1   AND (C-L) / (H-L) > .5   AND V < AVGV50

I'm trying to understand which portion of the formula represent the previous day.

Thanks

Bruce_L
Posted : Tuesday, March 21, 2017 3:38:51 PM


Worden Trainer

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

What you need to change is the bars ago parameter in all of the components of the fomula.

C1 < C2 AND V1 < MINV2.2 AND (C1 - L1) / (H1 - L1) > .5 AND V1 < AVGV50.1

Note however that in TC2000 v17, if you already have the Condition Formula saved for the current bar, you would not need to re-write it make a WatchList Column based on the previous bar. I only re-wrote the last one because the version given was an Indicator Formula designed to plot dots on the chart instead of being a Condition Formula.

Select Add Column (+ in an orange circle at the top of the WatchList) and choose the Condition Formula from the Formulas section.

Then right-click on the WatchList Column Header (the name of the WatchList Column at the top of the WatchList) and select Edit.

Click on the name of the condition in the conditions tab and change it from True Now to True x Bars ago with Bars Ago set to 1.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yifense86
Posted : Tuesday, March 21, 2017 3:50:47 PM
Registered User
Joined: 10/13/2011
Posts: 38

Thank you Bruce, I'm understanding now!

Bruce_L
Posted : Tuesday, March 21, 2017 3:55:16 PM


Worden Trainer

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

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.