How to get rates and data from Bitstamp

Full listing

Bitstamp 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("BITSTAMP:BTC/USD") to get the current Bitcoin price in US Dollar.

All information are returned from the Bitstamp ticker public API. All 7 ticker information can be retrieved: ask (default), bid, last, high, low, open, volume.

Examples:

• =CRYPTOFINANCE("BITSTAMP:BTC/USD") will return Bitcoin price (ask, sell price) in US Dollar. It is the same thing as calling =CRYPTOFINANCE("BITSTAMP:BTC/USD", "ask").
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "bid") will return Bitcoin bid price in US Dollar.
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "last") will return Bitcoin last price in US Dollar.
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "high") will return Bitcoin highest price in US Dollar over the last 24 hours.
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "low") will return Bitcoin lowest price in US Dollar over the last 24 hours.
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "open") will return Bitcoin open price in US Dollar over the last 24 hours.
• =CRYPTOFINANCE("BITSTAMP:BTC/USD", "volume") will return Bitcoin volume over the last 24 hours.