nibor100 1,052 posts msg #161451 - Ignore nibor100 |
12/3/2024 12:33:05 PM
Here is my work in progress filter to give you what I think you want
.
The column "varlo3" should give you the lowest low in the past 12 days since the latest/highest High 21 day new high.. ( not in every case yet, but I have some other things to try)
Basically I'm taking consecutive 2 day Low Minimums, storing them in a variable, and then progressing thru 2 day minimums of each succeeding variable.
Let me know if this is kind of what you are after.
Thanks,
Ed S.
|
rafting101 12 posts msg #161491 - Ignore rafting101 |
12/18/2024 11:06:40 AM
@nibor100
sorry that I didn't see your message earlier... I didn't realize that there is a new message on "page 2"....
Anyway, thank you for trying, but I don't understand what you are trying to achieve here.
The lines with "varlo", are just lowest low of some value.
for example, if you add to your example:
set{ll5, low 5 days low} add column ll5 draw ll5 /*on plot price*/
you will be able to see that it always has the same value as varlo3
so Its not the algorithm that I'm looking for.
|
nibor100 1,052 posts msg #161517 - Ignore nibor100 |
12/27/2024 11:28:56 AM
I ran into complexity issues, so I coded something that might be a little better than whatever your current method for tracking down "the lowest value of the last X days".
The way this filter works is it finds the 21 day high and shows its value in a column.
The next column (DaySincHi) shows how many days have occurred since the latest 21 day High( I only used a 12 day lookback period for this version)
Using the value from that column find the column to the right with the same #, and that value is the lowest Low since the latest High
The DLO column to the right of that column shows how many days since that lowest Low.
When there is a -1 in the DaySincHi column that means the 12 day lookback period I used was not long enough to find the most recent 21 day high.
Hope this helps some,
Ed S.
|
rafting101 12 posts msg #161538 - Ignore rafting101 |
1/15/2025 3:16:46 PM
nibor100, thanks.
your solution works, but adds calculations and columns in the final display.
I guess its not possible to do it dynamically in stockfetcher.
|
nibor100 1,052 posts msg #161539 - Ignore nibor100 |
1/16/2025 11:57:10 AM
Not that I can figure out.
Perhaps their help desk can figure out a way; as they actually gave me a good solution to a problem a few weeks ago. Maybe there is a new help guy.
Ed S.
|
SAFeTRADE 647 posts msg #161540 - Ignore SAFeTRADE |
1/16/2025 2:58:22 PM
You could try working with this. Edit to what suits you. It's a different look at what you are
trying to accomplish.
|