Automated trading journal for retail Investors

Automated trading journal for Retail Investors

A trading journal is very important to improve your trading success rate. This trading journal will track your trade and help you to analyze your average profit, average losses, best trading time for winning trades, time for your losing trades, Best trading days, bad trading days. Best stock of winning trades, Bad stocks for losing trades. So how it will improve your profits. 

Our Automated excel sheet for nifty options

Advance nifty option trading automated excel sheet with back Testing 

Download the trading journal excel sheet free

How to fill data in trading journal

1. Every data point is important in this excel sheet. If you don't want to fill the data don't trade in the stock market because this is a small improvement step for your trading or investment career.
2. Fill your starting account balance - fill your daily target - fill no of the month.
3. Fill data & time according to your trade.
4. Enter your position type long or short. Short trade can be executed in the future and options. Long trade can be executed in every stock available in the stock market.
5.  Enter the stock name and entry price.
6. Stock entry price should be stock support level if you are taking long trade & resistance level if you take a short trade
7. Support can be moving average - VWAP - Fibonacci level - or some patterns like rounding bottom- double top- double bottom. Try to find the reason for entry in trade writes the same reason in the trade note column.
8. Stop loss and take profit will decide your risk to reward ratio.
9. Check the total % of capital at risk. Never exceed the risk on your total amount greater than 2 % 
10. Fill every data. Data help in your trading decisions. It will increase your confidence.

How this trading journal will help 

1. It will analyze your average profits and losses - you will be realistic about trading. Try to decrease your losses and increase your profits. Reduce your stop losses increase your target.
2. Analyze your winning trade time and losing time: Try to increase your position size in winning time and don't trade in losing time. It will increase your average profits and reduce your average losses.
3. Analyze your winning trade by stock price: Trade-in price range where you got maximum no of winning trade. Datapoint will increase your confidence during trading.
4. Analyze your losing trade by stock price: Avoid trad in the price range where you got a maximum of losing trades. analyze the data every week Repeat this process to improve your average profits.
5. Analyze your profitable day. This data will improve your average profit. Try to avoid trading when you earn the least. This will increase your trading profitability by 20%.

Please share your suggestions or improvements.

Smart money vs Dumb money in the Stock market

If you are a stock trader or investor answer this question?

Supply and demand in the stock market

when did the bull market start? identify the starting point of the bull market