All Upbit 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("UPBIT")
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.open
, the 24hopen
price.high
, the 24hhigh
price.low
, the 24hlow
price.close
, the 24hclose
price, often the same as thelast
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.
Upbit Market Data
Market Current Price
This will return Ethereum price in Bitcoin as currently traded on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC")
Same thing as calling =CRYPTOFINANCE("UPBIT:ETH/BTC", "price")
.
Last Trade Price
This call will return Ethereum last trade price in Bitcoin as it just happened on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "last")
1h Price Change
This call will return Ethereum price change percentage in Bitcoin over the last hour on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "change_1h")
24h Price Change
This call will return Ethereum price change percentage in Bitcoin over the last 24h on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "change")
7d Price Change
This call will return Ethereum price change percentage in Bitcoin over the last 7 days on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "change_7d")
Open Price
This call will return Ethereum open price in Bitcoin as of 24h ago on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "open")
24h Highest Price
This call will return Ethereum highest price in Bitcoin over the last 24h ago on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "high")
24h Lowest Price
This call will return Ethereum lowest price in Bitcoin over the last 24h ago on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "low")
Close Price
This call will return Ethereum last trade price in Bitcoin as it just happened on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "close")
Same thing as calling =CRYPTOFINANCE("UPBIT:ETH/BTC", "last")
.
Market Volume
This call will return Ethereum traded volume in Bitcoin over the last 24h on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "volume")
Market Base Volume
This call will return Ethereum traded volume in ETH
over the last 24h on Upbit:
=CRYPTOFINANCE("UPBIT:ETH/BTC", "base_volume")
Upbit 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("UPBIT:ETH/BTC", "price", "2017-12-25")
Same thing as calling close
.
Historical Open Price
=CRYPTOFINANCE("UPBIT:ETH/BTC", "open", "2017-12-25")
Historical High Price
=CRYPTOFINANCE("UPBIT:ETH/BTC", "high", "2017-12-25")
Historical Low Price
=CRYPTOFINANCE("UPBIT:ETH/BTC", "low", "2017-12-25")
Historical Close Price
=CRYPTOFINANCE("UPBIT:ETH/BTC", "close", "2017-12-25")
Historical Market Volume
=CRYPTOFINANCE("UPBIT:ETH/BTC", "volume", "2017-12-25")
Historical Market Base Volume
=CRYPTOFINANCE("UPBIT:ETH/BTC", "base_volume", "2017-12-25")