STD Solution

• Simple Entities
• Currency
• Account
• Portfolio
• Counterparty
• Responsible
• Strategy 1
• Instrument
• Pricing Policy
• FX Rate (Currency History)
• Price (Price History)
• Transactions
• Complex Transactions
• Transactions Report
• Balance Report
• Profit and Loss Report
• Performance Report
• Dashboard Layouts
• Templates
• Simple Entity
• Layout Name

Simple Entities

Currency

Type

Not Applicable

User Attributes

None

Currency Entities

• "-" (-) - System default entity, indicating absence of relation to an entity
• USD (USD) - System default entity USD
• EUR (EUR) - System default entity EUR
• CHF (CHF) - System default entity CHF
• GBP (GBP) - System default entity GBP

Currency Entity Viewer Layout

• CCY (com.finmars.standard-layouts:currencies.currency:ccy)
  • User code (user_code) - unique code for the entity
  • Country (country) - associated country
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)

Currency Form Layout

• Entity Header
  • Currency - Complex Field which include Full Name, Short Name, User Code, Show by Default (Name by Default)
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Public name
    • Country - associated country
      
    • Notes
• System Tabs
  • Pricing
    • Pricing Policy
    • Pricing Module
    • Configure

Currency Import Scheme

• STD - CCY (com.finmars.standard-import-from-file:currencies.currency:ccy)

Account

Type

• "-" (dash) - System default entity, indicating absence of relation to an entity
• Default Account Type (com.finmars.standard-other:accounts.accounttype:default) - One and only multipurpose account type which is provided by default for every accounts.

User Attributes

None

Entities

• "-" (dash) - System default entity, indicating absence of relation to an entity
• Account (Provisional) (account_provisional) - Interim account for cash in transfer: after recognition but before actual movement.

Entity Viewer Layout

• ACCT (com.finmars.standard-layouts:accounts.account:acct)
  • User code (user_code) - unique code for the entity
  • Type (type) - account type
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)

Form Layout

• Entity Header
  • Account - Complex Field which include user_code and different Name fields
  • Type - account type
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • • Notes
• System Tabs
  • None

Import Scheme

• STD - ACCT (com.finmars.standard-import-from-file:accounts.account:acct)

Portfolio

Type

• General Portfolio (com.finmars.standard-other:portfolios.portfoliotype:general) - General Purpose Portfolio type.
• Manual Managed Portfolio (com.finmars.standard-other:portfolios.portfoliotype:manual) - Portfolios indicated as manually managed, meaning that new transactions and changes are supposed to be manually. 
• Position Only Portfolio (com.finmars.standard-other:portfolios.portfoliotype:position) - positional portfolios, meaning that it consists only of positions, doesn't need registers and portfolio calculations and should be used for reconciliation. 

User Attributes

None

Entities

• "-" (dash) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• PORT (com.finmars.standard-layouts:portfolios.portfolio:port)
  • User code (user_code) - unique code for the entity
  • Portfolio type (portfolio_type)
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)
  • 1st TXN DAT (first_transaction_date) - the trade date of the first transaction in the portfolio
  • 1st CF DAT (first_cash_flow_date) - the date of the first cash flow transaction (deposit or withdraw) in the portfolio

Form Layout

• Entity Header
  • Portfolio - Complex Field which include user_code and different Name fields
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Portfolio Type
    • Notes
    • First Transaction Date - see description above
    • First Cash Flow Date - see description above
• System Tabs
  • Performance
    • Relation name
    • Instrument
    • Valuation currency
    • Pricing policy

Import Scheme

• STD - PORT (com.finmars.standard-import-from-file:portfolios.portfolio:port)

Counterparty

Type

Not Applicable

User Attributes

None

Entities

• "-" (dash) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• CTP (com.finmars.standard-layouts:counterparties.counterparty:ctp)
  • User code (user_code) - unique code for the entity
  • Group (group) - workspace specific 
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)

Form Layout

• Entity Header
  • Counterparty - Complex Field which include user_code and different Name fields
  • Group
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Notes
• System Tabs
  • None

Import Scheme

• STD - CTP (com.finmars.standard-import-from-file:counterparties.counterparty:ctp)

Responsible

Type

Not Applicable

User Attributes

None

Entities

• "-" (dash) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• RESP (com.finmars.standard-layouts:counterparties.responsible:resp)
  • User code (user_code) - unique code for the entity
  • Group (group) - workspace specific 
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)

Form Layout

• Entity Header
  • Counterparty - Complex Field which include user_code and different Name fields
  • Group
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Notes
• System Tabs
  • None

Import Scheme

