How to pull instant mining profitability metrics from CryptUnit directly into Excel

In this tutorial we show you how to get an assortment of mining profitability metrics based on user hashrate from the CryptUnit API. 

CryptUnit Earnings

Description: Filter and search for current coin mining profitability.

Data returned:

• COIN ID

• COIN NAME

• COIN TICKER

• ALGO ID

• ALGO NAME

• ALGO ASIC

• HASHRATE AUTO

• HASHRATE MANUAL

• REWARD DAY USD

• REWARD MONTH USD

• REWARD DAY COINS

• REWARD MONTH COINS

• VOLUME 24H USD

• DATAAVG

• DEVICE

• HASHRATE

• UPDATETIME

Example: Return profitability metrics for GPU coins, averaged over a 24 hour period with a hash rate of 10,000 hashes/sec.

How to pull

1. In the Cryptosheets ribbon, click Dashboard

2. Login to the service through Google, or sign-up option

3. Click the orange + button

4. Click CrypUnit Earnings

5. In the Hash Rate textbox, enter 10000

6. In Chip Type, select GPU

7. In Averaging Period, select 24 hour

8. Click the Table Headers toggle

9. Click into A1 of the current tab, click Highlight Range, and Place Data

10. Verify that data has updated

11. You also have the option to choose a timed refresh interval.

About CryptUnit

CryptUnit is a web-based Cryptonote mining profitability calculator.