Skip to main content
Version: Streamsheets 3.0

BINANCE.SPOT.ORDER.NEW.TEST

Premium
Experimental

Test placing a new order without any effect.

Syntax

=BINANCE.SPOT.ORDER.NEW.TEST(Symbol, Side, Type, [Quantity], [ParametersJSON], [ResponseTarget])

Arguments

NameTypeDescription
SymbolStringSymbol of the digital asset, e.g. BTCUSDT. Please refer to the Binance Docs for a list of supported assets.
SideBinanceOrderSideCreate either a selling or buying order.

Options:
"BUY": Used to create a buying order.
"SELL": Used to create a selling order.
TypeBinanceSpotOrderTypeThe type of order to create.

Options:
"LIMIT": Used to create an order of type limit.
"MARKET": Used to create an order of type market.
"STOP_LOSS": Used to create an order of type stop_loss.
"STOP_LOSS_LIMIT": Used to create an order of type stop_loss_limit.
"TAKE_PROFIT": Used to create an order of type take_profit.
"TAKE_PROFIT_LIMIT": Used to create an order of type take_profit_limit.
"LIMIT_MAKER": Used to create an order of type limit_marker.
Quantity (optional)NumberThe order quantity.
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.NEW.TEST("BTCUSDT","SELL","MARKET")
JSONTests placing a new selling order without any effects.