Binance connection for LinkyFlow

LinkyFlow brings Binance data into Excel with 17 workflows for market analysis, wallet monitoring, and reporting without switching tools.

Resources

Read requests

Write actions

Documented fields

153

Workflows you can move into Excel

Each resource below maps to a practical spreadsheet workflow. Read actions bring useful columns into Excel; create and edit actions show what can be reviewed in rows before sending changes.

Account data

Get My Balances

Fetch my account balances (free, used, total)

Read

Get My Balances

Fetch my account balances (free, used, total)

Route: GET /myBalances

Excel formula: =LF.binance.myBalances("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`onlyPositive`	boolean	No	Filter to show only positive balances Default: true

Data returned in Excel

Field	Type	Relations	Description
`asset`	enum	—	-
`debt`	number	—	-
`free`	number	—	-
`total`	number	—	-
`used`	number	—	-

Get My Deposits

List my deposit history

Read

Get My Deposits

List my deposit history

Route: GET /myDeposits

Excel formula: =LF.binance.myDeposits("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT Values: ETH, LTC, BNB, NEO, QTUM
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`address`	string	—	-
`addressFrom`	string	—	-
`addressTo`	string	—	-
`amount`	number	—	-
`comment`	string	—	-
`currency`	string	—	-
`datetime`	string	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`fee_rate`	number	—	-
`id`	id	—	-
`status`	string	—	-
`tag`	string	—	-
`tagFrom`	string	—	-
`tagTo`	string	—	-
`timestamp`	date	—	-
`txid`	string	—	-
`type`	string	—	-
`updated`	number	—	-

Get My Orders

List my open and closed orders

Read

Get My Orders

List my open and closed orders

Route: GET /myOrders

Excel formula: =LF.binance.myOrders("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`symbol`	string	Yes	Trading symbol or market pair, e.g. BTC/USDT
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`amount`	number	—	-
`average`	number	—	-
`clientOrderId`	string	—	-
`cost`	number	—	-
`datetime`	string	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`filled`	number	—	-
`id`	id	—	-
`lastTradeTimestamp`	date	—	-
`lastUpdateTimestamp`	date	—	-
`postOnly`	boolean	—	-
`price`	number	—	-
`reduceOnly`	boolean	—	-
`remaining`	number	—	-
`side`	string	—	-
`status`	string	—	-
`stopLossPrice`	number	—	-
`stopPrice`	number	—	-
`symbol`	string	—	-
`takeProfitPrice`	number	—	-
`timeInForce`	string	—	-
`timestamp`	date	—	-
`trades`	string	—	-
`triggerPrice`	number	—	-
`type`	string	—	-

Create

Create Order

Route: POST /postTrade

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`price`	number	No	-
`side`	enum	Yes	Values: BUY, SELL
`symbol`	string	Yes	-
`timeInForce`	enum	No	Values: FOK, GTC, GTD, GTX, IOC
`type`	enum	Yes	Values: LIMIT, LIMIT_MAKER, MARKET, STOP, STOP_LOSS

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Get My Trades

Retrieve my trade history

Read

Get My Trades

Retrieve my trade history

Route: GET /myTrades

Excel formula: =LF.binance.myTrades("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`symbol`	string	Yes	Trading symbol or market pair, e.g. BTC/USDT
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`amount`	number	—	-
`cost`	number	—	-
`datetime`	string	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`id`	id	—	-
`order`	id	→ myOrders	-
`price`	number	—	-
`side`	string	—	-
`symbol`	string	—	-
`takerOrMaker`	string	—	-
`timestamp`	date	—	-
`type`	string	—	-

Get My Withdrawals

List my withdrawal history

Read

Get My Withdrawals

List my withdrawal history

Route: GET /myWithdrawals

Excel formula: =LF.binance.myWithdrawals("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT Values: ETH, LTC, BNB, NEO, QTUM
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`address`	string	—	-
`addressFrom`	string	—	-
`addressTo`	string	—	-
`amount`	number	—	-
`comment`	string	—	-
`currency`	string	—	-
`datetime`	string	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`fee_rate`	number	—	-
`id`	id	—	-
`status`	string	—	-
`tag`	string	—	-
`tagFrom`	string	—	-
`tagTo`	string	—	-
`timestamp`	date	—	-
`txid`	string	—	-
`type`	string	—	-
`updated`	number	—	-

Futures

Get Funding Rate

Retrieve the current funding rate for the given perpetual contract symbols

Read

Get Funding Rate

Retrieve the current funding rate for the given perpetual contract symbols

Route: GET /getFundingRate

Excel formula: =LF.binance.getFundingRate("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbols`	string	Yes	Futures/perpetual contract symbols, e.g. BTC/USDT:USDT

Data returned in Excel

Field	Type	Relations	Description
`fundingRate`	number	—	-
`fundingTimestamp`	date	—	-
`indexPrice`	number	—	-
`markPrice`	number	—	-
`nextFundingRate`	number	—	-
`symbol`	string	—	-

Get My Futures Balances

Fetch my futures (swap) wallet balances (free, used, total)

Read

Get My Futures Balances

Fetch my futures (swap) wallet balances (free, used, total)

Route: GET /myFuturesBalances

Excel formula: =LF.binance.myFuturesBalances("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`onlyPositive`	boolean	No	Filter to show only positive balances Default: true

Data returned in Excel

Field	Type	Relations	Description
`asset`	enum	—	-
`free`	number	—	-
`total`	number	—	-
`used`	number	—	-

Edit

Margin Mode

Route: PATCH /setMarginMode

Inputs you can set

Name	Type	Required	Description
`marginMode`	enum	Yes	Values: isolated, cross
`symbol`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Get My Positions

List my open futures positions with P&L and risk metrics

Read

Get My Positions

List my open futures positions with P&L and risk metrics

Route: GET /myPositions

Excel formula: =LF.binance.myPositions("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`symbols`	string	No	Futures/perpetual contract symbols, e.g. BTC/USDT:USDT

Data returned in Excel

Field	Type	Relations	Description
`collateral`	number	—	-
`contracts`	number	—	-
`contractSize`	number	—	-
`datetime`	string	—	-
`entryPrice`	number	—	-
`initialMargin`	number	—	-
`leverage`	number	—	-
`liquidationPrice`	number	—	-
`maintenanceMargin`	number	—	-
`marginMode`	enum	—	-
`markPrice`	number	—	-
`notional`	number	—	-
`percentage`	number	—	-
`side`	string	—	-
`symbol`	string	—	-
`timestamp`	date	—	-
`unrealizedPnl`	number	—	-

Create

Futures Order

Route: POST /postFuturesTrade

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`leverage`	number	No	-
`marginMode`	enum	No	Values: isolated, cross
`price`	number	No	-
`reduceOnly`	boolean	No	-
`side`	enum	Yes	Values: BUY, SELL
`symbol`	string	Yes	-
`timeInForce`	enum	No	Values: FOK, GTC, GTD, GTX, IOC
`type`	enum	Yes	Values: LIMIT, LIMIT_MAKER, MARKET, STOP, STOP_LOSS

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Leverage

Route: PATCH /setLeverage

Inputs you can set

Name	Type	Required	Description
`leverage`	number	Yes	-
`symbol`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Position

Route: DELETE /closePosition

Inputs you can set

Name	Type	Required	Description
`side`	string	No	-
`symbol`	string	Yes	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Market data

Get OHLCV

Get historical candlestick (OHLCV) data for given symbols

Read

Get OHLCV

Get historical candlestick (OHLCV) data for given symbols

Route: GET /getOHLCV

Excel formula: =LF.binance.getOHLCV("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbol`	string	Yes	Trading symbol or market pair, e.g. BTC/USDT
`timeframe`	enum	No	Granularity of candlestick data Default: 1d Values: 1s, 1m, 3m, 5m, 15m
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`close`	number	—	-
`high`	number	—	-
`low`	number	—	-
`open`	number	—	-
`openTime`	date	—	-
`volume`	number	—	-

Get Order Book

Fetch current order book (bids & asks) for given symbols

Read

Get Order Book

Fetch current order book (bids & asks) for given symbols

Route: GET /getOrderBook

Excel formula: =LF.binance.getOrderBook("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbol`	string	Yes	Trading symbol or market pair, e.g. BTC/USDT
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`amount`	number	—	-
`price`	number	—	-
`symbol`	string	—	-
`type`	string	—	-

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Read

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Route: GET /getTicker24h

Excel formula: =LF.binance.getTicker24h("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbols`	string	Yes	List of trading symbols or market pairs, e.g. BTC/USDT, ETH/EUR

Data returned in Excel

Field	Type	Relations	Description
`ask`	number	—	-
`askVolume`	number	—	-
`average`	number	—	-
`baseVolume`	number	—	-
`bid`	number	—	-
`bidVolume`	number	—	-
`change`	number	—	-
`close`	number	—	-
`datetime`	string	—	-
`high`	number	—	-
`indexPrice`	number	—	-
`last`	number	—	-
`low`	number	—	-
`markPrice`	number	—	-
`open`	number	—	-
`percentage`	number	—	-
`previousClose`	number	—	-
`quoteVolume`	number	—	-
`symbol`	string	—	-
`timestamp`	date	—	-
`vwap`	number	—	-

Trading

Get Trades

Retrieve recent trades for given symbols

Read

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

Excel formula: =LF.binance.getTrades("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbol`	string	Yes	Trading symbol or market pair, e.g. BTC/USDT
`since`	date	No	Fetch data starting from this timestamp
`limit`	number	No	Maximum number of records to fetch

Data returned in Excel

Field	Type	Relations	Description
`amount`	number	—	-
`cost`	number	—	-
`datetime`	string	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`id`	id	—	-
`order`	id	→ myOrders	-
`price`	number	—	-
`side`	string	—	-
`symbol`	string	—	-
`takerOrMaker`	string	—	-
`timestamp`	date	—	-
`type`	string	—	-