Intraday Trading System for Equities in Excel

#15
Attached herewith Intraday Trading System for Equities in Excel. There are total 3 logics. Try to understand the logic. Play safe.

DOWNLOAD
Seems interesting, but not able to understand the logic. Please explain...
 

suri112000

Well-Known Member
#17
LOGIC ONE (Refer Sheet 2 on the excel)

Say for example the price of XYZ scrip at 09:20 AM is Rs.200.

Enter this value in Yellow Box and press enter. You will buy price and buy target and sell price and sell target.

For a price of Rs.200, I have the following values,

buy at 200.50 and buy target 203.50
Sell at 199.50 and sell target 196.50

So, at 09:20 AM, you should place the buy and sell orders (both of them) with position size 10 shares (if your capital is more you can suitably choose your initial position size).

So, now the orders are placed. Now, either buy order or sell order gets executed.

If buy order is executed, immediately place Stop Loss order at 199.50 with a position size of 20 shares. In case, buy target is reached without hitting stop loss, book your profit on 10 shares. Cancel all other orders.


In Case, Stop Loss is hit, you have a new sell position with 10 shares (10 shares which you bought earlier get squared off and new sell position of 10 shares is executed).

Now, immediately place a Stop Loss order at 200.50 with a position of 30 shares. In case, profit target is hit book profits. In case Stop Loss gets hit, now we have a fresh buy position with 20 shares.


Likewise sequence follows.


Logic 2 and Logic 3 can easily understood, if you understand logic 1.


All the best.