StockFetcher Forums · General Discussion · Avg high > open % on only up and down weeks<< 1 2 3 >>Post Follow-up
nibor100
1,019 posts
msg #160123
Ignore nibor100
2/22/2023 11:11:27 AM

I just ran it again for 2/17 and my last 4 column for TESLA are 88.12, 1.81, 12.59, 0.60 so 3 are the same and one is different by 2 cents.
Ed S.

15minofPham
168 posts
msg #160124
Ignore 15minofPham
2/22/2023 12:03:33 PM

I realized where I messed up was that I ran the filter on yesterday's date instead of Friday's. Awesome job and thank you so much again for your help Ed!

15minofPham
168 posts
msg #160175
Ignore 15minofPham
3/23/2023 1:20:27 AM

Hi Ed,
Is there a way to have a column show how many times over the past 52 weeks the highabvopen% is greater than the 52 wk mov avg up high % abv open?

Thank again!

nibor100
1,019 posts
msg #160177
Ignore nibor100
3/24/2023 9:57:07 AM

I'm not sure what you mean by this phrase at the end of your question:

up high % abv open

Is it a variable or label in your personal filter or does it have a typo....

Please clarify,
Thanks,
Ed S.

15minofPham
168 posts
msg #160178
Ignore 15minofPham
3/24/2023 10:17:47 AM

Let's take TSLA for example. Going into this week, its 52-week avg high above the open during a green week is 11.20. This week's high above the open is 12.68 so it beat the 52-week avg. I was wondering if there's a way to do a count of the number of times this has happened over the past 52 weeks.

nibor100
1,019 posts
msg #160224
Ignore nibor100
3/31/2023 2:32:21 PM

Sorry about taking so long to get back to you... but below is my attempt to add a column for what you want.

I've only coded it to do a 1 week comparison so you can check and see if I'm comparing the right things before I code it to total for 52 weeks.

Let me know,
Ed S.

Fetcher[
chart-display is weekly close > 20

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

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{var22, count(var2 > 0, 52)} add column var22{up wks out of 52}
set{var33, count(var3 > 0, 52)} add column var33{down wks out of 52}

set{c1, weekly high-weekly open}
set{t1, c1/weekly open}
set{highabvopen%, t1 *100}

set{c1up, highabvopen% * var2} add column c1up{up wk profit} draw c1up
set{c1dn, highabvopen% * var3} add column c1dn{down wk profit} draw c1dn

set{smc1up, sum(c1up,52)} add column smc1up{up wks profit total 52wks} draw smc1up
set{smc1dn, sum(c1dn,52)} add column smc1dn{down wks profit total 52wks} draw smc1dn

set{var222, smc1up/var22 } add column var222{52 wk mov avg up wks profit} draw var222
set{var333, smc1dn/var33 } add column var333 {52 wk mov avg down wks profit}draw var333

set{var2000, count(c1up > var222 1 week ago, 1) } add column var2000{hi over 52 wk avg up wks profit} draw var2000
]



15minofPham
168 posts
msg #160275
Ignore 15minofPham
4/10/2023 11:48:36 AM

Thank you so much again Ed! I had to strip it down in order for it to work due to the "Stock filter is too advanced" note. I didn't want to upgrade just for one filter.

15minofPham
168 posts
msg #160287
Ignore 15minofPham
4/17/2023 10:53:22 AM

Hi Ed,
I thought I reversed everything correctly for a low screen, but apparently, I didn't. Could you please take a look at this when you have time.

Thanks again!

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)}
set{var3, count(weekly wclop greater than or equal to 0, 1)}

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

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

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

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

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{abv12wkavg, 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 abv12wkavg
add column lowbelowopen%
add column weekly low{wk_high}
add column weekly open{wk_open}
add column separator

add column wklyhighdiff
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
add column separator

add column count(lowbelowopen% above 3%, 12){wkly3%/12}
add column count(lowbelowopen% above 5%, 12){wkly5%/12}
add column count(lowopen% above 10%, 12){wkly10%/12}
add column separator

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

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

snappyfrog
667 posts
msg #160288
Ignore snappyfrog
4/17/2023 8:21:21 PM

Making it clickable

Fetcher[
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)}
set{var3, count(weekly wclop greater than or equal to 0, 1)}

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

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

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

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

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{abv12wkavg, 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 abv12wkavg
add column lowbelowopen%
add column weekly low{wk_high}
add column weekly open{wk_open}
add column separator

add column wklyhighdiff
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
add column separator

add column count(lowbelowopen% above 3%, 12){wkly3%/12}
add column count(lowbelowopen% above 5%, 12){wkly5%/12}
add column count(lowopen% above 10%, 12){wkly10%/12}
add column separator

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

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



nibor100
1,019 posts
msg #160293
Ignore nibor100
4/19/2023 11:07:23 AM

Here it is after my corrections, key one being divide by weekly open instead of weekly low, and with some other typos:

Ed S.

Fetcher[
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} add column weekly low
set{range, weekly high - weekly low}
set{pos, diff/range}
set{wkpos, pos *100}

set{var2, count(weekly wclop < 0, 1)}
set{var3, count(weekly wclop greater than or equal to 0, 1)}

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

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,12)}
set{smc1dn, sum(c1dn,12)}

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{abv12wkavg, 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 abv12wkavg
add column lowbelowopen%
add column weekly low{wk_high}
add column weekly open{wk_open}
add column separator

add column wklylowdiff
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
add column separator

add column count(lowbelowopen% above 3%, 12){wkly3%/12}
add column count(lowbelowopen% above 5%, 12){wkly5%/12}
add column count(lowbelowopen% above 10%, 12){wkly10%/12}
add column separator

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

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



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.