StockFetcher Forums · Filter Exchange · Help on writing a line for a filter<< >>Post Follow-up
marine2
829 posts
msg #98210
Ignore marine2
12/25/2010 8:27:38 PM

How would I write a line for a filter that I want to show MA(100) has been going downward (X amount of days, meaning your choice of days that you want to put in) but the last two days is going up? Your help will be greatly appreciated. Thank you, and Merry Christmas!

four
4,000 posts
msg #98211
Ignore four
modified
12/25/2010 8:42:19 PM

/*
How would I write a line for a filter that I want to show MA(100) has been going downward (X amount of days, meaning your choice of days that you want to put in) but the last two days is going up? Your help will be greatly appreciated. Thank you, and Merry Christmas!
*/


Fetcher[
set{dwn, count(ma(100) < ma(100) 1 day ago,10)} /*look at 10 days*/
dwn > 7 /* want > 7 days down */
ma(100) > ma(100) 1 day ago
ma(100) > ma(100) 2 days ago
ma(100) 1 day ago > ma(100) 2 days ago
add column dwn /* actual number of days down */
add column separator
add column ma(100) {tdy}
add column ma(100) 1 day ago {1ago}
add column ma(100) 2 days ago {2ago}
]



marine2
829 posts
msg #98246
Ignore marine2
12/27/2010 4:49:56 PM

Thank you so much in helping write lines of code for this thought I had. I really like what it's doing. I call it the Moving Average Pivot Point. What I did to refine it in simple terms was to: I put in a line saying, and day change % is above 0. That removes all the negative day price actions. I was wondering if you saw any further improvements to this filter to make it even better? I did run a back test in the period of 7/31/06 to 11/31/06. That's a 6 month test. My results were, 81% Wins and ROI = 53%. That's not too shabby. But, maybe with some refinements it could be better? Again, thank you for helping me on this problem.

marine2
829 posts
msg #98276
Ignore marine2
12/28/2010 9:09:59 PM

Just wanted to say, using this filter FOUR created from my question, a stock named Drugstore.com, its stock symbol DSCOD, just went up big time. It went from 2.50 to 5.40 in two days. In fact if you look at todays filter picks you will see an even bigger pop than I give to you. This is what this filter does, it has the opportunity for an explosive pop. It is the pivot point for the moving average to begin its journey upwards. Check it out and tell me what you all think of it. Thank you.

bkhurana43
103 posts
msg #98292
Ignore bkhurana43
12/29/2010 12:39:28 PM

Filter above would be more effective if we put a criteria for stocks meeting the objective. Such as stocks crossed MA(100) today or 1 day ago etc.
Fetcher[
set{dwn, count(ma(100) < ma(100) 1 day ago,10)} /*look at 10 days*/
dwn > 7 /* want > 7 days down */
ma(100) > ma(100) 1 day ago
ma(100) > ma(100) 2 days ago
ma(100) 1 day ago > ma(100) 2 days ago
Price crossed MA(100) from below /* Look at today's development */
add column dwn /* actual number of days down */
add column separator
add column ma(100) {tdy}
add column ma(100) 1 day ago {1ago}
add column ma(100) 2 days ago {2ago}
]





four
4,000 posts
msg #98294
Ignore four
modified
12/29/2010 12:50:12 PM

marine2
msg #98210
- Ignore marine2 12/25/2010 8:27:38 PM

How would I write a line for a filter that I want to show MA(100) has been going downward (X amount of days, meaning your choice of days that you want to put in) but the last two days is going up? Your help will be greatly appreciated. Thank you, and Merry Christmas!

-------
bkhurana43,

Respectfully, there was no criteria given for a stock price action.
The request is only for MA(100) action.
Your filter answers a different question.

marine2
829 posts
msg #98301
Ignore marine2
12/29/2010 3:36:35 PM

Four, you did a great job in writing this filter. Thank you very much! This is what his forum is all about. Helping write really cool filters like this.

four
4,000 posts
msg #98302
Ignore four
12/29/2010 3:58:28 PM

marine2,

Happy New Year.

Perhaps you will keep us in the loop as you trade this filter?



mystiq
650 posts
msg #98309
Ignore mystiq
modified
12/30/2010 12:30:02 AM

Fetcher[
set{dwn, count(ma(100) < ma(100) 1 day ago,10)} /*look at 10 days*/
dwn > 7 /* want > 7 days down */
ma(100) > ma(100) 1 day ago
ma(100) 1 day ago > ma(100) 2 days ago
price is approaching ma(100)
add column dwn /* actual number of days down */
add column separator
add column ma(100) {tdy}
add column ma(100) 1 day ago {1ago}
add column ma(100) 2 days ago {2ago}

draw ema(4)
chart-time is 45 days
volume > 1000000
]



buy when price crosses UNDER ema(4)

LCC
Call Options Expire at close Friday, January 21, 2011
Strike Symbol Last Chg Bid Ask Vol Open Int
11.00 LCC110122C00011000 0.15 0.03 0.14 0.15 211 7,369
12.50 LCC110122C00012500 0.03 0.03 0.03 0.05 7,080 21,828
LCC
Call Options Expire at close Friday, February 18, 2011
Strike Symbol Last Chg Bid Ask Vol Open Int
11.00 LCC110219C00011000 0.41 0.09 0.42 0.44 67 670
12.00 LCC110219C00012000 0.22 0.05 0.20 0.22 7,051 518


Eman93
4,659 posts
msg #98311
Ignore Eman93
12/30/2010 12:34:40 AM

Nice work... JP is a big believer in the power of the 100

StockFetcher Forums · Filter Exchange · Help on writing a line for a filter<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus