Bitcoin Forum
August 22, 2017, 05:56:47 AM *
News: Latest stable version of Bitcoin Core: 0.14.2  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Premade Excel spreadsheet to keep track of your Bitcoin earnings  (Read 3445 times)
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 05, 2011, 03:16:02 PM
 #1

So I've compiled this Excel spreadsheet for my personal use but thought I'd like to share with the rest of the Bitcoin community. This is a really handy way to keep track of your earnings and exchanges, with formulas embedded into the document to auto-calculate certain values. All you have to do is enter the pool you mined on, and the BTC you made that day.




How to use
1. First, enter the date in the leftmost column. You can then drag the cell down to automatically create following dates.



2. Enter the name of the pool you've been mining on.

3. Enter the MtGox rate that day. I always record my data at 6 PM every day so the results are consistent.

4. Enter the amount of BTC you've made that day. You can check whether or not you've mined for 24 hours by clicking the "Note" style on any 24 hr cell.

5. Enter the difficulty that day.

6. If you want, enter any notes that may be relevant to your mining statistics.

Auto-Computation Features
1. BTC is automatically highlighted green, yellow, or red based on if you had a lucky mining day, an average mining day, or a bad luck mining day, respectively. You might say, well as time goes by, difficulty goes up and I will make less BTC a day! So all the cells will become highlighted red..right?
I've made a formula to automatically compute the average of all the cells under the BTC column. If you look at cell O2, that is the BTC average for all the values in column D.


I have set up the following formula to determine how lucky your mining day is:
If your BTC/day is within a 0.2 BTC variance of the average, then your cell will be highlighted yellow.
If your BTC/day is higher than the average + 0.2 BTC, then your cell will be highlighted green.
If your BTC/day is lower than the average - 0.2 BTC, then your cell will be highlighted red.

This allows for the colors to be auto-updated based on a changing average.

2. The BTC sum is auto-calculated when you enter in values. The BTC sum is merely the total amount of BTC you've made thus far. However, the counter resets when you enter data in the "Exchange" column:

