StockFetcher Forums · General Discussion · The Rumpled One crock pot filter<< 1 2 >>Post Follow-up
kossvet
147 posts
msg #149574
Ignore kossvet
11/11/2019 2:11:05 PM

I am trying to figure a way to rearrange TRO'S filter.
I have an idea, where you buy the close on Friday.
and sell the open on Monday,
I love all the bells and whistles of this statistical filter. absolutely awesome information.
I would like the new filter to show me statistically, the best candidates for buying at close on Friday and selling at open on Monday.
showing 1pct, 2pct, 5pct. returns just like the original filter.
also sort descending so the best is at the top.
Tro's filter is a work of art, only problem is getting filled at the open, hence the reason for buying at Fridays close.
Any help from the Gurus who peruse theses forums would be greatly appreciated.
Thanks in advance
Robert

xarlor
585 posts
msg #149575
Ignore xarlor
11/11/2019 3:14:36 PM

Hi kossvet! To make things easier, can you post the specific filter you're working off?

kossvet
147 posts
msg #149576
Ignore kossvet
11/11/2019 3:26:01 PM

/* TRO STAT SCAN for SWING TRADERS - use only on Saturday and Sunday */

set{whiop, weekly high - weekly open}
set{Long_Profit, whiop / weekly open }
set{wkProfitPct, 100 * Long_Profit }

set{C1A, count(Long_Profit > .04 , 52)}
set{C2A, count(Long_Profit > .09, 52)}
set{C0010, C1A - C2A}

set{D1A, count(Long_Profit > .09 , 52)}
set{D2A, count(Long_Profit > .19, 52)}
set{D1020, D1A - D2A}

set{E1A, count(Long_Profit > .19 , 52)}
set{E2A, count(Long_Profit > .29, 52)}
set{E2030, E1A - E2A}

set{F1A, count(Long_Profit > .29 , 52)}
set{F2A, count(Long_Profit > .39, 52)}
set{F3040, F1A - F2A}

set{G1A, count(Long_Profit > .39 , 52)}
set{G2A, count(Long_Profit > .49, 52)}
set{G4050, G1A - G2A}

set{H1A, count(Long_Profit > .49 , 52)}
set{H2A, count(Long_Profit > .99, 52)}
set{H5052, H1A - H2A}

set{I52, count(Long_Profit > .99 , 52)}
set{fivepct, count(Long_Profit > .05 , 52)}
set{ziphi, count(whiop equal 0 , 52)}
set{ziphix, count(whiop below 0.10 , 1)}
set{onepct, count(Long_Profit > .01 , 52)}
set{twopct, count(Long_Profit > .02 , 52)}
set{halfpct, count(Long_Profit > .005 , 52)}
set{qtrpct, count(Long_Profit > .0025 , 52)}

add column wkProfitPct
add column qtrpct
add column halfpct
add column onepct
add column twopct
add column fivepct

add column ziphi


and add column separator
and add column C0010 {4_9}
and add column D1020 {10_19}
and add column E2030 {20_29}
and add column F3040 {30_39}
and add column G4050 {40_49}
and add column H5052 {50_99}
and add column I52 {100}
and add column separator
and add column weekly open {wopen}
and add column weekly high {whigh}
and add column weekly low {wlow}
and add column weekly close {wclose}
and add column separator

close is above 1
average volume(90) above 500000

draw whiop
draw ziphix
sort column 9 descending

chart-display is weekly

date offset is 0

This is an excellent statistical filter. The thought content involved in creating this filter is remarkable.
If we can rearrange the filter to pursue my ideas, Ill owe you a case of beer, or your favorite adult beverage.
This filter is excellent

risjr
229 posts
msg #149592
Ignore risjr
11/14/2019 10:17:59 AM

Greetings

There over 2,000 or so picks in this

How do you limit them?

Thanks

kossvet
147 posts
msg #149597
Ignore kossvet
11/14/2019 4:42:08 PM

