StockFetcher Forums · General Discussion · using average for a user defined variable<< >>Post Follow-up
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
891 posts
msg #126409
Ignore mahkoh
12/9/2015 2:47:23 PM

You will need to create a custom moving average of T value

Fetcher[
set { Tvalue , price * volume }
set{tvavg,cma(Tvalue,7)}
tvavg above 70000
]



alexan
41 posts
msg #126418
Ignore alexan
12/11/2015 12:04:47 PM

thank you very much mahkoh



Kevin_in_GA
4,548 posts
msg #126423
Ignore Kevin_in_GA
12/12/2015 7:27:43 AM

This is how I would do this:

Fetcher[

set{liquidity, close * volume}
count(liquidity above 70000,7) above 6
]



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.

StockFetcher Forums · General Discussion · using average for a user defined variable<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus