Bitcoin Forum
May 05, 2024, 06:07:17 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 [2]  All
  Print  
Author Topic: Historical mining calculator?  (Read 6068 times)
itod (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
March 26, 2014, 10:12:35 AM
 #21

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.
1714889237
Hero Member
*
Offline Offline

Posts: 1714889237

View Profile Personal Message (Offline)

Ignore
1714889237
Reply with quote  #2

1714889237
Report to moderator
1714889237
Hero Member
*
Offline Offline

Posts: 1714889237

View Profile Personal Message (Offline)

Ignore
1714889237
Reply with quote  #2

1714889237
Report to moderator
The Bitcoin software, network, and concept is called "Bitcoin" with a capitalized "B". Bitcoin currency units are called "bitcoins" with a lowercase "b" -- this is often abbreviated BTC.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714889237
Hero Member
*
Offline Offline

Posts: 1714889237

View Profile Personal Message (Offline)

Ignore
1714889237
Reply with quote  #2

1714889237
Report to moderator
1714889237
Hero Member
*
Offline Offline

Posts: 1714889237

View Profile Personal Message (Offline)

Ignore
1714889237
Reply with quote  #2

1714889237
Report to moderator
1714889237
Hero Member
*
Offline Offline

Posts: 1714889237

View Profile Personal Message (Offline)

Ignore
1714889237
Reply with quote  #2

1714889237
Report to moderator
Und3rd0g
Full Member
***
Offline Offline

Activity: 231
Merit: 100


View Profile
March 26, 2014, 11:31:14 AM
 #22

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 (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
March 26, 2014, 04:43:49 PM
 #23

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?
koryu
Hero Member
*****
Offline Offline

Activity: 681
Merit: 507



View Profile
March 26, 2014, 07:38:47 PM
 #24

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.


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?
Und3rd0g
Full Member
***
Offline Offline

Activity: 231
Merit: 100


View Profile
March 27, 2014, 01:03:58 AM
Last edit: March 27, 2014, 01:26:50 AM by Und3rd0g
 #25

so this already calculates back with historical difficulty?

Yep.  Starts with block 2016, when the difficulty was 1.
Und3rd0g
Full Member
***
Offline Offline

Activity: 231
Merit: 100


View Profile
March 27, 2014, 01:11:58 AM
 #26

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!)
itod (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
March 27, 2014, 09:51:42 AM
 #27

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
***
Offline Offline

Activity: 231
Merit: 100


View Profile
March 27, 2014, 11:49:07 AM
Last edit: March 30, 2014, 04:19:48 AM by Und3rd0g
 #28

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.
tuner
Member
**
Offline Offline

Activity: 73
Merit: 10


View Profile
May 03, 2014, 06:03:04 AM
 #29

Could someone help me to calculate? Smiley
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?
SelbyTsang
Hero Member
*****
Offline Offline

Activity: 577
Merit: 504



View Profile
May 03, 2014, 11:50:12 AM
 #30

Could someone help me to calculate? Smiley
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?

itod (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
May 03, 2014, 01:14:20 PM
 #31

Could someone help me to calculate? Smiley
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
*****
Offline Offline

Activity: 577
Merit: 504



View Profile
May 03, 2014, 01:15:47 PM
 #32

Could someone help me to calculate? Smiley
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 (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
June 28, 2014, 02:26:10 PM
 #33

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

Nice service, thanks.
philipma1957
Legendary
*
Offline Offline

Activity: 4116
Merit: 7849


'The right to privacy matters'


View Profile WWW
June 28, 2014, 02:32:23 PM
Last edit: June 28, 2014, 02:54:22 PM by philipma1957
 #34

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

▄▄███████▄▄
▄██████████████▄
▄██████████████████▄
▄████▀▀▀▀███▀▀▀▀█████▄
▄█████████████▄█▀████▄
███████████▄███████████
██████████▄█▀███████████
██████████▀████████████
▀█████▄█▀█████████████▀
▀████▄▄▄▄███▄▄▄▄████▀
▀██████████████████▀
▀███████████████▀
▀▀███████▀▀
.
 MΞTAWIN  THE FIRST WEB3 CASINO   
.
.. PLAY NOW ..
itod (OP)
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
June 28, 2014, 09:26:19 PM
 #35

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.
DrG
Legendary
*
Offline Offline

Activity: 2086
Merit: 1035


View Profile
June 29, 2014, 10:35:40 AM
 #36

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.
Pages: « 1 [2]  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!