LinkyFlow - Cashflow pour vos crypto, banques et gestion de budgetLinkyFlow
Documentation
Tarif
Blog
Installer
Connexion OKX pour LinkyFlow

Connexion OKX pour LinkyFlow

LinkyFlow ramene les donnees OKX dans Excel avec 10 workflows pour analyser les marches, suivre les wallets et preparer vos reportings sans changer d outil.

Ressources

9

Requetes de lecture

9

Actions ecriture

1

Champs documentes

126

Workflows a ramener dans Excel

Chaque ressource ci-dessous correspond a un workflow tableur concret. Les lectures ramenent des colonnes utiles dans Excel; les creations et modifications indiquent ce qui peut etre relu en lignes avant envoi.

Account data

Get My Balances

Fetch my account balances (free, used, total)

Lecture

Get My Balances

Fetch my account balances (free, used, total)

Route: GET /myBalances

Formule Excel: =LF.okx.myBalances("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
onlyPositivebooleanNoFilter to show only positive balances Default: true
Donnees retournees dans Excel
FieldTypeDescription
asset
enum-
debt
number-
free
number-
total
number-
used
number-

Get My Deposits

List my deposit history

Lecture

Get My Deposits

List my deposit history

Route: GET /myDeposits

Formule Excel: =LF.okx.myDeposits("selection", "fields")

Entrees configurables
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
Donnees retournees dans 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 champs supplementaires disponibles dans cette connexion

Get My Orders

List my open and closed orders

Lecture

Get My Orders

List my open and closed orders

Route: GET /myOrders

Formule Excel: =LF.okx.myOrders("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Donnees retournees dans 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 champs supplementaires disponibles dans cette connexion

Creation

Create Order

Create Order

Route: POST /postTrade

Entrees configurables
NameTypeRequiredDescription
amountnumberYes-
pricenumberNo-
sideenumYesValues: BUY, SELL
symbolstringYes-
timeInForceenumNoValues: FOK, GTC, IOC, PO
typeenumYesValues: LIMIT, MARKET, STOP, STOP_LIMIT, STOP_LOSS
Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Get My Trades

Retrieve my trade history

Lecture

Get My Trades

Retrieve my trade history

Route: GET /myTrades

Formule Excel: =LF.okx.myTrades("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
linkstringYes-
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Donnees retournees dans 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 champs supplementaires disponibles dans cette connexion

Get My Withdrawals

List my withdrawal history

Lecture

Get My Withdrawals

List my withdrawal history

Route: GET /myWithdrawals

Formule Excel: =LF.okx.myWithdrawals("selection", "fields")

Entrees configurables
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
Donnees retournees dans 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 champs supplementaires disponibles dans cette connexion

Market data

Get OHLCV

Get historical candlestick (OHLCV) data for given symbols

Lecture

Get OHLCV

Get historical candlestick (OHLCV) data for given symbols

Route: GET /getOHLCV

Formule Excel: =LF.okx.getOHLCV("selection", "fields")

Entrees configurables
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
Donnees retournees dans 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

Lecture

Get Order Book

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

Route: GET /getOrderBook

Formule Excel: =LF.okx.getOrderBook("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
limitnumberNoMaximum number of records to fetch
Donnees retournees dans Excel
FieldTypeDescription
amount
number-
price
number-
symbol
string-
type
string-

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Lecture

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Route: GET /getTicker24h

Formule Excel: =LF.okx.getTicker24h("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
symbolsstringYesList of trading symbols or market pairs, e.g. BTC/USDT, ETH/EUR
Donnees retournees dans Excel
FieldTypeDescription
ask
number-
askVolume
number-
average
number-
baseVolume
number-
bid
number-
bidVolume
number-
change
number-
close
number-
datetime
string-
high
number-

+11 champs supplementaires disponibles dans cette connexion

Trading

Get Trades

Retrieve recent trades for given symbols

Lecture

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

Formule Excel: =LF.okx.getTrades("selection", "fields")

Entrees configurables
NameTypeRequiredDescription
symbolstringYesTrading symbol or market pair, e.g. BTC/USDT
sincedateNoFetch data starting from this timestamp
limitnumberNoMaximum number of records to fetch
Donnees retournees dans 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 champs supplementaires disponibles dans cette connexion

← PrécédentConnexion MEXC pour LinkyFlowSuivant →Connexion Upbit pour LinkyFlow