Prepare Data in Finmars Excel Format

Prerequisites

We assume you have all prerequisites you may need, including:

Prepare Standard Template Files for Import

Standard Configuration supports importing from Excel files:

Currencies, Accounts, Portfolios, Instruments, Instruments Factor Schedules, Instruments Accrual Schedules, Counterparties, Responsibles, Strategies1, Transactions, Positions, Prices & FX Rates.

To import this files follow instruction: How to Import Files in PMS Core and PMS Plus

Below you can find instructions on how to fill in templates.

General Requirements:

Files MUST be of ".xlsx" extension
Files MUST be structured in accordance with templates (same columns and formatting).

Transactions

To book a transaction in the system you can import it from a file.
One transaction is one row of data in the file.
You should enter a transaction in the file for import in accordance with the instructions below for supported standard transaction/position types.
Supported Standard transaction types list (case-sensitive):
- Transactions
  - Deposit
  - Withdraw
  - Expense (Non-instrument)
  - Income (Non-instrument)
  - Coupon
  - Dividend
  - Expense (Instrument)
  - Other Income (Instrument)
  - Buy
  - Sell
  - FX Trade
  - FX Forward (Open)
  - FX Forward (Expiration)
  - Transfer Cash (In)
  - Transfer Cash (Out)
  - Transfer Instrument
  - Transfer Instrument (In)
  - Transfer Instrument (Out)
  - Split
  - Reverse Split

Deposit/Withdraw

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Deposit/Withdraw transactions values should be:
  - Deposit
  - Withdraw
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- For Deposit/Withdraw transactions values should be “0" (zero).
Account (Position)
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Instrument
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Allocation (PL)
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Position size
- Numeric field.
- For Deposit/Withdraw transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Deposit/Withdraw transactions:
  - The share price of the open-end fund.
- For Deposit/Withdraw transactions values should be “0" (zero) for default.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For Deposit/Withdraw transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Deposit/Withdraw transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Deposit/Withdraw transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Deposit/Withdraw transactions values should be “0" (zero).

Expense/Income (Non-instrument)

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Income/Expense (Non-instrument) transactions values should be:
  - Income (Non-instrument)
  - Expense (Non-instrument)
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- For Income/Expense (Non-instrument) transactions values should be “-" (dash).
Instrument
- Text field. Case-sensitive.
- For Income/Expense (Non-instrument) transactions values should be “-" (dash).
Allocation (PL)
- Text field. Case-sensitive.
- For Income/Expense (Non-instrument) transactions values should be “-" (dash).
Position size
- Numeric field.
- For Income/Expense (Non-instrument) transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Income/Expense (Non-instrument) transactions values should be “0" (zero).
Amount (Carry)
- Numeric field.
- An amount of an Income/Expense.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- A type of Income/Expense associated with a transaction.
- Used for grouping in reports for non-instrument transactions.
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Expense/Income (Non-instrument) transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Expense/Income (Non-instrument) transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Expense/Income (Non-instrument) transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Expense/Income (Non-instrument) transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Expense/Income (Non-instrument) transactions values should be “0" (zero).

Coupon/Dividend

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Coupon/Dividend transactions values should be:
  - Coupon
  - Dividend
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- For Coupon/Dividend transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Coupon/Dividend transactions values should be “0" (zero).
Amount (Carry)
- Numeric field.
- An amount of a Coupon/Dividend.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Coupon/Dividend transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Coupon/Dividend transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Coupon/Dividend transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Coupon/Dividend transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Coupon/Dividend transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Coupon/Dividend transactions values should be “0" (zero).

Expense/Other Income (Instrument)

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Other Income/Expense (Instrument) transactions values should be:
  - Other Income (Instrument)
  - Expense (Instrument)
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- For Other Income/Expense (Instrument) transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Other Income/Expense (Instrument) transactions values should be “0" (zero).
Amount (Carry)
- Numeric field.
- An amount of an Income/Expense.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- A type of Income/Expense associated with a transaction.
- Used for grouping in reports for non-instrument transactions.
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Expense/Other Income (Instrument) transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Expense/Other Income (Instrument) transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Expense/Other Income (Instrument) transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Expense/Other Income (Instrument) transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Expense/Other Income (Instrument) transactions values should be “0" (zero).

