alexan 41 posts msg #126408 - Ignore alexan |
12/9/2015 1:07:31 PM
set { Tvalue , price * volume }
show stocks where average Tvalue(7) above 70000
-------------------------------------------------------------
in a similar way to using average volumes, I am trying to filter stocks which their average trade value (price x volume) for past 7 days has been above 70k
but it looks like filter doesn't understand: average Tvalue(7)
|
mahkoh 1,065 posts msg #126409 - Ignore mahkoh |
12/9/2015 2:47:23 PM
You will need to create a custom moving average of T value
|
alexan 41 posts msg #126418 - Ignore alexan |
12/11/2015 12:04:47 PM
thank you very much mahkoh
|
Kevin_in_GA 4,599 posts msg #126423 - Ignore Kevin_in_GA |
12/12/2015 7:27:43 AM
This is how I would do this:
This assures you that you get stocks where the total dollar value traded each day over the last 7 days is above your threshold. I use this rather than the average since you could get stocks with 0 shares traded for 6 out of the last 7 days and 1 day with 490,000 dollars traded in one day and that is probably not what you are looking for.
|