ExcelFree · no sign-upIntraday and cash equity

Cash Equity (CNC) Swing Journal

A 14-column Excel log for delivery (CNC) swing trades, with entry and exit dates, days held, STT, net P&L and R-multiple for each position.

The .xlsx opens in Excel, LibreOffice or Google Sheets (upload it to Drive, then open with Sheets). Delete the sample row before you log real trades.

See a worked example →
Trade Log
Entry DateExit DateSymbolQtyEntryExitDays HeldNet P&LR-Multiple
28/05/202604/06/2026TCS40382039455+4,6551.94
01/06/202610/06/2026INFY60156015227−2,486−0.92
Illustrative delivery trades. Net P&L includes STT of 0.1% on both buy and sell.
FormatExcel (.xlsx)
Trade Log sheet14 columns
Best forDelivery swing traders
Fill itEach exit

What is inside

Swing trades need the date in and the date out, because time in the position is part of the result. A 2R winner held for five sessions and one held for six weeks are different trades.

Keep this book separate from F&O. Delivery gains are taxed as capital gains (short-term at 20% when held under 12 months), while F&O income is business income at slab rates.

Trade Log · 14 columns

One row per swing position.

  • Entry Date
  • Exit Date
  • Symbol
  • Side
  • Qty
  • Entry
  • Exit
  • Days Held
  • Gross P&L
  • STT
  • Net P&L
  • R-Multiple
  • Setup Tag
  • Notes

Worked example

A five-day breakout swing

Bought 40 TCS shares at ₹3,820 with a stop at ₹3,760 and sold at ₹3,945 five sessions later (illustrative prices).

Planned risk
₹2,400
Gross P&L
₹5,000
Net P&L
+₹4,655
R-multiple
1.94R

Brokerage is taken as zero here; add yours and any DP charge your broker levies on the sell.

The numbers

Risk = (3,820 − 3,760) × 40₹2,400
STT = 0.1% × (buy + sell value)0.1% × (1,52,800 + 1,57,800) = ₹311
Net = 5,000 − STT − other charges5,000 − 311 − 34 = ₹4,655

Formulas to paste in

The download has headers and a sample row, not formulas. These match its column letters.

Days Held (H2)
=NETWORKDAYS(A2,B2)-1
STT (J2), delivery
=(F2+G2)*E2*0.1%
R-Multiple (L2), stop in a helper cell X2
=K2/((F2-X2)*E2)

How to fill it

  1. Log the entry with its stopFill Entry Date, Qty, Entry and your stop on the day you buy.
  2. Complete the row on exitAdd Exit Date, Exit, Days Held, STT and Net P&L.
  3. Tag the setupUse one Setup Tag per trade, such as swing-breakout or pullback.
  4. Review by holding timeSort by Days Held and check whether long holds earn their extra time.

Same review, without the typing

TradeLyser imports trades from supported Indian brokers by sync or CSV, with charges, and shows win rate, profit factor and drawdown for each strategy.

Try TradeLyser free

Read next

Questions traders ask

How are swing trading profits taxed in India?

Listed shares held under 12 months are short-term capital gains taxed at 20% when STT is paid. Held over 12 months, gains above ₹1.25 lakh a year are taxed at 12.5%.

Why separate swing trades from intraday?

Intraday equity is speculative business income and delivery trades are capital gains. Holding periods and costs also differ, so mixing them blurs both results.

Is the Cash Equity (CNC) Swing Journal free?

Yes. The download link on this page needs no sign-up or email. The workbook ships with column headers and one sample row; add your own formulas or use the ones listed on this page.