Skip to main content

INFO

ETF Information Overview.

Syntax

=OBB.ETF.INFO(symbol)

Examples

=OBB.ETF.INFO("SPY")
=OBB.ETF.INFO("SPY,IWM,QQQ,DJIA")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. (ETF) Multiple comma separated items allowed.True

Data

NameDescription
symbolSymbol representing the entity requested in the data. (ETF)
nameName of the ETF.
descriptionDescription of the fund.
inception_dateInception date of the ETF.
fund_listing_dateThe date on which the Exchange Traded Product (ETP) or share class of the ETP is listed on a specific exchange.
data_change_dateThe last date on which there was a change in a classifications data field for this ETF.
etn_maturity_dateIf the product is an ETN, this field identifies the maturity date for the ETN.
is_listedIf true, the ETF is still listed on an exchange.
close_dateThe date on which the ETF was de-listed if it is no longer listed.
exchangeThe exchange Market Identifier Code (MIC).
isinInternational Securities Identification Number (ISIN).
ricReuters Instrument Code (RIC).
sedolStock Exchange Daily Official List (SEDOL).
figi_symbolFinancial Instrument Global Identifier (FIGI) symbol.
share_class_figiFinancial Instrument Global Identifier (FIGI).
firstbridge_idThe FirstBridge unique identifier for the Exchange Traded Fund (ETF).
firstbridge_parent_idThe FirstBridge unique identifier for the parent Exchange Traded Fund (ETF), if applicable.
intrinio_idIntrinio unique identifier for the security.
intraday_nav_symbolIntraday Net Asset Value (NAV) symbol.
primary_symbolThe primary ticker field is used for Exchange Traded Products (ETPs) that have multiple listings and share classes. If an ETP has multiple listings or share classes, the same primary ticker is assigned to all the listings and share classes.
etp_structure_typeClassifies Exchange Traded Products (ETPs) into very broad categories based on its legal structure.
legal_structureLegal structure of the fund.
issuerIssuer of the ETF.
etn_issuing_bankIf the product is an Exchange Traded Note (ETN), this field identifies the issuing bank.
fund_familyThis field identifies the fund family to which the ETF belongs, as categorized by the ETF Sponsor.
investment_styleInvestment style of the ETF.
derivatives_basedThis field is populated if the ETF holds either listed or over-the-counter derivatives in its portfolio.
income_categoryIdentifies if an Exchange Traded Fund (ETF) falls into a category that is specifically designed to provide a high yield or income
asset_classCaptures the underlying nature of the securities in the Exchanged Traded Product (ETP).
other_asset_typesIf 'asset_class' field is classified as 'Other Asset Types' this field captures the specific category of the underlying assets.
single_category_designationThis categorization is created for those users who want every ETF to be 'forced' into a single bucket, so that the assets for all categories will always sum to the total market.
beta_typeThis field identifies whether an ETF provides 'Traditional' beta exposure or 'Smart' beta exposure. ETFs that are active (i.e. non-indexed), leveraged / inverse or have a proprietary quant model (i.e. that don't provide indexed exposure to a targeted factor) are classified separately.
beta_detailsThis field provides further detail within the traditional and smart beta categories.
market_cap_rangeEquity ETFs are classified as falling into categories based on the description of their investment strategy in the prospectus. Examples ('Mega Cap', 'Large Cap', 'Mid Cap', etc.)
market_cap_weighting_typeFor ETFs that take the value 'Market Cap Weighted' in the 'index_weighting_scheme' field, this field provides detail on the market cap weighting type.
index_weighting_schemeFor ETFs that track an underlying index, this field provides detail on the index weighting type.
index_linkedThis field identifies whether an ETF is index linked or active.
index_nameThis field identifies the name of the underlying index tracked by the ETF, if applicable.
index_symbolThis field identifies the OpenFIGI ticker for the Index underlying the ETF.
parent_indexThis field identifies the name of the parent index, which represents the broader universe from which the index underlying the ETF is created, if applicable.
index_familyThis field identifies the index family to which the index underlying the ETF belongs. The index family is represented as categorized by the index provider.
broader_index_familyThis field identifies the broader index family to which the index underlying the ETF belongs. The broader index family is represented as categorized by the index provider.
index_providerThis field identifies the Index provider for the index underlying the ETF, if applicable.
index_provider_codeThis field provides the First Bridge code for each Index provider, corresponding to the index underlying the ETF if applicable.
replication_structureThe replication structure of the Exchange Traded Product (ETP).
growth_value_tiltClassifies equity ETFs as either 'Growth' or Value' based on the stated style tilt in the ETF prospectus. Equity ETFs that do not have a stated style tilt are classified as 'Core / Blend'.
growth_typeFor ETFs that are classified as 'Growth' in 'growth_value_tilt', this field further identifies those where the stocks in the ETF are both selected and weighted based on their growth (style factor) scores.
value_typeFor ETFs that are classified as 'Value' in 'growth_value_tilt', this field further identifies those where the stocks in the ETF are both selected and weighted based on their value (style factor) scores.
sectorFor equity ETFs that aim to provide targeted exposure to a sector or industry, this field identifies the Sector that it provides the exposure to.
industryFor equity ETFs that aim to provide targeted exposure to an industry, this field identifies the Industry that it provides the exposure to.
industry_groupFor equity ETFs that aim to provide targeted exposure to a sub-industry, this field identifies the sub-Industry that it provides the exposure to.
cross_sector_themeFor equity ETFs that aim to provide targeted exposure to a specific investment theme that cuts across GICS sectors, this field identifies the specific cross-sector theme. Examples ('Agri-business', 'Natural Resources', 'Green Investing', etc.)
natural_resources_typeFor ETFs that are classified as 'Natural Resources' in the 'cross_sector_theme' field, this field provides further detail on the type of Natural Resources exposure.
us_or_excludes_usTakes the value of 'Domestic' for US exposure, 'International' for non-US exposure and 'Global' for exposure that includes all regions including the US.
developed_emergingThis field identifies the stage of development of the markets that the ETF provides exposure to.
specialized_regionThis field is populated if the ETF provides targeted exposure to a specific type of geography-based grouping that does not fall into a specific country or continent grouping. Examples ('BRIC', 'Chindia', etc.)
continentThis field is populated if the ETF provides targeted exposure to a specific continent or country within that Continent.
latin_america_sub_groupFor ETFs that are classified as 'Latin America' in the 'continent' field, this field provides further detail on the type of regional exposure.
europe_sub_groupFor ETFs that are classified as 'Europe' in the 'continent' field, this field provides further detail on the type of regional exposure.
asia_sub_groupFor ETFs that are classified as 'Asia' in the 'continent' field, this field provides further detail on the type of regional exposure.
specific_countryThis field is populated if the ETF provides targeted exposure to a specific country.
china_listing_locationFor ETFs that are classified as 'China' in the 'country' field, this field provides further detail on the type of exposure in the underlying securities.
us_stateTakes the value of a US state if the ETF provides targeted exposure to the municipal bonds or equities of companies.
real_estateFor ETFs that provide targeted real estate exposure, this field is populated if the ETF provides targeted exposure to a specific segment of the real estate market.
fundamental_weighting_typeFor ETFs that take the value 'Fundamental Weighted' in the 'index_weighting_scheme' field, this field provides detail on the fundamental weighting methodology.
dividend_weighting_typeFor ETFs that take the value 'Dividend Weighted' in the 'index_weighting_scheme' field, this field provides detail on the dividend weighting methodology.
bond_typeFor ETFs where 'asset_class_type' is 'Bonds', this field provides detail on the type of bonds held in the ETF.
government_bond_typesFor bond ETFs that take the value 'Treasury & Government' in 'bond_type', this field provides detail on the exposure.
municipal_bond_regionFor bond ETFs that take the value 'Municipal' in 'bond_type', this field provides additional detail on the geographic exposure.
municipal_vrdoFor bond ETFs that take the value 'Municipal' in 'bond_type', this field identifies those ETFs that specifically provide exposure to Variable Rate Demand Obligations.
mortgage_bond_typesFor bond ETFs that take the value 'Mortgage' in 'bond_type', this field provides additional detail on the type of underlying securities.
bond_tax_statusFor all US bond ETFs, this field provides additional detail on the tax treatment of the underlying securities.
credit_qualityFor all bond ETFs, this field helps to identify if the ETF provides targeted exposure to securities of a specific credit quality range.
average_maturityFor all bond ETFs, this field helps to identify if the ETF provides targeted exposure to securities of a specific maturity range.
specific_maturity_yearFor all bond ETFs that take the value 'Specific Maturity Year' in the 'average_maturity' field, this field specifies the calendar year.
commodity_typesFor ETFs where 'asset_class_type' is 'Commodities', this field provides detail on the type of commodities held in the ETF.
energy_typeFor ETFs where 'commodity_type' is 'Energy', this field provides detail on the type of energy exposure provided by the ETF.
agricultural_typeFor ETFs where 'commodity_type' is 'Agricultural', this field provides detail on the type of agricultural exposure provided by the ETF.
livestock_typeFor ETFs where 'commodity_type' is 'Livestock', this field provides detail on the type of livestock exposure provided by the ETF.
metal_typeFor ETFs where 'commodity_type' is 'Gold & Metals', this field provides detail on the type of exposure provided by the ETF.
inverse_leveragedThis field is populated if the ETF provides inverse or leveraged exposure.
target_date_multi_asset_typeFor ETFs where 'asset_class_type' is 'Target Date / MultiAsset', this field provides detail on the type of commodities held in the ETF.
currency_pairThis field is populated if the ETF's strategy involves providing exposure to the movements of a currency or involves hedging currency exposure.
social_environmental_typeThis field is populated if the ETF's strategy involves providing exposure to a specific social or environmental theme.
clean_energy_typeThis field is populated if the ETF has a value of 'Clean Energy' in the 'social_environmental_type' field.
dividend_typeThis field is populated if the ETF has an intended investment objective of holding dividend-oriented stocks as stated in the prospectus.
regular_dividend_payor_typeThis field is populated if the ETF has a value of'Dividend - Regular Payors' in the 'dividend_type' field.
quant_strategies_typeThis field is populated if the ETF has either an index-linked or active strategy that is based on a proprietary quantitative strategy.
other_quant_modelsFor ETFs where 'quant_strategies_type' is 'Other Quant Model', this field provides the name of the specific proprietary quant model used as the underlying strategy for the ETF.
hedge_fund_typeFor ETFs where 'other_asset_types' is 'Hedge Fund Replication', this field provides detail on the type of hedge fund replication strategy.
excludes_financialsFor equity ETFs, identifies those ETFs where the underlying fund holdings will not hold financials stocks, based on the funds intended objective.
excludes_technologyFor equity ETFs, identifies those ETFs where the underlying fund holdings will not hold technology stocks, based on the funds intended objective.
holds_only_nyse_stocksIf true, the ETF is an equity ETF and holds only stocks listed on NYSE.
holds_only_nasdaq_stocksIf true, the ETF is an equity ETF and holds only stocks listed on Nasdaq.
holds_mlpIf true, the ETF's investment objective explicitly specifies that it holds MLPs as an intended part of its investment strategy.
holds_preferred_stockIf true, the ETF's investment objective explicitly specifies that it holds preferred stock as an intended part of its investment strategy.
holds_closed_end_fundsIf true, the ETF's investment objective explicitly specifies that it holds closed end funds as an intended part of its investment strategy.
holds_adrIf true, he ETF's investment objective explicitly specifies that it holds American Depositary Receipts (ADRs) as an intended part of its investment strategy.
ladderedFor bond ETFs, this field identifies those ETFs that specifically hold bonds in a laddered structure, where the bonds are scheduled to mature in an annual, sequential structure.
zero_couponFor bond ETFs, this field identifies those ETFs that specifically hold zero coupon Treasury Bills.
floating_rateFor bond ETFs, this field identifies those ETFs that specifically hold floating rate bonds.
build_america_bondsFor municipal bond ETFs, this field identifies those ETFs that specifically hold Build America Bonds.
dynamic_futures_rollIf the product holds futures contracts, this field identifies those products where the roll strategy is dynamic (rather than entirely rules based), so as to minimize roll costs.
currency_hedgedThis field is populated if the ETF's strategy involves hedging currency exposure.
includes_short_exposureThis field is populated if the ETF has short exposure in any of its holdings e.g. in a long/short or inverse ETF.
ucitsIf true, the Exchange Traded Product (ETP) is Undertakings for the Collective Investment in Transferable Securities (UCITS) compliant
registered_countriesThe list of countries where the ETF is legally registered for sale. This may differ from where the ETF is domiciled or traded, particularly in Europe.
issuer_country2 letter ISO country code for the country where the issuer is located.
domicile2 letter ISO country code for the country where the ETP is domiciled.
listing_country_code2 letter ISO country code for the country of the primary listing.
listing_regionGeographic region in the country of the primary listing falls.
bond_currency_denominationFor all bond ETFs, this field provides additional detail on the currency denomination of the underlying securities.
base_currencyBase currency in which NAV is reported.
listing_currencyListing currency of the Exchange Traded Product (ETP) in which it is traded. Reported using the 3-digit ISO currency code.
number_of_holdingsThe number of holdings in the ETF.
month_end_assetsNet assets in millions of dollars as of the most recent month end.
net_expense_ratioGross expense net of Fee Waivers, as a percentage of net assets as published by the ETF issuer.
etf_portfolio_turnoverThe percentage of positions turned over in the last 12 months.