BLOG

0 views

Paper Trading Journal Template India: Excel Download and Guide

A paper trading journal template is a spreadsheet for logging trades made with virtual money. For Indian markets, it records the NSE or BSE symbol, simulated entry and exit prices, quantity, stop, assumed costs and net result in rupees. Use the Excel template

Paper Trading Journal Template India: Excel Download and Guide

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

  1. Set your capital and rules on the Assumptions sheet.
  2. Plan the trade before you place it: entry, stop, target and quantity.
  3. Record the simulated fill and your assumed costs in the Trade Log.
  4. Check the Dashboard after each session or batch of trades.
  5. 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:

  1. Which trades followed my plan, and which did not?
  2. What was my biggest mistake: entry, stop, size, exit or costs?
  3. Did any loss exceed planned risk, and why?
  4. Which strategy tag did best and worst, and is the sample large enough to say?
  5. What did costs change compared with gross results?
  6. 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.

Questions readers ask

Can I use the template in Google Sheets?

Yes, you can import the .xlsx file through Google Drive or File, then Import. After importing, compare the Dashboard with the sample rows: net P&L should read ₹3,895. Fix any formula that does not match before using the sheet for your own trades.

Can I record NIFTY and BANK NIFTY options paper trades?

Yes. Set the segment to Options and enter the quantity as lots × lot size. Write the strike, call or put, and expiry in the Symbol column. The sheet does not know lot sizes, so look up the current value on NSE and enter it yourself.

Does the template calculate simulated profit and loss?

Yes. It calculates gross P&L, net P&L, planned risk, R-multiple, cumulative P&L and drawdown from the cells you fill. You enter the prices, quantity and costs. Check the formulas against the sample rows once.

Does the template calculate brokerage and other charges?

No. You enter an assumed cost for each row. The sheet does not look up brokerage, STT, GST or other charges, and those change over time. Check your broker's current charges and label the figure as an assumption.

How many paper trades should I review before evaluating a strategy?

There is no magic number. A small sample can mislead, because a few wins or losses can come from chance. Review in batches that used the same rules, and look at plan adherence as well as profit.

Can paper trading results predict live trading profits?

No. Simulated fills, missing costs and the absence of real-money pressure mean practice results may not carry over. Use paper results to test your process, not to forecast income.