StockFetcher Forums · Filter Exchange · filter out long upper shadow candlestick<< >>Post Follow-up
monte399
1 posts
msg #157238
Ignore monte399
7/17/2021 11:16:11 AM

I am looking for a simple filtering phrase that can eliminate all the candles with very long Upper Wick/Shadow.

I tried to get (Upper Shadow is shorter than the candle body) using the following phrases, but failed:

(weekly high - weekly close) is below (weekly close - weekly open)

weekly high minus weekly close is below weekly close minus weekly open

can anyone help me?

Thanks

wantonellis
161 posts
msg #157239
Ignore wantonellis
modified
7/17/2021 11:39:10 AM

This should work for you. Just set tail_top_true equal 0 to exclude the big top tails. It's currently set to 1 so you can see what they look like.

Fetcher[
/* compute the range */
set{range, high minus low}
add column range

/* compute the tail top */
set{tail_top, high minus max(close,open)}
add column tail_top

/* compute the tail top percent */
set{tail_top_pct_raw, tail_top / range}
set{tail_top_pct, tail_top_pct_raw * 100}
add column tail_top_pct
set{tail_top_count, count(tail_top_pct > 70.00, 1)} /* set tail_top_pct to desired value */
set{tail_top_true, count(tail_top_count > 0,1)} /* count the number of times over the last x days. currently set to 1 day */

/* Include or exclude */
tail_top_true equal 1 /* set to 1 to include - 0 to exclude */
]



StockFetcher Forums · Filter Exchange · filter out long upper shadow candlestick<< >>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.