JohnT328
53 posts
msg #148433
- Ignore JohnT328 |
7/9/2019 6:20:00 PM
Hi, I don't think this is right because for the most part, it is not filtering stocks that were more than 4% below their EMA (17) within the last 15 trading days. Can someone take a look at help?
"Price was at least 4% below EMA(17) within the last 15 days and price is above EMA(17) and exchange is not OTCBB and exchange is not ETF and exchange is not AMEX and average volume is above 1,000,000 and price is between 15 and 1000 and optionable and the Historical Volatility(100,1) is above 20 and optionable and RSI (14) is below 69"
|
compound_gains
222 posts
msg #148434
- Ignore compound_gains |
7/9/2019 7:14:58 PM
PPO(10,50) was at least 4% below EMA(17) within the last 15 days and price is above EMA(17) and exchange is not OTCBB and exchange is not ETF and exchange is not AMEX and average volume is above 1,000,000 and price is between 15 and 1000 and optionable and the Historical Volatility(100,1) is above 20 and optionable and RSI (14) is below 69
|
JohnT328
53 posts
msg #148435
- Ignore JohnT328 |
7/9/2019 7:42:00 PM
Thank you for this but I don't think it works. For example, TSLA has not traded more than 4% its ema(17) within the last 15 trading days and it is in the filter
|
xarlor
587 posts
msg #148436
- Ignore xarlor |
7/9/2019 9:32:29 PM
TSLA below EMA(17) was:
5% on 07/05/19
6% on 07/03/19
4% on 07/01/19
All these satisfy the "within last 15 days" requirement. See the following filter and go back to those days:
Your filter request here:
|
JohnT328
53 posts
msg #148437
- Ignore JohnT328 |
7/9/2019 9:46:00 PM
You are looking at daily charts right? When I go to stockcharts and look up daily TSLA, it does not go below EMA (17). What am I missing here?
Also, in your charts, if the green line is EMA (17), you can clearly see by the actual charts you posted, that price is not below EMA (17), nonetheless at least 4% below it....
|
xarlor
587 posts
msg #148438
- Ignore xarlor
modified |
7/9/2019 10:20:58 PM
My mistake, I misread it as EMA(17) below price. Just switched var1 and var2 around and I think this is what you're after:
Note I used price as the condition, not close. That means if any time during the day the price reached 4% below EMA(17) it will count. Or did you just want it to count if the close is 4% below?
|
JohnT328
53 posts
msg #148442
- Ignore JohnT328 |
7/10/2019 7:54:14 AM
This works perfect. Thanks for your help!
|