Avg high > open % on only up and down weeks - StockFetcher.com Stock Screener

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,044 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,044 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

StockFetcher Tools
Filter Editor
My Filters
Watch Lists
Chart+
Find Similar Stocks
Shared Lists

Support
Contact Us
Support Home

Subscriber
Subscriber Benefits

Settings
Chart
Results
MyFilters

*** 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.