Trade Multi Leg Tradier
Places multi-leg option trades (spreads, straddles, iron condors, etc.) through Tradier brokerage. Supports up to 4 legs.
Prerequisites
- Active Tradier brokerage account
- Tradier API connection configured in MarketXLS
- Options trading approval level for the strategy
Parameters
| Parameter | Required | Description |
|---|---|---|
| OrderType | Yes | market, debit, credit, or even |
| Duration | Yes | day or gtc |
| Price | Yes | Net price for spread |
| SymbolOption1-4 | Leg 1 req | OCC option symbols |
| Quantity1-4 | Leg 1 req | Contracts per leg |
| OrderSide1-4 | Leg 1 req | buy_to_open, sell_to_open, etc. |
Common Strategies
| Strategy | Legs | Description |
|---|---|---|
| Vertical Spread | 2 | Same expiry, different strikes |
| Iron Condor | 4 | Sell spread + buy spread |
| Butterfly | 3-4 | ATM short, OTM long both sides |
| Straddle | 2 | Same strike call + put |
WARNING
This function places REAL trades. Always verify parameters before executing.
Examples
Bull Call Spread (debit)
=TradeMultiLegTradier("debit", "day", 2.50, "AAPL240119C00180000", 1, "buy_to_open", "AAPL240119C00185000", 1, "sell_to_open")Bear Put Spread (debit)
=TradeMultiLegTradier("debit", "day", 3.00, "AAPL240119P00185000", 1, "buy_to_open", "AAPL240119P00180000", 1, "sell_to_open")Credit Put Spread
=TradeMultiLegTradier("credit", "gtc", 1.50, "SPY240119P00470000", 1, "sell_to_open", "SPY240119P00465000", 1, "buy_to_open")Iron Condor (4 legs)
=TradeMultiLegTradier("credit", "day", 2.00, "SPY240119P00465000", 1, "buy_to_open", "SPY240119P00470000", 1, "sell_to_open", "SPY240119C00485000", 1, "sell_to_open", "SPY240119C00490000", 1, "buy_to_open")When to Use
- Executing vertical spreads (bull/bear call/put spreads)
- Placing iron condors or iron butterflies
- Trading straddles or strangles
- Any multi-leg options strategy through Tradier
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Single-leg option trade | TradeSingleLegTradier() |
| Stock trade | TradeSingleLegTradier() |
| ThinkOrSwim broker | TradeMultiLegThinkOrSwim() |
| Just need quotes | Option_Last_Price() |
Common Issues & FAQ
Q: What's the difference between debit and credit? A: Debit = you pay money (buying spread). Credit = you receive money (selling spread). Price should match order type.
Q: How do I get OCC option symbols?
A: Use OptionSymbol() to generate proper format: AAPL240119C00180000
Q: Why is my order rejected? A: Check:
- Options approval level
- Margin/buying power
- Valid OCC symbols
- Consistent quantities across legs (for defined-risk strategies)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?