ETF Info

The etfInfo data type returns detailed information specific to ETFs, such as the Assets Under Management (AUM) or Net Asset Value (NAV).

=SF(ETF, "etfInfo", metric, "", options)

• ETF is the ticker symbol of the ETF (e.g., "SPY"). You can use our Symbol Search to find the correct ticker symbol.

• metric selects what metrics to display (see options below), display all metrics by leaving blank or using "all". Chain together as many metrics as you'd like using &, e.g., "asset&weightPercentage".

• options adjusts the formatting of the output. There are two available options for etfInfo, (1) "NH" for no header row and (2) "NLI" for no line items (when displaying more than one metric).

The ETF Info metric options are:

• All ("all")

• Name ("name")

• Asset Class ("assetClass")

• Assets Under Managemet (AUM) ("AUM")

• Net Asset Value (NAV) ("NAV")

• Avg. Volume ("avgVolume")

• Expense Ratio ("expenseRatio")

• Domicile ("domicile")

• ETF Company ("etfCompany")

• Inception Date ("inceptionDate")

• ISIN ("isin")

• CUSIP ("cusip")

• Holdings Count ("holdingsCount")

• Description ("description")

• Website ("website")

Examples

Example 1 - All Metrics

=SF("SPY","etfInfo")

Example 2 - Display several selected metrics

=SF("SPY","etfInfo","aum&nav&avgVolume")

Example 3 - Display a single metric

=SF("SPY","etfInfo","expenseRatio")

Example 4 - Display several metrics with no line items or header

=SF("SPY","etfInfo", "aum&nav&avgVolume", "", "NLI&NH")