If one takes day trading as a profession, then it is important to keep records carefully. The trading record not only helps to define the net profit-loss but also analyze how well your strategy works. The intraday track can be maintained through excel sheets. Today, we are going to demonstrate the steps of making a day trading profit calculator in excel.
Day Trading Profit Calculator in Excel
This is the easiest way to get started tracking the trades with an excel. First, set up columns for the asset being purchased, the trading time, stock price, the purchased quantity, and the commission. After that, set up similar columns to show what happens when the position is closed out. Finally, calculate the performance based on the change in the security’s price and the and percentage return on your trade.
Here, is the example of excel record.
In order to clarify the concept, here I’ve created an excel sheet which contains important information of day trading. I’ve started the column with SL no, name of the script, Buying price, quantity, total purchase value, brokerage, service tax on brokerage, purchase value, sales rate, sales quantity, gross sells value, brokerage, etc.
CLICK TO DOWNLOAD THE EXCEL FROM HERE.
As I’ve mentioned earlier that keeping the track record is the easiest way, there are few mathematical formulas and tricks with which one can easily track the record. For example, brokerage, service tax, gross sales value, net profit-loss value all are done by certain formula here. You just need to click on the particular figure and the formula will have appeared in the formula bar.
As for example, here I show you how you can get the formula from the formula bar. In the above pic, the total purchase value is calculated by buying rate of a stock multiplied by quantity. As you can see the formula is displayed in the formula bar (C3*D3).
The profit-loss tracker works best for day trader but long term investors also apply the same strategy to keep track record of their investment.