• STD - CTP (com.finmars.standard-import-from-file:counterparties.counterparty:ctp)

Strategy 1

Type

Not Applicable

User Attributes

None

Entities

• "-" (dash) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• STRAT (com.finmars.standard-layouts:strategies.strategy1:strat)
  • User code (user_code) - unique code for the entity
  • Group (group) - workspace specific 
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • Notes (notes)

Form Layout

• Entity Header
  • Strategy 1 - Complex Field which include user_code and different Name fields
  • Group
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Notes
      
• System Tabs
  • None

Import Scheme

• STD - STRAT (com.finmars.standard-import-from-file:strategies.strategy1:strat)

Instrument

Type

Comparison Table: [WORK IN PROGRESS]

1. Portfolio (com.finmars.standard-instrument-type:portfolio)
2. Other (com.finmars.standard-instrument-type:other)
3. Bond (com.finmars.standard-instrument-type:bond)
4. T-Bill (com.finmars.standard-instrument-type:t_bill)
5. Stock (com.finmars.standard-instrument-type:stock)
6. Derivative (com.finmars.standard-instrument-type:derivative)
7. FX Forward (com.finmars.standard-instrument-type:fx_forward)
8. Forward (com.finmars.standard-instrument-type:fx_forward) 
9. Option (com.finmars.standard-instrument-type:option)
10. CDS (com.finmars.standard-instrument-type:cds)

User Attributes

1. Asset Type (com.finmars.standard-instrument-type:instruments.instrument:asset_type) the values are set according to agreed classification: https://finmars2018.atlassian.net/wiki/spaces/FD/pages/2678784001/Asset+types 
   1. Debt
   2. Equity
   3. Cash and Equivalents
   4. Commodities
   5. Crypto
   6. Derivatives
   7. Alternative Investments
   8. Transport
   9. Real Estate
   10. Equipment
   11. Other

Entities

• "-" (-) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• INSTR (com.finmars.standard-layouts:instruments.instrument:instr)
  • User code (user_code) - unique code for the entity
  • Modified At (modified_at)
  • Asset Type (attributes.com.finmars.standard-instrument-type:instruments.instrument:asset_type) - see User Attributes above
  • Country (country) - associated country
  • PRC CCY (pricing_currency)
  • ACCR CCY (accrued_currency)
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • MAT DT (maturity_date)
  • MAT PRC (maturity_price)
  • PRC MULT (price_multiplier)
  • ACCR MULT (accrued_multiplier)
  • INSTR TYPE (instrument_type) - see Type above
  • PMT SZ DTL (payment_size_detail)
  • Notes (notes)

Form Layout

• Entity Header
  • Instrument - Complex Field which include Full Name, Short Name, User Code, Show by Default (Name by Default)
  • Instrument type
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Asset Type
    • Country - associated country
    • Accrual Size Clarification
    • Pricing currency
    • Price multiplier
    • Accrued currency
    • Accrued multiplier
    • Maturity date
    • Maturity price
    • Notes
    • Identifier - JSON dictionary that stores all key:values of different identifiers of the instrument, e.g:
      • {"figi":null,"isin":"USP37341AA50","cusip":null,"sedol":null,"isin 144a":null,"std_user_code":"USP37341AA50"}
• System Tabs
  • Accruals
    • Accrual start date
    • First payment date
    • Accrual size
    • Periodicity
  • Factors
    • Value
    • Date
  • Pricing
    • Pricing Policy
    • Pricing Module
    • Configure

Import Scheme

• STD - INSTR (com.finmars.standard-import-from-file:instruments.instrument:instruments_instr) - for Instrument Import
• STD - ACCR SCHED (com.finmars.standard-import-from-file:instruments.accrualcalculationschedule:accr_sched) - for Accrual Schedule
• STD - FCTR SCHED (com.finmars.standard-import-from-file:instruments.instrumentfactorschedule:fctr_sched) - for Factor Schedule

Pricing Policy

Type

Not applicable

User Attributes

None

Entities

• "-" (-) - System default entity, indicating absence of relation to an entity
• Standard (com.finmars.standard-pricing:standard) - STD Solution pricing policy that is used by default when importing Prices & FX Rates

Entity Viewer Layout

• Default (system-defined)
  • Name
  • Unique Code
  • Notes

Form Layout

• Entity Header
  • None
• Layout Tabs
  • None
• System Tabs
  • Default
    • Name
    • Configuration Code
    • User Code
    • Notes

Import Scheme

Not applicable

FX Rate (Currency History)

Type

Not Applicable

User Attributes

None

Entities

None

Entity Viewer Layout

• FX Rates (com.finmars.standard-layouts:currencies.currencyhistory:fx_rates_layout)
  • Currency (currency) - unique user code for the currency entity
  • Date (date)
  • Pricing policy (pricing_policy)
  • FX rate (fx_rate)

Form Layout

• Entity Header
  • None
• Layout Tabs
  • General
    • Currency
    • Date
    • Pricing policy
    • FX rate
      
• System Tabs
  • None

Import Scheme

• STD - FX RATE (com.finmars.standard-import-from-file:currencies.currencyhistory:fx_rate)

Price (Price History)

Type

Not applicable

User Attributes

None

Entities

None

Entity Viewer Layout

• Price Layout (com.finmars.standard-layouts:instruments.pricehistory:price_layout)
  • Instrument (instrument) - unique user code for the instrument entity
  • Date (date)
  • Pricing policy (pricing_policy)
  • Principal price (principal_price)
  • Accrued price (accrued_price)
  • Factor (factor)
  • YTM (ytm)
  • Modified Duration (modified_duration)
  • Is Temporary Price (is_temporary_price) - indicates whether the price is final or it was temporary imported as a part of rolling missing prices or any other prices that was obtained through external manipulations outside of the source

Form Layout

• Entity Header
  • None
• Layout Tabs
  • General
    • Instrument
      Date
      Pricing policy
      Principal price
      Accrued price
      Factor
      YTM
      Modified Duration
      Is Temporary Price
• System Tabs
  • • None

Import Scheme

• STD  - PRC (com.finmars.standard-import-from-file:instruments.pricehistory:prices_prc)
  

Transactions

Complex Transactions

Type Group

See in comparison table: standard-config.xlsx Tab: groups

Inputs

See in comparison table: standard-config.xlsx Tab: inputs

Type

Comparison Table: standard-config.xlsx Tab: transaction types

1. Buy (com.finmars.standard-transaction-type:buy_with_fx_trade)

   1. 

   2. 

   3. 

2. Coupon (com.finmars.standard-transaction-type:coupon_with_fx_trade)

   1. 

   2. 

   3. 

   4. 

3. Deposit (com.finmars.standard-transaction-type:deposit)

   1. 

   2. 

4. Dividend (com.finmars.standard-transaction-type:dividend_with_fx_trade)

   1. 

   2. 

   3. 

   4. 

5. Error (com.finmars.standard-transaction-type:error)
6. Expense (Instrument) (com.finmars.standard-transaction-type:expense_instrument_with_fx)

   1. 

   2. 

   3. 

   4. 

7. Expense (Non-instrument) (com.finmars.standard-transaction-type:expense_non_instrument_with_fx_trade)

   1. 

   2. 

   3. 

   4. 

8. FX Forward (Expiration) (com.finmars.standard-transaction-type:fx_forward_expiration)
   

   1. 

   2. 

9. FX Forward (Open) (com.finmars.standard-transaction-type:fx_forward_open)
   

   1. 

   2. 

10. FX Trade (com.finmars.standard-transaction-type:fx_trade)
    

    1. 

    2. 

11. Ignore (com.finmars.standard-transaction-type:ignore)
    
12. Income (Non-instrument) (com.finmars.standard-transaction-type:income_non_instrument_with_fx_trade)
    

    1. 

    2. 

    3. 

    4. 

13. Other Income (Instrument) (com.finmars.standard-transaction-type:other_income_instrument_with_fx_trade)
    

    1. 

    2. 

    3. 

    4. 

14. Position Daily Cash (com.finmars.standard-transaction-type:position_daily_cash)
    

    1. 

    2. 

15. Position Daily FX Forward (com.finmars.standard-transaction-type:position_daily_fx_forward_open)
    

    1. 

    2. 

16. Position Initial Cash (com.finmars.standard-transaction-type:position_initial_cash)
    

    1. 

    2. 

17. Position Initial FX Forward (com.finmars.standard-transaction-type:position_initial_fx_forward_open)
    

    1. 

    2. 

18. Position Initial Instrument (com.finmars.standard-transaction-type:position_initial_instrument)
    

    1. 

    2. 

19. Position Daily Instrument (com.finmars.standard-transaction-type:position_instrument_daily)
    

    1. 

    2. 

20. Sell (com.finmars.standard-transaction-type:sell_with_fx_trade)
    

    1. 

    2. 

    3. 

    4. 

21. Transfer Cash (com.finmars.standard-transaction-type:transfer_cash)
    

    1. 

    2. 

22. Transfer Instrument (com.finmars.standard-transaction-type:transfer_instrument)
    

    1. 

    2. 

23. Undefined (com.finmars.standard-transaction-type:undefined)
    
24. Withdraw (com.finmars.standard-transaction-type:withdraw)
    

    1. 

    2. 

User Attributes

Not applicable

Entities

Not applicable

Aliases

See in comparison table: standard-config.xlsx Tab: aliases

Entity Viewer Layout

• TXN (com.finmars.standard-layouts:transactions.complextransaction:txn)
  • TXN ID (transaction_unique_code)
  • *** [WORK IN PROGRESS]

Form Layout

Each Transaction Type has its own Form Layout, see in the Type section above.

Import Scheme

• STD - INSTR (com.finmars.standard-import-from-file:instruments.instrument:instruments_instr) - for Instrument Import
• STD - ACCR SCHED (com.finmars.standard-import-from-file:instruments.accrualcalculationschedule:accr_sched) - for Accrual Schedule
• STD - FCTR SCHED (com.finmars.standard-import-from-file:instruments.instrumentfactorschedule:fctr_sched) - for Factor Schedule

Transactions Report

Balance Report

Profit and Loss Report

Performance Report

Dashboard Layouts

Templates

Simple Entity

Type

1. Portfolio (com.finmars.standard-instrument-type:portfolio)
2. Other (com.finmars.standard-instrument-type:other)
3. Bond (com.finmars.standard-instrument-type:bond)
4. T-Bill (com.finmars.standard-instrument-type:t_bill)
5. Stock (com.finmars.standard-instrument-type:stock)
6. Derivative (com.finmars.standard-instrument-type:derivative)
7. FX Forward (com.finmars.standard-instrument-type:fx_forward)
8. Forward (com.finmars.standard-instrument-type:fx_forward) 
9. Option (com.finmars.standard-instrument-type:option)
10. CDS (com.finmars.standard-instrument-type:cds)

User Attributes

1. Asset Type (com.finmars.standard-instrument-type:instruments.instrument:asset_type)
   1. Debt
   2. Equity
   3. Cash and Equivalents
   4. Commodities
   5. Crypto
   6. Derivatives
   7. Alternative Investments
   8. Transport
   9. Real Estate
   10. Equipment
   11. Other

Entities

• "-" (-) - System default entity, indicating absence of relation to an entity

Entity Viewer Layout

• INSTR (com.finmars.standard-layouts:instruments.instrument:instr)
  • User code (user_code) - unique code for the entity
  • Modified At (modified_at)
  • Asset Type (attributes.com.finmars.standard-instrument-type:instruments.instrument:asset_type) - see User Attributes above
  • Country (country) - associated country
  • PRC CCY (pricing_currency)
  • ACCR CCY (accrued_currency)
  • Short name (short_name)
  • Name (name)
  • Public name (public_name)
  • MAT DT (maturity_date)
  • MAT PRC (maturity_price)
  • PRC MULT (price_multiplier)
  • ACCR MULT (accrued_multiplier)
  • INSTR TYPE (instrument_type) - see Type above
  • PMT SZ DTL (payment_size_detail)
  • Notes (notes)

Form Layout

• Entity Header
  • Instrument - Complex Field which include Full Name, Short Name, User Code, Show by Default (Name by Default)
  • Instrument type
  • Status - Enabled/Disabled/Deleted (Disabled is when it's excluded from reports)
• Layout Tabs
  • General
    • Asset Type
    • Country - associated country
    • Accrual Size Clarification
    • Pricing currency
    • Price multiplier
    • Accrued currency
    • Accrued multiplier
    • Maturity date
    • Maturity price
    • Notes
    • Identifier - JSON dictionary that stores all key:values of different identifiers of the instrument, e.g:
      • {"figi":null,"isin":"USP37341AA50","cusip":null,"sedol":null,"isin 144a":null,"std_user_code":"USP37341AA50"}
• System Tabs
  • Accruals
    • Accrual start date
    • First payment date
    • Accrual size
    • Periodicity
  • Factors
    • Value
    • Date
  • Pricing
    • Pricing Policy
    • Pricing Module
    • Configure

Import Scheme

• STD - INSTR (com.finmars.standard-import-from-file:instruments.instrument:instruments_instr) - for Instrument Import
• STD - ACCR SCHED (com.finmars.standard-import-from-file:instruments.accrualcalculationschedule:accr_sched) - for Accrual Schedule
• STD - FCTR SCHED (com.finmars.standard-import-from-file:instruments.instrumentfactorschedule:fctr_sched) - for Factor Schedule

Layout Name

Purpose

What for & how to use

List of Columns

1. Column 1 - Description: - Format: - Is Group Column

Filters

Linked

1. ***

Simple

1. ***

Settings

1. Setting 1 - Description: - Default Value

Split options

1. ***