Premade Excel spreadsheet to keep track of your Bitcoin earnings

[kiwiasian]

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. Donate if you did.

[CentroniX]

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

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]

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

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

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.

[broker11]

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

[kiwiasian]

Thanks

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

[kiwiasian]

Bump

I'm sure many can benefit from this

[kiwiasian]

Bump

[dlasher]

Page not found

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

[omoba4real]

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.

https://i.imgur.com/IVylp.jpg
https://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.
https://i.imgur.com/WB67n.jpg
https://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.
https://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.
https://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. Donate if you did.

[-ck]

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.