Skip to main content
Version: Streamsheets 3.0

BINANCE.SPOT.ORDER.CANCEL

Premium

Cancel an active order. NOTE: either orderId or origClientOrderId must be specified.

Syntax

=BINANCE.SPOT.ORDER.CANCEL(Symbol, [OrderId], [OrigClientOrderId], [ParametersJSON], [ResponseTarget])

Arguments

NameTypeDescription
SymbolStringSymbol of the digital asset, e.g. BTCUSDT. Please refer to the Binance Docs for a list of supported assets.
OrderId (optional)NumberID of order to cancel. Either this parameter or OrigClientOrderId must be specified.
OrigClientOrderId (optional)StringID of original client order. Either this parameter or OrderId must be specified.
ParametersJSON (optional)JSONJSON which defines additional parameters as key value pairs. See binance api for supported parameters and their values.
ResponseTarget (optional)TargetSpecify inbox, outbox, cell or cell-range to write any response to.

Return

TypeDescription
JSONResponse if successful.

Examples

FormulaResultComment
=BINANCE.SPOT.ORDER.CANCEL("LTCBTC",4,"myOrder1")
JSONCancels order for "LTCBTC" and with id 4.