Welcome Guest, please sign in to participate in a discussion. | Search | Active Topics | |
Registered User Joined: 10/16/2011 Posts: 12
|
how to eleminate after market data from end of day scan??????
mac
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You can right-click on the chart and select Pre/Post Market Data to adjust the settings for when such data is available if at all.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
Yesterday, October 1 at 9:45 am AC.B.TO had a price point below the lower Bollinger Band. If I wanted to capture that event and it was 9:46 am yesterday, what would the scan have looked like?
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
What are the settings of the Bollinger Band and what is the time frame of the chart?
Beyond the particular example, are you just interested in the results of the previous bar, or do you want to check for more than one bar?
Does the bar need to close the Bollinger Band or does the low just need to be below the Bollinger Band?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
QUOTE (Bruce_L)
What are the settings of the Bollinger Band and what is the time frame of the chart?
Beyond the particular example, are you just interested in the results of the previous bar, or do you want to check for more than one bar?
Does the bar need to close the Bollinger Band or does the low just need to be below the Bollinger Band?
I was looking at the weekly chart i.e. 15 minute. It also appeared in the monthly chart on an hourly basis
The Bollinger Bands are 20 2.. The low just needs to be below the lower bollinger band and ultimately it will rise back into it. So that is just one bar.
I just cannot understand why in my scan didn't capture AC.B.TO. I know that once it is past the formula gets quite involved but I did another scan using the monthly chart ie hourly and it captured similar movement on other stocks but not this one.
Thanks, Bob
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
If you want to do it without creating a Condition Formula, add both the Bollinger Bands and a 1-Period Simple Moving Average withan Offset of 1 to Price History with the Average of setting of the moving average set to Low.
Adding and Moving Indicators
Then click on the moving average and select Create Scan Condition to create a condition for the moving average being Below Chan Bottom in the Moving Average of Low versus Bollinger Bands section of the Condition drop-down menu.
Create Conditions from Your Chart
A Condition Formula for the Low being below the 20-Period Simple Lower Bollinger Band during the previous bar could be written as:
L1 < AVGC20.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)
Modelling Bollinger Bands (& Standard Deviation) in a TC PCF
If you wanted to check for the low to be below the lower BB on either the current or previous bar, we could do that too:
L < AVGC20 - 2 * SQR(ABS(C ^ 2 + C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 - 20 * AVGC20 ^ 2) / 20) OR L1 < AVGC20.1 - 2 * SQR(ABS(C1 ^ 2 + C2 ^ 2 + C3 ^ 2 + C4 ^ 2 + C5 ^ 2 + C6 ^ 2 + C7 ^ 2 + C8 ^ 2 + C9 ^ 2 + C10 ^ 2 + C11 ^ 2 + C12 ^ 2 + C13 ^ 2 + C14 ^ 2 + C15 ^ 2 + C16 ^ 2 + C17 ^ 2 + C18 ^ 2 + C19 ^ 2 + C20 ^ 2 - 20 * AVGC20.1 ^ 2) / 20)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
Thanks for the reply. One other question. Why does a scan capture only certain stocks that have my choice of conditions and not other stocks which have those same conditions and in the same time frame?
Bob
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Please provide a specific example. It should not do this and never does so on my system.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
AC.B.TO at 9:45 Oct 1, 2013 on weekly chart did not show on a scan I did yesterday but on the same chart time frame same day and time there were two others with identical chart patterns all at 9:45 and it was only later in the day when I came across AC.B.TO quite by accident that I began to wonder why it hadn't appeared on the scan. Unfortunately I cannot recall the other two stocks, both out of TO.
I agree with your comment that this should not happen but in looking at my scan parameters AC.B should have been included. My scan parameters were TSX, volume greater than 50,000, price greater than $3.00, price less than $30.00, RSI going up through 40, all daily. Is there any way to follow my work in your system?
I cannot provide any further details. If this is too non specific please let me know and I will move on.
Thanks.
Bob
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
I have no way to access the settings on your account or see what you are or were doing in the program. What are the settings of your RSI that AC.B.TO would have been crossing up through 40 in a daily time frame?
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
QUOTE (Bruce_L)
I have no way to access the settings on your account or see what you are or were doing in the program. What are the settings of your RSI that AC.B.TO would have been crossing up through 40 in a daily time frame?
RSI 14 was crossing up through 40 in an hourly chart of AC.B.TO
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You said the time frame of all of the conditions in the EasyScan were daily. The EasyScan will only return true based on the conditions which are actually in the EasyScan. The time frame settings of the RSI based EasyScan Condition would need to be hourly for the EasyScan to return true.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Registered User Joined: 10/1/2012 Posts: 8
|
QUOTE (Bruce_L)
You said the time frame of all of the conditions in the EasyScan were daily. The EasyScan will only return true based on the conditions which are actually in the EasyScan. The time frame settings of the RSI based EasyScan Condition would need to be hourly for the EasyScan to return true.
I thank you for your time. It has been most informative.
Bob
|
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
|
Guest-1 |