How to Get The Most Profitable Cryptocurrencies to Mine and More in Google Sheets

John Young
Dec 5, 2017 · 6 min read
Image for post
Image for post

One of the most challenging aspects of cryptocurrency mining is finding the most profitable coins to mine.

A few services exist, but nothing beats what the creators of WhatToMine.com have done in a few short months.

The big benefit of the data offered by WhatToMine is a ranking of cryptocurrencies by mining profitability.

The =SS() function, available in Google Sheets as part of the Spreadstreet Google Sheets Add-in, allows the user to pull in two seperate endpoints from the WhatToMine API:

  1. Stats — Used to compare the profitability of all GPU based cryptocurrencies
  2. ASIC — Used to compare the profitability of all ASIC coins
Image for post
Image for post

How to install

1. Go to the “Add-ons” menu, and click on “Get add-ons”.

Image for post
Image for post

2. On the Add-ons panel, search for “Spreadstreet”, click on “+ FREE” to install it.

Image for post
Image for post

3. Choose under which account you want to install the Add-on.

Image for post
Image for post

4. Spreadstreet needs to connect to an external API, click on “Allow”.

Image for post
Image for post

Note on security: All add-ins within the store go through a review. This is a wonderful security measure, especially in the Crypto industry, which is rife with scams and hacks.

5. Make sure the add-on is activated in your sheet:

  1. Go to Add-on > Spreadstreet > Help
  2. Click on View in store , then click on Manage and check Use in this document:
Image for post
Image for post

Tadaa! You are now able to use the =SS() function to pull in all sorts of amazing data within the cryptocurrency space.

Image for post
Image for post

How to use for GPU-Mineable Coins

How does WhatToMine calculate profitability for GPU-mineable cryptocurrencies?

  • All values are based on a default configuration and hash power of 3 Radeon RX480 graphics cards
  • Price is formulated from the following exchanges: Abucoins, Bitfinex, Bittrex, Bleutrade, Cryptopia, HitBTC, Poloniex, YoBit
  • Hash rate and wattage vary by algorithm. See the main page of WhatToMine for default values
  • Calculations are based on mean values, so final results will vary

What is the calculation missing?

  • Calculation does not account for future changes in price
  • Calculation does not account for future changes in network hash rate
  • Block rewards are fixed, future block reward reductions not taken into consideration
  • No significant changes to the underlying algorithm are assumed (for example, the Casper update)

Get most profitable GPU coins
Call the function =SS(“get-stats-whattomine”, true) to return various stats from GPU-minable cryptocurrencies.

  • 13 different GPU mining algorithms available, including: CryptoNight, Ethash, NeoScrypt, Equihash, Groestl, Skunkhash, Blake (14r), Pascal, LBRY, X11Gost, Blake (2b), Lyra2REv2, and Myriad-Groestl
  • Data returned includes: Coin, ID, Tag, Algorithm, Block Time, Block Reward, Block Reward 24, Last Block, Difficulty, Difficulty 24, Net Hash, Exchange Rate, Exchange Rate Volume, Exchange Rate Currency, Market Cap, Estimated Rewards, Estimated Rewards 24, BTC Revenue, BTC Revenue 24, Profitability, Profitability 24, Lagging, and Timestamp

Example usage using the GUI:

  1. Open the Add-in
Image for post
Image for post

2. Click “Add” to view the list of available APIs

Image for post
Image for post

3. Click on the “WhatToMine” icon

Image for post
Image for post

4. Click “Stats”

Image for post
Image for post

5. Click “Insert”

Image for post
Image for post

6. Click “Run”. This will paste values into the currently selected Cell, and save that in the main GUI for future retrieval

Image for post
Image for post

Example usage using the =SS() Formula:

Image for post
Image for post

=QUERY(A:W,”select A, T where T is not null order by T desc”) returns the most profitable GPU-minable cryptocurrencies.

How to use for ASIC-Mineable Coins

How does WhatToMine calculate profitability for ASIC-mineable cryptocurrencies?

  • SHA-256 values are adapted for Antminer S9, Scrypt for L3+ and X11 for D3.
  • Price is formulated from the following exchanges: Abucoins, Bitfinex, Bittrex, Bleutrade, Cryptopia, HitBTC, Poloniex, YoBit
  • Hash rate and wattage vary by algorithm. See the main page of WhatToMine for default values
  • Calculations are based on mean values, so final results will vary

What is the calculation missing?

  • Calculation does not account for future changes in price
  • Calculation does not account for future changes in network hash rate
  • Block rewards are fixed, future block reward reductions not taken into consideration
  • No significant changes to the underlying algorithm are assumed (for example, the Casper update)

Get most profitable ASIC coins
Call the function =SS(“get-asic-whattomine”, true) to return various stats from ASIC-minable cryptocurrencies.

  • 5 different ASIC mining algorithms available, including: SHA-256, Scrypt, X11, Qubit, Quark
  • Data returned includes: Coin, ID, Tag, Algorithm, Block Time, Block Reward, Block Reward 24, Last Block, Difficulty, Difficulty 24, Net Hash, Exchange Rate, Exchange Rate Volume, Exchange Rate Currency, Market Cap, Estimated Rewards, Estimated Rewards 24, BTC Revenue, BTC Revenue 24, Profitability, Profitability 24, Lagging, and Timestamp

Example usage:

Image for post
Image for post

=QUERY(A:W,”select A, T where T is not null order by T desc”) returns the most profitable GPU-minable cryptocurrencies.

Common issues and how to fix:

  1. Do not keep your sheet open at all time. This will prevent the rates from refreshing. The rates will auto-refresh each time you re-open your sheet.
  2. The add-on may not work right away on other old spreadsheets. You need to do this to activate Spreadstreet: Open the old sheet, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click Use in this document .

RESOURCES

Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in

Help: https://spreadstreet.io/docs

First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg

Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Is Genesis Mining Worth it? A Genesis Mining Profitability Calculator You’ll Actually Use

How to Create an Ethereum Mining Calculator from Start to Finish

10 Statistical Price Predictions for 10 Cryptocurrencies

Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

Bio for Spreadstreet
Bio for Spreadstreet

Spreadstreet

Spreadstreet makes it simple to connect cryptocurrency…

John Young

Written by

Founder, Cryptosheets.com and Spreadstreet.io. Husband to the most beautiful woman in the world. Runner-up in 6th grade spelling bee. Super-nerd.

Spreadstreet

Spreadstreet makes it simple to connect cryptocurrency services to spreadsheets.

John Young

Written by

Founder, Cryptosheets.com and Spreadstreet.io. Husband to the most beautiful woman in the world. Runner-up in 6th grade spelling bee. Super-nerd.

Spreadstreet

Spreadstreet makes it simple to connect cryptocurrency services to spreadsheets.

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store