Risjr

If a fllter can be created where:
Fridays close is the buy price.
Mondays open is the sell.
The filter should be able to tell us, which stocks have the greatest number of gap ups over the last year.
Also, as I stated before, can we have all the bells and whistles of TRO'S filter.
Those stocks that gap 1% the most.
Those stocks that gap 2%, 3% and 5% the most.
I have been researching the stocks at the top of TRO'S filter, based on a 2% return for the week.
Getting in at the open, has been a difficult process for me. It might skewer the weekly returns slightly.
If we could have the filter run on Fridays close instead, We have a definite price point to begin.
Maybe it's not possible to rearrange this filter, I don't know.
I have tried, an been unsuccessful.
My coding skills are vastly inferior to many of the Champs that write these awesome filters.
This is why I have reached out for help.



xarlor
585 posts
msg #149657
Ignore xarlor
11/21/2019 6:30:17 PM

Okay I've started and scrapped this request several times before finally settling on this. It's a bit cumbersome, but I think it mostly gets what you need.

To start, you have to move the day back to a Friday for it to work right, From there you can jump back 1 week at a time.

The top line represents a 5% profit
The middle line is a 1% profit
The bottom line is a stop loss set 3% below your entry (the close price on Friday).

At a glance, hitting the 1% profit before a 3% loss during the week is highly probable and occurs often enough to offset the occasional 3% loser.

Trade idea: Set stop loss at 3%. At 1% profit, set a 1% trailing stop.

