StockFetcher Forums · View by Author: (835 messages)  [ Display By: Date / Subject ]<< 1 ... 2 3 4 5 6 ... 84 >> 
Filter Exchange · TRO'S CROCK POT 2.0
msg #157785
10/6/2021 12:02:05 PM

@Cheese and any others following Redversa721's live weekly tests of TROs Crock Pot 2.0,

1. It dawned on me that due to the nature of how SF builds weekly bars during the week, that we can run Tro Crock pot 2.0 on each day of the week and see how the stocks, that filter found on the prior Friday close, are doing each day on either a cumulative basis or day by day.

2. To make the process a little more exact the following steps need to be taken on Friday after the close or anytime before the Open on Monday:

a. Create a blank watchlist, I named mine RedOct2
b. Run Tro Crock Pot 2.0 with the sort on column 5 descending
c. Check the boxes to the left of each stock listed from 1 to 20 then add them to your watchlist which should load up the watchlist with the 20 stocks Redversa721 will buy at the Open on Monday
d. Refresh your SF window so the Watchlist changes are updated system wide

3. After the Open on Monday do the following:

a. Make sure your filter results show up in Table mode with watchlist columns turned on
b. Run the modified TRO Crock Pot 2.0 filter, further below, and cycle thru the different days of the week to see the different results

4. Items that may be of interest to you when you run the filter for each day of the week

a. how many stocks achieved their 2% and 1% gains as of that day
b. the actual SF weekly bar Open, Close, High, and Low values thru that day( which is handy as no matter which day of the week you run the filter the charts are going to show the SF weekly bar thru the latest day of the week the market has been open)
c. how many stocks so far have failed to achieve 1% and/or 2% gains
d. And what I believe is a more interesting piece of info, is the results each day in the sort column 5, the weekly gain to date from Open to High, Perhaps a higher target than 2% should be used for taking profits based on the few weeks I've looked at.....

5. My changes to the filter were to add the Apply to Watchlist term for the putting in your watchlist of the 20 stocks, Commenting out all of the lines in the filter that filter the results as they sometimes reduce the results to less than 20, and I added in a weekly profit Open to weekly Close for studying results after the end of the week.

6. Being curious, I also create a Friday watchlist that has all of the Friday results in it and run the modified filter with that watchlist name in the Apply to Watchlist term so I can see how the rest of the stocks not in the top 20 also fare during the week as its easy to sort by the 20 stock watchlist column to see those stocks at the top on any given day.

Note, if you look at the filter results in the Forum view, the column 5 sort will be 1 column off, so you need to run the filter in its own window to get the right sort effect.

Ed S.

/* TRO STAT SCAN for SWING TRADERS - use only on Saturday and Sunday
apply to watchlist(redoct2)

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

set{onepct, count(Long_Profit > .01 , 52)}
set{twopct, count(Long_Profit > .02 , 52)}
set{triggered, count(Long_Profit > .02 , 1)}


set{onepcttriggered, count(Long_Profit > .01 , 1)}
set{twopcttriggered, count(Long_Profit > .02 , 1)}

add column wkProfitPct
add column onepct {hit 1% target over last 52 weeks}
add column twopct {hit 2% target over last 52 weeks}

and add column separator
add column onepcttriggered {hit 1% target this week}
add column twopcttriggered {hit 2% target this week}
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}
set{wclop, weekly close - weekly open}
and add column wclop{wk prft wkop to wkclose}

/*close is above 5*/
/*average volume(90) above 500000*/

