Bitwise Indices and CryptUnit Earnings now available in Cryptosheets

Cryptosheets is now available on Microsoft’s official store, Appsource

Investors need access to detailed and robust data. We wanted to give our users the deepest, cleanest, and most extensive cryptocurrency data. We are excited to announce powerful new datasets aimed at making your cryptocurrency analysis easier than ever before.

Our newest update includes:

  • Bitwise Index Historical: Full historical data for all of Bitwise’s indices
  • Bitwise Ticker: Current ticker index price data, performance, and constituent weights
  • CryptUnit Earnings: Displays the earnings of a cryptocurrency based on user-input hash rate

Let’s take a deeper dive into each integration:

Bitwise

About Bitwise

Bitwise Asset Management pioneered the first cryptocurrency index fund and is the leading provider of rules-based exposure to the cryptoasset space.

Their index methodologies take into account crypto-native factors surrounding liquidity, security, regulatory status, market representation, network distributions and more to ensure they fully capture the investable cryptoasset market opportunity.

See complete index methodology here (https://www.bitwiseinvestments.com/indexes/methodology)

Bitwise Index Historical

Description: Full historical data for all of Bitwise’s indices.

Data returned:

  • Index
  • Index Price (USD)
  • Date UTC

Example: Return historical data for the Bitwise 10 index from August 20, 2018 till August 26th, 2018.

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 Bitwise Index Historical
  5. In the Index dropdown, choose Bitwise 10 Index
  6. Choose Start Time (GMT) and End Time (GMT)
  7. Click the Table Headers toggle
  8. Click into A1 of the current tab, click Highlight Range, and Place Data
  9. Verify that data has updated

Bitwise Ticker

Description: Load Bitwise’s current data by index with the option of daily, automatic refresh. This pull also includes index performance and a break down of the index’s weight constituents.

Data returned:

  • Bitwise 10 Value
  • Time UTC
  • performance 24h
  • performance mtd
  • performance qtd
  • performance ytd
  • Weights (Changes per index. Returns breakdown of coins and percentage)

Example: Return ticker data for the Bitwise 10 Index

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 Bitwise Ticker
  5. In the Index dropdown, choose Bitwise 10 Index
  6. Choose refresh interval
  7. Click into A1 of the current tab, click Highlight Range, and Place Data
  8. Verify that data has updated
  9. You also have the option to choose a timed refresh interval.

CryptUnit

About CryptUnit

CryptUnit is a web-based Cryptonote mining profitability calculator.

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.

Available on Microsoft Appsource

Cryptosheets is available to install on the official Microsoft app store, Appsource:

Have a feature request?

Head over to our feature requests page to submit new features!

Questions?

Send us a message from within Cryptosheets. We would love to chat with you.

Related posts

Crypto War Zone: Top 100 Cryptocurrencies Ranked by Risk-Adjusted Return

10 Price Predictions for 10 Top Cryptocurrencies — Aug 2018

Financial Modeling for Cryptocurrencies: A CoinMarketCap Spreadsheet That Doesn’t Suck

Introducing Cryptosheets: Real-time Excel Add-in for Cryptocurrencies