Portfolio Holdings Tracker template
Instruments, trades, and positions with validated ISIN, MIC, and LEI fields, market-value and P&L formulas, a traded-quantity rollup, and an allocation chart over the live data.
Tables
Instruments
Instrument, ISIN, Listing exchange (MIC), Issuer LEI, Sector, Currency, Last price, Ticker, Asset class, Country of risk, Risk band, Covering analyst, Dividend yield, P/E ratio and 11 more
Trades
Trade #, Instrument, Side, Account, Trade date, Settle date, Quantity, Price, Fees, Gross value, Instrument record, ISIN, Broker, Execution venue and 8 more
Positions
Instrument, Account, Quantity, Avg cost, Market price, Opened on, Market value, Cost basis, Unrealised P/L
Views
- Holdings (grid)
- Allocation (chart)
- Trade calendar (calendar)
- By sector (kanban)
- Trade blotter (grid)
Forms
- Log a trade
Automations
- Notify on new trade
- Push position changes to the risk feed
- “Settled” was ticked in “Trades”
- Large value in “Quantity”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.