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 |

Quick Sort using TC 200 v11 Platinum Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
lex6ix
Posted : Wednesday, March 23, 2011 1:09:55 PM
Registered User
Joined: 1/2/2008
Posts: 11
A few questions:I created a quick sort on a 10 minute chart,price crossing up through a moving average. I am assuming that for the current 10 minute bar, if the low is below the moving average and the price is above the moving average, then I should get the checkmark in the column. Is this correct? I ask as this happens some of the time, but often a stock fits the assumption but no checkmark.
Bruce_L
Posted : Wednesday, March 23, 2011 1:16:09 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I do not believe your assumption is correct. I believe the Quick Sort is checking for the Close of the previous Bar to below the Moving Average and the Close (or current Price) of the current Bar to be above the Moving Average.

You could create a Personal Criteria Formula for your version of crossing up through with the Time Frame of the PCF set as desired, but you would need to know the settings of the Moving Average to create the formula.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lex6ix
Posted : Wednesday, March 23, 2011 1:40:07 PM
Registered User
Joined: 1/2/2008
Posts: 11
Bruce,Got it. Thanks. Any idea what that PCF would be for a 15 minute chart and a 4 EMA?
Bruce_L
Posted : Wednesday, March 23, 2011 1:43:58 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
If you just want the Low of the current Bar to be below the EMA4 and the Close (or current Price) of the current Bar to be above it:

L < XAVGC4 AND XAVGC4 < C

If the Close of the previous Bar being below the EMA4 would qualify it as well then:

(C1 < XAVGC4 OR L < XAVGC4) AND XAVGC4 < C

The Time Frame part is handled by setting the Time Frame setting within the Personal Criteria Formula itself to 15-Minutes.

PCF Formula Descriptions
Handy PCF example formulas to help you learn the syntax of PCFs!

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lex6ix
Posted : Wednesday, March 23, 2011 2:02:38 PM
Registered User
Joined: 1/2/2008
Posts: 11
Bruce,Thanks! Created PCF, but not always working accurately. Some stocks shown as fitting the criteria opened above the EMA. Odd.....
Bruce_L
Posted : Wednesday, March 23, 2011 2:05:41 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
Which of the two Personal Criteria Formulas are you using?

Does it matter if the Open of the Bar is below the Moving Average? You did not mention this as a criteria previously.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lex6ix
Posted : Wednesday, March 23, 2011 2:07:41 PM
Registered User
Joined: 1/2/2008
Posts: 11
L < XAVGC4 AND XAVGC4 < C Sorry, I meant to say that some stocks show where the low is above the ema for the current bar.
Bruce_L
Posted : Wednesday, March 23, 2011 2:16:36 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
I have not been able to reproduce this at all.

Is your Chart set to the same Time Frame as the Personal Criteria Formula?

Are you scrolled all the way to the right on the Chart?

Is your Watchlist Column current? When you right-click on the Watchlist Column Header and select Edit, what is the Refresh Rate? How recently have you right-clicked on the Watchlist Column Header and selected Refresh Column (especially if the Refresh Rate is set to Manual)?

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lex6ix
Posted : Wednesday, March 23, 2011 2:21:45 PM
Registered User
Joined: 1/2/2008
Posts: 11
Refresh = 1 minute Example QCOR
lex6ix
Posted : Wednesday, March 23, 2011 2:25:14 PM
Registered User
Joined: 1/2/2008
Posts: 11
Bruce,I created the PCF in the 15 minute chart. How do I ensure the PCF is for the 15 minute Timeframe? Maybe that is the issue.
Bruce_L
Posted : Wednesday, March 23, 2011 2:29:42 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138
QCOR does not return True for me at 2:28 PM ET.

The Low is 13.94, the EMA4 is 14.00 and current Price is 13.95.

When you Create or Edit a Personal Criteria Formula there is a line that says Time Frame with a drop down menu where you can adjust the Time Frame of the PCF.

-Bruce
Personal Criteria Formulas
TC2000 Support Articles
lex6ix
Posted : Wednesday, March 23, 2011 2:33:13 PM
Registered User
Joined: 1/2/2008
Posts: 11
I had it set to daily...duh. Thanks for all the help Bruce
Bruce_L
Posted : Wednesday, March 23, 2011 2:42:34 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.