StockFetcher Forums · General Discussion · Avg high > open % on only up and down weeks<< 1 2 3 >>Post Follow-up
15minofPham
170 posts
msg #160300
Ignore 15minofPham
4/20/2023 2:19:03 PM

Thank you so much again Ed!

TheRumpledOne
6,411 posts
msg #160340
Ignore TheRumpledOne
5/29/2023 8:50:54 PM

Some of that code looks familiar. Good job!

15minofPham
170 posts
msg #160728
Ignore 15minofPham
12/16/2023 3:57:20 AM

Hi Ed,
I'll need your help again. Could you please see why the filter is returning 0 on these two columns?

add column var222 {12 wk mov avg up low % below open} draw var222
add column var333 {12 wk mov avg down low % abv open}draw var333

Thanks again!

15minofPham
170 posts
msg #160883
Ignore 15minofPham
2/18/2024 12:54:50 AM

It looks like Ed has given up the ghost on SF. Can anyone else help me on why I'm getting 0 results in a few columns?

Fetcher[
optionable
price above 10
average volume(30) above 1000000

set{wclop, weekly close - weekly close 1 week ago}
set{Long_Profit, wclop/ weekly close 1 week ago}
set{wkprofitpct, 100 * Long_Profit}

set{diff, weekly close - weekly low}
set{range, weekly high - weekly low}
set{pos, diff/range}
set{wkpos, pos *100}

set{var2, count(wclop < 0, 1)}
set{var3, count(wclop greater than 0, 1)}

set{var22, count(var2 < 0, 52)}
set{var33, count(var3 < 0, 52)}

set{a1, weekly low-weekly open}
set{m1, a1/weekly open}
set{lowbelowopen%, m1 *100}

set{c1up, lowbelowopen% * var2}
set{c1dn, lowbelowopen% * var3}

set{smc1up, sum(c1up,52)}
set{smc1dn, sum(c1dn,52)}

set{var222, smc1up/var22}
set{var333, smc1dn/var33}

set{d1, var222-var333}
set{n1, d1/var333}
set{wklylowdiff, n1 *100}

set{e1, lowbelowopen%-var222}
set{o1, e1/var222}
set{abv52wkavg, o1 *100}

add column wkprofitpct
add column weekly rsi(14)
add column wkpos
add column weekly average day range(12)
add column weekly RSquared(close, 12)
add column separator

add column abv52wkavg
add column lowbelowopen%
add column weekly open{wk_open}
add column weekly low{wk_low}
add column separator

add column wklylowdiff
add column var222 {52 wk mov avg up low % below open} draw var222
add column var333 {52 wk mov avg down low % below open}draw var333
add column separator

add column count(lowbelowopen% below -3%, 52){wkly3%/52}
add column count(lowbelowopen% below -5%, 52){wkly5%/52}
add column count(lowbelowopen% below -10%, 52){wkly10%/52}
add column separator

add column var22{up/52}
add column var33{down/52}
add column separator

average day range(63) above 1
sort column 16 descending
chart-display is weekly
]



nibor100
1,042 posts
msg #160884
Ignore nibor100
2/19/2024 8:53:28 AM

I’m not gone, just missed your post, I’ll look into it today.
Ed S


15minofPham
170 posts
msg #160885
Ignore 15minofPham
2/19/2024 1:11:52 PM

Awesome! Thanks Ed!

nibor100
1,042 posts
msg #160888
Ignore nibor100
2/20/2024 11:47:03 AM

Below are my changes to make the up weeks and down weeks segments work properly and show up in columns.

However these changes reverse some numbers in 4 other columns, and I'm not sure what those columns are really supposed to indicate to you since its been so long since I first worked on this filter.

Let me know if anything is still wrong,
Ed S.

Fetcher[
symlist(svxy)
optionable
price above 10
average volume(30) above 1000000

set{wclop, weekly close - weekly close 1 week ago}
set{Long_Profit, wclop/ weekly close 1 week ago}
set{wkprofitpct, 100 * Long_Profit}

set{diff, weekly close - weekly low}
set{range, weekly high - weekly low}
set{pos, diff/range}
set{wkpos, pos *100}

set{var2, count(weekly wclop > 0, 1)} add column var2{up wk} draw var2
set{var3, count(weekly wclop less than or equal to 0, 1)} add column var3 {down wk}

/*set{var2, count(wclop < 0, 1)}
set{var3, count(wclop greater than 0, 1)}*/

set{var22, count(var2 > 0, 52)}
set{var33, count(var3 > 0, 52)}

set{a1, weekly low-weekly open}
set{m1, a1/weekly open}
set{lowbelowopen%, m1 *100}

set{c1up, lowbelowopen% * var2}
set{c1dn, lowbelowopen% * var3}

set{smc1up, sum(c1up,52)}
set{smc1dn, sum(c1dn,52)}

set{var222, smc1up/var22}
set{var333, smc1dn/var33}

set{d1, var222-var333}
set{n1, d1/var333}
set{wklylowdiff, n1 *100}

set{e1, lowbelowopen%-var222}
set{o1, e1/var222}
set{abv52wkavg, o1 *100}

add column wkprofitpct
add column weekly rsi(14)
add column wkpos
add column weekly average day range(12)
add column weekly RSquared(close, 12)
add column separator

add column abv52wkavg
add column lowbelowopen%
add column weekly open{wk_open}
add column weekly low{wk_low}
add column separator

add column wklylowdiff
add column var222 {52 wk mov avg up low % below open} draw var222
add column var333 {52 wk mov avg down low % below open}draw var333
add column separator

add column count(lowbelowopen% below -3%, 52){wkly3%/52}
add column count(lowbelowopen% below -5%, 52){wkly5%/52}
add column count(lowbelowopen% below -10%, 52){wkly10%/52}
add column separator

add column var22{up/52}
add column var33{down/52}
add column separator

average day range(63) above 1
sort column 16 descending
chart-display is weekly
]



15minofPham
170 posts
msg #160894
Ignore 15minofPham
2/21/2024 9:52:53 AM

It seems to be working. I'll play around with it and let you know. Thank you so much for your help again Ed!

StockFetcher Forums · General Discussion · Avg high > open % on only up and down weeks<< 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 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.