HOLDINGS
Get the holdings for an individual ETF.
Syntax
=OBB.ETF.HOLDINGS(symbol,[date])
Examples
=OBB.ETF.HOLDINGS("XLK")
=OBB.ETF.HOLDINGS("XLK","2022-03-31")
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| symbol | Text | Symbol to get data for. (ETF) | True |
| date | Text | A specific date to get data for. | False |
Data
- intrinio
| Name | Description |
|---|---|
| symbol | Symbol representing the entity requested in the data. (ETF) |
| name | Name of the ETF holding. |
| lei | The LEI of the holding. |
| title | The title of the holding. |
| cusip | The CUSIP of the holding. |
| isin | The ISIN of the holding. |
| balance | The balance of the holding, in shares or units. |
| units | The type of units. |
| cur_cd | The currency of the holding. |
| valUsd | The value of the holding, in dollars. |
| pctVal | The weight of the holding, as a normalized percent. |
| payoffProfile | The payoff profile of the holding. |
| assetCat | The asset category of the holding. |
| issuerCat | The issuer category of the holding. |
| invCountry | The country of the holding. |
| isRestrictedSec | Whether the holding is restricted. |
| fairValLevel | The fair value level of the holding. |
| isCashCollateral | Whether the holding is cash collateral. |
| isNonCashCollateral | Whether the holding is non-cash collateral. |
| isLoanByFund | Whether the holding is loan by fund. |
| cik | The CIK of the filing. |
| acceptanceTime | The acceptance datetime of the filing. |
| updated | The date the data was updated. |