StockFetcher Forums · Filter Exchange · New filter from forum chatter<< 1 2 3 >>Post Follow-up
defau
24 posts
msg #43398
Ignore defau
5/1/2006 5:37:31 PM

Here is a filter I have created based on the threads I've been reading. Also attached are the backtesting results. Is there a way to make this better?


rsi(2)crossed above 20
and 5 day slope of rsi(8) is above 0
and average day range(20) is greater than 1.5%
and ema(8) is greater than ema(18)
and macd(8,18) fast line is above macd(8,18) slow line
and close is between 15 and 30
and average volume (90) is greater than 500000
and volume today is greater than average volume
and 36 day slope of ema(18) is greater than 0


Approach Information
Approach Name: Play 2
Test started on 12/30/2005 ended on 04/28/2006, covering 81 days
Filter used:
Play 2 (saved filter)

Trade Statistics
There were 19 total stocks entered. Of those, 18 or 94.74% were complete and 1 or 5.26% were open.
Of the 18 completed trades, 13 trades or 72.22%resulted in a net gain.
Your average net change for completed trades was: 4.28%.
The average draw down of your approach was: -2.09%.
The average max profit of your approach was: 6.84%
The Reward/Risk ratio for this approach is: 4.95
Annualized Return on Investment (ROI): 404.40%, the ROI of ^SPX was: 13.66%.

Exit Statistics
Stop Loss was triggered 1 times or 5.56% of the time.
Stop Profit was triggered 1 times or 5.56% of the time.
Trailing Stop Loss was triggered 0 times or 0.00% of the time.
You held for the maximum period of time (5 days) 2 times or 11.11% of the time.
An exit trigger was executed 14 times or 77.78% of the time.

Statistics By Holding Period
 Completed2 day chg5 day chg10 day chg25 day chg40 day chg
Winners:131412968
Losers:546775
Win/Loss Ratio:2.60:13.50:12.00:11.29:10.86:11.60:1
Net Change:4.27%2.30%4.59%5.54%3.84%6.49%

Statistics By Variable: Match Price
 <15<16.5<18<19.5<21<22.5<24<25.5<27<28.5
Completed2:02:01:0--2:22:01:11:22:0
2 day chg2:02:01:0--2:22:01:12:12:0
5 day chg2:01:11:0--2:22:01:12:11:1
10 day chg1:10:11:0--2:22:01:11:21:0
25 day chg0:10:11:0--1:32:01:11:1-
40 day chg0:11:01:0--2:22:01:11:1-

Statistics By Variable: Average Volume
 <1.5M<3.0M<4.5M<6.0M<7.5M<9.0M<10.5M<12.0M<13.5M<15.0M
Completed7:21:22:02:01:0----0:1
2 day chg6:32:12:02:01:0----1:0
5 day chg7:21:21:11:11:0----1:0
10 day chg5:31:20:21:01:0----1:0
25 day chg2:52:10:11:0-----1:0
40 day chg3:42:11:01:0-----1:0



__fetcheruser123
msg #43417
Ignore __fetcheruser123
5/2/2006 12:20:10 PM

Not sure what kind of backtest setup you used, but here are the results over a 2 year period.

Approach Information
Approach Name: unnamed approach
Test started on 12/31/2003 ended on 12/30/2005, covering 504 days
Filter used:
rsi(2)crossed above 20
and 5 day slope of rsi(8) is above 0
and average day range(20) is greater than 1.5%
and ema(8) is greater than ema(18)
and macd(8,18) fast line is above macd(8,18) slow line
and close is between 15 and 30
and average volume (90) is greater than 500000
and volume today is greater than average volume
and 36 day slope of ema(18) is greater than 0

Trade Statistics
There were 57 total stocks entered. Of those, 54 or 94.74% were complete and 3 or 5.26% were open.
Of the 54 completed trades, 26 trades or 48.15%resulted in a net gain.
Your average net change for completed trades was: -1.10%.
The average draw down of your approach was: -7.45%.
The average max profit of your approach was: 6.34%
The Reward/Risk ratio for this approach is: 0.74
Annualized Return on Investment (ROI): -17.69%, the ROI of ^SPX was: 6.12%.

Exit Statistics
Stop Loss was triggered 20 times or 37.04% of the time.
Stop Profit was triggered 13 times or 24.07% of the time.
Trailing Stop Loss was triggered 0 times or 0.00% of the time.
You held for the maximum period of time (25 days) 21 times or 38.89% of the time.
An exit trigger was executed 0 times or 0.00% of the time.

Statistics By Holding Period
 Completed2 day chg5 day chg10 day chg25 day chg40 day chg
Winners:262722243030
Losers:283035322727
Win/Loss Ratio:0.93:10.90:10.63:10.75:11.11:11.11:1
Net Change:-1.10%0.12%-0.47%-0.70%-0.08%-0.63%

