Holdings Overview - MX Documentation

Holdings represent individual investment positions within investment accounts, including stocks, bonds, mutual funds, and other securities.

Holding Fields

As of January 1, 2025, CUSIP is no longer supported. Please refer to the most-up-to-date investment documentation.

Field Name	Data Type	Description
`account_guid`	String	Unique identifier for the account. Defined by MX.
`allocations_cash`	Decimal	The percentage of a holding held in cash or cash equivalents.
`allocations_convertible`	Decimal	The percentage of a holding held in convertible shares.
`allocations_foreign_bond`	Decimal	The percentage of a holding held in US bonds.
`allocations_foreign_stock`	Decimal	The percentage of a holding held in non-US stocks.
`allocations_other`	Decimal	The percentage of a holding held in otherwise undefined assets. Real estate, commodities, and precious metals are examples of ‘other’ assets.
`allocations_preferred`	Decimal	The percentage of a holding held in preferred stocks.
`allocations_unknown`	Decimal	The percentage of a holding held in assets that are currently undefined by MX.
`allocations_us_bond`	Decimal	The percentage of a holding held in US bonds.
`allocations_us_stock`	Decimal	The percentage of a holding held in US stocks.
`bond_coupon_rate`	Decimal	The coupon rate for a bond.
`bond_coupon_rate_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`bond_coupon_rate_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`bond_maturity_date`	String	The bond maturity date, represented in ISO 8601 format without a timestamp (e.g. 2015-04-13).
`bond_maturity_date_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`bond_maturity_date_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`cost_basis`	Decimal	The cost basis is the original value of an asset adjusted for stock splits, dividends, and capital distributions.
`cost_basis_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`cost_basis_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`cost_basis_updated_at`	String	Date and time the cost basis was last updated, represented in ISO 8601 format with timestamp (e.g. 2015-04-13T12:01:23-00:00).
`created_at`	String	Date and time the holding was created, represented in ISO 8601 format with timestamp (e.g. 2015-04-13T12:01:23-00:00).
`currency_code`	String	The ISO 4217 three-character currency code (e.g. USD).
`currency_code_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`currency_code_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`daily_change`	Decimal	The change from the previous day in the price of the security.
`daily_change_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`daily_change_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`deleted_at`	String	Date and time the holding was deleted, represented in ISO 8601 format with timestamp (e.g. 2015-04-13T12:01:23-00:00).
`description`	String	Description of the holding.
`description_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`description_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`equity_classification`	Integer	A graphical representation of the investment style of the stocks and stock funds within a holding according to the Morningstar Style Box. See Holding Classification for more information.
`equity_classification_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`equity_classification_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`external_guid`	String	Partner created identifier for the holding.
`feed_bond_coupon_rate`	Decimal	The coupon rate for a bond, as defined by our data feed. See `bond_coupon_rate` for more information.
`feed_bond_maturity_date`	String	The bond maturity date, as defined by our data feed. See `bond_maturity_rate` for more information.
`feed_cost_basis`	Decimal	Cost basis, as provided by our data feed. See `cost_basis` for more information.
`feed_currency_code`	String	The ISO 4217 three-character currency code, as provided by our data feed (e.g. USD).
`feed_cusip`	String	The cusip, as provided by our data feed. See `cusip` for more information.
`feed_daily_change`	Decimal	Daily change of the holding, as provided by our data feed. See `daily_change` for more information.
`feed_description`	String	Description of the holding, as provided by our data feed. See `description` for more information.
`feed_equity_classification`	String	The equity classification, as defined by our data feed. See `equity_classification` for more information.
`feed_fixed_income_classification`	String	The fixed income classification, as defined by our data feed. See `fixed_income_classification` for more information.
`feed_isin`	String	The International Securities Identification Number (ISIN), as defined by our data feed. See `fixed_income_classification` for more information.
`feed_market_value`	Decimal	Market value of the holding, as provided by our data feed. See `market_value` for more information.
`feed_purchase_price`	Decimal	Purchase price of the holding, as provided by our data feed. See `purchase_price` for more information.
`feed_sector`	Integer	The area of the economy the holding is invested in, as defined by our data feed. See `sector` for more information.
`feed_sedol`	String	The Stock Exchange Daily Official List (SEDOL) classification code, as defined by our data feed. See `sedol` for more information.
`feed_shares`	Decimal	Shares for the holding, as provided by our data feed. See `shares` for more information.
`feed_symbol`	String	Ticker symbol, as provided by our data feed. See `symbol` for more information.
`fixed_income_classification`	Integer	A graphical representation of the investment style of the fixed income funds within a holding (like bonds) according to the Morningstar Style Box. See Fixed Income Classification for more information.
`fixed_income_classification_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`fixed_income_classification_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`guid`	String	Unique transaction identifier. Defined by MX.
`holding_type`	Integer	The type of holding, such as Mutual Fund, Equity, or Bond.
`holding_type_name`	String	The name of the holding type.
`holding_type_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`holding_type_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`is_deleted`	Boolean	If the holding is deleted, this field will be true. Otherwise, this field will be false.
`isin`	String	The International Securities Identification Number (ISIN) in ISO 6166 format.
`isin_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`isin_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`large_core_weight`	Decimal	The percentage of a holding’s stock value with a large core investment style.
`large_growth_weight`	Decimal	The percentage of a holding’s stock value with a large growth investment style.
`large_value_weight`	Decimal	The percentage of a holding’s stock value with a large value investment style.
`market_value`	Decimal	The market value of the holding.
`market_value_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`market_value_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`member_is_managed_by_user`	Boolean	If the member the holding belongs to is managed by the user, this field will be true. Otherwise, the member is managed by the MX partner and this field will be false. Members created with Nexus are considered to be managed by the user.
`metadata`	String	Additional information a partner can store on the holding.
`mid_core_weight`	Decimal	The percentage of a holding’s stock value with a mid core investment style.
`mid_growth_weight`	Decimal	The percentage of a holding’s stock value with a mid growth investment style.
`mid_value_weight`	Decimal	The percentage of a holding’s stock value with a mid value investment style.
`purchase_price`	Decimal	The purchase price of the holding.
`purchase_price_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`purchase_price_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`sector`	Integer	The area of the economy the holding is invested in.
`sector_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`sector_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`sedol`	String	The Stock Exchange Daily Official List (SEDOL) classification code, represented as a seven-character code (e.g. B03MM40).
`sedol_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`sedol_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`shares`	Decimal	The number of shares for the holding.
`shares_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`shares_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`small_core_weight`	Decimal	The percentage of a holding’s stock value with a small core investment style.
`small_growth_weight`	Decimal	The percentage of a holding’s stock value with a small growth investment style.
`small_value_weight`	Decimal	The percentage of a holding’s stock value with a small value investment style.
`symbol`	String	Ticker symbol. Abbreviation used to uniquely identify publicly traded stocks, bonds, mutual funds, and ETFs.
`symbol_set_by`	Integer	The source that set the data ( 1 = FEED, 2 = USER, 3 = SYSTEM ).
`symbol_set_by_name`	String	The source that set the data ( FEED, USER, or SYSTEM ).
`updated_at`	String	Date and time the transaction was updated, represented in ISO 8601 format with timestamp (e.g. 2015-04-13T12:01:23-00:00).
`unknown_weight`	Decimal	The percentage of a holding’s stock value with an investment style currently undefined by MX.
`user_guid`	String	Unique identifier for the user. Defined by MX.

