All BitHumb 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("BITHUMB")

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.
  • 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.
  • When not quote currency is provided the default is KRW.

BitHumb Market Data

Market Current Price

This will return Bitcoin price in Korean Republic Won as currently traded on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW")

Same thing as calling =CRYPTOFINANCE("BITHUMB:BTC/KRW", "price").

Best Ask Price

This will return Bitcoin best ask price in Korean Republic Won as currently available on BitHumb order book:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "ask")

Best Bid Price

This will return Bitcoin best bid price in Korean Republic Won as currently available on BitHumb order book:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "bid")

1h Price Change

This call will return Bitcoin price change percentage in Korean Republic Won over the last hour on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "change_1h")

24h Price Change

This call will return Bitcoin price change percentage in Korean Republic Won over the last 24h on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "change")

7d Price Change

This call will return Bitcoin price change percentage in Korean Republic Won over the last 7 days on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "change_7d")

Open Price

This call will return Bitcoin open price in Korean Republic Won as of 24h ago on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "open")

24h Highest Price

This call will return Bitcoin highest price in Korean Republic Won over the last 24h ago on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "high")

24h Lowest Price

This call will return Bitcoin lowest price in Korean Republic Won over the last 24h ago on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "low")

Close Price

This call will return Bitcoin last trade price in Korean Republic Won as it just happened on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "close")

Same thing as calling =CRYPTOFINANCE("BITHUMB:BTC/KRW", "last").

Market Volume

This call will return Bitcoin traded volume in Korean Republic Won over the last 24h on BitHumb:

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "volume")

Market Base Volume

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

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "base_volume")

BitHumb Historical Data

Historical prices are available on daily and hourly candles, including open, high, low, close, volume and base_volume.

Quota: Historical data has with a quota of 25 calls per day per user. The quota reset itself everyday at midnight UTC. For unlimited data and full historical listing the Historical Data subscription is available.

ProTip: See here for how to reference other cells to build the date or specifying the hour.

Historical Price

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "price", "2017-12-25")

Same thing as calling close.

Historical Open Price

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "open", "2017-12-25")

Historical High Price

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "high", "2017-12-25")

Historical Low Price

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "low", "2017-12-25")

Historical Close Price

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "close", "2017-12-25")

Historical Market Volume

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "volume", "2017-12-25")

Historical Market Base Volume

=CRYPTOFINANCE("BITHUMB:BTC/KRW", "base_volume", "2017-12-25")