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!
