Full Listing

AltCoinTrader 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("ALTCOINTRADER:BTC/ZAR") to get the current Bitcoin price in South African Rand.

All information are returned from the AltCoinTrader public API. All 4 tickers information can be retrieved: ask (default), bid, high, low, volume.

Examples:

  • =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR") will return the Bitcoin price (ask price), same thing as calling =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR", "ask")
  • =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR", "bid") will return Bitcoin bid price.
  • =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR", "high") will return Bitcoin highest price over the last 24 hours.
  • =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR", "low") will return Bitcoin lowest price over the last 24 hours.
  • =CRYPTOFINANCE("ALTCOINTRADER:BTC/ZAR", "volume") will return Bitcoin volume over the last 24 hours.