My Trading Journal used to be real-time tracking of profits and Loss using Excel RTD function in 2010.
After Yahoo Finance stopped providing real-time stock data, I had to manually
update the stock price inorder to know if the stock is currently making money
or losing.
After some thought, decided to do manually input for buy, sell and cutloss level.
Redo the formulae to reflect the changes to the clearing fees, GST over the years.
Revised Journal has been using for more than a decade to keep track of trade
performance without fail.
Below is an sample entries on how I would keep track of each transaction over
the time.
(click image to enlarge)
A good trading journal allows you to review why you done right or wrong on certain
trades.
Rewind back to the point in time on chart, plot the "buy" and "Sell" order on the past
historical chart, allow me to review past good trades or bad trades taken and what need
to be done for future trades.
