Skip to main content

Transform Transactions to Standard Configuration

Precondition: You downloaded some Transactions from Exante (Check your /explorer/data/exante/transactions folder)

Go to Worfklow Page

Screenshot 2024-09-28 at 00.42.51.png

Run Task  com.finmars.exante-data-transformer:transform-transactions

 

Screenshot 2024-09-28 at 00.43.55.png

Go to see you Task Status

Screenshot 2024-09-28 at 00.45.19.png

So all your downloaded Transactions files from Exante should be packed into one .json file that converted to Standard Configuration

You shall able to see it in 

/explorer/data/general/transactions

data/general - is a folder where data accumulates from all the sources, we keep transformed data there
Screenshot 2024-09-28 at 00.46.46.png

Example Content

[
    {
        "source_origin": "exante",
        "source": "Exante",
        "account_cash": "ABCD1234.001",
        "account_cash_to": "-",
        "account_interim": "-",
        "account_position": "ABCD1234.001",
        "account_position_to": "-",
        "accrued_price": "-",
        "accrued_price_multiplier": 1,
        "allocation_pl": "-",
        "broker_fee_with_sign": 0,
        "carry_with_sign": 166.46,
        "cash_consideration_with_sign": 166.46,
        "cash_movement_fx_adjusted": 0,
        "charges_with_sign": 0,
        "commission_with_sign": 0,
        "counterparty": "-",
        "date_accounting": "2024-09-05",
        "date_change": "2024-09-05",
        "factor": 1,
        "fees_with_sign": 0,
        "forward_buy_leg": "-",
        "forward_sell_leg": "-",
        "fx_account_buy": "-",
        "fx_account_sell": "-",
        "fx_amount_buy": "-",
        "fx_amount_sell": "-",
        "fx_currency_buy": "-",
        "fx_currency_sell": "-",
        "fx_rate": 1,
        "fx_rate_reverse": 1,
        "if_reverse": "-",
        "instrument": "US92206C8709",
        "is_canceled": false,
        "isin_code": "-",
        "linked_instrument": "-",
        "notes": "DIVIDEND",
        "notes_front_office": "-",
        "notes_middle_office": "-",
        "other_charges_with_sign": 0,
        "portfolio": "ABCD1234.001",
        "portfolio_to": "-",
        "position_adjusted_with_sign": 0,
        "position_nominal_with_sign": 0,
        "pricing_currency": "USD",
        "principal_price": 0,
        "principal_price_multiplier": 1,
        "principal_with_sign": 0,
        "ref_tr_code": "-",
        "responsible": "-",
        "selector": "Dividend",
        "settlement_currency": "USD",
        "stamp_duty_with_sign": 0,
        "strategy1": "-",
        "sub_type": "-",
        "tax_with_sign": 0,
        "tax_withholding_with_sign": 0,
        "trade_date": "2024-09-05",
        "trade_price": 0,
        "transaction_code": "1b7f5128-4bf9-4766-8ac2-12ff79ded491",
        "value_date": "2024-09-05",
        "vat_with_sign": 0
    }
]




Great, so this file will be dispatched to Standard Import (see schema com.finmars.standard-import-from-file:txn)  STD - TXN

P.S. Before we able to import Transactions, we must ensure that all Instruments/Currencies already present in Space. So after it, you free to import file either manually or via Standard AutoImport Schedule

Back to top