LinkyFlow - full treasury management for crypto, bank and budget planningLinkyFlow
Documentation
Pricing
Blog
Install
HTX connection for LinkyFlow

HTX connection for LinkyFlow

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

Resources

9

Read requests

9

Write actions

1

Documented fields

126

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.htx.myBalances("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
onlyPositivebooleanNoFilter to show only positive balances Default: true
Data returned in Excel
FieldTypeDescription
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.htx.myDeposits("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
assetenumNoAsset symbol for deposits or withdrawals Default: USDT Values: ETH, LTC, BNB, NEO, QTUM
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
address
string-
addressFrom
string-
addressTo
string-
amount
number-
comment
string-
currency
string-
datetime
string-
fee_cost
number-
fee_currency
string-
fee_rate
number-

+9 more fields available in this connection

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.htx.myOrders("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
amount
number-
average
number-
clientOrderId
string-
cost
number-
datetime
string-
fee_cost
number-
fee_currency
string-
filled
number-
id
id-
lastTradeTimestamp
date-

+16 more fields available in this connection

Create

Create Order

Create Order

Route: POST /postTrade

Inputs you can set
NameTypeRequiredDescription
amountnumberYes-
pricenumberNo-
sideenumYesValues: BUY, SELL
symbolstringYes-
timeInForceenumNoValues: FOK, GTC, IOC, PO
typeenumYesValues: LIMIT, MARKET, STOP, STOP_LIMIT, 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.htx.myTrades("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
amount
number-
cost
number-
datetime
string-
fee_cost
number-
fee_currency
string-
id
id-
order
id-
price
number-
side
string-
symbol
string-

+3 more fields available in this connection

Get My Withdrawals

List my withdrawal history

Read

Get My Withdrawals

List my withdrawal history

Route: GET /myWithdrawals

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

Inputs you can set
NameTypeRequiredDescription
linkstringYes-
assetenumNoAsset symbol for deposits or withdrawals Default: USDT Values: ETH, LTC, BNB, NEO, QTUM
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
address
string-
addressFrom
string-
addressTo
string-
amount
number-
comment
string-
currency
string-
datetime
string-
fee_cost
number-
fee_currency
string-
fee_rate
number-

+9 more fields available in this connection

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.htx.getOHLCV("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
timeframeenumNoGranularity of candlestick data Default: 1d Values: 1s, 1m, 3m, 5m, 15m
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
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.htx.getOrderBook("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
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.htx.getTicker24h("selection", "fields")

Inputs you can set
NameTypeRequiredDescription
symbolsstringYesList of trading symbols or market pairs, e.g. BTC/USDT, ETH/EUR
Data returned in Excel
FieldTypeDescription
ask
number-
askVolume
number-
average
number-
baseVolume
number-
bid
number-
bidVolume
number-
change
number-
close
number-
datetime
string-
high
number-

+11 more fields available in this connection

Trading

Get Trades

Retrieve recent trades for given symbols

Read

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

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

Inputs you can set
NameTypeRequiredDescription
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Data returned in Excel
FieldTypeDescription
amount
number-
cost
number-
datetime
string-
fee_cost
number-
fee_currency
string-
id
id-
order
id-
price
number-
side
string-
symbol
string-

+3 more fields available in this connection

← PrécédentGate IO connection for LinkyFlowSuivant →MEXC connection for LinkyFlow