What Is a Paper Trading Journal?
A paper trading journal is a record of simulated trades. Each row holds what you planned, what the platform filled and what you learned. Its purpose is to review your decisions, not to track virtual profit. Because the money is not real, the journal also needs to record the assumptions behind each result, such as the cost you assumed and the price source you used. Simulated results do not equal live performance, so the journal helps you practice a process, not forecast returns.
If you are new to journaling, start with what to write down on your first paper trade, then use this template to keep the record over many trades.
How Does It Differ From a Real Trading Journal?
A real journal starts from trades that actually happened, with broker contract notes and real charges. A paper journal starts from your own record of simulated trades, so you must supply the details a contract note would give.
| Point | Paper trading journal | Real trading journal |
|---|---|---|
| Source of fills | Your platform's simulated fills | Exchange-matched orders |
| Costs | Assumed by you, unless the platform models them | Shown on contract notes |
| Slippage | Often small or absent | Can be large in fast markets |
| Psychology | Low pressure | Real money affects decisions |
Record the price your platform filled, note any slippage you assume, and mark costs as assumptions.
Download the Paper Trading Journal Template for India
The template is an Excel workbook (.xlsx) with five sheets: Read Me, Assumptions, Trade Log, Dashboard and Weekly Review. The Trade Log holds 100 rows and calculates gross P&L, net P&L, planned risk, R-multiple and drawdown from the cells you fill. The Dashboard summarises win rate, average win and loss, expectancy, drawdown and plan adherence. Five grey sample rows show how it works. Delete them before you start your own record.
Excel Paper Trading Journal Template
Open the file in Excel and fill the yellow cells. The blue cells calculate. Costs are numbers you enter, because the sheet does not look up brokerage, STT or other charges. Drop-down lists cover segment, direction and discipline tag.
Use the Template in Google Sheets
Upload the .xlsx file to Google Drive and open it with Google Sheets, or use File, then Import. The formulas are common ones (SUM, IF, COUNTIF, AVERAGEIF and MAX). After importing, check the Dashboard against the sample rows: net P&L should read ₹3,895 and maximum drawdown ₹440. If a figure differs, a formula did not convert and needs a fix before you rely on it.
What Should an Indian Paper Trading Journal Include?
A useful journal records the plan before the trade, the fill during it and the outcome after it. The template uses 21 columns. You fill 14 of them, including Notes, and seven calculate. The key columns are below, and the India-specific fields follow.
Essential Trade Log Columns
| Column | Purpose | Sample | Filled by |
|---|---|---|---|
| Trade ID | Groups the legs of one trade | T4-a | You |
| Date | When the simulated trade closed | 05-Nov-2026 | You |
| Symbol | NSE or BSE symbol | SAMPLE EQUITY | You |
| Direction | Long or short | Long | You (list) |
| Quantity (units) | Shares, or lots × lot size | 100 | You |
| Entry price / Exit price | Simulated fills | ₹250 / ₹260 | You |
| Planned stop | Where the idea fails | ₹245 | You |
| Assumed costs (₹) | Your cost assumption | ₹45 | You |
| Gross P&L | (Exit − entry) × quantity; reversed for shorts | ₹1,000 | Calculated |
| Net P&L | Gross P&L minus costs | ₹955 | Calculated |
| R-multiple | Net P&L ÷ planned risk | 1.91 | Calculated |
R is your planned risk on one trade. Here, a ₹500 planned risk and a ₹955 net gain give 1.91R.
India-Specific Fields for NSE and BSE
- Segment: choose Equity, Futures or Options.
- Symbol: write the exchange symbol. For options, add the strike, call or put, and expiry, such as "NIFTY 24500 CE 28-Nov".
- Quantity: for futures and options, enter lots × lot size. The exchange sets lot sizes and revises them, so check the current value on NSE's contract specifications and record the date on the Assumptions sheet.
- Amounts: enter prices and costs in rupees.
Use the Notes column for the expiry or contract detail you need to remember.
Strategy, Emotion and Discipline Fields
Two columns record behavior: a strategy tag, such as Breakout, and a discipline tag, such as Followed plan, FOMO, Revenge trade or Moved stop. They let you ask why a result happened, not only what it was. Tag every trade honestly. A tag is only useful if you apply it when the trade is fresh.
How to Use a Paper Trading Journal in 5 Steps
- Set your capital and rules on the Assumptions sheet.
- Plan the trade before you place it: entry, stop, target and quantity.
- Record the simulated fill and your assumed costs in the Trade Log.
- Check the Dashboard after each session or batch of trades.
- Complete the Weekly Review once a week.
Set Your Virtual Capital and Trading Rules
Enter your starting balance, such as ₹1,00,000, and your planned risk per trade, such as 1%. Your capital feeds the Dashboard's percentage figure. The risk and cost cells are reminders and do not feed formulas, so type the cost on each Trade Log row. The ₹20 cost shown is only a placeholder. Replace it with your broker's current charges. These amounts are illustrations, not recommendations. Keep your rules fixed for a batch of trades so you can compare results fairly.
Record Every Simulated Trade
Add one row per closed trade. If you sell in parts, add one row per exit and give the rows related IDs, such as T4-a and T4-b. Enter the price your platform actually filled, not the price you wanted. Add your assumed costs and pick a discipline tag. The calculated columns fill in at once. Do this the same day, while you remember what you were thinking.
Review Your Performance After Each Session
Open the Dashboard and read four numbers: win rate, average win against average loss, expectancy and maximum drawdown. Then look at plan adherence. A high win rate with a poor adherence score tells you the results came from luck or loose rules. Win rate vs expectancy shows why the first number alone can mislead.
Paper Trading Journal Example for Indian Markets
These two examples are already entered as sample rows in the template. They are hypothetical, and the costs are assumptions, not current tariffs.
Example 1: NSE Equity Paper Trade Calculation
| Input | Value | Calculation |
|---|---|---|
| Entry | ₹250 | Simulated purchase |
| Exit | ₹260 | Simulated sale |
| Quantity | 100 shares | Hypothetical |
| Gross P&L | ₹1,000 | (260 − 250) × 100 |
| Assumed costs | ₹45 | Teaching assumption |
| Net P&L | ₹955 | 1,000 − 45 |
| Planned risk | ₹500 | (250 − 245) × 100 |
| R-multiple | 1.91 | 955 ÷ 500 |
For a short trade, reverse the sign: entry minus exit, times quantity. Selling 50 shares short at ₹800 and buying back at ₹808 loses ₹400 before costs.
Example 2: NIFTY Options Paper Trade
Assume you buy one lot of an index call option at a premium of ₹120 and sell at ₹150. This example uses an assumed lot size of 100 units. That round number is for arithmetic only and is not the real NIFTY lot size. Enter the current value from NSE.
| Input | Value | Calculation |
|---|---|---|
| Entry premium | ₹120 | Simulated purchase |
| Exit premium | ₹150 | Simulated sale |
| Quantity | 100 units | 1 lot × assumed 100 |
| Gross P&L | ₹3,000 | (150 − 120) × 100 |
| Assumed costs | ₹80 | Teaching assumption |
| Net P&L | ₹2,920 | 3,000 − 80 |
| Planned risk | ₹2,000 | (120 − 100) × 100 |
| R-multiple | 1.46 | 2,920 ÷ 2,000 |
The planned stop here is a premium level of ₹100. A real option can lose more than the plan if premium falls fast or the market gaps.
How to Measure Paper Trading Performance
The Dashboard turns your rows into a few measures. Use them to judge process, not to predict returns.
Win Rate, Expectancy and Risk-Reward
- Win rate = winning trades ÷ trades logged.
- Expectancy = (win rate × average win) + (loss rate × average loss), with the average loss shown as a negative number.
- R-multiple = net P&L ÷ planned risk.
The five sample rows give a win rate of 60%, an average win of ₹1,451.67, an average loss of −₹230 and an expectancy of ₹779 per trade. Five trades prove nothing. The numbers only show how the formulas work. The template also shows the average net P&L as a check, and the two figures should match.
Drawdown, Strategy Tags and Consistency
Drawdown is the fall from the highest point of your running net P&L. In the sample rows, the short trade T3 takes the total from ₹3,875 to ₹3,435, so maximum drawdown is ₹440. The Dashboard also adds up trades and net P&L by strategy tag. With few trades per tag, treat those totals as notes, not conclusions.
How Should Indian Traders Model Costs and Execution?
Assume costs and fills that are worse than the simulator's, then record them as assumptions. A simulator may fill your order exactly at your price and charge nothing. Live trading often does neither.
Hypothetical Brokerage, STT and Other Charges
Real trades can carry brokerage, securities transaction tax (STT), exchange charges, GST, SEBI fees and stamp duty. The rates differ by segment and broker, and they change. See how intraday trading charges work for the structure, then check your broker's current rate card. In this template, the cost column is your own estimate per row. It is notional and not a real charge. The Neostox FAQs say its reports include simulated brokerage, fees and taxes, so compare your assumption with what your platform reports.
Slippage, Missed Fills and Unrealistic Results
| Assumption | Effect on results | How to handle it in the sheet |
|---|---|---|
| Perfect fill at your price | Overstates results | Enter the platform's fill, and test a worse price |
| No slippage | Understates losses | Record fill minus stop price in Notes |
| Always filled | Ignores missed orders | Log orders that would not fill as skipped, with a note |
| Zero costs | Overstates net P&L | Enter an assumed cost on every row |
Paper Trading vs Backtesting vs Live Trading
Paper trading tests decisions with simulated orders as the market moves. Backtesting applies rules to past data. Live trading uses real capital and real execution. Each answers a different question, so do not treat them as interchangeable.
| Dimension | Paper trading | Backtesting | Live trading |
|---|---|---|---|
| Market data | Current or replayed | Historical | Current |
| Capital | Virtual | None needed | Real |
| Execution | Simulated, with assumptions | Modeled from rules | Actual |
| Main limitation | Fills, emotions and costs differ | Overfitting and hindsight | Real loss and execution risk |
On Neostox, prices are delayed by 30 days, per its paper trading platform page, so use it to practice process, not market timing. Paper trading vs real trading explains why the same trade can end differently.
How to Review Paper Trades Before Considering Live Trading
No fixed number of trades or profit level proves you are ready. Look for steady process across different market conditions, with costs and slippage included.
Weekly Paper Trading Review Checklist
The Weekly Review sheet asks six questions:
- Which trades followed my plan, and which did not?
- What was my biggest mistake: entry, stop, size, exit or costs?
- Did any loss exceed planned risk, and why?
- Which strategy tag did best and worst, and is the sample large enough to say?
- What did costs change compared with gross results?
- What one rule will I test next week?
If you trade on Neostox, its trading reports let you download the Detailed Trading Report to Excel. Read it next to your journal. A report shows what happened, but only your journal shows what you intended.
Limitations of Paper Trading Results
Simulated results do not predict live results. Fills may be kinder, costs may be missing and the pressure of real losses is absent. A short run of wins can come from luck or from a market phase that will not repeat. Treat the journal as practice for habits, and move to real money only if you choose to, in small size.
This article is for education only and is not investment advice. Neostox profits are virtual and cannot be withdrawn. Simulated results do not indicate how live trading will perform, and trading involves risk of loss. All rupee examples and costs are hypothetical.