Understanding the Manaos File Template
The Manaos template file can be used when disseminating fund inventories.
Click on this link to download our Manaos template file
What's on it?
- The first tab is an explanatory guide for the different columns of the template
- The second tab is for you to fill out with your data
Below is an explanation as to the the mandatory and conditional columns to fill for each line:
| Mandatory |
At a portfolio level:
- portfolio_id (like ISIN, Sedol, CUSIP, internal code, or other but ISIN is preferred)
- portfolio_name
- portfolio_currency (ISO 4217)
- portfolio_valuation_date (YYYY-MM-DD format is preferred)
- portfolio_official_NAV_validated (It is used for consistency checks when available. Might be approximated by sum of market values when it’s not available)
(i) As these columns are at portfolio level, it is expected that within the same portfolio they all have the same values. Also, please note that you can have multiple portfolios within a single tab.
|
At a security level:
-
- security_id (like ISIN, Sedol, CUSIP, internal code, or other but ISIN is preferred, especially for providers' analyses)
- security_name
- security_type or CIC Code (CIC code is preferred)
- security_quotation_currency (ISO 4217)
- security_market_valuation_in_portfolio_currency
|
| Recommended |
- security_market_valuation_in_quotation_currency
- security_clean_market_valuation_in_portfolio_currency
- security_clean_market_valuation_in_quotation_currency
- security_market_exposure_in_portfolio_currency
- security_market_exposure_in_quotation_currency
- accrued interest ptf currency
- accrued interest quotation currency
|
Below is a list encapsulating the possible security types:
| Sovereign bond |
| Corporate bond |
| Equity |
| Investment fund |
| Structured note |
| Collateralized securities |
| Cash and deposits |
| Mortgages and loans |
| Property |
| Future |
| Call option |
| Put option |
| Swap |
| Forward |
| Credit derivative |
| Other |
