KSK8
561 posts
msg #149541
- Ignore KSK8 |
11/6/2019 3:53:55 PM
Attempting to find stocks that have a day range (high-low) that is in between 70% - 90% of the 13-week range.
How would I calculate this?
|
xarlor
581 posts
msg #149545
- Ignore xarlor |
11/6/2019 6:50:20 PM
When you say 13-week range do you mean [13 week high - 13 week low] or the average true range for the past 13 weeks: ATR(65)? These are two very different numbers. Here I'm using ATR(65):
|
KSK8
561 posts
msg #149546
- Ignore KSK8 |
11/6/2019 7:20:29 PM
On the 26th of September, you can see how PRPO's candle body engulfs most of its recent price range over the past few months. I'm not quite sure what percent of the range it engulfs, but that's what I'm in pursuit of measuring. I hope that clarifies.
|
xarlor
581 posts
msg #149547
- Ignore xarlor |
11/6/2019 8:30:22 PM
Ah, that does help. Here you go.
|
KSK8
561 posts
msg #149548
- Ignore KSK8 |
11/6/2019 10:52:07 PM
Thank you very much xarlor!
|
KSK8
561 posts
msg #149553
- Ignore KSK8
modified |
11/8/2019 12:40:53 AM
How would I calculate it to tell me what percent of the range the current candle engulfs excluding the range the current candle already makes?
For example;
CNST on November 6 shows it took up 75% of the range yet it's current candle was responsible for the majority of that range. Ultimately I'm trying to avoid including the current day's range when factoring in how much of the previous range the current candle engulfs.
How would I do this?
|
nibor100
1,031 posts
msg #149555
- Ignore nibor100 |
11/8/2019 10:13:50 AM
@ksk8,
I made some changes to xarlor's filter to adjust for your last question as you can see further below:
However, I'm not sure these filters are giving you quite the results you are looking for in all cases.
For example, look at the below filter run 1 day ago for result stock FAGI. The large candle is completely above all of the 13 week High Low history so it doesn't really encompass 70% to 90%.
It's total range is just 76% of the 13 week high-low range mathematically.
Ed S.
|
KSK8
561 posts
msg #149556
- Ignore KSK8 |
11/8/2019 10:54:58 AM
I'm trying to have it to where the current candle's range is within 70% of the 13week range (from 1 day ago), instead of its current candle range is equivalent to 70% of the 13week range.
For example, if you look at FAGI on November 6, it's candle is not within 70% of the 13week range (1 day ago). But if you look at BEAT on the same day, it definitely looks like it's within 70% of the 13week range 1 day ago.
Does this make sense in terms of what I'm trying to calculate?
|
nibor100
1,031 posts
msg #149557
- Ignore nibor100 |
11/8/2019 11:03:57 AM
Yes that’s what I suspected u really wanted.
Thanks,
Ed S.
|
nibor100
1,031 posts
msg #149558
- Ignore nibor100 |
11/8/2019 12:14:39 PM
@ksk8,
body of candle or entire candle including wick is to be inside 70 to 90% of 13 wk hi-lo range?
When I look at BEAT on Nov 6th part of its wick is above the prior 13 wk hi so I think it doesn't qualify as a candle you want to see.
Thanks,
Ed S.
|