I was wondering if any of you could help me in making my own mining calculator. I know there are many good web apps out there, but I would like to make one myself.

What I don't understand is how to calculate the statistical outcome, knowing a given hardware's hashrate per second and the difficulty level.

Do you know what formula should I use?

1 Answer 1


If you have Excel, try:

  1. BTC Per Day = (B3*POWER(10,9)/B1)*(B4*B6)/B5
  2. B1 = 907549524 (Difficulty Factor - obtained from http://bitcoindifficulty.com/ or http://bitcoinwatch.com/)
  3. B3 = 70 (Hashing Rate in GH/s)
  4. B4 = 25 (Block Award in BTC)
  5. B5 = POWER(2,32) (Is a constant, is the number of integer nonce values that can be hashed with a 32 bit integer register)
  6. B6 = 86400 (seconds per day)

Answer for #1 is 0.038790162 when the data from B3, B4, B5 and B6.

I add two other fields in my spreadsheet: 1) Difficulty Factor Compound Rate in % per 2048 Blocks (somewhere around 15% to 20%), 2) the value in BTC denominated in USD. The remainder of the spreadsheet I use determines risks associated with late ASIC hardware deliveries in terms of BTC or USD opportunity losses. Absolutely, don't use any of the online mining calculators to make big Mining H/W acquisition decisions... You must take into account the non-linear difficulty factor compounding rate to make reasonable computations of what your profits are likely to be. Otherwise, your estimated profits are likely to be losses...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.