...
| View file | ||
|---|---|---|
|
This example file contains two tabs, one for each fund that you want to manage (just create more tabs or remove tabs based on how many funds you work with.
The file contains a number of columns with the following example values:
...
The table below describes values that could be entered.
Header | Data type | Description |
|---|---|---|
PosId | Text (max 200 chars) | A unique identifier for the position. |
SrcPosId | Text (max 200 chars) | An internal reference if one exists in the source system. |
PosNm | Text (max 200 chars) | The name of the position. |
MktValBaseAmt | Decimal number | The book value expressed in the base currency of the fund where assets have a positive value and liabilities have a negative value. This is a component in the NAV calculation. |
Tp | Text (max 2 chars) | This is a simple text value that represents the type of the asset or liability: B = Borrowings |
BalAmt | Decimal number | Balance amount. Expressed in original currency specified in the Ccy tag below. |
Ccy | Text (3 chars) | The ISO currency code of the account’s balance |
ShrClssId | Text (200 chars) | Share Class Identifier. Applicable when certain positions are specific for a share class. |
Once you have filled out the values for the correct share classes you can save the excel file and navigate to the following page: http://beautifytools.com/excel-to-json-converter.php
Simply click the “Browse”-button and navigate to the Excel file that you just saved.
Do the same exercise that was described for the Share classes above with copying of the content from the JSON converter tool.