Type FIOAggregateHolderStat
Type category Entity
Description The Holder Stat represents a detailed summary of fixed income asset statistics at the holder level for a particular Security, including key data points such as the market value of fixed income assets, standardized market value, and turnover styles of the holder. This metric captures the portfolio turnover ratio and categorizes holders by their debt capitalization group type, providing insights into the investment strategies and behaviors of different holders. It offers a comprehensive view of the engagement and positioning of holders within the fixed income market, facilitating analysis of trends and performance over time.
Fields
Name Type Filters Description
key id string(250)* = It uniquely identifies the entity record.
link batch Batch* = The batch for which this batchrun is an instance.
link batchRun BatchRun* = The batchrun in which the parheld is reported.
ciqCompanyId long(-2147483648,2147483647) A unique identifier assigned to each fund or firm within the CIQ database. It facilitates the tracking and management of firm-specific information related to fixed income securities. This identifier is crucial for linking firms with their respective investment holdings and performance data.
dateEndedStandard date The standardized format used to indicate the quarter end date. It provides a uniform method for documenting when an event or timeframe officially concludes. This standardization ensures accuracy and consistency across records and systems.
debtCapitalizationGroupType string(100) The debt capitalization emphasis for a given security. It groups debt held by a particular holder based on the type of capitalization approach such as senior or subordinated debt.
fiAssetsMarketValue long(-9223372036854775807,9223372036854775806) The current total market valuation of all fixed income securities held by a specific investor or holder. This value reflects the price at which these securities can be sold in the market providing crucial information for assessing the worth of fixed income investments within that holders portfolio and their contribution to overall investment performance.
fiAssetsStandardizedMarketValue decimal{32,4} The current total market valuation of all fixed income securities held by a specific investor or holder. This value reflects the price at which these securities can be sold in the market providing crucial information for assessing the worth of fixed income investments within that holders portfolio and their contribution to overall investment performance.
formOrder long(-32768,32767) It represents the rows of output are to be displayed in ascending order by this value. This item should have no absolute value. It is used for relative ordering.
groupId long(-2147483648,2147483647) A unique identifier assigned to each group within Orion database. It facilitates the tracking and management of group-specific information related to fixed income securities. This identifier is crucial for linking groups and their respective firms with the investment holdings and performance data.
holderId long(-9223372036854775807,9223372036854775806) A unique identifier assigned to each fund or firm or group holder for a security.
holderTurnOverStyle string(100) The trading turnover style of investors for a particular security. It categorizes the frequency and style of trading activities of a particular holder for a specific calendar quarter end date.
institutionalInvestment boolean The value indicates whether an owner type is classified as an institutional investor or not.
instnName string(100) The company which shall be displayed to arrange the companies of the group in ascending or descending order basis the alphabetical order.
isDeleted boolean The row is (logically) deleted or not.
keyDebtCapitalizationGroupType long(-32768,32767) The primary key of the debt based on capitalization emphasis. It provides a breakdown of debt types for a particular holder in a specific calendar quarter end date.
keyHolderTurnOverStyle long(-32768,32767) The primary key of the turnover style of holders. It categorizes trading styles and frequencies of each holder for a specific calendar quarter end date.
keyHoldingInvestmentType long(-32768,32767) The primary key for the holding investment type of security holders.
lastModifiedDateTime dateTime* Date and time of a physical row when last modified in UTC timezone.
latestFlag boolean The aggregate calculations in the table are made based on the latest available active portfolio only in which case the value will be true. If the calculations are made based on historical portfolios the value will be false.
miKeyInstn long(-2147483648,2147483647) A unique identifier for funds and firms in the MI database. It is used to manage and track firm investment details related to fixed income securities. This key aids in associating firms with their investment activities and holdings.
portfolioTurnOverRatio decimal{9,6} The frequency at which assets within a portfolio are bought and sold over a specific period indicating the level of trading activity. A higher ratio suggests a more actively managed portfolio while a lower ratio indicates a more passive investment strategy.
22 rows of 22 total
API Open API Specification