How to get rate and data from Gemini

Full listing

Gemini full listing is not available at this moment. Their API output needs too much rewriting to fit a sheet format.

Specific market data

In a nutshell, call =CRYPTOFINANCE("GEMINI:BTC/USD") to get the current Bitcoin price in US Dollar.

All information are returned from the Gemini ticker public API. All 5 ticker information can be retrieved: ask (sell, default), bid (buy), last, volume and base_volume.

Examples:

• =CRYPTOFINANCE("GEMINI:BTC/USD") will return Bitcoin price (ask, sell price) in US Dollar, similar to=CRYPTOFINANCE("GEMINI:BTC/USD", "ask").
• =CRYPTOFINANCE("GEMINI:BTC/USD", "bid") will return Bitcoin bid price in US Dollar.
• =CRYPTOFINANCE("GEMINI:BTC/USD", "last") will return Bitcoin last trade price in US Dollar.
• =CRYPTOFINANCE("GEMINI:BTC/USD", "volume") will return Bitcoin volume in US Dollar.
• =CRYPTOFINANCE("GEMINI:BTC/USD", "base_volume") will return Bitcoin volume in Bitcoin.