3. The Exchange column is used for entering data about a market exchange. For example, I recently exchanged 4.05 BTC at a rate of 15 USD/BTC on 5/31. Thus, I entered that data into that column. Whenever data is entered in that cell, the BTC sum will automatically reset (since you've sold all your BTC). You can, however, manually change the value of the BTC sum if you did not sell all of your bitcoins.


4. Graphs are automaticaly created and updated based on the values you enter. There are graphs for BTC/day, BTC sum, the rate, and the difficulty.

Download
http://www.share.cx/files/988415982015/Bitcoin_Statistics.xlsx.html

I hope you guys find this useful. Smiley Donate if you did.

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
1503381407
Hero Member
*
Offline Offline

Posts: 1503381407

View Profile Personal Message (Offline)

Ignore
1503381407
Reply with quote  #2

1503381407
Report to moderator
1503381407
Hero Member
*
Offline Offline

Posts: 1503381407

View Profile Personal Message (Offline)

Ignore
1503381407
Reply with quote  #2

1503381407
Report to moderator
There are several different types of Bitcoin clients. The most secure are full nodes like Bitcoin-Qt, but full nodes are more resource-heavy, and they must do a lengthy initial syncing process. As a result, lightweight clients with somewhat less security are commonly used.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
CentroniX
Member
**
Offline Offline

Activity: 109


View Profile
June 05, 2011, 03:39:35 PM
 #2

Thanks for this! Exactly along the lines of what I've been wanting, but too lazy to create myself.  Grin

Also, this works great in Numbers on the iPad. The only feature that appears ot to work is the color-highlighting. Graphs, calculations, etc all work as they should. Very cool!

cent
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 05, 2011, 03:42:23 PM
 #3

Thanks for this! Exactly along the lines of what I've been wanting, but too lazy to create myself.  Grin

Also, this works great in Numbers on the iPad. The only feature that appears ot to work is the color-highlighting. Graphs, calculations, etc all work as they should. Very cool!

cent

You're welcome Smiley

Also: since I'm a n00b at Excel, if anyone knows quite a lot about Excel--does anyone know how to take the first number in the "Exchange" column and subtract it from the BTC sum, so that you don't have to manually enter in the BTC sum if you don't sell all of your coins?

Edit: I've made a formula for a BTC sum cell like this:
Code:
=IF(I8>0, E7+D8-I8, E7+D8)

But as long as there is a value in the "Exchange" column other than a number, I get an error.

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
broker11
Jr. Member
*
Offline Offline

Activity: 30


View Profile
June 05, 2011, 06:23:12 PM
 #4

You could extract the first four numbers in column I using in J8:
=left(I8,4)
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 06, 2011, 01:39:23 AM
 #5

Thanks Cheesy

But I've decided against implementing the feature, since it varies how much BTC is exchanged (i.e. 2, 4.1, or 6.93)

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 06, 2011, 07:34:41 PM
 #6

Bump

I'm sure many can benefit from this

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
kiwiasian
Full Member
***
Offline Offline

Activity: 168


View Profile
June 08, 2011, 02:41:43 AM
 #7

Bump

Tradehill referral link, save 10% | http://www.tradehill.com/?r=TH-R12328
www.payb.tc/kiwiasian | 1LHNW1JGMBo2e7rKiiFz7KJPKE57bqCdEC
dlasher
Sr. Member
****
Offline Offline

Activity: 468



View Profile WWW
July 20, 2011, 07:57:29 AM
 #8


Page not found

This page may be in preparation, please check back in a few minutes.

Sad
omoba4real
Newbie
*
Offline Offline

Activity: 2


View Profile
June 29, 2017, 01:13:55 PM
 #9

Please can you kindly resend the link to download the Excel spreadsheet as the link you provided is no longer working. Thanks
So I've compiled this Excel spreadsheet for my personal use but thought I'd like to share with the rest of the Bitcoin community. This is a really handy way to keep track of your earnings and exchanges, with formulas embedded into the document to auto-calculate certain values. All you have to do is enter the pool you mined on, and the BTC you made that day.

http://i.imgur.com/IVylp.jpg
http://i.imgur.com/lVABK.jpg

How to use
1. First, enter the date in the leftmost column. You can then drag the cell down to automatically create following dates.
http://i.imgur.com/WB67n.jpg
http://i.imgur.com/GeZqV.jpg

2. Enter the name of the pool you've been mining on.

3. Enter the MtGox rate that day. I always record my data at 6 PM every day so the results are consistent.

4. Enter the amount of BTC you've made that day. You can check whether or not you've mined for 24 hours by clicking the "Note" style on any 24 hr cell.

5. Enter the difficulty that day.

6. If you want, enter any notes that may be relevant to your mining statistics.

Auto-Computation Features
1. BTC is automatically highlighted green, yellow, or red based on if you had a lucky mining day, an average mining day, or a bad luck mining day, respectively. You might say, well as time goes by, difficulty goes up and I will make less BTC a day! So all the cells will become highlighted red..right?
I've made a formula to automatically compute the average of all the cells under the BTC column. If you look at cell O2, that is the BTC average for all the values in column D.
http://i.imgur.com/Wk4rG.jpg

I have set up the following formula to determine how lucky your mining day is:
If your BTC/day is within a 0.2 BTC variance of the average, then your cell will be highlighted yellow.
If your BTC/day is higher than the average + 0.2 BTC, then your cell will be highlighted green.
If your BTC/day is lower than the average - 0.2 BTC, then your cell will be highlighted red.

This allows for the colors to be auto-updated based on a changing average.

2. The BTC sum is auto-calculated when you enter in values. The BTC sum is merely the total amount of BTC you've made thus far. However, the counter resets when you enter data in the "Exchange" column:

3. The Exchange column is used for entering data about a market exchange. For example, I recently exchanged 4.05 BTC at a rate of 15 USD/BTC on 5/31. Thus, I entered that data into that column. Whenever data is entered in that cell, the BTC sum will automatically reset (since you've sold all your BTC). You can, however, manually change the value of the BTC sum if you did not sell all of your bitcoins.
http://i.imgur.com/jiOoT.jpg

4. Graphs are automaticaly created and updated based on the values you enter. There are graphs for BTC/day, BTC sum, the rate, and the difficulty.

Download
http://www.share.cx/files/988415982015/Bitcoin_Statistics.xlsx.html

I hope you guys find this useful. Smiley Donate if you did.
-ck
Moderator
Legendary
*
Offline Offline

Activity: 2254


Ruu \o/


View Profile WWW
June 29, 2017, 01:56:50 PM
 #10

Please can you kindly resend the link to download the Excel spreadsheet as the link you provided is no longer working. Thanks
You have resurrected a topic that has been dead for 6 years and the link has been dead for all that time. When the forum warns you about posting in a long inactive thread there's usually a reason. I'm locking this thread to prevent further posts on a long dead topic.

Primary developer/maintainer for cgminer and ckpool/ckproxy.
ZERO FEE Pooled mining at ckpool.org 1% Fee Solo mining at solo.ckpool.org
-ck
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!