| 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 |