Buy/Sell

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Buy/Sell transactions values should be:
  - Buy
  - Sell
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Buy/Sell transactions this field is a Principal price:
  - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- An amount or expense that has been incurred but not yet paid or settled.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-” (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Buy/Sell transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Buy/Sell transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Buy/Sell transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Buy/Sell transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Buy/Sell transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Buy/Sell transactions values should be “0" (zero).

FX Trade

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For FX Trade transactions values should be:
  - FX Trade
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For FX Trade transactions:
  - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Currency (Settlement)
- Text field. Case-sensitive.
- For FX Trade transactions:
  - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- For FX Trade transactions:
  - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+” (plus sign) is for position increase
  - “-” (minus sign) is for position decrease
Amount (Charges)
- Numeric field.
- For FX Trade transactions values should be “0" (zero).
Account (Position)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For FX Trade transactions:
  - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Instrument
- Text field.
- For FX Trade transactions:
  - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- For FX Trade transactions:
  - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For FX Trade transactions:
  - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For FX Trade transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For FX Trade transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For FX Trade transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For FX Trade transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For FX Trade transactions values should be “-" (dash).
Position size New
- Numeric field.
- For FX Trade transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For FX Trade transactions values should be “0" (zero).

Transfer Cash

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Transfer Cash transactions values should be:
  - Transfer Cash
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero).
Account (Position)
- Text field. Case-sensitive.
- For Transfer Cash transactions values should be “-" (dash).
Instrument
- Text field. Case-sensitive.
- For Transfer Cash transactions values should be “-" (dash).
Allocation (PL)
- Text field. Case-sensitive.
- For Transfer Cash transactions values should be “-" (dash).
Position size
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero) for default.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Transfer Cash transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization where the transaction transfer to.
Account To (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions where the transaction transfer to.
Account To (Position)
- Text field. Case-sensitive.
- For Transfer Cash transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Transfer Cash transactions values should be “0" (zero).

Transfer Cash (In/Out)

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Transfer Cash (In/Out) transactions values should be:
  - Transfer Cash (In)
  - Transfer Cash (Out)
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero).
Account (Position)
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Instrument
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Allocation (PL)
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Position size
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero) for default.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Transfer Cash (In/Out) transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Transfer Cash (In/Out) transactions values should be “0" (zero).

