Sunday, May 21, 2017

Trading Record - A Must For After Analysis Of Trades: Download Record Sheet

Update of this Post

Trading Journal Is Immensely Important For A Trader.

When I was analysing my trades I felt the need of a trading journal spreadsheet and I formulated a simple spread sheet which helped in keeping the record of the trades done by me. I shared this spreadsheet at my blog, link for which is given below. Over the years need for more deep analysis arose & I found various good resources for keeping trading journal. I have shared these resources in my blog post which you can read here at Trading Journal: The Must Have Tool For A Trader-From A Case Study Perspective.

Below is the basic spreadsheet which you can view after downloading. Some changes will have to be made as new cess have been imposed & transaction costs have changed with passage of time. Also some discount brokers are charging fixed brokerage rates rather than a percent of the total traded value so this also needs to be implemented. Discount brokers have changed the game for the broking industry

You may like to read How to choose best broker for online trading.

My self made amateur trading journal spreadsheet.

Download Excel Trading Journal Spreadsheet here.

Instructions For Help :-

1. Formulas have been inserted for quick record keeping.

2. The user has just to fill the values in the columns of:

A). No: of shares
B). Rate [buy & sell]

3. The brokerage, buy price, sell price, total values, net profit/loss will be calculated automatically.

4. Colour coding has been done for easier recognition of outcome of trades.

5. The rate of brokerage is taken as 0.04% for both legs i.e. [buy-0.02% + sell-0.02% (including taxes)] by default which is most often used by many brokerage houses. However the user can change the rate in the formula bar as per his/her prevailing rate of brokerage.

6. Scrip name, no: of shares, buy/sell rate, transaction date, long/short trades, remarks columns will have to be filled manually. These columns are important for after trade analysis.

7. Example trades have been inserted which can be erased.

8. Please remember not to erase data using backspace from formula cells as the sheet has not been protected for making it user friendly. Only remove data from the columns of no: of shares & buy/sell rate columns and the calculated data will automatically be removed.

1 comment:

Required US Government Disclaimer & CTFC Rule 4.41

Futures trading contains substantial risk and is not suitable for every investor. An investor could potentially lose all or more than the initial investment. Risk capital is money that can be lost without jeopardizing ones financial security or lifestyle. Only consider risk capital that should be used for trading and only those with sufficient risk capital should consider trading. Past performance is not necessarily indicative of future results. CTFC RULE 4.41 – HYPOTHETICAL OR SIMULATED PERFORMANCE RESULTS HAVE CERTAIN LIMITATIONS. UNLIKE AN ACTUAL PERFORMANCE RECORD, SIMULATED RESULTS DO NOT REPRESENT ACTUAL TRADING. ALSO, SINCE THE TRADES HAVE NOT BEEN EXECUTED, THE RESULTS MAY HAVE UNDER-OR-OVER COMPENSATED FOR THE IMPACT, IF ANY, OF CERTAIN MARKET FACTORS SUCH AS LIQUIDITY. SIMULATED TRADING PROGRAMS IN GENERAL ARE ALSO SUBJECT TO THE FACT THAT THEY ARE DESIGNED WITH THE BENEFIT OF HINDSIGHT. NO REPRESENTATION IS BEING MADE THAT ANY ACCOUNT WILL OR IS LIKELY TO ACHIEVE PROFIT OR LOSSES SIMILAR TO THOSE SHOWN. All trades, patterns, charts, systems, etc., discussed in this website or advertisement are for illustrative purposes only and not construed as specific advisory recommendations. All ideas and materials presented herein are for information and educational purposes only. No system or trading methodology has ever been developed that can guarantee profits or prevent losses. The testimonials and examples used herein are exceptional results which do not apply to average people and are not intended to represent or guarantee that anyone will achieve the same or similar results. Trades placed on the reliance of Trend Methods systems are taken at your own risk for your own account. This is not an offer to buy or sell futures interests.