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!