tgoo426193 19 posts msg #127405 - Ignore tgoo426193 |
2/23/2016 6:38:01 PM
I've tried searching for my answer using much the same text you see in the Thread Heading, with no luck, so I'm falling back on the word of the Filter Guru's.
Here is what I'm after today. Once I see the format, I'm sure I can use it elsewhere:
I wish to find the Average, of the Lows, for 4 consecutive days, starting with the most recent day.
I want to build this filter to use it as a column on my results table.
If I'm correct, I understand that the most recent figure, at the time of this posting, is "todays", since the market closed a couple of hours ago, and I need the figures for the 3 prior days as well. I think the following should get those for me, as I have the 4 columns on my table now. Please do correct me if I'm wrong.
add column daily low
add column daily low 1 day ago
add column daily low 2 day ago
add column daily low 3 day ago
OK, from this point (be I right or wrong above), how do I format the filter to Add the 4 figures, and divide the total by 4?
I will build a similar filter/column for the High average as well, and I'm sure it will come in handy for some others in the future.
Thx in advance for any help. This Forum is always a pleasure to participate in
|
four 5,087 posts msg #127406 - Ignore four modified |
2/23/2016 7:09:46 PM
Average, of the Lows, for 4 consecutive days, starting with the most recent day.
I want to build this filter to use it as a column on my results table.
-Important- StockFetcher only allows '2 items' at a time...
|