HOLDINGS

Get the holdings for an individual ETF.

Syntax

=OBB.ETF.HOLDINGS(symbol,[date])

=OBB.ETF.HOLDINGS("XLK")

=OBB.ETF.HOLDINGS("XLK","2022-03-31")

Name	Type	Description	Required
symbol	Text	Symbol to get data for. (ETF)	True
date	Text	A specific date to get data for.	False

Name	Description
symbol	Symbol representing the entity requested in the data. (ETF)
name	The common name for the holding.
security_type	The type of instrument for this holding. Examples(Bond='BOND', Equity='EQUI')
isin	The International Securities Identification Number.
ric	The Reuters Instrument Code.
sedol	The Stock Exchange Daily Official List.
share_class_figi	The OpenFIGI symbol for the holding.
country	The country or region of the holding.
maturity_date	The maturity date for the debt security, if available.
contract_expiry_date	Expiry date for the futures contract held, if available.
coupon	The coupon rate of the debt security, if available.
balance	The number of units of the security held, if available.
unit	The units of the 'balance' field.
units_per_share	Number of units of the security held per share outstanding of the ETF, if available.
face_value	The face value of the debt security, if available.
derivatives_value	The notional value of derivatives contracts held.
value	The market value of the holding, on the 'as_of' date.
weight	The weight of the holding, as a normalized percent.
updated	The 'as_of' date for the holding.