Portfolio Analytics Lab icon

Portfolio Analytics Lab

Simple, transparent portfolio analytics for everyday investors. portfolioanalyticslab.net

Next step

Welcome

Portfolio Analytics Lab brings Trading212 and normalized manual broker or crypto data into one private portfolio workspace.

Start in three steps

  1. Explore with synthetic demo data, or create an account to save your own dashboard.
  2. Connect a read-only Trading212 API key, or import normalized transactions and current positions from another provider.
  3. Run the default current-year refresh. If no Trading212 cache exists yet, PAL automatically loads the available history; use Full refresh later only to repair or deliberately re-fetch it.

What you can review

  • Portfolio value, holdings, PnL, activity and estimated return comparisons.
  • Received-dividend history and a next-12-month calendar that separates announcements from estimates.
  • Forecasting, Decision Quality, Tax Prep, custom charts, asset details and focused reports.
Calculation and data notes

PAL is an analytical beta, not financial or tax advice. Broker credentials are encrypted server-side and are never shown back in the browser. Historical portfolio values and return lines are estimates built from available quantities, cached prices and FX; they are not broker MWRR/TWR. Dividend estimates are not issuer announcements. Display-currency conversion changes the view, not stored account-currency data. Verify important figures against official broker, issuer and tax records.

Value-change badges and benchmark return lines are estimates from available broker, manual, FX and cached market data. They are not broker MWRR/TWR.

Benchmark process: what to expect

Benchmarking is automatic and uses cached public market data where possible.

Recalculates the visible comparison from that month onward.

Portfolio cash-flow & benchmark timeline

Desktop: use Ctrl/Shift-click. Touch: tap the lines you want.

Compares cash invested, dividends, benchmark value and the best available portfolio value line.

Portfolio gain vs benchmark

Gain divided by net invested, with an optional time-linked comparison.

Top current positions

Top current positions by calculated market value in account currency.

LLM portfolio analysis prompt

Copy this to your preferred LLM.



Filters

These filters apply to both positions and PnL. Symbol matching is exact; use semicolons for multiple tickers.

Filtered current positions by market value.

Upcoming dividend calendar

Next 12 months: announced payments and unconfirmed estimates. Event amounts use dividend currency; monthly and annual totals use your display currency and available FX rates.

Dividend analysis uses received dividends from available broker/API data plus manual source inputs. Gross dividends are not calculated unless the source provides them clearly.

Symbol filter uses exact symbol matching. Example: O matches only O. Use semicolon for multiple symbols. When all brokers are selected, monthly/quarterly charts aggregate brokers into one value per period.

Forecast selections and assumptions

Choose the scenario methods and projection inputs. Portfolio value uses total return; dividends are projected separately as income.

Ctrl/Shift-click to select more than one extra line.

Adjust the inputs, then update both forecast charts.

Method assumptions

Forecast computation notes

Portfolio value uses the selected total-return assumption and contribution. Projected dividends are shown as income and are not added again to portfolio value.

Portfolio value forecast. Includes the selected portfolio history method unless hidden, plus any selected extra comparison lines.

Annual dividend forecast. Includes the selected dividend history method unless hidden, plus any selected extra comparison lines.

Forecast calculation detail

Each row shows the selected historical method and any extra comparison lines, including assumptions and exact calculation steps.

Activity / Orders

This tab uses parsed broker order history plus manual source inputs where available. Realized PnL is only as good as the broker/manual data provides, so older sell orders may still be incomplete.

The date filter is applied to the yearly/monthly Activity charts and the orders table below. Symbol filter uses exact matching and supports multiple terms separated by semicolon, comma or space.

Net buy value by year: buys minus sells from broker order history plus manual source inputs where available.

Reported realized PnL by year, only where broker/manual source data provides realized PnL fields. Older sells may exist without reported realized PnL.

Monthly net buy activity to see when cash was deployed or positions were reduced.

Decision Quality

Experimental decision-quality view using available broker data plus manual source inputs. It combines buys, sells, open PnL, reported realized PnL and dividends by symbol. Return charts are shown as percentages, so 1.50 means 150%. Values below -100% usually mean cost basis, FX, ticker history or manual input needs review. This is not tax-grade realized PnL and cannot judge decisions where history is incomplete.

These filters apply to both Decision Quality plots and the table. Symbol filter uses exact matching and supports multiple terms separated by semicolon, comma or space.

Best observed result = reported realized PnL + current unrealized PnL including FX + received dividends.

Best open return %, based on current open position cost basis and current unrealized PnL including FX. Axis labels are percentages.

Worst observed result from the same filtered symbols.

Worst open return % from the same filtered symbols. Axis labels are percentages.

Import another broker or crypto file, or maintain source rows yourself. You can start here without a Trading212 snapshot.

Manual transactions

Use this table for manual buys, sells, dividends, deposits, withdrawals, fees, taxes or FX adjustments from other brokers or corrections. For BUY/SELL/DIVIDEND, symbol is required. If the row is not in account currency, fill currency and fx_rate_to_account_currency.

Example rows:
Dividend: enabled=TRUE, date=2026-03-15, broker=manual_broker, event_type=Dividend, symbol=O, net_amount=25.50, currency=EUR, fx_rate_to_account_currency=1.
Buy: enabled=TRUE, date=2026-03-20, broker=manual_broker, event_type=Buy, symbol=AAPL, quantity=2, price=180, gross_amount=360, currency=USD, fx_rate_to_account_currency=0.92.

Manual positions

Use this for holdings from another broker or manual open-position corrections. Provide either market_value_eur, or quantity + current_price. If the row is not in account currency, fill currency and fx_rate_to_account_currency so values can be converted.

Example row:
enabled=TRUE, broker=manual_broker, symbol=VWCE, quantity=10, average_price=100, current_price=115, market_value_eur=1150, cost_basis_eur=1000, currency=EUR, fx_rate_to_account_currency=1.

Validation warnings

This table is read-only. It does not accept rows. It only shows warnings/errors found in your manual inputs, for example missing date, missing symbol, missing amount, missing FX rate, invalid event type, or a position without enough value fields. If it is empty, no obvious issue was detected.

Tax Prep Hub helps organize investment activity that may be relevant for tax reporting. It is not tax advice, certified tax software, or a guaranteed tax calculator. Verify everything with a qualified tax professional.

Dividends & withholding tax

Shows paid/received account-currency cash. Trading212 gross per share is retained separately in instrument currency; exact net and withholding require explicit broker evidence or official statements.

Broker/app reported realized gains/losses

Reported realized PnL is shown only where broker/manual source data provides it. Sells without reported realized PnL are review-required.

Tax readiness checks

Accountant review summary



LLM / accountant prompt



Questions for accountant

Export Tax Prep Workbook

Download annual statements, dividend reports, transaction reports and cash statements directly from each broker, then compare them with this workbook before filing or sending anything to an accountant.

Creates one Excel workbook with summary, dividends, withholding tax, reported realized PnL, fees/FX/cashflows, classifications, checks, prompts and assumptions.

Self-Service Charts

Create quick exploratory charts from any dashboard table. Choose X and Y, then optionally split the plot by one useful category such as broker, year, sector or asset type.

Save up to 5 builder setups. Saved setups fill the builder controls; saved chart slots below are the charts that load automatically for signed-in accounts.

Review and organize assets

Check asset identities, maintain your labels and save changes before refreshing the dashboard. Provider metadata stays separate and cannot silently replace protected user classifications.

Admin diagnostics

Visible only to configured admin emails. Use this page to check hosted health, shared cache growth, price-backfill failures and recent hosted jobs.