Futures trading

Futures trading

Overview: The Futures dashboard brings derivatives trading into Excel. It reads your open positions, futures (swap) wallet and funding rate, computes portfolio KPIs, and embeds one-click action buttons to open and close positions and to set leverage and margin mode. It works with Binance and the other supported exchanges.

Key features:

  • Live open positions with entry/mark/liquidation price, leverage and unrealized P&L - Portfolio KPIs (open positions, total unrealized P&L, total notional, futures wallet) - Funding rate for the selected perpetual contract - Embedded action buttons: open, close, set leverage, set margin mode

Exchange reports:

  • Open positions (myPositions): side, contracts, leverage, entry/mark/liquidation price, unrealized P&L, notional and margin mode. - Futures wallet (myFuturesBalances): free, used and total balance of the swap wallet. - Funding rate (getFundingRate): current and next funding rate for the contract.

Actions:

  • Open Futures Position (postFuturesTrade): symbol, side, type, amount, price, leverage, margin mode, reduce-only. - Close Position (closePosition): flattens the position with a reduce-only market order. - Set Leverage (setLeverage): change the leverage for a contract. - Set Margin Mode (setMarginMode): switch a contract between isolated and cross margin.

Inputs:

  • Contract selection (e.g. BTC/USDT:USDT) - Private link (API key with trade permission)

Notes:

  • Futures use the ccxt unified contract symbol format BASE/QUOTE:SETTLE, e.g. BTC/USDT:USDT. - Orders are validated against each contract's min/max amount, price and notional before being sent. - Trading permission is required to place orders; read-only links still show positions and funding. - Derivatives are high risk. Test with a Binance testnet link first.