All Yobit Markets Listing

This function call will return the list of all markets along with all their data point. It is recommend to use this to avoid the Google Sheets imposed API call quota.

=CRYPTOFINANCE("YOBIT")

The following market data will be returned:

  • last_updated, when the data has been fetched from the exchange, timezone is UTC time.
  • market, the market name following the syntax BASE/QUOTE.
  • price, the current price, either the last trade price when available or the current ask price.
  • ask, the best ask price currently in the order book.
  • bid, the best bid price currently in the other book.
  • open, the 24h open price.
  • high, the 24h high price.
  • low, the 24h low price.
  • close, the 24h close price, often the same as the last price.
  • last, the price of the last trade.
  • avg, the average price over the last 24h.
  • vwap, the volume weighted average over the last 24h.
  • change 24h, 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).
  • base_volume, the volume traded over the last 24h in BASE currency (so that’s BTC for BTC/USD).

Note: When the exchange doesn’t provide a given market data, a hyphen (-) will be shown.

Specific Yobit Market Data

Current Price

This will return ETH price in Bitcoin as currently traded on the exchange.

=CRYPTOFINANCE("YOBIT:ETH/BTC")

Same thing as calling =CRYPTOFINANCE("YOBIT:ETH/BTC", "last") or =CRYPTOFINANCE("YOBIT:ETH/BTC", "price").

Best Bid Price

This call will return ETH bid price in Bitcoin.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "bid")

Best Ask Price

This call will return ETH highest price in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "ask")

Low Price

This call will return ETH lowest price in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "low")

High Price

This call will return ETH last price in Bitcoin.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "high")

Market Volume

This call will return ETH volume in Bitcoin over the last 24 hours.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "volume")

Market Base Volume

This call will return ETH volume in Ether over the last 24 hours.

=CRYPTOFINANCE("YOBIT:ETH/BTC", "base_volume")