Connexion MEXC pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

153

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

Entrees configurables

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

Donnees retournees dans Excel

Field	Type	Relations	Description
`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.mexc.myDeposits("selection", "fields")

Entrees configurables

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

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

Lecture

Get My Orders

List my open and closed orders

Route: GET /myOrders

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

Entrees configurables

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

Donnees retournees dans 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	—	-

Creation

Create Order

Route: POST /postTrade

Entrees configurables

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, IOC, PO
`type`	enum	Yes	Values: LIMIT, LIMIT_MAKER, MARKET

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.mexc.myTrades("selection", "fields")

Entrees configurables

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

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

Lecture

Get My Withdrawals

List my withdrawal history

Route: GET /myWithdrawals

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

Entrees configurables

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

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

Lecture

Get Funding Rate

Retrieve the current funding rate for the given perpetual contract symbols

Route: GET /getFundingRate

Formule Excel: =LF.mexc.getFundingRate("selection", "fields")

Entrees configurables

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

Donnees retournees dans 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)

Lecture

Get My Futures Balances

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

Route: GET /myFuturesBalances

Formule Excel: =LF.mexc.myFuturesBalances("selection", "fields")

Entrees configurables

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

Donnees retournees dans Excel

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

Modification

Margin Mode

Route: PATCH /setMarginMode

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Get My Positions

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

Lecture

Get My Positions

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

Route: GET /myPositions

Formule Excel: =LF.mexc.myPositions("selection", "fields")

Entrees configurables

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

Donnees retournees dans 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	—	-

Creation

Futures Order

Route: POST /postFuturesTrade

Entrees configurables

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, IOC, PO
`type`	enum	Yes	Values: LIMIT, LIMIT_MAKER, MARKET

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Leverage

Route: PATCH /setLeverage

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Position

Route: DELETE /closePosition

Entrees configurables

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

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

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

Entrees configurables

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

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

Lecture

Get Order Book

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

Route: GET /getOrderBook

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

Entrees configurables

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

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

Lecture

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Route: GET /getTicker24h

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

Entrees configurables

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

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

Lecture

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

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

Entrees configurables

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

Donnees retournees dans 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	—	-