All Bitzeus 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("BITZEUS")
The following market data will be returned:
last_updated
, when the data has been fetched from the exchange, timezone isUTC
time.market
, the market name following the syntaxBASE/QUOTE
.price
, the current price, either thelast
trade price when available or the currentask
price.ask
, the bestask
price currently in the order book.bid
, the bestbid
price currently in the other book.open
, the 24hopen
price.high
, the 24hhigh
price.low
, the 24hlow
price.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
inBTC/USD
).base_volume
, the volume traded over the last 24h in base currency (BTC
inBTC/USD
).
Notes:
- When the exchange doesn’t provide a given market data, a hyphen (-) will be shown.
Bitzeus Market Data
Market Current Price
This will return Binance Coin price in Bitcoin as currently traded on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC")
Same thing as calling =CRYPTOFINANCE("BITZEUS:BNB/BTC", "price")
.
Best Ask Price
This will return Binance Coin best ask price in Bitcoin as currently available on Bitzeus order book:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "ask")
Best Bid Price
This will return Binance Coin best bid price in Bitcoin as currently available on Bitzeus order book:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "bid")
Last Trade Price
This call will return Binance Coin last trade price in Bitcoin as it just happened on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "last")
1h Price Change
This call will return Binance Coin price change percentage in Bitcoin over the last hour on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "change_1h")
24h Price Change
This call will return Binance Coin price change percentage in Bitcoin over the last 24h on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "change")
7d Price Change
This call will return Binance Coin price change percentage in Bitcoin over the last 7 days on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "change_7d")
Open Price
This call will return Binance Coin open price in Bitcoin as of 24h ago on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "open")
24h Highest Price
This call will return Binance Coin highest price in Bitcoin over the last 24h ago on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "high")
24h Lowest Price
This call will return Binance Coin lowest price in Bitcoin over the last 24h ago on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "low")
Market Volume
This call will return Binance Coin traded volume in Bitcoin over the last 24h on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "volume")
Market Base Volume
This call will return Binance Coin traded volume in BNB
over the last 24h on Bitzeus:
=CRYPTOFINANCE("BITZEUS:BNB/BTC", "base_volume")
Bitzeus Historical Data
Historical data is not available for Bitzeus at this time.