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 |

Formula Help Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
OneDay816
Posted : Friday, November 24, 2006 8:25:01 AM
Registered User
Joined: 6/30/2005
Posts: 30
Please help,

I am looking for stocks that:
1. Bounce off of the 9 exponential MA. The open is at or near the 9EMA and the close is at or near the high of that same day. WIth the the 20EMA, being the slow average, less than the 9EMA.

Number 1 would be for bullish stocks, where I'd also like the contrary of this formulated for the bearish stocks. Hopefully I make sense and that you can help me. Thanks for your time.

OneDay
Craig_S
Posted : Friday, November 24, 2006 12:43:59 PM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
How near is "near" to qualify when you say the "open is at or near the 9EMA and the close is at or near the high of that same day"?

- Craig
Here to Help!
OneDay816
Posted : Saturday, November 25, 2006 6:51:25 AM
Registered User
Joined: 6/30/2005
Posts: 30
Hey Craig,

Well I assumed that it would be unrealistic for the price to open at the same price as the 9EMA. So I guess near can be less than or greater than 5% of the 9EMA price.

One Day
Craig_S
Posted : Saturday, November 25, 2006 6:57:57 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
How near is near for this part: "the close is at or near the high of that same day"?

- Craig
Here to Help!
OneDay816
Posted : Sunday, November 26, 2006 4:51:31 AM
Registered User
Joined: 6/30/2005
Posts: 30
the same plus/minus 5% from the 9EMA
OneDay816
Posted : Sunday, November 26, 2006 4:53:57 AM
Registered User
Joined: 6/30/2005
Posts: 30
So sorry,

I meant to say: closes at the high or within 5% of the high. Sorry. Thanks

OneDay
Craig_S
Posted : Sunday, November 26, 2006 6:01:20 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
Try this for me:

ABS(O-XAVGC9)/XAVGC9 <=0.05 AND (C-L)/(H-L)>=0.95 AND XAVGC20<XAVGC9

I put the close at 95% of the daily range. A stock with the close's value at 5% of the high's value may still be closer to the daily low than the high (which I don't believe you wanted).

- Craig
Here to Help!
OneDay816
Posted : Sunday, November 26, 2006 6:35:09 AM
Registered User
Joined: 6/30/2005
Posts: 30
Hi Craig,

I tryed the formula above but the scan provided stocks far away from the 9EMA. Let me give you an example of what I'm looking for: CRM on 9/20/06 off the daily, candlestick chart. another would be NYX on 9/21/06 daily, candlestick chart. Here r some of the stocks that the above formula gave me: CAL, SPG, UTX, IPS. I hope you can help me. Thanks.

One Day
Craig_S
Posted : Sunday, November 26, 2006 6:53:18 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
It would appear we need to get tighter than 5% and less restrictive on the close as percent of range.

Try this:

ABS(O-XAVGC9)/XAVGC9 <=0.01 AND (C-L)/(H-L)>=0.85 AND XAVGC20<XAVGC9

It is TRUE for NYX and CRM on the dates you gave.

Here are some of the stocks it found today:

BMC
ORCL
GT
CNP
CELG

- Craig
Here to Help!
bustermu
Posted : Sunday, November 26, 2006 10:12:24 AM
Registered User
Joined: 1/1/2005
Posts: 2,645
Craig,

The portion of the PCF:

(C-L)/(H-L)>=0.85

should be changed to:

(C-L)>=0.85*(H-L)

in order to prevent a divide by zero.

An attempt to plot the PCF as a Custom Cumulative Indicator will fail in many cases without the change.

Thanks,
Jim Murphy
Craig_S
Posted : Sunday, November 26, 2006 10:17:55 AM


Worden Trainer

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

- Craig
Here to Help!
OneDay816
Posted : Monday, November 27, 2006 1:45:09 AM
Registered User
Joined: 6/30/2005
Posts: 30
The outputs r much better. Can u pls convert this on the bear side as well? Also Craig, a long time ago (8/9/06 thread) you had given me a conversion table, an easy way for me to convert daily candlestick patterns into 3-day patterns. Can you pls provide a table with 4-day and weekly conversions as well? Thanks.

One Day
Craig_S
Posted : Monday, November 27, 2006 6:59:41 AM


Worden Trainer

Joined: 10/1/2004
Posts: 18,819
I need you to define the &quot;bear side&quot; version of this. Describe it and I will write it.


Daily to 4-day:

O -> O3
H -> MAXH4
L -> MINL4
C -> C
O1 -> O7
H1 -> MAXH4.4
L1 -> MINL4.4
C1 -> C4
O2 -> O11
H2 -> MAXH4.8
L2 -> MINL4.8
C2 -> C8
O3 -> O15

See the relationship between the daily and the 4-day? Review the one I gave for the 3-day as well. I bet you can make your own 5-day (or any day) version. Let me know if you have trouble.

- Craig
Here to Help!
OneDay816
Posted : Wednesday, November 29, 2006 6:24:24 AM
Registered User
Joined: 6/30/2005
Posts: 30
Thank you very much for the definitions, i can see the relationships to develop further versions(5, 6, 7, 8 day charts). When i meant bearish, i just meant now the 9EMA is lower than the 20EMA and the open falls off the 9EMA. Hope i make sense.

Thanks,
OneDay
Craig_S
Posted : Wednesday, November 29, 2006 7:01:59 AM


Worden Trainer

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

ABS(O-XAVGC9)/XAVGC9 <=0.01 AND (C-L)/(H-L)<=0.05 AND XAVGC20>XAVGC9

I assumed you wanted the close near the low as well.

- Craig
Here to Help!
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.