Historical mining calculator? | Bitcointalksearch.org

DrG

legendary

Activity: 2086

Merit: 1035

Quote from: itod on June 28, 2014, 04:26:19 PM

Quote from: philipma1957 on June 28, 2014, 09:32:23 AM

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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

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.

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: philipma1957 on June 28, 2014, 09:32:23 AM

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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

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.

philipma1957

legendary

Activity: 4326

Merit: 8950

'The right to privacy matters'

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

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

Nice service, thanks.

SelbyTsang

hero member

Activity: 577

Merit: 504

Quote from: itod on May 03, 2014, 08:14:20 AM

Quote from: SelbyTsang on May 03, 2014, 06:50:12 AM

Quote from: tuner on May 03, 2014, 01:03:04 AM

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. Wink

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: SelbyTsang on May 03, 2014, 06:50:12 AM

Quote from: tuner on May 03, 2014, 01:03:04 AM

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.

SelbyTsang

hero member

Activity: 577

Merit: 504

Quote from: tuner on May 03, 2014, 01:03:04 AM

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?

tuner

member

Activity: 73

Merit: 10

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?

Und3rd0g

full member

Activity: 231

Merit: 100

Quote from: itod on March 27, 2014, 04:51:42 AM

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.

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: Und3rd0g on March 26, 2014, 08:11:58 PM

Quote from: itod on March 26, 2014, 11:43:49 AM

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

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

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?

Und3rd0g

full member

Activity: 231

Merit: 100

Quote from: itod on March 26, 2014, 11:43:49 AM

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

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!)

Und3rd0g

full member

Activity: 231

Merit: 100

Quote from: koryu on March 26, 2014, 02:38:47 PM

so this already calculates back with historical difficulty?

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

koryu

hero member

Activity: 681

Merit: 507

Quote from: itod on March 25, 2014, 03:50:09 PM

Quote from: koryu on March 25, 2014, 04:46:53 AM

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

- 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 Wink

thx for the data.

Quote from: Und3rd0g on March 26, 2014, 06:31:14 AM

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.

so this already calculates back with historical difficulty?

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: Und3rd0g on March 26, 2014, 06:31:14 AM

Quote from: itod on March 26, 2014, 05:12:35 AM

Quote from: Und3rd0g on March 25, 2014, 08:40:38 PM

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?

Und3rd0g

full member

Activity: 231

Merit: 100

Quote from: itod on March 26, 2014, 05:12:35 AM

Quote from: Und3rd0g on March 25, 2014, 08:40:38 PM

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.

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: Und3rd0g on March 25, 2014, 08:40:38 PM

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.

Und3rd0g

full member

Activity: 231

Merit: 100

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.

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: koryu on March 25, 2014, 04:46:53 AM

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

- 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 Wink

koryu

hero member

Activity: 681

Merit: 507

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.

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: jabetizo on March 24, 2014, 03:50:18 PM

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.

jabetizo

full member

Activity: 125

Merit: 101

bump, does this exist yet?

rampalija

full member

Activity: 154

Merit: 100

Quote from: TheDragonSlayer on October 30, 2013, 03:46:08 AM

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

if ppl are paying some BTCs someone will create it Cheesy

TheDragonSlayer

sr. member

Activity: 273

Merit: 250

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

Moshi

newbie

Activity: 56

Merit: 0

Quote from: itod on October 27, 2013, 02:34:27 PM

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.

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.

rampalija

full member

Activity: 154

Merit: 100

i dont think that calculator is invented

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: BombaUcigasa on October 27, 2013, 09:16:59 AM

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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.

BombaUcigasa

legendary

Activity: 1442

Merit: 1005

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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

Gotta go fast!

newbie

Activity: 45

Merit: 0

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

TheDragonSlayer

sr. member

Activity: 273

Merit: 250

Quote from: itod on October 24, 2013, 07:15:05 PM

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?

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

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: DrG on October 25, 2013, 11:29:33 PM

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 Huh

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.

DrG

legendary

Activity: 2086

Merit: 1035

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 Huh

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: high110 on October 25, 2013, 03:35:52 PM

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.

high110

sr. member

Activity: 728

Merit: 253

A Blockchain Mobile Operator With Token Rewards

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

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

Quote from: high110 on October 25, 2013, 12:14:23 AM

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.

high110

sr. member

Activity: 728

Merit: 253

A Blockchain Mobile Operator With Token Rewards

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

itod

legendary

Activity: 1974

Merit: 1077

Honey badger just does not care

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?

Topic: Historical mining calculator? (Read 6111 times)