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 |

scans Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
mhenley
Posted : Wednesday, September 25, 2013 5:27:55 AM
Registered User
Joined: 10/16/2011
Posts: 12

how to eleminate after market data from end of day scan??????

 

mac

Bruce_L
Posted : Wednesday, September 25, 2013 7:36:10 AM


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
Beliveau
Posted : Wednesday, October 2, 2013 9:10:29 AM
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?

Bruce_L
Posted : Wednesday, October 2, 2013 9:34:58 AM


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
Beliveau
Posted : Wednesday, October 2, 2013 10:57:20 AM
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

 

 

Bruce_L
Posted : Wednesday, October 2, 2013 11:08:54 AM


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
Beliveau
Posted : Wednesday, October 2, 2013 11:39:24 AM
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

Bruce_L
Posted : Wednesday, October 2, 2013 11:40:42 AM


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
Beliveau
Posted : Wednesday, October 2, 2013 1:58:55 PM
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

 

 

 

Bruce_L
Posted : Wednesday, October 2, 2013 2:12:16 PM


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
Beliveau
Posted : Wednesday, October 2, 2013 3:13:51 PM
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

Bruce_L
Posted : Wednesday, October 2, 2013 3:25:19 PM


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
Beliveau
Posted : Wednesday, October 2, 2013 3:42:10 PM
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

Bruce_L
Posted : Wednesday, October 2, 2013 3:49:03 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.