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.

3 tables · 5 views · 1 form · 4 automations · sample rows included, so it opens looking like a working app

Use this template

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

Forms

Automations

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.

More Finance & legal templates

All templates