Connexion Coinbase pour LinkyFlow

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

Ressources

Requetes de lecture

Actions ecriture

Champs documentes

331

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.

Connection

Get My Capabilities

What this connection can actually do right now: which account types are reachable and which operations are available or unavailable, with the reason. Costs no exchange call.

Lecture

Get My Capabilities

What this connection can actually do right now: which account types are reachable and which operations are available or unavailable, with the reason. Costs no exchange call.

Route: GET /myCapabilities

Formule Excel: =LF.coinbase.myCapabilities("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-

Donnees retournees dans Excel

Field	Type	Relations	Description
`available`	boolean	—	-
`capability`	string	—	-
`providerEnvironment`	enum	—	-
`reason`	string	—	-

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.coinbase.getFundingRate("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`symbols`	enum	Yes	Futures/perpetual contract symbols, e.g. BTC/USDT:USDT
`marketDataEnvironment`	enum	No	Where the prices come from. Defaults to the selected connection's environment, so a testnet connection is never shown production prices with... Values: production, testnet, demo

Donnees retournees dans Excel

Field	Type	Relations	Description
`fundingRate`	number	—	-
`fundingRateExact`	string	—	-
`fundingTimestamp`	number	—	-
`indexPrice`	number	—	-
`indexPriceExact`	string	—	-
`markPrice`	number	—	-
`markPriceExact`	string	—	-
`nextFundingRate`	number	—	-
`nextFundingRateExact`	string	—	-
`symbol`	enum	—	-

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.coinbase.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	—	-
`freeExact`	string	—	-
`total`	number	—	-
`totalExact`	string	—	-
`used`	number	—	-
`usedExact`	string	—	-

Modification

Margin Mode

Route: PATCH /setMarginMode

Entrees configurables

Name	Type	Required	Description
`marginMode`	enum	Yes	Values: isolated, cross
`symbol`	enum	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.coinbase.myPositions("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`symbols`	enum	No	Futures/perpetual contract symbols, e.g. BTC/USDT:USDT
`accountType`	enum	No	Which futures account: future_usdm (USD-margined, the default) or future_coinm (coin-margined). They are separate wallets with separate posi... Default: future_usdm Values: future_usdm, future_coinm

Donnees retournees dans Excel

Field	Type	Relations	Description
`accountType`	enum	—	-
`collateral`	number	—	-
`collateralExact`	string	—	-
`contracts`	number	—	-
`contractsExact`	string	—	-
`contractSize`	number	—	-
`contractSizeExact`	string	—	-
`datetime`	date	—	-
`entryPrice`	number	—	-
`entryPriceExact`	string	—	-
`initialMargin`	number	—	-
`initialMarginExact`	string	—	-
`leverage`	number	—	-
`liquidationPrice`	number	—	-
`liquidationPriceExact`	string	—	-
`maintenanceMargin`	number	—	-
`maintenanceMarginExact`	string	—	-
`marginMode`	enum	—	-
`markPrice`	number	—	-
`markPriceExact`	string	—	-
`notional`	number	—	-
`notionalExact`	string	—	-
`percentage`	number	—	-
`provider`	enum	—	-
`providerEnvironment`	enum	—	-
`side`	enum	—	-
`symbol`	enum	—	-
`timestamp`	number	—	-
`unrealizedPnl`	number	—	-
`unrealizedPnlExact`	string	—	-

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`	enum	Yes	-
`timeInForce`	enum	No	Values: FOK, GTC, GTD, IOC, PO
`type`	enum	Yes	Values: LIMIT, MARKET, STOP, STOP_LIMIT

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`	enum	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`	enum	No	Values: long, short
`symbol`	enum	Yes	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Margin

Get My Borrow Interest

List the interest accrued on my margin borrows

Lecture

Get My Borrow Interest

List the interest accrued on my margin borrows

Route: GET /myBorrowInterest

Formule Excel: =LF.coinbase.myBorrowInterest("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT
`symbol`	enum	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

Donnees retournees dans Excel

Field	Type	Relations	Description
`amountBorrowed`	number	—	-
`currency`	string	—	-
`datetime`	date	—	-
`interest`	number	—	-
`interestRate`	number	—	-
`marginMode`	enum	—	-
`symbol`	enum	—	-
`timestamp`	number	—	-

Get My Borrow Rates

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

Lecture

Get My Borrow Rates

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

Route: GET /myBorrowRates

Formule Excel: =LF.coinbase.myBorrowRates("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT
`marginMode`	enum	No	Margin mode for the position (isolated or cross) Default: cross Values: isolated, cross

Donnees retournees dans Excel

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

Get My Margin Balances

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

Lecture

Get My Margin Balances

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

Route: GET /myMarginBalances

Formule Excel: =LF.coinbase.myMarginBalances("selection", "fields")

Entrees configurables

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`	enum	No	List of trading symbols or market pairs, e.g. BTC/USDT, ETH/EUR

Donnees retournees dans Excel

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

Creation

Margin Order

Route: POST /postMarginTrade

Entrees configurables

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`	enum	Yes	-
`timeInForce`	enum	No	Values: FOK, GTC, GTD, IOC, PO
`type`	enum	Yes	Values: LIMIT, MARKET, STOP, STOP_LIMIT

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Borrow

Route: PATCH /borrowMargin

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`asset`	enum	Yes	-
`marginMode`	enum	No	Values: isolated, cross
`symbol`	enum	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Repay

Route: DELETE /repayMargin

Entrees configurables

Name	Type	Required	Description
`amount`	number	Yes	-
`asset`	enum	Yes	-
`marginMode`	enum	No	Values: isolated, cross
`symbol`	enum	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Spot

Get Market Metadata

Trading rules for a symbol: minimum and maximum quantity, lot step, price tick and minimum notional. Use it to size an order that the exchange will accept.

Lecture

Get Market Metadata

Trading rules for a symbol: minimum and maximum quantity, lot step, price tick and minimum notional. Use it to size an order that the exchange will accept.

Route: GET /getMarketMetadata

Formule Excel: =LF.coinbase.getMarketMetadata("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`symbol`	enum	Yes	Trading symbol or market pair, e.g. BTC/USDT

Donnees retournees dans Excel

Field	Type	Relations	Description
`active`	boolean	—	-
`base`	string	—	-
`contract`	boolean	—	-
`maxNotional`	string	—	-
`maxPrice`	string	—	-
`maxQty`	string	—	-
`minNotional`	string	—	-
`minPrice`	string	—	-
`minQty`	string	—	-
`quote`	string	—	-
`stepSize`	string	—	-
`symbol`	enum	—	-
`tickSize`	string	—	-

Get My Balances

Fetch my account balances (free, used, total). Filter with "assets" to read only the ones you care about instead of the whole wallet, and pick the account with "accountType".

Lecture

Get My Balances

Fetch my account balances (free, used, total). Filter with "assets" to read only the ones you care about instead of the whole wallet, and pick the account with "accountType".

Route: GET /myBalances

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`assets`	enum	No	Only these assets, e.g. BTC,USDT. Omit for the whole wallet.
`accountType`	enum	No	Which account: spot, margin_cross, margin_isolated, future_usdm or future_coinm. Replaces marginMode, which is still accepted. Default: spot Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm
`onlyPositive`	boolean	No	Filter to show only positive balances Default: true
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.

Donnees retournees dans Excel

Field	Type	Relations	Description
`accountType`	enum	—	-
`asset`	enum	—	-
`debt`	number	—	-
`debtExact`	string	—	-
`free`	number	—	-
`freeExact`	string	—	-
`providerEnvironment`	enum	—	-
`total`	number	—	-
`totalExact`	string	—	-
`used`	number	—	-
`usedExact`	string	—	-

Get My Deposits

List my deposit history. Not every connection can serve it — a sandbox account can be much narrower than the real venue — and the capability matrix says so up front rather than failing at the exchange.

Lecture

Get My Deposits

Route: GET /myDeposits

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT
`since`	date	No	Fetch data starting from this timestamp
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`status`	enum	No	Current status of the order or transaction
`network`	string	No	Chain of a deposit or withdrawal, e.g. TRC20.
`txId`	string	No	On-chain transaction id to look up.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.

Donnees retournees dans Excel

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

Get My Open Orders

List the orders still resting on the book, across every pair when no symbol is given. Use it to find the orderId to cancel.

Lecture

Get My Open Orders

List the orders still resting on the book, across every pair when no symbol is given. Use it to find the orderId to cancel.

Route: GET /myOpenOrders

Formule Excel: =LF.coinbase.myOpenOrders("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`symbol`	enum	No	Trading symbol or market pair, e.g. BTC/USDT
`accountType`	enum	No	Which account: spot, margin_cross, margin_isolated, future_usdm or future_coinm. Replaces marginMode, which is still accepted. Default: spot Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm

Donnees retournees dans Excel

Field	Type	Relations	Description
`_meta`	string	—	-
`accountType`	enum	—	-
`amount`	number	—	-
`amountExact`	string	—	-
`average`	number	—	-
`averagePrice`	number	—	-
`averagePriceExact`	string	—	-
`clientOrderId`	string	—	-
`cost`	number	—	-
`costExact`	string	—	-
`datetime`	date	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`feeCost`	number	—	-
`feeCostExact`	string	—	-
`feeCurrency`	string	—	-
`fees`	string[]	—	-
`filled`	number	—	-
`filledExact`	string	—	-
`id`	id	—	-
`lastUpdateTimestamp`	number	—	-
`linkyflowOrderId`	id	—	-
`orderType`	enum	—	-
`price`	number	—	-
`priceExact`	string	—	-
`providerEnvironment`	enum	—	-
`providerOrderId`	id	—	-
`remaining`	number	—	-
`remainingExact`	string	—	-
`side`	enum	—	-
`status`	enum	—	-
`stopPrice`	number	—	-
`stopPriceExact`	string	—	-
`symbol`	enum	—	-
`timeInForce`	string	—	-
`timestamp`	number	—	-
`type`	enum	—	-

Modification

Cancel All

Route: DELETE /cancelAllOrders

Entrees configurables

Name	Type	Required	Description
`accountType`	enum	No	Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm
`confirm`	boolean	Yes	-
`symbol`	enum	No	-

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Get My Orders

List my open and closed orders

Utilise comme filtre par

Get One Order · orderId

Lecture

Get My Orders

List my open and closed orders

Route: GET /myOrders

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`symbol`	enum	No	Trading symbol or market pair, e.g. BTC/USDT
`status`	enum	No	open, partially_filled, filled, canceled, expired or rejected Values: open, partially_filled, filled, canceled, expired
`side`	enum	No	Buy or sell. BUY/SELL are still accepted and converted. Values: buy, sell
`since`	date	No	Fetch data starting from this timestamp
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.
`accountType`	enum	No	Which account: spot, margin_cross, margin_isolated, future_usdm or future_coinm. Replaces marginMode, which is still accepted. Default: spot Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm

Donnees retournees dans Excel

Field	Type	Relations	Description
`_meta`	string	—	-
`accountType`	enum	—	-
`amount`	number	—	-
`amountExact`	string	—	-
`average`	number	—	-
`averagePrice`	number	—	-
`averagePriceExact`	string	—	-
`clientOrderId`	string	—	-
`cost`	number	—	-
`costExact`	string	—	-
`datetime`	date	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`feeCost`	number	—	-
`feeCostExact`	string	—	-
`feeCurrency`	string	—	-
`fees`	string[]	—	-
`filled`	number	—	-
`filledExact`	string	—	-
`id`	id	—	-
`lastTradeTimestamp`	number	—	-
`lastUpdateTimestamp`	number	—	-
`linkyflowOrderId`	id	—	-
`orderType`	enum	—	-
`postOnly`	boolean	—	-
`price`	number	—	-
`priceExact`	string	—	-
`providerEnvironment`	enum	—	-
`providerOrderId`	id	—	-
`reduceOnly`	boolean	—	-
`remaining`	number	—	-
`remainingExact`	string	—	-
`side`	enum	—	-
`status`	enum	—	-
`stopLossPrice`	number	—	-
`stopPrice`	number	—	-
`stopPriceExact`	string	—	-
`symbol`	enum	—	-
`takeProfitPrice`	number	—	-
`timeInForce`	string	—	-
`timestamp`	number	—	-
`trades`	string	—	-
`triggerPrice`	number	—	-
`type`	enum	—	-

Creation

Create Order

Route: POST /postTrade

Entrees configurables

Name	Type	Required	Description
`accountType`	enum	No	Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm
`amount`	string	No	-
`idempotencyKey`	string	No	-
`marginMode`	enum	No	Values: isolated, cross
`orderType`	enum	Yes	Values: market, limit, stop_loss, stop_loss_limit, take_profit
`previewToken`	string	No	-
`price`	string	No	-
`quoteAmount`	string	No	-
`side`	enum	Yes	Values: buy, sell
`stopPrice`	string	No	-
`symbol`	enum	Yes	-
`timeInForce`	enum	No	Values: GTC, IOC, FOK
`type`	enum	No	Values: LIMIT, MARKET, STOP, STOP_LIMIT

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Preview Order

Route: PATCH /previewTrade

Entrees configurables

Name	Type	Required	Description
`accountType`	enum	No	Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm
`amount`	string	No	-
`marginMode`	enum	No	Values: isolated, cross
`orderType`	enum	Yes	Values: market, limit, stop_loss, stop_loss_limit, take_profit
`price`	string	No	-
`quoteAmount`	string	No	-
`side`	enum	Yes	Values: buy, sell
`stopPrice`	string	No	-
`symbol`	enum	Yes	-
`timeInForce`	enum	No	Values: GTC, IOC, FOK
`type`	enum	No	Values: LIMIT, MARKET, STOP, STOP_LIMIT

Donnees retournees dans Excel

Cette action retourne une confirmation plutot qu une table selectionnable.

Modification

Cancel Order

Route: DELETE /cancelOrder

Entrees configurables

Name	Type	Required	Description
`accountType`	enum	No	Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm
`orderId`	string	Yes	-
`symbol`	enum	No	-

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`symbol`	enum	No	Trading symbol or market pair, e.g. BTC/USDT
`side`	enum	No	Buy or sell. BUY/SELL are still accepted and converted. Values: buy, sell
`since`	date	No	Fetch data starting from this timestamp
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.
`accountType`	enum	No	Which account: spot, margin_cross, margin_isolated, future_usdm or future_coinm. Replaces marginMode, which is still accepted. Default: spot Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm

Donnees retournees dans Excel

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

Get My Withdrawals

List my withdrawal history (read only — LinkyFlow never sends crypto out). Not every connection can serve it; the capability matrix says which can.

Lecture

Get My Withdrawals

List my withdrawal history (read only — LinkyFlow never sends crypto out). Not every connection can serve it; the capability matrix says which can.

Route: GET /myWithdrawals

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

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`asset`	enum	No	Asset symbol for deposits or withdrawals Default: USDT
`since`	date	No	Fetch data starting from this timestamp
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`status`	enum	No	Current status of the order or transaction
`network`	string	No	Chain of a deposit or withdrawal, e.g. TRC20.
`txId`	string	No	On-chain transaction id to look up.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.

Donnees retournees dans Excel

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

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

Entrees configurables

Name	Type	Required	Description
`symbol`	enum	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
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.
`marketDataEnvironment`	enum	No	Where the prices come from. Defaults to the selected connection's environment, so a testnet connection is never shown production prices with... Values: production, testnet, demo

Donnees retournees dans Excel

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

Get One Order

Read one order by its exchange id, with what it has actually filled so far.

Lecture

Get One Order

Read one order by its exchange id, with what it has actually filled so far.

Route: GET /myOrder

Formule Excel: =LF.coinbase.myOrder("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`link`	string	Yes	-
`orderId`	string	Yes	Exchange order id, exactly as it was returned.
`symbol`	enum	No	Trading symbol or market pair, e.g. BTC/USDT
`accountType`	enum	No	Which account: spot, margin_cross, margin_isolated, future_usdm or future_coinm. Replaces marginMode, which is still accepted. Default: spot Values: spot, margin_cross, margin_isolated, future_usdm, future_coinm

Donnees retournees dans Excel

Field	Type	Relations	Description
`_meta`	string	—	-
`accountType`	enum	—	-
`amount`	number	—	-
`amountExact`	string	—	-
`average`	number	—	-
`averagePrice`	number	—	-
`averagePriceExact`	string	—	-
`clientOrderId`	string	—	-
`cost`	number	—	-
`costExact`	string	—	-
`datetime`	date	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`feeCost`	number	—	-
`feeCostExact`	string	—	-
`feeCurrency`	string	—	-
`fees`	string[]	—	-
`filled`	number	—	-
`filledExact`	string	—	-
`id`	id	—	-
`lastUpdateTimestamp`	number	—	-
`linkyflowOrderId`	id	—	-
`orderType`	enum	—	-
`price`	number	—	-
`priceExact`	string	—	-
`providerEnvironment`	enum	—	-
`providerOrderId`	id	—	-
`remaining`	number	—	-
`remainingExact`	string	—	-
`side`	enum	—	-
`status`	enum	—	-
`stopPrice`	number	—	-
`stopPriceExact`	string	—	-
`symbol`	enum	—	-
`timeInForce`	string	—	-
`timestamp`	number	—	-
`type`	enum	—	-

Get Order Book

Fetch the current order book for a symbol. Asks come first, best (lowest) offer first, then bids, best (highest) first.

Lecture

Get Order Book

Fetch the current order book for a symbol. Asks come first, best (lowest) offer first, then bids, best (highest) first.

Route: GET /getOrderBook

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

Entrees configurables

Name	Type	Required	Description
`symbol`	enum	Yes	Trading symbol or market pair, e.g. BTC/USDT
`depth`	number	No	Levels per side. Replaces limit, which is still accepted. Default: 5
`marketDataEnvironment`	enum	No	Where the prices come from. Defaults to the selected connection's environment, so a testnet connection is never shown production prices with... Values: production, testnet, demo

Donnees retournees dans Excel

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

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.coinbase.getTicker24h("selection", "fields")

Entrees configurables

Name	Type	Required	Description
`symbols`	enum	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`	date	—	-
`high`	number	—	-
`indexPrice`	number	—	-
`last`	number	—	-
`low`	number	—	-
`markPrice`	number	—	-
`open`	number	—	-
`percentage`	number	—	-
`previousClose`	number	—	-
`quoteVolume`	number	—	-
`symbol`	enum	—	-
`timestamp`	number	—	-
`vwap`	number	—	-

Get Trades

Retrieve recent trades for given symbols

Lecture

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

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

Entrees configurables

Name	Type	Required	Description
`symbol`	enum	Yes	Trading symbol or market pair, e.g. BTC/USDT
`since`	date	No	Fetch data starting from this timestamp
`until`	date	No	Read up to this date. ISO 8601 or an epoch in milliseconds.
`limit`	number	No	Maximum number of records to fetch
`cursor`	string	No	Opaque cursor from a previous page. Pass it back verbatim; never build or edit one.
`marketDataEnvironment`	enum	No	Where the prices come from. Defaults to the selected connection's environment, so a testnet connection is never shown production prices with... Values: production, testnet, demo

Donnees retournees dans Excel

Field	Type	Relations	Description
`_meta`	string	—	-
`accountType`	enum	—	-
`amount`	number	—	-
`amountExact`	string	—	-
`average`	number	—	-
`cost`	number	—	-
`costExact`	string	—	-
`datetime`	date	—	-
`fee_cost`	number	—	-
`fee_currency`	string	—	-
`feeCost`	number	—	-
`feeCostExact`	string	—	-
`feeCurrency`	string	—	-
`fees`	string[]	—	-
`id`	id	—	-
`lastUpdateTimestamp`	number	—	-
`linkyflowOrderId`	id	—	-
`order`	id	→ myOrders	-
`orderType`	enum	—	-
`price`	number	—	-
`priceExact`	string	—	-
`providerEnvironment`	enum	—	-
`side`	enum	—	-
`symbol`	enum	—	-
`takerOrMaker`	enum	—	-
`timestamp`	number	—	-
`type`	enum	—	-