Notes:
  • I had to remove the weekly display.
  • I removed ETFs from the results as there were just too many that move really slow and never cleared 1% during the week.
  • I added the suggestion in the original TRO thread about only entering during an uptrend. My loose definition of an uptrend is low > wma(150).
  • I added "Gaps" which shows you how many times in the last 52 weeks the weekly open was higher than the prior week's close.

    Fetcher[
    /* TRO STAT SCAN for SWING TRADERS */
    /* Enter Friday at the close added by Xarlor */

    set{whiop, weekly high - weekly open}
    set{Long_Profit, whiop / weekly open }
    set{wkProfitPct, 100 * Long_Profit }

    set{C1A, count(Long_Profit > .04 , 52)}
    set{C2A, count(Long_Profit > .09, 52)}
    set{C0010, C1A - C2A}

    set{D1A, count(Long_Profit > .09 , 52)}
    set{D2A, count(Long_Profit > .19, 52)}
    set{D1020, D1A - D2A}

    set{E1A, count(Long_Profit > .19 , 52)}
    set{E2A, count(Long_Profit > .29, 52)}
    set{E2030, E1A - E2A}

    set{F1A, count(Long_Profit > .29 , 52)}
    set{F2A, count(Long_Profit > .39, 52)}
    set{F3040, F1A - F2A}

    set{G1A, count(Long_Profit > .39 , 52)}
    set{G2A, count(Long_Profit > .49, 52)}
    set{G4050, G1A - G2A}

    set{H1A, count(Long_Profit > .49 , 52)}
    set{H2A, count(Long_Profit > .99, 52)}
    set{H5052, H1A - H2A}

    set{I52, count(Long_Profit > .99 , 52)}
    set{fivepct, count(Long_Profit > .05 , 52)}
    set{ziphi, count(whiop equal 0 , 52)}
    set{ziphix, count(whiop below 0.10 , 1)}
    set{onepct, count(Long_Profit > .01 , 52)}
    set{twopct, count(Long_Profit > .02 , 52)}
    set{halfpct, count(Long_Profit > .005 , 52)}
    set{qtrpct, count(Long_Profit > .0025 , 52)}

    add column wkProfitPct
    add column qtrpct
    add column halfpct
    add column onepct
    add column twopct
    add column fivepct

    add column ziphi


    and add column separator
    and add column C0010 {4_9}
    and add column D1020 {10_19}
    and add column E2030 {20_29}
    and add column F3040 {30_39}
    and add column G4050 {40_49}
    and add column H5052 {50_99}
    and add column I52 {100}
    and add column separator
    and add column weekly open {wopen}
    and add column weekly high {whigh}
    and add column weekly low {wlow}
    and add column weekly close {wclose}
    and add column separator

    close is above 1
    average volume(90) above 500000

    draw whiop
    draw ziphix
    sort column 9 descending

    date offset is 0

    /* Buy at close on Friday. Sell at 1% profit the next week */

    market not etf
    low > wma(150)

    set{Enter,close}
    set{1p,Enter * 1.01}
    set{5p,Enter * 1.05}
    set{Stoploss,Enter * .97}

    draw price line at 1p
    draw price line at 5p
    draw price line at Stoploss
    add column close
    set{Gaps,count(weekly open > weekly close 1 week ago,52)}
    add column Gaps
    ]



  • kossvet
    147 posts
    msg #149667
    Ignore kossvet
    11/22/2019 4:40:32 PM

    Xarlor

    Thank you for putting in the time, and creating this filter.
    I am just starting to plow through it. You have cut down my prep time enormously.
    There are many new ideas I can glean from this filter.
    Once again a big Thank You
    Robert

    xarlor
    585 posts
    msg #149696
    Ignore xarlor
    11/27/2019 1:21:14 PM

    @kossvet With TDA doing commission-free trading I decided to jump in feet first on the strategy. I committed $1200 and took the top 4 results in the filter. I entered at the close on Friday and set a mental stop-loss at 3%. If a ticker hit 2% profit, I entered a trailing stop of 1%. Below are the results.



    Other than APPS, they all hit 2% on Monday and I enacted the trailing stop. They all stopped out the same day.

    Only APPS failed to reach 2% Monday and actually ended the day below the 3% mental stop loss. The technicals looked good though so I held. Tuesday it gained back a little but was still below my entry. Today it shot up and I entered the trailing stop.

    Week 1 worked as advertised. Let's see what Week 2 holds.



    manojb21
    16 posts
    msg #149701
    Ignore manojb21
    11/27/2019 6:41:40 PM

    Thank you @xarlor & Robert (kossvet) for starting this new thread…

    Actually, I have just completed reading TRO’s original complete thread.. and then luckily I found this thread.. just want to make sure, I am doing this right.. I have few questions..

    1) Do we need to RUN this modified filter on few mins (or half hour) before Friday market closing bell and then place the orders for first few stocks which are sorted in desc by ‘twopct’ column ? To get Friday close price
    2) On Friday before market close, after orders filled, do we need to place
    a. stop loss order @3% &
    b. take profit order @ 1%

    Robert, you are right, In original TRO’s thread.. lot of people mentioned same that they can’t get Monday open price.. your idea is superb..

    rgds
    MK

    xarlor
    585 posts
    msg #149702
    Ignore xarlor
    modified
    11/27/2019 7:54:37 PM

    @manojb21 That's what I did. Ran it about 5 minutes before close Friday and entered an orders to my broker about 30 seconds before the bell. You won't always nail the close, but should be within a few cents. If you want to get in at the exact close, you can wait until after the bell then enter a limit order and enable after-market execution. You'll usually get filled, but it's not guaranteed.

    Don't place stop loss order before market close. Do it after and make sure it is not set for after-market hours. I didn't place any stop loss orders, only alerts at 3%. If it triggered I wanted to see the technicals and judge whether it may bounce back.

    When to take profit is up to you. I made the decision to let mine run to 2% and entered a trailing stop of 1% so i was guaranteed at least a 1% profit. Note: trailing stops can backfire if there is an event and the stock drops precipitously.

    StockFetcher Forums · General Discussion · The Rumpled One crock pot filter<< 1 2 >>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 2022 - 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


    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.