How to Import File in PMS Core and PMS Plus

Prerequisites

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

1. Get Access to Finmars
2. Link with Finmars ID
3. Install PMS Core or PMS Plus add-on

Import File in PMS Core and PMS Plus

In this guide we will demonstrate how to import excel files in PMS Plus add-on, while commenting what is available to PMS Plus only and absent in PMS Core (which is the subset of PMS Plus). 

Step 1: Go to the sidebar menu Add-ons > PMS. 

Step 2: You will see the PMS add-on page which provide the access to the Excel Import (1) interface and Helper (2) they both have similar structure of 2 panes: left pane - run page where you configure what to do, and right pane - execution info page where you can see logs and result.

In this guide we will go through how to use Excel Import tab of PMS add-on. 

Step 3: Let me guide you through Excel Import tab of PMS add-on.

PMS Plus version

PMS Core version (marked differences)

Overview of the elements on the Excel Import tab:

1. "Plus" badge - indicator that you are using PMS Plus version. If you have PMS Core, there will be "Core" badge and "Upgrade" button that will link you to the PMS Plus add-on. 
2. "Download excel Example" the button allows you to download Excel files for import, there are 2 set of them:
   1. excel_demo_data - ready to import data that will allows you to check Finmars platform in action;
   2. excel_import_file_templates - templates how to populate the excel file in Finmars format and you still can import them as well but they won't give you nice values in reports. 
3. Next to some labels in file select, input or checkboxes elements you will see Info icon - click on it to see description of the element. 
4. You will see Multiple File Select input and Text Input elements where your input required.
5. "Reset" button allows to reset selected files. 
6. "File Fields (Advanced Import)" section is only for "PMS Plus" and contains Multiple File Select inputs for: 
   1. Simple entities (more control over creation): currencies, accounts, portfolios, counterparties, responsibles, strategies;
   2. Instruments: Factor and Accrual schedules;
   3. Positions: Daily (one day living snapshot), Initial (starting positions in case you can't import historical transactions).