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 |

Easy Scan for stock bouncing off the 50 sma Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
spurs2567
Posted : Monday, July 28, 2008 3:41:36 AM
Registered User
Joined: 4/11/2007
Posts: 23

Hi
Can you assist me please. I want to set up 2 easy scans, the first is for stocks that are in a downward trend for the last 60 days, the 50 day sma is below the 200 sma and the stock has tried to break through the 50 sma and failed, it may be easier for the scan if the stock is 1% below the 50 sma.
The second scan is for stocks that are in an upward trend for the last 60 days the 50 sma is above the 200 sma and the stock is 1% above the 50 sma.
Thanks 
M

Craig_S
Posted : Monday, July 28, 2008 3:19:15 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819

I need to clarify this part:

QUOTE
the stock has tried to break through the 50 sma and failed, it may be easier for the scan if the stock is 1% below the 50 sma.

Do you mean the stock, today, is below the 50MA but with 1% of the value of the 50MA?



- Craig
Here to Help!
spurs2567
Posted : Monday, July 28, 2008 4:05:42 PM
Registered User
Joined: 4/11/2007
Posts: 23
Yes, today
Thanks
M
Craig_S
Posted : Monday, July 28, 2008 4:23:18 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Try these:

First PCF:
C<C60 AND
AVGC50<AVGC200 AND
C<AVGC50 AND C>AVGC50-(AVGC50*0.01)

Second PCF:
C>C60 AND
AVGC50>AVGC200 AND
C>AVGC50 AND C<AVGC50+(AVGC50*0.01)


- Craig
Here to Help!
spurs2567
Posted : Tuesday, July 29, 2008 4:39:51 AM
Registered User
Joined: 4/11/2007
Posts: 23
Hi Craig

Nearly, the first scan, most of the stocks have already hit their head off the 50 sma and made their move down, can you tweak the first scan so the stock is just below !% the 50 sma today.
Thanks and I'll check out the other other scan.
Craig_S
Posted : Tuesday, July 29, 2008 9:10:10 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
The PCF only finds stocks that are between the 50SMA and 1% below the value of the 50sma.  What stocks are returning TRUE that you don't think should?

- Craig
Here to Help!
spurs2567
Posted : Wednesday, July 30, 2008 2:47:56 AM
Registered User
Joined: 4/11/2007
Posts: 23
about 50% of them, could you remove the 60 day trend, so 2 pcf's one for stock that has formed a hammer or bullish engulfing candle on or above the 50 day sma and another pcf for stock that has formed a shooting star or bearish engulfing line below or on the 50 day sma, maybe we could try within a 1% price range again thanks
spurs2567
Posted : Wednesday, July 30, 2008 6:54:39 AM
Registered User
Joined: 4/11/2007
Posts: 23
Craig

Also could you offer me a pcf for stock that has its 50 day sma above its 200 sma and has formed or is forming a cup and handle formation
thanks 
M
Craig_S
Posted : Wednesday, July 30, 2008 7:49:33 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Before we start writing other PCFs, we need to figure out why the first one did not work for you.

What symbols return TRUE for the PCF that do not fit the condition?

- Craig
Here to Help!
spurs2567
Posted : Wednesday, July 30, 2008 8:07:25 AM
Registered User
Joined: 4/11/2007
Posts: 23
I think the reason it didnt meet my criteria Craig, is becasue of the 60 day trending, I beleive if we remove this the pcf will meet my requirements, could we try this and then I can tell you which stock arent true?
Thanks 
M
spurs2567
Posted : Wednesday, July 30, 2008 8:12:03 AM
Registered User
Joined: 4/11/2007
Posts: 23
craig
It seems ok today, I dont know what happened yesterday, so it is working toady, could you offer me a PCF without the 60 day trending, so like you gave me before 2 tow pcfs this time without the trending though and i think we will have it then, thanks
Craig_S
Posted : Wednesday, July 30, 2008 8:12:49 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819

Did the stocks found by the PCF not meet your requirements OR did they not meet the criteria formula I wrote?  These are two different things.

Here are the PCFs without any "trending" requirements.

First PCF
[this finds the 50sma below the 200sma and price below the 50sma but within 1% of the 50sma]

AVGC50<AVGC200 AND
C<AVGC50 AND C>AVGC50-(AVGC50*0.01)



Second PCF:
[this finds the 50sma above the 200sma and price above the 50sma but within 1% of the 50sma]

AVGC50>AVGC200 AND
C>AVGC50 AND C<AVGC50+(AVGC50*0.01)



- Craig
Here to Help!
spurs2567
Posted : Wednesday, July 30, 2008 8:16:29 AM
Registered User
Joined: 4/11/2007
Posts: 23
thanks, they did meet my requirements I made a mistake, sorry for the confusion and thank you for your help, I will revert back to you, once ive tried these pdf's
Once again thanks
spurs2567
Posted : Wednesday, July 30, 2008 8:21:59 AM
Registered User
Joined: 4/11/2007
Posts: 23
Perfecto, thanks Craig, can you also offer me a PCF, for stock that has or is forming a cup and handle formation please.
Thanks
M
Craig_S
Posted : Wednesday, July 30, 2008 8:59:54 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Please check out this post on C+H: Cup with a handle formation

- Craig
Here to Help!
spurs2567
Posted : Thursday, July 31, 2008 3:07:00 AM
Registered User
Joined: 4/11/2007
Posts: 23
thanks Craig
Craig_S
Posted : Thursday, July 31, 2008 5:26:50 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
My pleasure

- Craig
Here to Help!
yurinc
Posted : Tuesday, October 22, 2013 12:08:36 AM
Registered User
Joined: 4/19/2013
Posts: 15

good evening, I have installed the TC 2000 V.12, 3 my question is because I displays historical data on older frames the mobile Media 500 days only displays one point me in the present day?

yurinc
Posted : Tuesday, October 22, 2013 1:15:08 AM
Registered User
Joined: 4/19/2013
Posts: 15

Greetings, I have the version12, 3, my question is because it shows me historical data on daily and weekly under the 500-day moving average shows a point only for the current day. very grateful for your reply.

Bruce_L
Posted : Tuesday, October 22, 2013 8:50:55 AM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

TC2000 version 12.3 only has the most recent 500 bars of data available in any given time frame. This means there would not be enough data available to calculate a 500 bar moving average for older bars.



-Bruce
Personal Criteria Formulas
TC2000 Support Articles
yurinc
Posted : Wednesday, October 30, 2013 2:59:30 PM
Registered User
Joined: 4/19/2013
Posts: 15
greetings, because when I do the condition
C> = AVGC50
where c = 1.40
AVGC50 = 1.40
 
  when testing formulation indicated false.
 
apparently the equal sign is not considered in the test.formula
 
hope will help me, thanks
Bruce_L
Posted : Wednesday, October 30, 2013 3:14:47 PM


Worden Trainer

Joined: 10/7/2004
Posts: 65,138

The sign is considered in the testing, but the computer would need to see AVGC50 as exactly equal to C for the equal sign to be make a difference (the calculations that the computer cares about are using the single precision floating point data type which rounds things to approximately 7 significant digits).

The Condition Formula will not return true if C is slightly below AVGC50 even if they both round to 1.40 when rounded to two digits past the decimal.

Note that your formula needs to be:

C >= AVGC50

You can't have a space between the > and = signs.



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