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!