Transfer Instrument

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Transfer Instrument transactions values should be:
  - Transfer Instrument
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- For Transfer Instrument transactions values should be “-" (dash).
Position size
- Numeric field.
- An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Transfer Instrument transactions this field is a Principal price:
  - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- An amount or expense that has been incurred but not yet paid or settled.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-” (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Transfer Instrument transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization where the transaction transfer to.
Account To (Cash)
- Text field. Case-sensitive.
- For Transfer Instrument transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets where the transaction transfer to.
Position size New
- Numeric field.
- For Transfer Instrument transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Transfer Instrument transactions values should be “0" (zero).

Transfer Instrument (In/Out)

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Transfer Instrument (In/Out) transactions values should be:
  - Transfer Instrument (In)
  - Transfer Instrument (Out)
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- For Transfer Instrument (In/Out) transactions values should be “-" (dash).
Position size
- Numeric field.
- An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Transfer Instrument (In/Out) transactions this field is a Principal price:
  - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- An amount or expense that has been incurred but not yet paid or settled.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-” (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Transfer Instrument (In/Out) transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Transfer Instrument (In/Out) transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Transfer Instrument (In/Out) transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Transfer Instrument (In/Out) transactions values should be “-" (dash).
Position size New
- Numeric field.
- For Transfer Instrument (In/Out) transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For Transfer Instrument (In/Out) transactions values should be “0" (zero).

FX Forward (Open)/FX Forward (Expiration)

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be:
  - FX Forward (Open)
  - FX Forward (Expiration)
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Currency (Settlement)
- Text field. Case-sensitive.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+” (plus sign) is for position increase
  - “-” (minus sign) is for position decrease
Amount (Charges)
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “0" (zero).
Account (Position)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Instrument
- Text field.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions:
  - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “-" (dash).
Position size New
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “0" (zero).
Principal/Share price New
- Numeric field.
- For FX Forward (Open)/FX Forward (Expiration) transactions values should be “0" (zero).

Split/Reverse Split

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Transactions.
- For Split/Reverse Split transactions values should be:
  - Split
  - Reverse Split
Reverse
- Text field.
- Indicator for a reverse transaction.
- Valid values:
  - True
  - False
- This field has only indicative meaning and will NOT invert any signs in other fields.
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Amount (Charges)
- Numeric field.
- Costs or fees associated with a transaction.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Allocation (PL)
- Text field. Case-sensitive.
- An instrument to which the financial outcome of a transaction is attributed or allocated.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Split/Reverse Split transactions this field is a Principal price:
  - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- An amount or expense that has been incurred but not yet paid or settled.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-” (dash).
Payment Purpose (for Income/Expense)
- Text field. Case-sensitive.
- For Split/Reverse Split transactions values should be “-" (dash).
Reference transaction code
- Text field. Case-sensitive.
- A reference to related transactions' unique identifiers.
- For reverse transaction you can specify a transaction ID of the reversed transaction.
Counterparty
- Text field. Case-sensitive.
Responsible
- Text field. Case-sensitive.
Strategy1
- Text field. Case-sensitive.
Portfolio To
- Text field. Case-sensitive.
- For Split/Reverse Split transactions values should be “-" (dash).
Account To (Cash)
- Text field. Case-sensitive.
- For Split/Reverse Split transactions values should be “-" (dash).
Account To (Position)
- Text field. Case-sensitive.
- For Split/Reverse Split transactions values should be “-" (dash).
Position size New
- Numeric field.
- A new (e.g. after Corporate Action) quantity or size of an asset or instrument after any changes or corrections made to the nominal position. With sign of instrument movement (+ is for increase, - is for decrese).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price New
- Numeric field.
- For Split/Reverse Split transactions this field is a Principal price:
  - A new (e.g. after Corporate Action) unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)

Positions Initial/Daily

To book a position in the system you can import it from a file, what differentiate Initial from Daily is Import Schemes, use corresponding.
One position is one row of data in the file.
You should enter a position in the file for import in accordance with the instructions below for supported standard transaction types.
Supported Standard transaction types for Positions Initial/Daily list (case-sensitive):
- Positions Initial/Daily (different schemes use the same selectors):
  - Position Cash
  - Position Instrument
  - Position FX Forward

Position Cash

Daily transaction type is valid only on the trade date then position will be nullified.

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Positions.
- For Position Cash transactions values should be:
  - Position Cash
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
- For Position Cash transactions:
  - Date (Value) should be equal to Date (Trade)
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- For Position Cash transactions values should be “-" (dash).
Instrument
- Text field. Case-sensitive.
- For Position Cash transactions values should be “-" (dash).
Position size
- Numeric field.
- For Position Cash transactions values should be “0" (zero).
Principal/Share price
- Numeric field.
- For Position Cash transactions:
  - The share price of the open-end fund.
- For Position Cash transactions values should be “0" (zero) for default.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For Position Cash transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).

Position Instrument

Daily transaction type is valid only on the trade date then position will be nullified.

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Positions.
- For Position Instrument transactions values should be:
  - Position Instrument
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
- For Position Instrument transactions:
  - Date (Value) should be equal to Date (Trade)
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
Currency (Settlement)
- Text field. Case-sensitive.
- A currency in which the payment or transfer of funds takes place to fulfil the terms of the transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- A monetary value or payment made in the form of cash for a particular transaction or asset.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Account (Position)
- Text field. Case-sensitive.
- An account that tracks and records the positions or holdings of assets.
Instrument
- Text field. Case-sensitive.
- A financial asset or security involved in a transaction.
- Value must be:
  - ISIN (e.g. GB00BFZNLB60) to import Instrument from Finmars Database
  - user_code - for instruments without ISIN or already created instruments.
Position size
- Numeric field.
- An adjusted position of the asset after all alterations or corrections (e.g. adjusted for a factor).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Position Instrument transactions this field is a Principal price:
  - A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in Settlement Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- An amount or expense that has been incurred but not yet paid or settled.
- Must be in Settlement Currency.
- A sign of the number:
  - “+" (plus sign) is for income
  - “-" (minus sign) is for expenses
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-” (dash).

Position FX Forward

Transaction ID
- Text field. Case-sensitive.
- A unique complex transaction identifier (only one in the workspace).
- Transactions with repeated ID will be overwritten.
Transaction Type
- Text field. Case-sensitive.
- Type of a transaction.
- Should be a value from Standard transaction types for Positions.
- For Position FX Forward transactions values should be:
  - Position FX Forward
Date (Accounting)
- Date field.
- A date on which a particular financial transaction was entered into the source system.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Trade)
- Date field.
- A date on which a particular financial transaction is executed or agreed upon.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Date (Value)
- Date field.
- A date when cash or funds are expected to be received or paid as part of a financial transaction.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Portfolio
- Text field. Case-sensitive.
- A collection of financial assets or investments held by an individual or organization.
Account (Cash)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For Position FX Forward transactions:
  - An account for the quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Currency (Settlement)
