All Binance Jersey 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("BINANCE JERSEY")

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.
  • 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.

Binance Jersey Market Data

Market Current Price

This will return Litecoin price in Bitcoin as currently traded on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC")

Same thing as calling =CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "price").

Best Ask Price

This will return Litecoin best ask price in Bitcoin as currently available on Binance Jersey order book:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "ask")

Best Bid Price

This will return Litecoin best bid price in Bitcoin as currently available on Binance Jersey order book:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "bid")

Last Trade Price

This call will return Litecoin last trade price in Bitcoin as it just happened on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "last")

1h Price Change

This call will return Litecoin price change percentage in Bitcoin over the last hour on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "change_1h")

24h Price Change

This call will return Litecoin price change percentage in Bitcoin over the last 24h on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "change")

7d Price Change

This call will return Litecoin price change percentage in Bitcoin over the last 7 days on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "change_7d")

Open Price

This call will return Litecoin open price in Bitcoin as of 24h ago on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "open")

24h Highest Price

This call will return Litecoin highest price in Bitcoin over the last 24h ago on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "high")

24h Lowest Price

This call will return Litecoin lowest price in Bitcoin over the last 24h ago on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "low")

Market Volume

This call will return Litecoin traded volume in Bitcoin over the last 24h on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "volume")

Market Base Volume

This call will return Litecoin traded volume in LTC over the last 24h on Binance Jersey:

=CRYPTOFINANCE("BINANCE JERSEY:LTC/BTC", "base_volume")

Binance Jersey Historical Data

Historical data is not available for Binance Jersey at this time.