A paper trade can show a virtual gain without showing every cost. This paper trading transaction costs worksheet separates the price-change calculation from the hypothetical commissions and fees you choose to record. It is a one-trade bookkeeping exercise—not an estimate of what a live trade would have earned.
All prices, quantities and costs below are fictional. You need only a notebook or spreadsheet; no account, live order or market quote is required. If you start with a simulator's reported P/L instead, first check its documentation: which costs does that figure already include, what are its units, and is the result realized or still open? When those details are unknown, leave the adjusted result blank rather than inventing a comparable number.
Gross vs. net virtual P/L: what are you calculating?
For this simple fictional long position, gross price-change P/L is (exit price − entry price) × quantity, provided the price units, quantity and currency are consistent. The worksheet then subtracts only the invented costs entered here. We call the answer an assumption-adjusted worksheet result, not a platform-defined net P/L or a live-trading result. A loss becomes larger after costs under the same convention.
Some tools let you enter simulated trading commissions, but that is not a complete cost model. TradingView's Replay Trading documentation says that Replay Trading in Bar Replay is separate from TradingView Paper Trading and lets users configure a commission size before starting. That says nothing about commission controls in the Games for Traders game or whether a virtual fill matches a live one. Check the specific tool's current calculation before using its displayed P/L as a starting figure.
Copy the paper trading transaction costs worksheet
This example assumes a fictional instrument quoted in dollars per teaching unit, a closed long position, and a gross figure calculated from the invented prices—not imported from any simulator. The quantity is not a suggested position size. Copy the empty column into your notes and write unknown where the tool or fee basis is not documented; a blank display is not proof that a cost is zero.
| Field | Fictional example | Your paper note |
|---|---|---|
| Price and quantity convention | Dollars per teaching unit; fictional closed long position | |
| Entry price | $100.00 | |
| Exit price | $102.00 | |
| Quantity (teaching units) | 10 | |
| Starting figure and fee status | Gross price-change calculation; no fees included | |
Gross price-change P/L: (exit − entry) × quantity |
$20.00 | |
| Assumed entry commission | $1.00 | |
| Assumed exit commission | $1.00 | |
| Other invented fees: entry $0.50 + exit $0.50 | $1.00 | |
| Total newly entered costs, without double counting | $3.00 | |
Assumption-adjusted worksheet result: gross − entered costs |
$17.00 | |
| Costs already in starting figure? | No simulator figure used; verify if using one | |
| Excluded or unknown | Spread, slippage, partial/missed fills, taxes, emotional stakes |
Here is the whole calculation: ($102.00 − $100.00) × 10 = $20.00; $1.00 + $1.00 + $0.50 + $0.50 = $3.00; $20.00 − $3.00 = $17.00. Those commission and fee amounts are invented inputs, not a broker's rates. A real schedule could charge per order, per unit, as a percentage or with minimums; product, venue, brokerage and jurisdiction matter. Do not carry this $3 assumption into a real product without checking its current terms.
Four checks before subtracting costs
- Identify the starting number. Is it your own gross price-change calculation, a documented fee-adjusted simulator result, or unknown? Do not subtract a commission twice. If its units, contract multiplier or fee inclusion are unclear, stop the comparison and record
unknown. - Write entry and exit separately. Record the assumed commission on each side if your fictional exercise calls for both. Do not quietly turn an undisclosed exit charge into
$0. - Name every other assumption. Keep the invented fee line distinct from execution effects. Do not add a flat spread charge if the spread is already reflected in the entry and exit prices. Without an appropriate model, slippage and taxes belong in the unknown column, not in an invented fee total.
- Label the answer. Write “$17.00 after the costs entered above,” not “this trade would have made $17.00.” Keep excluded items beside the number.
What if the fictional trade shows a loss?
With the same invented $100.00 entry and 10 teaching units, a $99.00 exit gives ($99.00 − $100.00) × 10 = −$10.00 gross. Subtract the same hypothetical $3.00 in entered costs and the adjusted worksheet result is −$13.00. This only illustrates signed arithmetic; it predicts neither a market move nor an account balance.
What the worksheet—and the game—leave out
A commission setting describes only the charge that a particular tool actually applies. It does not tell you the live fill price, guarantee that an order fills in full, or account by itself for spread, slippage, taxes, missed fills and the pressure of risking money. These assumptions vary by product and platform; real trading can lose capital. The Paper Trading Liquidity Practice exercise explores spread and displayed depth separately. Order Execution Quality Practice explains aggregate U.S. stock execution reports, not a personal fee schedule or a forecast for one order.
The Games for Traders Trading Simulator is a historical forex candlestick game. Its public page says it does not account for spreads or broker fees and commissions. Keep this worksheet in your own notes, outside the game: it does not add a fee setting, save a worksheet inside the game, or reproduce live execution.
For the reasons behind a simulated choice, use the Replay Trading Journal to write before the outcome is visible or the broader Trading Journal Template to record a practice session. This worksheet asks a smaller question: which costs did I explicitly assume for this one virtual result, and what remains unknown?
Three questions to take away
- What does my starting virtual P/L already include, and which price, quantity and currency units does it use?
- Which costs are fictional additions, already included, excluded or unknown?
- Have I called the answer an assumption-adjusted practice figure rather than a live outcome?
If the first answer is uncertain, leave the adjusted figure blank. This is an educational exercise, not personalized financial, investment or tax advice or a recommendation to trade. Browse the Articles library for other practice guides.
Source notes: TradingView Replay Trading help (mode distinction and configurable commission size); Games for Traders Trading Simulator (game scope and stated cost omissions). Check current platform documentation before adapting the exercise to a particular tool.