All Ice3x Markets in One Listing

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

=CRYPTOFINANCE("ICE3X")

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.
  • vwap, the volume weighted average over the last 24h.
  • last, the price of the last trade.
  • change 24h, the price change in percentage over the last 24h.
  • volume, the volume traded over the last 24h in quote currency (USD in BTC/USD).
  • base_volume, the volume traded over the last 24h in base currency (BTC in BTC/USD).

Notes:

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

Ice3x Market Data

Market Current Price

This will return Bitcoin price in South-African Rand as currently traded on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR")

Same thing as calling =CRYPTOFINANCE("ICE3X:BTC/ZAR", "price").

Best Ask Price

This will return Bitcoin best ask price in South-African Rand as currently available on Ice3x order book:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "ask")

Best Bid Price

This will return Bitcoin best bid price in South-African Rand as currently available on Ice3x order book:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "bid")

Last Trade Price

This call will return Bitcoin last trade price in South-African Rand as it just happened on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "last")

1h Price Change

This call will return Bitcoin price change percentage in South-African Rand over the last hour on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "change_1h")

24h Price Change

This call will return Bitcoin price change percentage in South-African Rand over the last 24h on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "change")

7d Price Change

This call will return Bitcoin price change percentage in South-African Rand over the last 7 days on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "change_7d")

Open Price

This call will return Bitcoin open price in South-African Rand as of 24h ago on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "open")

24h Highest Price

This call will return Bitcoin highest price in South-African Rand over the last 24h ago on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "high")

24h Lowest Price

This call will return Bitcoin lowest price in South-African Rand over the last 24h ago on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "low")

Close Price

This call will return Bitcoin last trade price in South-African Rand as it just happened on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "close")

Same thing as calling =CRYPTOFINANCE("ICE3X:BTC/ZAR", "last").

Volume Weighted Average Price (VWAP)

This call will return Bitcoin volume-weighted average price in South-African Rand over the last 24h on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "close")

Market Volume

This call will return Bitcoin traded volume in South-African Rand over the last 24h on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "volume")

Market Base Volume

This call will return Bitcoin traded volume in BTC over the last 24h on Ice3x:

=CRYPTOFINANCE("ICE3X:BTC/ZAR", "base_volume")

Ice3x Historical Data

Historical data is not available for Ice3x at this time.