- Text field. Case-sensitive.
- For Position FX Forward transactions:
  - A quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Cash Consideration
- Numeric field.
- For Position FX Forward transactions:
  - An amount of a quote currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+” (plus sign) is for position increase
  - “-” (minus sign) is for position decrease
Account (Position)
- Text field. Case-sensitive.
- An account that is specifically designated for managing and tracking cash transactions.
- For Position FX Forward transactions:
  - An account for the base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
Instrument
- Text field.
- For Position FX Forward transactions:
  - A base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Position size
- Numeric field.
- For Position FX Forward transactions:
  - An amount of a base currency in a foreign exchange transaction (BaseCCY/QuoteCCY).
- A sign of the number:
  - “+" (plus sign) is for position increase
  - “-" (minus sign) is for position decrease
Principal/Share price
- Numeric field.
- For Position FX Forward transactions:
  - An exchange rate used for a contract’s foreign exchange transaction, where Sell currency is the Quote currency and Buy currency is the Base currency (e.g. we sell 110 USD and buy 100 EUR, then the field’s value should be 1.1 EUR/USD).
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Amount (Carry)
- Numeric field.
- For Position FX Forward transactions values should be “0" (zero).
Notes
- Text field.
- Additional comments, instructions, or relevant information associated with a particular transaction.
- If there are no notes enter “-" (dash).

Instruments

Instrument ID
- Text field. Case-sensitive.
- A unique user_code for a financial asset or security involved in a transaction.
ISIN
- Text field. Case-sensitive.
- An identification code assigned to a financial instrument (e.g. GB00BFZNLB60).
Pricing Currency
- Text field. Case-sensitive.
- A currency in which the valuation or pricing of a financial instrument is expressed.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Instrument Type
- Text field. Case-sensitive.
- A user-friendly name for a instrument type of financial asset or security involved in a transaction (may influence view forms).
- Valid values:
  - Bond
  - CDS
  - CFD
  - Deposit
  - Derivative
  - Forward
  - FX Forward Leg
  - Loan
  - Option
  - Other
  - Portfolio
  - Stock
  - T-Bill
Asset Type
- Text field. Case-sensitive.
- A user-friendly name for an asset type financial asset or security involved in a transaction.
- Valid values:
  - Alternative Investments
  - Cash & Equivalents
  - Commodities
  - Crypto
  - Debt
  - Derivatives
  - Equipment
  - Equity
  - Other
  - Real Estate
  - Transport
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Description
- Text field. Case-sensitive.
- Additional comments, instructions, or relevant information associated with a particular instrument.
- If there are no notes enter “-" (dash).
Country
- Text field. Case-sensitive.
- A country of a financial instrument.
- Must be iso 3 symbols country alphabetic code (e.g. LUX, GBR, USA).
Price Multiplier
- Numeric field.
- A factor applied to adjust the nominal value of certain assets. For example, in the context of bonds, a price multiplier of 0.01 is used to convert the quoted price to its actual value.
Maturity Date
- Date field.
- A date on which a financial instrument (e.g. bond or certificate of deposit) reaches the end of its term.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Maturity Price
- Numeric field.
- A unit price or value of a financial instrument, excluding any accrued interest or additional earnings effective after and including Maturity Date.
- Must be in instrument Pricing Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
FIGI (ex. BBGID)
- Text field. Case-sensitive.
- An identification code assigned to a financial instrument (e.g. BBG000C6K6G9).
CUSIP
- Text field. Case-sensitive.
- An identification code assigned to a financial instrument (e.g. 02079K107).
SEDOL
- Text field. Case-sensitive.
- An identification code assigned to a financial instrument (e.g. 0540528).
ISIN 144A
- Text field. Case-sensitive.
- An identification code assigned to a financial instrument (e.g. US89855VAA89).
Accrued Currency
- Text field. Case-sensitive.
- A currency in which the accrued of a financial instrument is expressed.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Accrued Multiplier
- Numeric field.
- A factor applied to adjust the nominal accrued value of certain assets. For example, in the context of bonds, an accrued multiplier of 0.01 is used to convert the quoted accrued price to its actual value.
Exposure Currency (Codirectional)
- Not implemented.
- Text field. Case-sensitive.
- A currency in which the codirectional exposure of a financial instrument is expressed.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Exposure Currency (Counterdirectional)
- Not implemented.
- Text field. Case-sensitive.
- A currency in which the counterdirectional exposure of a financial instrument is expressed.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Default Price
- Numeric field.
- A unit price or value of a financial instrument, excluding any accrued interest or additional earnings which is used for creating Price History entity for this instrument if the price is not specified (None).
- Must be in instrument Pricing Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Last Update Date
- Date field.
- A date on which was a financial instrument's last update.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")

