Excel Share Portfolio Model Interactive Brokers ('IB') live data
Budget: ₹750 – ₹1,250 INR
I am looking for someone to create an excel model that can automatically connect to an Interactive Brokers ('IB') account DDE/excel feed to provide:
1. High-level portfolio Net Asset Value ('NAV') Reconciliation:
1a. Share Portfolio: Start balance, purchases, sales, realised/unrealised gains/losses (split between fx and underlying), dividends received, closing Market Value
1b. Account NAV: take closing Market Value from 1a above, and include fees/expenses paid to result in closing Account NAV agreeing to IB live market value.
1. High-level portfolio Net Asset Value ('NAV') Reconciliation:
1a. Share Portfolio: Start balance, purchases, sales, realised/unrealised gains/losses (split between fx and underlying), dividends received, closing Market Value
1b. Account NAV: take closing Market Value from 1a above, and include fees/expenses paid to result in closing Account NAV agreeing to IB live market value.