Transform Transactions to Standard Configuration

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

 

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

   

 Go to see you Task Status 

 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 

 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