Holding Classification

Value	Definition
0	UNKNOWN
1	LARGE_VALUE
2	LARGE_CORE
3	LARGE_GROWTH
4	MID_VALUE
5	MID_CORE
6	MID_GROWTH
7	SMALL_VALUE
8	SMALL_CORE
9	SMALL_GROWTH

Fixed Income Classification

Value	Definition
0	UNKNOWN_FIXED_INCOME_CLASSIFICATION
1	HIGH_LIMITED
2	HIGH_MODERATE
3	HIGH_EXTENSIVE
4	MEDIUM_LIMITED
5	MEDIUM_MODERATE
6	MEDIUM_EXTENSIVE
7	LOW_LIMITED
8	LOW_MODERATE
9	LOW_EXTENSIVE

Holding Type

Value	Definition
0	UNKNOWN_TYPE
1	EQUITY
2	EXCHANGE_TRADED_FUND
3	MONEY_MARKET
4	MUTUAL_FUND
5	HEDGE_FUND
6	ANNUITY
7	UNIT_INVESTMENT_TRUST
8	CASH
9	FIXED_INCOME
10	OPTIONS

Holding `set_by`

Date Source	Definition	Information
1	FEED	Information provided from the MX data feed.
2	USER	Information provided from the user.
3	SYSTEM	Information provided from the MX system.

​Holding Fields

​Holding Classification

​Fixed Income Classification

​Holding Type

​Holding set_by

Holding Fields

Holding Classification

Fixed Income Classification

Holding Type

Holding `set_by`