Full 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("LIVECOIN")

When no data is available on the exchange, the cells will be blank.

Specific Market Data

In a nutshell, call =CRYPTOFINANCE("LIVECOIN:ETH/BTC") to get the current Ether price in Bitcoin.

All information are returned from the LiveCoin public API. All 6 tickers information can be retrieved: ask (default), bid, last, high, low, vwap, volume.

Examples:

  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC") will return the Ether price (ask price) in Bitcoin. Same thing as calling =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "ask")
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "bid") will return Ether bid price in Bitcoin.
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "last") will return Ether last price in Bitcoin.
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "high") will return Ether highest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "low") will return Ether lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "vwap") will return Ether lowest price in Bitcoin over the last 24 hours.
  • =CRYPTOFINANCE("LIVECOIN:ETH/BTC", "volume") will return Ether volume (in Ether) over the last 24 hours.