All Bitmex Contracts in One Listing

This function call will return the list of all active instruments along with all their data points.

=CRYPTOFINANCE("BITMEX")

Note: When Bitmex doesn’t provide data, a hyphen (-) will be shown.

Bitmex Contract Market Data

All the currently traded instruments are made available, including perpetual and futures contracts.

Perpetual contracts

You get perpetual contract data with this syntax, example for the Ethereum 24h volume:

=CRYPTOFINANCE("BITMEX:ETHUSD", "volume")

Futures contracts

Pull futures contract data with this syntax, here for Bitcoin XBTH19 contract current price:

=CRYPTOFINANCE("BITMEX:XBTH19", "price")

Data Point Available

By default the last trade price is returned. You can specify the following arguments to pull more info:

  • price, the last trade price
  • ask, the best ask price currently in the order book.
  • bid, the best bid price currently in the other book.
  • high, the 24h high price.
  • low, the 24h low price.
  • last, the price of the last trade (same as price).
  • vwap, the volume weighted average over the last 24h.
  • change, the price change in percentage over the last 24h.
  • volume, the volume traded over the last 24h in QUOTE currency (so that’s USD for BTC/USD).

Example getting Litecoin LTCM19 volume-weighted average price:

=CRYPTOFINANCE("BITMEX:LTCM19", "vwap")

More contracts data points are available, the full list includes:

  • rootsymbol
  • state
  • typ
  • listing
  • front
  • expiry
  • settle
  • relistinterval
  • inverseleg
  • sellleg
  • buyleg
  • optionstrikepcnt
  • optionstrikeround
  • optionstrikeprice
  • optionmultiplier
  • positioncurrency
  • underlying
  • quotecurrency
  • underlyingsymbol
  • reference
  • referencesymbol
  • calcinterval
  • publishinterval
  • publishtime
  • maxorderqty
  • maxprice
  • lotsize
  • ticksize
  • multiplier
  • settlcurrency
  • underlyingtopositionmultiplier
  • underlyingtosettlemultiplier
  • quotetosettlemultiplier
  • isquanto
  • isinverse
  • initmargin
  • maintmargin
  • risklimit
  • riskstep
  • _limit
  • capped
  • taxed
  • deleverage
  • makerfee
  • takerfee
  • settlementfee
  • insurancefee
  • fundingbasesymbol
  • fundingquotesymbol
  • fundingpremiumsymbol
  • fundingtimestamp
  • fundinginterval
  • fundingrate
  • indicativefundingrate
  • rebalancetimestamp
  • rebalanceinterval
  • openingtimestamp
  • closingtimestamp
  • sessioninterval
  • prevcloseprice
  • limitdownprice
  • limitupprice
  • bankruptlimitdownprice
  • bankruptlimitupprice
  • prevtotalvolume
  • totalvolume
  • prevtotalturnover
  • totalturnover
  • turnover
  • turnover24h
  • homenotional24h
  • foreignnotional24h
  • prevprice24h
  • lastpriceprotected
  • lasttickdirection
  • midprice
  • impactbidprice
  • impactmidprice
  • impactaskprice
  • hasliquidity
  • openinterest
  • openvalue
  • fairmethod
  • fairbasisrate
  • fairbasis
  • fairprice
  • markmethod
  • markprice
  • indicativetaxrate
  • indicativesettleprice
  • optionunderlyingprice
  • settledprice