Get cryptocurrency price
Returns the current price of a given cryptocurrency.
URL
https://api.excelapi.org/crypto/rate
Configuration
| Configuration | Required | Description |
|---|---|---|
| pair | ✔ | Specify the currency pair. Include hyphen. |
Pair
| symbol name | Currency Pair Name |
|---|---|
| btc-jpy | bitcoin/Yen |
| btc-usd | bitcoin/US dollar |
| eth-jpy | Ethereum/Yen |
| eth-usd | Ethereum/US dollar |
| ltc-jpy | LiteCoin/Yen |
| ltc-usd | LiteCoin/US dollar |
| xrp-jpy | Rpple/Yen |
| xrp-usd | Rpple/US dollar |
| xem-jpy | XEM/Yen |
| xem-usd | XEM/US dollar |
| mona-jpy | MonaCoin/円 |
| ada-usd | AdaCoin/US dollar |
| bnb-btc | Binance Coin/bitcoin |
| bnb-usdt | Binance Coin/US dollar |
※ These are just a few examples. All cryptocurrencies listed on Coinbase are supported.
Example
B2:
=WEBSERVICE("https://api.excelapi.org/crypto/rate?pair="&A2)