Multi-Leg Validation
Validates multi-leg options trade parameters.
Syntax
=MultiLegValidation(TradeType, Quantity, OrderSide, Price, Duration)Parameters
tradeTypestringRequired
Type of trade
quantitynumberRequired
Trade quantity
orderSidestringRequired
Buy or Sell
pricenumberRequired
Trade price
durationstringRequired
Order duration
Returns
string
Validation result
Examples
=MultiLegValidation("Spread", 10, "Buy", 1.50, "Day")When to Use
- Options spread validation
- Trade order verification
When NOT to Use
| Scenario | Use Instead |
|---|
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
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?