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 |

Adding a gap condition to a watchlist Rate this Topic:
Previous Topic · Next Topic Watch this topic · Print this topic ·
jasonwaynesmith
Posted : Sunday, March 20, 2016 2:55:21 PM
Registered User
Joined: 6/17/2015
Posts: 15

 

 

Can somoene help me write this?

 

I want to add a column for gappers with the following parameters so it will give me a check mark if it meets these conditrions:

 

1. The stock must gap up or down a minimum of $0.20

2. The gap must be less than 85% of yesterdays range

3. The gap must be greater than 15% of yesterdays range

 

I'm not good at programming so I am not sure if this is possible.

 

 

 

 

 

Every morning I want to check the SPY

jasonwaynesmith
Posted : Sunday, March 20, 2016 8:48:17 PM
Registered User
Joined: 6/17/2015
Posts: 15

No one has any ideas?

StockGuy
Posted : Monday, March 21, 2016 10:59:27 AM

Administration

Joined: 9/30/2004
Posts: 9,187

Since you want both directions with the additional parameters, you'll need two separate formulas:

Gap Up

L > H1 and L - H1 > .20 and (L - H1) / (H1-L1) < .85 and (L - H1) / (H1-L1) > .15

Gap Down

H < L1 and L1- H > .20 and (L1- H) / (H1-L1) < .85 and (L1- H) / (H1-L1) > .15

jasonwaynesmith
Posted : Tuesday, March 22, 2016 10:37:06 PM
Registered User
Joined: 6/17/2015
Posts: 15

Thanks

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.