Skip to content
Persona: Trading Book

Disguise live sport as a trading book

The Trading Book persona relabels a live match grid as a P&L blotter: each fixture is a trade, the two teams are the instrument and the counterparty, the scoreline reads as P&L, and expected goals (xG) becomes VaR. The live numbers move constantly — a passer-by sees a book being marked, not a scoreboard.

A trading blotter is the one screen where numbers moving every few seconds is not just normal but expected — and where nobody leans over to ask what they mean. That constant, self-explanatory motion makes a trading book an ideal cover for a live match grid.

What it looks like

The sheet titles itself a “Trading Book — P&L”. Rows are trades; the columns read Instrument, Counterparty, State, P&L and Trader, with KPI columns like Exposure %, Fill Rate %, Amendments and Limit Breaches. A goal reads as P&L moving; a red card reads as a limit breach.

The trading book column mapping

Every sports column maps to a trading-book column. This is the exact relabelling the app applies live — here's the before and after:

In the sportOn the “Trading Book” sheet
HomeInstrument
AwayCounterparty
ResultP&L
ScorersDesk Notes
StatusState
LeagueBook
RoundSession
KickoffBooked
VenueDesk
Poss %Exposure %
xGVaR
CardsLimit Breaches

When to use it

Pick the Trading Book if you work in trading, markets, treasury or finance, where a live blotter belongs on your screen. It's also the most credible cover in any environment where fast-moving numbers are the norm — the motion sells itself.

Why it holds up

P&L and exposure move tick by tick, exactly like scores, so the live refresh reads as a book being marked to market rather than a match unfolding. Fouls and cards become Breaks and Limit Breaches — ordinary on any desk. Instrument names reduce to short tickers, the match clock is stripped from the desk-notes memo, and the boss key hides everything behind a Protected View.

Questions

What does the score become in the Trading Book persona?
The scoreline is relabelled as P&L, so a match result reads as a position's profit and loss. It's the same live figure under a blotter header.
What does xG become?
Expected goals (xG) is relabelled as VaR (value at risk), so an advanced football stat reads as a risk figure on the book.
Is the data still live under the disguise?
Yes — the persona only relabels headers and codes cell values; the live scores and standings keep updating underneath.

Try the Trading Book persona

Open the spreadsheet, switch the persona, and the match hides in plain sight. Free, instant, gone in a keystroke.

Disguise Live Sport as a Trading Book — Sport Spreadsheet · Sport Spreadsheet