Excel Input Guide for Algo Trading System

📘 Excel Input Guide for Algo Trading System

This guide explains what to type in Excel to execute, modify, cancel, and exit trades.


📌 1. Understanding the Excel Columns

You will enter trades in the Orders Sheet of ALICE_EXCEL.xlsx.

Column Name Description Example
Row ID Unique identifier for each trade 1, 2, 3
Instrument The stock/index you want to trade NIFTY50, BANKNIFTY, RELIANCE
Transaction Type Trade direction BUY or SELL
Quantity Number of lots/shares to trade 1, 2, 10
Limit Price Price to execute order (0 for Market Order) 19750, 44200, 0
Stoploss (SL) Price at which trade should exit for loss 19650, 44100
Target (TGT) Price at which trade should exit for profit 19850, 44300
Trailing SL Enable trailing stoploss (YES or NO) YES or NO
Status Trade status (for modification/cancel/exit) PENDING, EXECUTED, EXIT, CANCEL

📌 You only need to enter values in the first 8 columns. The system will update the rest.


🔹 2. Placing a New Trade

✅ Example: Market Order (Instant Execution)

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL
1 NIFTY50 BUY 1 0 (Market) 19650 19850 NO

✅ This places a BUY order at market price with SL = 19650 and TGT = 19850.


✅ Example: Limit Order (Buy Below or Sell Above)

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL
2 BANKNIFTY SELL 1 44200 44300 44050 NO

✅ This places a SELL order only when BANKNIFTY reaches 44200.


🔹 3. Modifying an Order

If an order is still pending, you can modify it by changing values in Excel and saving the file.

✅ Example: Modify Order Price from 19750 → 19740

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL
1 NIFTY50 BUY 1 19740 19650 19850 NO

✅ This updates the pending order price to 19740.


🔹 4. Cancelling an Order

To cancel a pending order, type “CANCEL” in the Status column.

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL Status
3 RELIANCE BUY 10 2450 2440 2465 NO CANCEL

✅ This cancels the pending RELIANCE order.


🔹 5. Exiting a Trade

To manually exit an active position, type “EXIT” in the Status column.

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL Status
1 NIFTY50 BUY 1 0 19650 19850 NO EXIT

✅ This exits the trade at market price.


🔹 6. Using Trailing Stoploss (TSL)

To enable TSL, type "YES" in the Trailing SL column.

Row ID Instrument Transaction Type Quantity Limit Price Stoploss Target Trailing SL
4 BANKNIFTY BUY 1 44100 44050 44250 YES

✅ Trailing SL will move up every time price increases.


🎯 Summary: What to Type in Excel

Action What to Type Example
Place Market Order Set Limit Price = 0 BUY NIFTY at market price
Place Limit Order Set Limit Price = Target Price BUY NIFTY at 19750
Modify Order Change Limit Price/SL/TGT Change NIFTY buy price to 19740
Cancel Order Type “CANCEL” in Status CANCEL pending RELIANCE order
Exit Order Type “EXIT” in Status EXIT open NIFTY trade
Enable Trailing SL Type “YES” in Trailing SL TSL enabled for BANKNIFTY

📌 Save the Excel file after making changes for the system to detect updates!


Leave a Reply

STOP LOOSING your hard earned money
Subscribe now to get free demo ID of our software.
Learn Best Intraday Trading Tricks Now !!
    Get Free Demo ID Now
    I agree with the term and condition
    Verified by MonsterInsights