Bitcoin Forum

Is there any software/site where you can enter two dates in the past + hashrate, and get the result how many BTC was mined in the period between these two dates?

I think most of them are to project future earnings. You're looking to see if they've been paying you the correct amounts??

Yes, that among the other things. Would also be very useful for analysis if some decision not to buy some hardware was correct or not.

Maybe you can make one =)  Or team up with someone to make it.  It's not a bad idea.

That's one of the reasons I've asked the question. There's no point to duplicate work. Regarding the few responses I've got it either doesn't exists or I've posted in the wrong subforum, maybe Development subforum was a better idea, but I thought the miners would know if one exists.

My 6870s were making about 0.136BTC/day in January 2012 and they cost me about $140USD.  To get the same 0.136BTC/day today you would need 1/5 of a KNC Jupiter - so roughly $1000USD.   I sold my 6870s for $100s 2 years after purchase, doubt I would get $100 for KNC in 2 years.

Even with the 1/2ing the current pricing models are outside of equilibrium.  Anybody buying devices now is just gambling on fast ship times and trying to beat others to the punch.  I doubted the network would hit 1PH by this time - apparently I was wrong.  I guess some people will buy hardware even if means losing $.  Stronger network I guess  ???

It doubt that majority is buying whit awareness they are going to lose money and contributing to the network. There are two other factors, first many people still don't get the concept that if they invest USD and get more USD they may be in a huge loss, because they would get more USD if they didn't buy equipment and bought BTC in the firs place. For them fiat is the only currency that counts. Second factor is many people buy miners ill-informed. It takes time and effort to figure all the factors. Calculator we are talking about in this thread may help with these a lot, it would be in the plain site historical profitability of every peace of equipment that ever where, without the input of actual owners/manufacturers. Try to get that info now.

Non, but u can calculate your self using the difficulty and your hash rate.

You could do it yourself, if you know how to code. You need to calculate the historical difficulty.

You mean like this: http://www.bitcoinx.com/profit/ ? (with manual form filling for each month)

No, I've meant to do it comfortably, with some database with historic difficulty, which will extrapolate the projected difficulty for each day in the past. You enter the start and end date, and the hashrate. Optionally the power consumption, but it's easy to calculate manually since it doesn't change through time. There are no other variables, you should get how much BTC is mined in that period.

i dont think that calculator is invented

Unfortunately, your best bet would probably be to calculate it manually and do some interpolation. Alternatively, a little bit of javascript could conceivably do the same with one of the calculators avaliable: grab the difficulty between each retarget, calculate that number, and add all of the results. Roundabout, but about the easiest I could come up with.

Lets hope for someone to come out with this type of calculator...

if ppl are paying some BTCs someone will create it :D

bump, does this exist yet?

Unfortunately not. Seems nobody has a time to code it. Maybe some incentive in donations would speed things up. Wonder if there is interest to do that.

sounds interesting, if its really not existing i would help to develop such a tool.

data needed is

- raw historical data for difficulty over time (change each 2016 blocks)
- date of halving bitcoins per block from 50 to 25 (should be after 210k blocks)


if someone can provide this data, i could find only charts or incomplete data.

- Historical data:
https://docs.google.com/spreadsheet/ccc?key=0AiFMBvXvL2dtdEZkR2J4eU5rS3B4ei1iUmJxSWNlQ0E#gid=0 (https://docs.google.com/spreadsheet/ccc?key=0AiFMBvXvL2dtdEZkR2J4eU5rS3B4ei1iUmJxSWNlQ0E#gid=0)

- Halving from 50 to 25 BTC happened on block 210000, 2012-11-28 15:24:38, next one from 25 to 12.5 will be on block 420000. It's enough for you to start ;)

Following is a link to a bitcoin calculator in Excel that I have been improving and maintaining for some time now.  It is based on an original model created by the folks at Bitmain.  The historical data is current as of the last difficulty change.

https://drive.google.com/file/d/0B1DkFD-cfVr4d2NkV2hyWTE2NVk/edit?usp=sharing

PM me with any question or enhancement requests.

Nice work, but what's needed is an option to enter 3 pieces of data:
- GHs
- starting date
- end date (option: today)
and the calculator should show how many BTC is mined in that period.

My calculator can do that.  Send me the parameters you are interested in (start, end, GHs) and I will send you a screen shot of how it looks.

For instance: How many BTC 560GHs KnC Jupiter has mined from October 15th until now?

thx for the data.


so this already calculates back with historical difficulty?

Yep.  Starts with block 2016, when the difficulty was 1.

10/15/2013 until today = 51.85755704 btc total @ 560GHs

Day 1, October 15:
Difficulty - 189,281,249.28   
btc mined - 1.48790198 (now, that would have been sweet!)

You said you'll show how it can be calculated? Please don't tell me one has to manually sum the columns from the Excel table?

Sorry mate.  Yeah, you would have to add up the rows to get a total.

Could someone help me to calculate? :)
I received BFL 60GHs miner in march 10th, and payed 0,5 BTC for it,
i wonder how much it earned in this period of time till today, my guess 0,3 btc?

Why don't you just check your account history on your pool?

Many people switch pools, or mine p2p. That's some of the reasons why this thread started.

I see. I didn't thought of this as my mining life was very short. ;)

Somebody made it:
http://retrocalc.net/ (http://retrocalc.net/)

Nice service, thanks.

yes but not exactly .  You can go to bitcoin wisdom calculator  and play around with settings.  


 Lets say you want Jan 1 to March 1 2014 .

 An antminer s-1  set at 200gh.  you do this.

go to this link.

https://bitcoinwisdom.com/bitcoin/difficulty

determine the diff on jan 1 2014.

 it was  1,180,923,000 for 1 day jan 1                                 1 day 200gh earned .08517  x 1 = .08517

it was   1,418,481,000 for 11 days jan 2 to jan 12                1 day 200gh earned  .07091 x 11 = .78001

it was   1,789,546,951 for 11 days jan 13 to jan 23               1 day 200gh earned .05621 x 11 = .61831

it was  2,193,847,870 for  12 days jan  24 to feb 4                1 day 200gh earned .04586 x 12 = .55032

it was  2,621,404,453 for   12 days feb 5 to  feb 16                1 day 200gh earned .03837 x 12 = .46044

it was  3,129,573, 175 for  11 days feb 16 to feb 28               1 day 200gh earned .03214 x 11 = .35354

TOTAL------------------------------------------------------------------------------------------------------------ 2.84779 btc for jan 1 to mar 1 not including mar 1


A shit load of math for someone that wants to get an idea of what the gear earned
http://imagizer.imageshack.us/v2/1280x1024q90/819/2rld.png

I've got this using calculator, from Jan 1st to Feb 28th: 2.8546 BTC

It differs with your calculation on 2nd decimal, maybe a rounding error.

Those figures don't take into account variance of the pool's luck.  If the pool had horrible luck during a certain time it would have made 90% of earnings and if it was lucky it could have made 110% of earnings.  So the number it shows is expected earnings.  The reality is any downtime, DDoS or pool luck variances would have altered true earnings.  It's not a big deal unless a pool had really good or really bad luck the first 1 or 2 difficulties that you mine since that's when most of your coin is generated.