StockFetcher Forums · Filter Exchange · Calling all FILTER Geniuses! **GAP FINDER**<< 1 2 3 4 >>Post Follow-up
karennma
8,056 posts
msg #155631
Ignore karennma
modified
2/8/2021 10:09:45 AM

I don't know if this poster (Marco of Sicily) is still here, but I am going to give him credit ...
https://www.stockfetcher.com/forums/Filter-Exchange/Gap-Investigator/152027/30

Fetcher[

and stock is an ETF
add column separator
add column average day range(20)


and average volume(100) is above 100000
add column separator
set{Xgapped, open - close 1 day ago}
set{Xgapup, count(Xgapped > 0, 1)}
set{Xgapdn, count(Xgapped < 0, 1)}

set{absgap, abs(Xgapped)}

set{gappedup100, count(Xgapup > 0, 100)}
set{gappeddn100, count(Xgapdn > 0, 100)}

set{cl1lo, close 1 day ago - low}
set{hicl1, high - close 1 day ago }

set{fillup, count(cl1lo > 0, 1)}
set{filldn, count(hicl1 > 0, 1)}

set{gapupfilled, Xgapup * fillup }
set{gapdnfilled, Xgapdn * filldn }

set{gapup100f, count(gapupfilled > 0, 100)}
set{gapdn100f, count(gapdnfilled > 0, 100)}

set{gapfilled, gapup100f + gapdn100f}
set{dollargap, open - close 1 day ago}
add column close 1 day ago { Prior close}

add column separator
add column open
add column separator
add column high
add column separator
add column low
add column separator


set{CCb,days(open is above close 1 day ago,100)}
set{CCa,days(open is below close 1 day ago,100)}
set{CxC, CCa - CCb}
and add column CxC {gap Up/Down}
add column separator
add column dollargap {today's gap $}
add column separator
add column gap { today's gap %}
add column separator

set{GGb,days(close is above close 1 day ago,100)}
set{GGa,days(close is below close 1 day ago,100)}
set{GxG, GGa - GGb}
add column separator
and add column GxG {close Up/Down}
add column separator
add column count(close is above close 1 day ago, 100) { close UP-100days}

add column separator
set{upper, gapup100f / gappedup100 }
set{ding, gapdn100f / gappeddn100 }
and add column gappedup100{Gap up}
add column separator
and add column gapup100f{Up Filled}
add column separator
add column upper { gap up filled %}
add column separator
and add column gappeddn100{gap down}
add column separator
and add column gapdn100f{down filled}
add column separator
add column ding { gap down filled %}

add column separator
and add column absgap 100 day high{largest gap}
add column separator

]



Here's my question ....
This is TMI for me.
Is there any way, to change this filter so that it shows me gaps on a chart in the last 6-12 months by drawing a line thru that area?
EDIT:
Clarification:
I don't need all those columns in the filter results.
I just need to see the line(s) where the gaps are on the chart.
TIA!
Oh! One exception ...
A column with the location of the gaps would be great.


Cheese
1,374 posts
msg #155634
Ignore Cheese
modified
2/8/2021 12:16:54 PM

karen,
something to get you started until better coding comes along


Fetcher[
SYMLIST(SSO,SDS,TQQQ,SQQQ)
DRAW CLOSE-TO-OPEN GAP
ADD COLUMN CLOSE-TO-OPEN GAP

DRAW PRICE LINE AT close 1 day ago
DRAW PRICE LINE AT open
]



SAFeTRADE
592 posts
msg #155639
Ignore SAFeTRADE
2/8/2021 4:42:01 PM

From the code that looks like a TRO(therumpledone) filter. Credit should probably go to him.

Safetrade

karennma
8,056 posts
msg #155646
Ignore karennma
2/8/2021 7:59:26 PM

I posted the link. It said Marco Polo.
Honestly, I'm grateful to whoever wrote it.
My point was, it was NOT me. LOL!
I didn't want anyone mistaking me for a "genius", 'cuz I certainly didn't deserve the credit.
Anyway --- back to my original question ...

ANYONE know how to draw lines where the gaps are on a one-year chart.
(Less all the extra columns)
TIA!

Cheese
1,374 posts
msg #155647
Ignore Cheese
2/8/2021 8:50:15 PM

Fetcher[

ETF
AVERAGE VOLUME(30) > 10000000
chart-time 24 months

DRAW CLOSE-TO-OPEN GAP
ADD COLUMN CLOSE-TO-OPEN GAP

DRAW PRICE LINE AT close 1 day ago
DRAW PRICE LINE AT open

days offset 252

]



karennma
8,056 posts
msg #155654
Ignore karennma
2/9/2021 8:02:12 AM

@ Cheese,
You know what?
I realized when I read this:
"DRAW PRICE LINE AT close 1 day ago
DRAW PRICE LINE AT open"
I don't think SF can do what I'm looking for.

I was looking for ANY gaps that occurred in the last 6 months to a year.
Thanks, tho'.
I appreciate your effort.




Cheese
1,374 posts
msg #155656
Ignore Cheese
2/9/2021 10:04:33 AM

karen,

So, you didn't get what you were looking for in the convenient way that you'd expect
What I gave you is tools and materials, piecemeal style. You can build a sundeck or whatever.

Did you pay attention to "days offset 252"?
Do you believe that many unfilled gaps wil be filled eventually ?
Did you see that there is a year old "unfilled gap down" for XLE around $53
where the horizontal line was drawn?
Did you notice XLE on the way back up?
XLE will likely recover with global vaccination success and global economic recovery.

Green energies (solar, wind, battery, electric) still have a way to go for
many industries in America and many parts of the world. They are still too expensive.

Just my two cents

Fetcher[
SYMLIST(XLE)
AVERAGE VOLUME(30) > 10000000
chart-size huge
chart-time 16 months

DRAW CLOSE-TO-OPEN GAP
ADD COLUMN CLOSE-TO-OPEN GAP

DRAW PRICE LINE AT close 1 day ago
DRAW PRICE LINE AT open

days offset 252
]



karennma
8,056 posts
msg #155658
Ignore karennma
2/9/2021 12:26:24 PM

Thanks a bunch, Cheese.
When I have a chance, I'll revisit it.
Appreciate your efforts ...


nibor100
937 posts
msg #155662
Ignore nibor100
2/9/2021 2:15:49 PM

@ karennma,

The filter below does some of what you are asking for on using a limited gap criteria to reduce both the number of gaps and the number of stocks, covering the past year of data.

Do you have a small group of stocks you want the 6-12 months of gap info for?

Thanks,
Ed S.

Fetcher[
open 1 day ago > 1

set{var1, count(close-to-open gap 1 day ago is above 40,1)} add column var1 {if 0 no gap yesterday }
set{var10, var1 * close-to-open gap 1 day ago } /*add column var10*/ draw var10
set{var5, count(var1 > 0 ,252)} add column var5 {total hits }

var20 above 0
and sort column 6 descending


chart-time is 252 days
]



karennma
8,056 posts
msg #155668
Ignore karennma
modified
2/9/2021 6:56:14 PM

@nibor,
Okay, let's take BYND as an example.
Look at a candlestick chart of BYND with NO indicators.
There are 3 huge gaps.
So, this phantom filter which is a figment of my imagination, would mark those 3 gaps.

EDIT:
The filter would say something like:
Draw line where open is 5% greater than close the day before.
Draw line at yesterdays close.
Draw line at next day's open.
(those 2 lines would show the gap.)
chart-time 1 year


StockFetcher Forums · Filter Exchange · Calling all FILTER Geniuses! **GAP FINDER**<< 1 2 3 4 >>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.