Required Account Management,Account Reconciliation,Excel VBA,Financial Accounting,Microsoft Excel freelancer for Project: Creating VBA/Marcos for Trade line up generation, Portfolio and SOD file calculations. job

1. Trade lineup generation.
This is aggregate calculation of values to be traded for portfolio of securities for all clients put together, based on
a. assigned portfolio weights,
b. Total value to be traded
c. Type of securities.

2. Trade allocations to be done to assign break up of traded securities for each client to their sub account.

3. Client portfolio numbers, to be calculated and constantly updated based on market price, addition/subtraction. Calculated values would be:
a. Time weighted return,
b. Unrealised + Realised Gains (actuals and percentages)
c. Inventory Levels

Skills & Expertise Required

Account Management Account Reconciliation Excel VBA Financial Accounting Microsoft Excel