Binance connection for LinkyFlow

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

Resources

Read requests

Write actions

Documented fields

173

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.

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.

Margin

Get My Borrow Interest

List the interest accrued on my margin borrows

Read

Get My Borrow Interest

List the interest accrued on my margin borrows

Route: GET /myBorrowInterest

Excel formula: =LF.binance.myBorrowInterest("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
`symbol`	string	No	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
`amountBorrowed`	number	—	-
`currency`	string	—	-
`datetime`	string	—	-
`interest`	number	—	-
`interestRate`	number	—	-
`marginMode`	enum	—	-
`symbol`	string	—	-
`timestamp`	date	—	-

Get My Borrow Rates

Current margin borrow interest rates (cross per asset, isolated per pair)

Read

Get My Borrow Rates

Current margin borrow interest rates (cross per asset, isolated per pair)

Route: GET /myBorrowRates

Excel formula: =LF.binance.myBorrowRates("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
`marginMode`	enum	No	Margin mode for the position (isolated or cross) Default: cross Values: isolated, cross

Data returned in Excel

Field	Type	Relations	Description
`currency`	string	—	-
`datetime`	string	—	-
`period`	number	—	-
`rate`	number	—	-
`symbol`	string	—	-
`timestamp`	date	—	-

Get My Margin Balances

Fetch my margin account balances with borrowed debt (cross or isolated)

Read

Get My Margin Balances

Fetch my margin account balances with borrowed debt (cross or isolated)

Route: GET /myMarginBalances

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-
`onlyPositive`	boolean	No	Filter to show only positive balances Default: true
`marginMode`	enum	No	Margin mode for the position (isolated or cross) Default: cross Values: isolated, cross
`symbols`	string	No	List of trading symbols or market pairs, e.g. BTC/USDT, ETH/EUR

Data returned in Excel

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

Create

Margin Order

Route: POST /postMarginTrade

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`marginMode`	enum	No	Values: isolated, cross
`price`	number	No	-
`side`	enum	Yes	Values: BUY, SELL
`sideEffect`	enum	No	Values: NO_SIDE_EFFECT, MARGIN_BUY, AUTO_REPAY, AUTO_BORROW_REPAY
`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

Borrow

Route: PATCH /borrowMargin

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`asset`	enum	Yes	Values: ETH, LTC, BNB, NEO, QTUM
`marginMode`	enum	No	Values: isolated, cross
`symbol`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Repay

Route: DELETE /repayMargin

Inputs you can set

Name	Type	Required	Description
`amount`	number	Yes	-
`asset`	enum	Yes	Values: ETH, LTC, BNB, NEO, QTUM
`marginMode`	enum	No	Values: isolated, cross
`symbol`	string	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Spot

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	—	-

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	—	-

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	—	-