/* sort column 7 descending
Original TRO Cookpot

sort column 5 descending
chart-display is weekly

Stock Picks and Trading · $PROG / $USWS
msg #157713
9/30/2021 12:07:02 PM


1. The first part of your post refers to more than 1 week back and the end of your post seems to only want filters that find those 2 stocks in the past week.

Is that irrespective of whether or not the filter itself was posted in the past weeK?

Not knowing for sure, I did a couple of filter tests and got those 2 stocks on each that I tested.

2. The first was posted on 9/17 by Xarlor and returns those 2 stocks on 9/24 and is

set{x1,close - low}
set{x2,high - low}
x3 <= 0.25

add column x3

3. The 2nd is one I wrote per a new users question, on 9/22 and finds those 2 stocks on 9/20 and is

open is less than low 1 day ago
add column open add column low 1 day ago

I added the line
apply to symlist (prog,usws)

to both filters before I tested them to limit results.

Ed S.

General Discussion · "within time" not working...
msg #157710
9/30/2021 10:53:11 AM


The following should work for you:

MyMFL crossed below -1 within the last 2 weeks

My guess is by replacing "is" with "crossed" SF understands it to be more of a temporary occurrence as opposed to a more permanent status.

Which probably explains why when you went back to the actual day without the "within" it returns a result for that date....but this is only a guess on my part as nuances of SFs language and syntax processing occasionally create quite the mystery.

Hope this helps,
Ed S.

Filter Exchange · Weekly Inside Candle
msg #157701
9/29/2021 11:39:38 AM

I've never found the "historical" to be consistently accurate, unfortunately,

Ed S.

General Discussion · How to code 5 day low?
msg #157691
9/27/2021 1:28:27 PM


I prefer the following, where I put "1 day ago" nearest the variable that I want SF to look at "1 day ago" as sometimes compound phrases in SF return anomalous results:

show stocks where low 1 day ago reached a new 5-day low

but in this case, it appears either position is fine as your line and my line return identical results.

Ed S.

General Discussion · How to code Closing Range
msg #157640
9/23/2021 9:26:54 AM


1. Looks like you have found a SF error in that Example you posted as I agree it should state "close" instead of "open".

Hopefully SF support will see your post and correct that example....

2. I suspect you'll find when you use the corrected statement as your filter and compare the results to Xarlor's suggested filter, that Xarlor's filter will return many more stocks than the corrected statement filter.

My initial investigation into that difference in results seems to indicate that SF is doing some kind of rounding on some of the calculations.....but who knows for sure

Hope this helps some,
Ed S.

General Discussion · Need help with filter
msg #157628
9/22/2021 9:57:50 AM

This might be what you want:

open is less than low 1 day ago
add column open add column low 1 day ago

There are several sample filters under the Examples header on the SF webpage that could have given you some starting points.

Also at the bottom of the SF webpage is the SF manual/ Usage guide

Ed S.

Filter Exchange · TRO'S CROCK POT 2.0
msg #157601
9/20/2021 11:27:08 AM


A few questions if you don't mind.

1.. For week1 of your testing you indicated you had invested about $5K

a. Are you investing nearly the same amount in each position in a given week?
b. Are you increasing the total amount you have to invest with the gains you've accrued?
c. Is the total amount available for a given week's trades reduced due to the positions you held over?

2. For the 2 positions you held over from week 1, how did they turn out?

3. Did you run a Week 3 of tests last week?

Ed S.

General Discussion · Filter not working
msg #157583
9/14/2021 12:07:29 PM

I believe you guys have run into one of SF’s occasional anomalies between math symbols and English text.

If you change this line

show stocks where rsi71 = 0

To this

show stocks where rsi71 equals 0

I believe it will work as expected

Ed S.

Filter Exchange · Need help to write filter
msg #157574
9/13/2021 1:59:17 PM

For those who like 1 line solutions that don't use Set statements, I offer several:
Ed S.

add column low 10-day high {Highest Low past 10 days}

the next 1 liner adds the price line drawing at 10 day highest Low

add column low 10-day high {Highest Low past 10 days} draw price line at low 10 day high

the next 1 liner adds filtering for only lows greater than $100, note SF overrides my column header label

add column low 10-day high is greater than 100 {Highest Low past 10 days}

my final 1 liner adds filtering for those 10 day highest Lows that occurred today

add column low 10-day high is equal to low

StockFetcher Forums ·  · << 1 ... 2 3 4 5 6 ... 84 >>

*** Disclaimer *** 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. does not recommend particular securities., 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 2021 - 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.