Full Description
Calculates the number of times a formula evaluates to TRUE (not 0) within each scope. FCount works like this:
- The formula in quotes is evaluated for all the stocks in each scope. The formula could be a single factor, like "MktCap" or more complex like "Close(0)/Close(10)".
- The number of stocks whose expression evaluates to TRUE (not zero) is counted for each scope
Parameters
formula: an expression that evaluates to TRUE or FALSE
scope: determines how stocks are grouped before counting (see below)
Examples:
Return only stocks in industry where at least 50% of the stocks made a new 52 week high in the past 10 trading days
FCount("HighValBar( 250, 0)<10",#Industry) > NoConst * 0.5
Scope Parameter
Values |
Stocks |
ETFs |
Description |
#All | Y | Y | Operates on current universe |
#Previous1 | Y | Y | Operates on the results from previous rule |
#GroupVar2 | Y | Y | Operates on groups based on value of variable @Group |
--------------------------- For Stocks Only --------------------------- |
#SP500 | Y | | Operates within the SP500 universe |
#Sector | Y | | Operates within each Sector of current universe |
#SubSector | Y | | Operates within each SubSector of current universe |
#Industry | Y | | Operates within each Industry of current universe |
#SubIndustry | Y | | Operates within each SubIndustry of current universe |
--------------------------- For ETFs Only ------------------------------ |
#Family | | Y | Operates within each ETF Family |
#AssetClass | | Y | Operates within each ETF Class |
#Region | | Y | Operates within each ETF Region |
#Country | | Y | Operates within each ETF Country |
#Method | | Y | Operates within each ETF Method |
#Style | | Y | Operates within each ETF Style |
#Size | | Y | Operates within each ETF Size |
#ETFSector | | Y | Operates within each ETF Sector |
1Available only in the Screener and Custom Universe
2Not available in Ranking Systems