Statistics By Variable: Match Price
 <14<16<18<20<22<24<26<28<30<32
Completed0:42:46:45:65:03:24:40:21:2-
2 day chg0:43:35:55:64:23:45:30:22:1-
5 day chg1:31:53:74:73:33:45:30:22:1-
10 day chg0:42:44:55:64:24:33:51:11:2-
25 day chg1:31:57:35:65:15:25:30:21:2-
40 day chg1:32:46:43:86:04:36:20:22:1-

Statistics By Variable: Average Volume
 <4.0M<8.0M<12.0M<16.0M<20.0M<24.0M<28.0M<32.0M<36.0M<40.0M
Completed21:252:11:1-2:0----0:1
2 day chg21:282:11:1-2:0----1:0
5 day chg18:311:21:1-2:0----0:1
10 day chg20:282:11:1-1:1----0:1
25 day chg25:242:11:1-2:0----0:1
40 day chg27:222:11:1-0:2----0:1



defau
24 posts
msg #43419
Ignore defau
5/2/2006 1:34:33 PM

The exit makes a difference. rsi(8) crossed over 70 or rsi(2) crossed below 20 and hold time of 5 days max with 50% profit stop and 10% stop loss


defau
24 posts
msg #43420
Ignore defau
5/2/2006 1:36:51 PM

Also, I think the results could be better if I could qualify the entry based on intraday signals


__fetcheruser123
msg #43422
Ignore __fetcheruser123
5/2/2006 2:26:48 PM

Here it is with the settings you suggested...

Stop Loss: 10%
Profit Stop: 50%
Trailing Stop Loss: N/A
Minimum Holding Days: N/A
Maximum holding days: 5
Exit Trigger #1: rsi(8) crossed over 70 or rsi(2) crossed below 20

Approach Information
Approach Name: unnamed approach
Test started on 12/31/2003 ended on 12/30/2005, covering 504 days
Filter used:
rsi(2)crossed above 20
and 5 day slope of rsi(8) is above 0
and average day range(20) is greater than 1.5%
and ema(8) is greater than ema(18)
and macd(8,18) fast line is above macd(8,18) slow line
and close is between 15 and 30
and average volume (90) is greater than 500000
and volume today is greater than average volume
and 36 day slope of ema(18) is greater than 0

Trade Statistics
There were 57 total stocks entered. Of those, 56 or 98.25% were complete and 1 or 1.75% were open.
Of the 56 completed trades, 20 trades or 35.71%resulted in a net gain.
Your average net change for completed trades was: -0.56%.
The average draw down of your approach was: -4.27%.
The average max profit of your approach was: 4.60%
The Reward/Risk ratio for this approach is: 0.77
Annualized Return on Investment (ROI): -29.68%, the ROI of ^SPX was: 6.12%.

Exit Statistics
Stop Loss was triggered 6 times or 10.71% of the time.
Stop Profit was triggered 0 times or 0.00% of the time.
Trailing Stop Loss was triggered 0 times or 0.00% of the time.
You held for the maximum period of time (5 days) 50 times or 89.29% of the time.
An exit trigger was executed 0 times or 0.00% of the time.

Statistics By Holding Period
 Completed2 day chg5 day chg10 day chg25 day chg40 day chg
Winners:202722243030
Losers:363035322727
Win/Loss Ratio:0.56:10.90:10.63:10.75:11.11:11.11:1
Net Change:-0.56%0.12%-0.45%-0.67%-0.08%-0.60%

Statistics By Variable: Match Price
 <14<16<18<20<22<24<26<28<30<32
Completed1:31:53:74:72:42:45:30:22:1-
2 day chg0:43:35:55:64:23:45:30:22:1-
5 day chg1:31:53:74:73:33:45:30:22:1-
10 day chg0:42:44:55:64:24:33:51:11:2-
25 day chg1:31:57:35:65:15:25:30:21:2-
40 day chg1:32:46:43:86:04:36:20:22:1-

Statistics By Variable: Average Volume
 <4.0M<8.0M<12.0M<16.0M<20.0M<24.0M<28.0M<32.0M<36.0M<40.0M
Completed16:321:21:1-2:0----0:1
2 day chg21:282:11:1-2:0----1:0
5 day chg18:311:21:1-2:0----0:1
10 day chg20:282:11:1-1:1----0:1
25 day chg25:242:11:1-2:0----0:1
40 day chg27:222:11:1-0:2----0:1



defau
24 posts
msg #43423
Ignore defau
5/2/2006 2:36:32 PM

I would like to know why I got a much better result.
Also, if you have a more reliable scan then I would love to see it.


__fetcheruser123
msg #43426
Ignore __fetcheruser123
5/2/2006 3:05:41 PM

I think it probably had something to do with the time frame in which you did the backtest... 4 months isn't a very reliable sample timeframe because it might not account for various market directions. (i.e.) If the market was trending up in those 4 months, it might produce tainted results. This is just my 2 cents, though. I also had a couple scans that backtested well over a 4 month period but then did poorly when tested over 2 years (which was my reason for purchasing the "advanced" membership here at SF).

A more reliable scan would be the Muddy Combined -- RSI(2) < 1. It's available in the Public Filters portion of SF and I just recently posted the results of a 2 year backtest.


heyen
124 posts
msg #43427
Ignore heyen
modified
5/2/2006 3:08:22 PM

How representative are 19 stocks in just 81 days (=4 months)?
This might be just a trend.

When TA fails - the trend has change!


Argh! Cross post!


Ray1
20 posts
msg #43433
Ignore Ray1
modified
5/2/2006 5:26:21 PM

chrismnu2003, your right about having to use a longer bracketing time frame. I can only backtest four months at a time. I normally change my date per quarter in order to test a filter over a year time. I tested this filter had and had some good results trading with it. Seeing you can test a 2 year time frame can you run it for me to see how it did? Im more interreated in ROI, Win-Lost etc.

Fetcher[show stocks where the Bollinger width(20) is between 0 and 0.15 and draw Bollinger(20)
and Volume above 50000
and Volume above Average Volume(20)
and close above open
and close 1 day ago was below the open 1 day ago
and MA(50) increasing for the last 4 Months
and Close between 1 and 10
and +DI(14) crossed above -DI(14) within the last 1 day
]



Triggers are:
Stop Loss: 8%
Profit Stop: 50%
Trailing Stop Loss: N/A
Minimum Holding Days: N/A
Maximum holding days: 45
Exit Trigger #1: rsi(8) crossed over 70 or rsi(2) crossed below 20

Just REMEMBER basktesting is to give you and ideal on how that filter worked during a giving time frame.
Good luck to yah!





__fetcheruser123
msg #43434
Ignore __fetcheruser123
5/2/2006 5:57:59 PM

Not too shabby...

Stop Loss: 8%
Profit Stop: 50%
Trailing Stop Loss: N/A
Minimum Holding Days: N/A
Maximum holding days: 45
Exit Trigger #1: rsi(8) crossed over 70 or rsi(2) crossed below 20

Approach Information
Approach Name: show stocks where the Bollinger width(20) is betwe...
Test started on 12/31/2003 ended on 12/30/2005, covering 504 days
Filter used:
show stocks where the Bollinger width(20) is between 0 and 0.15 and draw Bollinger(20)
and Volume above 50000
and Volume above Average Volume(20)
and close above open
and close 1 day ago was below the open 1 day ago
and MA(50) increasing for the last 4 Months
and Close between 1 and 10
and +DI(14) crossed above -DI(14) within the last 1 day

Trade Statistics
There were 31 total stocks entered. Of those, 26 or 83.87% were complete and 5 or 16.13% were open.
Of the 26 completed trades, 9 trades or 34.62%resulted in a net gain.
Your average net change for completed trades was: 2.88%.
The average draw down of your approach was: -6.43%.
The average max profit of your approach was: 15.38%
The Reward/Risk ratio for this approach is: 1.71
Annualized Return on Investment (ROI): 32.31%, the ROI of ^SPX was: 6.12%.

Exit Statistics
Stop Loss was triggered 11 times or 42.31% of the time.
Stop Profit was triggered 2 times or 7.69% of the time.
Trailing Stop Loss was triggered 0 times or 0.00% of the time.
You held for the maximum period of time (45 days) 6 times or 23.08% of the time.
An exit trigger was executed 7 times or 26.92% of the time.

Statistics By Holding Period
 Completed2 day chg5 day chg10 day chg25 day chg40 day chg
Winners:91919211619
Losers:16111291512
Win/Loss Ratio:0.56:11.73:11.58:12.33:11.07:11.58:1
Net Change:2.88%2.63%5.05%6.34%3.34%10.54%

Statistics By Variable: Match Price
 <2<3<4<5<6<7<8<9<10<11
Completed1:01:11:1-0:10:52:51:33:0-
2 day chg2:02:01:1-1:13:43:33:24:0-
5 day chg2:01:11:1-1:13:45:24:12:2-
10 day chg1:01:12:0-1:15:25:24:12:2-
25 day chg1:11:11:1-1:13:43:42:34:0-
40 day chg1:12:01:1-0:24:35:22:34:0-

Statistics By Variable: Average Volume
 <200000<400000<600000<800000<1000000<1.2M<1.4M<1.6M<1.8M<2.0M
Completed6:92:30:2--0:1--1:1-
2 day chg11:62:43:1--1:01:0-1:0-
5 day chg9:85:12:2--0:11:0-2:0-
10 day chg11:53:33:1--1:01:0-2:0-
25 day chg9:82:43:1--0:11:0-1:1-
40 day chg10:73:33:1--1:01:0-1:1-



StockFetcher Forums · Filter Exchange · New filter from forum chatter<< 1 2 3 >>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