Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
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.
|
|
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
|
|
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?
|
|
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
|
|
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.....
|
|
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
|
|
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.
|
|
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
|
|
Registered User Joined: 1/2/2008 Posts: 11
|
Refresh = 1 minute Example QCOR
|
|
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.
|
|
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
|
|
Registered User Joined: 1/2/2008 Posts: 11
|
I had it set to daily...duh. Thanks for all the help Bruce
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |