How to Prepare Standard Template Files for Import

Prerequisites

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

  1. If needed: the VPN is configured to access the Finmars resources
  2. If needed: access to the Virtual Machine to work with the sensitive information
  3. Must have: registered in Finmars in the needed region environment (self-registered or registered by Finmars)
  4. Must have: having permissions set to allow continue with the Action in the Guide
  5. Must have: to create a new Workspace you must have a License Key (provided by Finmars)
  6. Must have: installed Standard Configuration package from the marketplace

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 Data into a Workspace via Dashboard (STD Manual Import)

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

General Requirements:

Transactions

Deposit/Withdraw

Expense/Income (Non-instrument)

Coupon/Dividend

Expense/Other Income (Instrument)

Buy/Sell

FX Trade

Transfer Cash

Transfer Instrument

FX Forward (Open)/FX Forward (Expiration)

Positions Initial/Daily

Position Cash

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

Position Instrument

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

Position FX Forward

Instruments

Instruments

Instruments Accrual Schedules

Instruments Factor Schedules

Prices

FX Rates

Other Entities

Currencies

Accounts

Portfolios

Counterparties

Responsibles

Strategies


Revision #11
Created 15 January 2025 11:21:57 by Sergei Osipov
Updated 18 April 2025 18:47:12 by Sergei Osipov