Coinbase connection for LinkyFlow

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

Resources

Read requests

Write actions

Documented fields

331

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.

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.

Read

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

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

Inputs you can set

Name	Type	Required	Description
`link`	string	Yes	-

Data returned in 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

Read

Get Funding Rate

Retrieve the current funding rate for the given perpetual contract symbols

Route: GET /getFundingRate

Excel formula: =LF.coinbase.getFundingRate("selection", "fields")

Inputs you can set

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

Data returned in 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)

Read

Get My Futures Balances

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

Route: GET /myFuturesBalances

Excel formula: =LF.coinbase.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	—	-
`freeExact`	string	—	-
`total`	number	—	-
`totalExact`	string	—	-
`used`	number	—	-
`usedExact`	string	—	-

Edit

Margin Mode

Route: PATCH /setMarginMode

Inputs you can set

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

Inputs you can set

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

Data returned in 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	—	-

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

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

Data returned in 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)

Read

Get My Borrow Rates

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

Route: GET /myBorrowRates

Excel formula: =LF.coinbase.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
`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`	date	—	-
`period`	number	—	-
`rate`	number	—	-
`symbol`	enum	—	-
`timestamp`	number	—	-

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

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

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	-
`marginMode`	enum	No	Values: isolated, cross
`symbol`	enum	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	-
`marginMode`	enum	No	Values: isolated, cross
`symbol`	enum	No	-

Data returned in Excel

This action returns a confirmation rather than a selectable table.

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.

Read

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

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

Inputs you can set

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

Data returned in 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".

Read

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

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

Inputs you can set

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.

Data returned in 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.

Read

Get My Deposits

Route: GET /myDeposits

Excel formula: =LF.coinbase.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
`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.

Data returned in 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.

Read

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

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

Inputs you can set

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

Data returned in 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	—	-

Edit

Cancel All

Route: DELETE /cancelAllOrders

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Get My Orders

List my open and closed orders

Used as filter by

Get One Order · orderId

Read

Get My Orders

List my open and closed orders

Route: GET /myOrders

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

Inputs you can set

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

Data returned in 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	—	-

Create

Create Order

Route: POST /postTrade

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Preview Order

Route: PATCH /previewTrade

Inputs you can set

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

Data returned in Excel

This action returns a confirmation rather than a selectable table.

Edit

Cancel Order

Route: DELETE /cancelOrder

Inputs you can set

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

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

Inputs you can set

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

Data returned in 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.

Read

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

Excel formula: =LF.coinbase.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
`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.

Data returned in 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

Read

Get OHLCV

Get historical candlestick (OHLCV) data for given symbols

Route: GET /getOHLCV

Excel formula: =LF.coinbase.getOHLCV("selection", "fields")

Inputs you can set

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

Data returned in 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.

Read

Get One Order

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

Route: GET /myOrder

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

Inputs you can set

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

Data returned in 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.

Read

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

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

Inputs you can set

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

Data returned in 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

Read

Get Ticker 24h

Retrieve 24-hour rolling ticker statistics for given symbols

Route: GET /getTicker24h

Excel formula: =LF.coinbase.getTicker24h("selection", "fields")

Inputs you can set

Name	Type	Required	Description
`symbols`	enum	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`	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

Read

Get Trades

Retrieve recent trades for given symbols

Route: GET /getTrades

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

Inputs you can set

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

Data returned in 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	—	-