To import export we suggest you download - https://www.openoffice.org/
Fields and files should respect UTF8 format. The following data is just for example and not for investment purpose.
InvestGlass offers the industry's leading integrated wealth advisor platform. Before any client interaction wealth advisors check on your customised InvestGlass platform for recommendations. InvestGlass is not an investment advisor, broker or dealer and therefore does not participate in the offer, sale or distribution of securities, nor does it provide any investment advice. 

Beginner 

Advanced 


PMS mapping in 2 parts (API or flat files)

Transactions FILE :

manager_id

client_id

client_pseudonym

portfolio_id

portfolio_title

portfolio_currency

transaction_id

transaction_datetime

transaction_type

transaction_price

last_price

last_price_datetime

cotation_type (absolute or percentage)

currency

quantity

mic

figi

isin

symbol

name

asset_class

industry_classification

country

description

expiration_date

contract_number

contract_size

net_amount

exchange_rate

fees (can be sudivised into multiple fields)

taxes (can be sudivised into multiple fields)


Positions FILE :

manager_id

client_id

client_pseudonym

portfolio_id

portfolio_title

portfolio_currency

portfolio_last_change_datetime

portfolio_performance

mic

figi

isin

symbol

contract_number

contract_size

name

expiration_date

asset_class

industry_classification

country

currency

last_price

last_price_datetime

cotation_type (absolute or percentage)

quantity

average_execution_price

average_execution_exchange_rate

cash_reference_currency

cash_amount

Did this answer your question?