Instruments Accrual Schedules

Instrument ID
- Text field. Case-sensitive.
- A unique user_code for a financial asset or security involved in a transaction.
Accrual ID
- Text field. Case-sensitive.
- ID of accrual schedule entries (unique in one Instrument, may repeat for different instruments).
Accrual Start Date
- Date field.
- A date on which a financial instrument starts accrual.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
First Payment Date
- Date field.
- A date on which a financial instrument has its first accrual payment.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Accrual Calculation Model
- Text field. Case-sensitive.
- A user code of the Day Count Convention a.k.a. Accrual Calculation Model (drop-down valid values in Excel).
- Valid values (as per 2024-07-19 see reference in Finmars API like https://ADDRESS/REALM_CODE/SPACE_CODE/api/v1/instruments/accrual-calculation-model/):
  - DAY_COUNT_30_360_ISDA
  - DAY_COUNT_30_360_ISMA
  - DAY_COUNT_30_360_GERMAN
  - DAY_COUNT_30_360_US
  - DAY_COUNT_30_365
  - DAY_COUNT_30E_PLUS_360
  - DAY_COUNT_30E_360
  - DAY_COUNT_ACT_360
  - DAY_COUNT_ACT_364
  - DAY_COUNT_ACT_365
  - DAY_COUNT_ACT_365A
  - DAY_COUNT_ACT_365_FIXED
  - DAY_COUNT_ACT_365L
  - DAY_COUNT_ACT_366
  - DAY_COUNT_ACT_ACT_AFB
  - DAY_COUNT_ACT_ACT_ICMA
  - DAY_COUNT_ACT_ACT_ISDA
  - DAY_COUNT_BD_252
  - DAY_COUNT_NL_365
  - NONE
  - DAY_COUNT_SIMPLE
- NONE is only applicable for Periodicity with defined N for example:
  - Periodicity=N_DAY and Periodicity N=35
Periodicity
- Text field. Case-sensitive.
- A user code of the Periodicity (drop-down valid values in Excel).
- Valid values (as per 2024-07-19 see reference in Finmars API like https://ADDRESS/REALM_CODE/SPACE_CODE/api/v1/instruments/periodicity/):
  - -
  - ANNUALLY
  - BIMONTHLY
  - MONTHLY
  - N_DAY
  - N_MONTH_EOM
  - N_MONTH_SAME_DAY
  - N_WEEK_EOBW
  - N_YEAR_EOY
  - N_YEAR_SAME_DAY
  - QUARTERLY
  - SEMI_ANNUALLY
  - WEEKLY
Periodicity N
- Numeric field.
- Only applicable for Periodicity with defined N, for example:
  - Accrual Calculation Model=N_DAY and Periodicity N=35.
Accrual Size, %
- Numeric field.
- Accrual size is in %, so that you need to input 5 for 5% and NOT 0.05.
End of Month
- Text field.
- Indicator for a payment in the End of Month.
- Valid values:
  - True
  - False
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).

Instruments Factor Schedules

Instrument ID
- Text field. Case-sensitive.
- A unique user_code for a financial asset or security involved in a transaction.
Factor ID
- Text field. Case-sensitive.
- ID of factor schedule entries (unique in one Instrument, may repeat for different instruments).
Date
- Date field.
- A date on which a financial instrument set the factor.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Factor
- Numeric field.
- Factor size is of float type, so that you need to input 0.5 for 50% and NOT 50.

Prices

Date
- Date field.
- A date of valuation.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Instrument ID
- Text field. Case-sensitive.
- A unique user_code for a financial asset or security involved in a transaction.
Principal Price
- Numeric field.
- A unit price or value of a financial instrument, excluding any accrued interest or additional earnings.
- Must be in instrument Pricing Currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Accrued Price
- Numeric field.
- A unit price or value of accrued interest or other earnings of a financial instrument.
- Must be in accrued currency.
- Multipliers will be applied automatically in accordance with an instrument of the transaction.
- A sign of the number:
  - “+" (plus sign) is for standard prices
  - “-" (minus sign) is for special prices (e.g. for exotic derivatives)
Factor
- Numeric field.
- A multiplicative factor applied to the nominal or face value of a security, such as bonds or other financial instruments to adjust its value for various purposes.
- Must NOT be negative.
YTM
- Numeric field.
- Yield to maturity.
Modified Duration
- Numeric field.
Pricing Policy
- Text field. Case-sensitive.
- A unique user_code for a container which determines what set of prices and fx rates to use for valuation.
is_temporary_price
- Text field.
- Indicator for a modified price (e.g. or auto populated by rolling).
- Valid values:
  - True
  - False
long_delta
- Not implemented.
short_delta
- Not implemented.

FX Rates

Date
- Date field.
- A date of valuation.
- Format should be: “YYYY-MM-DD” (e.g. “2000-12-31")
Currency ID
- Text field. Case-sensitive.
- A currency that is being purchased in a foreign exchange transaction.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
FX Rate
- Numeric field.
- An exchange rate used for a foreign exchange transaction.
- Must be in USD (USD must be quoted currency).
- Must NOT be negative.
Pricing Policy
- Text field. Case-sensitive.
- A unique user_code for a container which determines what set of prices and fx rates to use for valuation.

Other Entities

Currencies

Currency ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
- Must be an alphabetic code of a currency alphabetic code (e.g. USD, EUR, CHF).
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Country
- Text field. Case-sensitive.
- A currency's country of origin.
- Must be iso 3 symbols country alphabetic code (e.g. LUX, GBR, USA).
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Pricing Reference
- Not implemented.
Pricing Condition
- Not implemented.
Default FX Rate
- Numeric field.
- A unit fx rate or value of a currency which is used for creating Currency History entity for this currency if the fx rate is not specified (None).
- Must be in USD (USD must be quoted currency).
- Must NOT be negative.

Accounts

Account ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Account Type ID
- Text field. Case-sensitive.
- Unique user code of the entity's type which is used for aggregation, no functional impact.

Portfolios

Portfolio ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Portfolio Type ID
- Text field. Case-sensitive.
- Unique user code of the entity's type which is used to classify portfolios between:
  - General (com.finmars.standard-other:portfolios.portfoliotype:general)
  - Manual (com.finmars.standard-other:portfolios.portfoliotype:manual)
  - Positional (com.finmars.standard-other:portfolios.portfoliotype:position)
Register Pricing Policy
- Text field. Case-sensitive.
- A unique user_code for a container which determines what set of prices and fx rates to use for valuation.
Register Currency
- Text field. Case-sensitive.
- A user code of a currency that is being used in portfolio valuation.
Register Instrument Type
- Text field. Case-sensitive.
- A user code for an instrument type of a register.
- Recommended and default is: com.finmars.standard-instrument-type:portfolio .

Counterparties

Counterparty ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Counterparty Type ID
- Text field. Case-sensitive.
- Unique user code of the entity's type which is used for aggregation, no functional impact.

Responsibles

Responsible ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Responsible Type ID
- Text field. Case-sensitive.
- Unique user code of the entity's type which is used for aggregation, no functional impact.

Strategies

Strategy ID
- Text field. Case-sensitive.
- Unique user code of the entity.
- Entities with repeated ID will be overwritten.
Name
- Text field. Case-sensitive.
- A name of the entity.
Short Name
- Text field. Case-sensitive.
- A short name of the entity.
Public Name
- Text field. Case-sensitive.
- A public name of the entity. Will be shown instead of Name if user has no right to see this entity.
Notes
- Text field.
- Additional comments, instructions, or relevant information.
- If there are no notes enter “-" (dash).
Strategy Type ID
- Text field. Case-sensitive.
- Unique user code of the entity's type which is used for aggregation, no functional impact.

Revision #36
Created 2025-01-15 11:21:57 UTC by Sergei Osipov
Updated 2025-09-30 16:22:01 UTC by Sergei Osipov