HELP SAMPLE REPORT Try it free

Accounting

Calculating Realised P&L Across Venues: FIFO, Multipliers and Assignment

The trade is closed and the cash is in, so the profit should be beyond argument. It rarely is.

Realised P&L sounds like the one number that should be beyond argument — the trade is closed, the cash is in. In practice it is where reconciliations most often fail, because "what did I actually make" depends on lot-matching rules, a contract multiplier, and whose figures you trust for derivatives.

FIFO, and why the method changes the answer

Sell part of a holding built over time and something must decide which shares left. FIFO — first in, first out — matches each sale against your earliest open lots. It is the common default and the one most brokers report.

Same sale, different answers. You bought 100 at $50, later 100 at $70, then sold 100 at $80.
FIFO: matched against the $50 lot → realised +$3,000, remaining lot cost $70.
LIFO: matched against the $70 lot → realised +$1,000, remaining lot cost $50.
Identical cash, identical position, a $2,000 difference in reported profit — and a different unrealised figure carried forward.

Neither is wrong. But mixing methods across venues, or against your broker's reporting, guarantees numbers that never tie out.

The ×100 multiplier

Options are quoted per share and traded per contract of 100. Miss the multiplier and every option line is off by two orders of magnitude:

option P&L = (exit price − entry price) × 100 × contracts
Sold at $6.40, bought back at $2.10, 3 contracts → ($6.40 − $2.10) × 100 × 3 = +$1,290

Obvious stated plainly, and still one of the most frequent errors in hand-built tracking — usually because a CSV export lists per-share prices and the multiplier is applied inconsistently.

Short positions realise backwards

Selling to open means you profit when you buy back lower. Applying the long convention to a short leg flips the sign on every premium-selling trade you have ever made. For a short option the realised figure is entry minus exit, times the multiplier — and an option that expires worthless realises the full premium with no closing trade at all, which is exactly the row that tends to go missing.

Expiry, assignment and exercise

Three closes that produce no closing trade, and therefore no obvious row to record:

Expired worthless. Short option realises the entire premium. Nothing arrives from the venue to tell you.

Assigned on a short put. The option is not realised as a gain in isolation — it converts into a stock lot. The premium properly reduces the basis of the shares you now hold.

Called away on a short call. The shares are sold at the strike. Realised P&L is strike minus share basis, and the call premium is separate income.

These conversions are why option and stock P&L cannot be reconciled in isolation. A cycle that starts as an option and ends as stock has to be followed across the transition or the premium ends up in one bucket and the shares in another.

Derivatives: take the venue's number

For perps and similar, do not re-derive P&L with FIFO. Funding payments, mark conventions and fee treatment vary by venue, and any independent reconstruction will disagree with the account you are checking against. Use the venue's own realised figure so your total is reconcilable against its interface. Consistency with the source beats theoretical purity.

What a defensible realised figure requires

One lot-matching method applied everywhere. The ×100 multiplier on every option line. Correct sign convention for shorts. Expiries and assignments recorded even though nothing traded. Venue-reported figures for derivatives. Fees handled consistently — and stated, since most quick calculations quietly omit them.

None of it is difficult. It is just unforgiving: any single one of those omitted produces a total that looks plausible and is wrong, which is considerably worse than one that is obviously broken.

Frequently asked questions

What is FIFO cost basis?

First in, first out: each sale is matched against your earliest open lots. It is the common default and what most brokers report, and it determines both realised profit and the basis carried forward.

Why is my option P&L off by 100x?

The ×100 contract multiplier is missing. Options are quoted per share and traded per 100-share contract, so every option line needs it applied.

How do I record an option that expired worthless?

A short option that expires realises the full premium, even though no closing trade occurs. It has to be recorded deliberately — nothing arrives from the venue to prompt it.

How is assignment treated for realised P&L?

It is a conversion, not a realisation. The short put becomes a stock lot, and the premium collected properly reduces the basis of those shares.

Should I recalculate perp P&L myself?

No. Funding, mark and fee conventions differ by venue, so use the venue's own realised figure. That keeps your total reconcilable against the account you are checking.

Stop losing the thread at the first roll. RiskGlass keeps brokerages, exchanges, wallets and venues in one book, with the analytics computed on top.

Open the live demo — no signup

Educational only. Nothing here is investment, financial, legal or tax advice, and none of it is a recommendation to trade. Figures are worked examples, not forecasts. Verify against your broker before acting.