Trading Journal Template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 39
At a glance
Powered by AI
The document contains details of various trades in stocks, futures, options and cash markets over multiple dates. It includes information like instruments traded, buy/sell quantities, entry/exit prices, profits/losses, remarks etc.

Stocks, futures, options and cash are mentioned as instruments traded. Specific stocks like JSW Steel and Bank Nifty futures/options are also listed.

Details provided about trades include buy/sell type, quantities, entry/exit prices, profits/losses, stop-losses triggered, remarks on entry and exit among others.

Date Time

3/16/2021 9.21 TO 9.25


3/16/2021 9.32 TO 9.43
3/23/2021 2.25 TO 2.26
3/23/2021 2.30 TO 2.30
3/25/2021 12.30 TO 2.22
4/6/2021 12.25 TO 12.43
4/7/2021 12.09 TO 12.47
4/15/2021 11.18 TO 11.33
4/15/2021 11.20 TO 11.21
5/6/2021 10.20 TO 12.22
5/6/2021 12.20 TO 12.50
6/1/2021 1.20 TO 1.51
6/1/2021 1.51 TO 1.51
6/3/2021 10.51 TO 11.35
6/4/2021 11.25 TO 12.20
6/8/2021 1.28 TO 2.03
6/9/2021 11.25 TO 11.51
6/9/2021 11.51 TO 12.25
Ocks/Futures/Options
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
OPTIONS
CASH
CASH
CASH
CASH
CASH
CASH
CASH
Name of Instrument
BANK NIFTY 35000 PE
BANK NIFTY 35200 CE
BANK NIFTY 34500 CE
BANK NIFTY 35000 CE
BANK NIFTY 32000 PE
BANK NIFTY 32500 PE
BANK NIFTY 33200 CE
BANK NIFTY 31500 PE
BANK NIFTY 31500 CE
BANK NIFTY 32500 PE
BANK NIFTY 32900 CE
JSW STEEL
JSW STEEL
JSW STEEL
JSW STEEL
JSW STEEL
JSW STEEL
JSW STEEL
System BUY/SELL Qty
UNPLANNED BUY 25
UNPLANNED BUY 25
UNPLANNED BUY 25
UNPLANNED BUY 25
PLANNED BUY 50
PLANNED BUY 25
PLANNED BUY 25
PLANNED BUY 25
UNPLANNED BUY 25
PLANNED BUY 25
UNPLANNED BUY 25
PLANNED BUY 100
UNPLANNED SELL 100
PLANNED BUY 100
PLANNED SELL 100
PLANNED BUY 100
PLANNED BUY 200
PLANNED SELL 200
Brokerage Entry price
80 403.50
80 441.00
80 267.45
80 123.00
80 20.58
80 320.30
80 281.40
80 208.00
80 167.10
80 135.60
80 115.95
40 697.40
40 697.95
40 707.85
40 708.65
40 705.55
40 708.80
40 705.80
Exit Price M2M DIFF
363.10 -40.40
404.00 -37.00
279.70 12.25
112.75 -10.25
5.45 -15.13
404.30 84.00
240.65 -40.75
180.05 -27.95
155.95 -11.15
49.45 -86.15
82.20 -33.75
697.25 -0.15
697.50 0.45
712.50 4.65
709.40 -0.75
703.95 -1.60
705.75 -3.05
709.30 -3.50
P&L STATUS
-1,090.00 CLOSED
-1,005.00 CLOSED
226.25 CLOSED
-336.25 CLOSED
-836.25 CLOSED
2,020.00 CLOSED
-1,098.75 CLOSED
-778.75 CLOSED
-358.75 CLOSED
-2,233.75 CLOSED
-923.75 CLOSED
-55.00 CLOSED
5.00 CLOSED
425.00 CLOSED
-115.00 CLOSED
-200.00 CLOSED
-650.00 CLOSED
-740.00 CLOSED

7,745.00
% Returns Initial STOP LOSS
-10.01% 0.00
-8.39% 0.00
4.58% 0.00
-8.33% 0.00
-73.51% 0.00
26.23% 0.00
-14.48% 0.00
-13.44% 0.00
-6.67% 0.00
-63.53% 0.00
-29.11% 0.00
-0.02% 693.91
0.06% 0.00
0.66% 704.00
-0.11% 705.10
-0.23% 703.95
-0.43% 705.75
-0.50% 709.30
SL AMT ON TRIGGER
-10,087.50
-11,025.00
-6,686.25
-3,075.00
-1,028.75
-8,007.50
-7,035.00
-5,200.00
-4,177.50
-3,390.00
-2,898.75
-349.00
69,795.00
-385.00
355.00
-160.00
-610.00
-700.00

5,334.75
EXPOSURE
10,087.50
11,025.00
6,686.25
3,075.00
1,028.75
8,007.50
7,035.00
5,200.00
4,177.50
3,390.00
2,898.75
69,740.00
69,795.00
70,785.00
70,865.00
70,555.00
141,760.00
141,160.00

6,97,271.25
Remarks
UNPLANNED TRADE WI
UNPLANNED TRADE WI
UNPLANNED TRADE WI
UNPLANNED TRADE WI
UNPLANNED TRADE WI
DEMA CROSSOVER,RSI BELOW
BOUGHT
BOUGHT
HED
DEMA & VW
ACCIDENTAL
VWAP-DEMA CROSSE
H&S PATTERN, VW
VWAP-DEMA-PIVOT S1 CROS
VWAP-DEMA-S
INITIALLY WE WANTE
Remarks on exit
UNPLANNED TRADE WITHOUT
UNPLANNED TRADE WITHOUT
UNPLANNED TRADE WITHOUT
UNPLANNED TRADE WITHOUT
UNPLANNED TRADE WITHOUT
MONETARY EXIT: GREEN CANDLE

SHOULD HAS HOLD IT: IT WAS


OVERHELD: DID NOT FOL
EXITED AFTER RED CANDLE CLOSE
ACCIDENTAL SHORT
TARGET HIT
RSI 40 SUPPORT,BULLISH ENGULF
RED CANDLE CLOSED BELOW
S/L HIT
S/L HIT
CASH BUY
FUTURES SELL
OPTIONS
`=IF(C68="OPTIDX",F68/AI68*200,IF(C68="CASH MARKETS",(H68*F68)*(0.5/1
Xyz's P&L for Financial Year 2018-2019
Startup Capital
P&L (Open + Closed Positions)
Exposure (Open Positions)
Mark to Market (Open Positions)

Overall stop loss Hit amt (Open Positions)


EXPOSURE TIMES
Return On Capital Employed in %
PTIDX",F68/AI68*200,IF(C68="CASH MARKETS",(H68*F68)*(0.5/100),IF(C68="FUTURES",F68/AI6
AMOUNT
45,000.00
-7,745.00
0.00
0.00

0.00
0.00
-17.21%
URES",F68/AI68*450)))
ENTRY
EXIT
Sr.No. Mistake

Execution error in putting SL order on Hexaware. In hurry, I picked


day high price instead of closing price due to which the SL order
1
got triggered and I had to exit and re-enter again. This cost me 2
point on the upside in matter of couple of hours

I was manually roll overing the positions due to which was loosing
2 out on quite a few points. Plus did not know about the roll over
possibility when the stock is on ban period
Learning

Write down every orders entry price and SL price clearly. Cross
check for accuracy before execution. Do not be in a hurry to
execute orders especially when travelling or during holiday period

Roll over can be done by the broker either at market price or at


any specific strike price. Call up broker on the rollover day and get
it executed by him instantly

You might also like