Print Page  
FORMULA FUNCTIONS / CROSS SECTIONAL
FSum("formula" [,scope])
Full Description

Calculates the sum value of the formula within each scope.

Parameters

formula: any valid stock formula
scope: determines how stocks are grouped before median is calculated (see below)


Scope Parameter


Values Stocks ETFs Description
#AllYYOperates on current universe
#Previous1YYOperates on the results from previous rule
#GroupVar2YYOperates on groups based on value of variable @Group
--------------------------- For Stocks Only ---------------------------
#SP500YOperates within the SP500 universe
#SectorYOperates within each Sector of current universe
#SubSectorYOperates within each SubSector of current universe
#IndustryYOperates within each Industry of current universe
#SubIndustryYOperates within each SubIndustry of current universe
--------------------------- For ETFs Only ------------------------------
#FamilyYOperates within each ETF Family
#AssetClassYOperates within each ETF Class
#RegionYOperates within each ETF Region
#CountryYOperates within each ETF Country
#MethodYOperates within each ETF Method
#StyleYOperates within each ETF Style
#SizeYOperates within each ETF Size
#ETFSectorYOperates within each ETF Sector
1Available only in the Screener and Custom Universe
2Not available in Ranking Systems