wallybaby
9 posts
msg #156809
- Ignore wallybaby |
5/15/2021 11:54:14 AM
Hello, I am trying to get this to work.
I am looking to create filter that will
find the midpoint of each days range for the last 5 days
and then add them together and divide by 5 to get a 5 day average of the midpoint
and then subtracting the 5 day average of the midpoint from the close of the day
and then divide that by atr(5)
and then divide that by 5 ( this results in answer step6 which presents a performance issue SOME of the time)
and then filtering step6 for results less than -.4 so that the answer can be plotted and then
I would like to put in a "count" function so that all instances of this occurring can be highlighted.
Ideally I would like to leave step6 in but it sometimes puts me over the edge on performance issues with sf so I can leave that out, unless with tighter code, it passes.
I posted below what I could do, and am stuck, and I am sure there is an easier way to find this.
thanks in advance for any help.
|