Bitcoin Forum
December 08, 2016, 04:25:35 AM *
News: Latest stable version of Bitcoin Core: 0.13.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: « 1 [2] 3 4 »  All
  Print  
Author Topic: Spreadsheet: Invest in BTC or mining hardware?  (Read 56502 times)
phelix
Legendary
*
Offline Offline

Activity: 1680


nmc:id/phelix


View Profile
May 09, 2011, 02:46:56 PM
 #21

Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.

Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).

I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3.


blockchained.com ■ bitcointalk top posts
1481171135
Hero Member
*
Offline Offline

Posts: 1481171135

View Profile Personal Message (Offline)

Ignore
1481171135
Reply with quote  #2

1481171135
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1481171135
Hero Member
*
Offline Offline

Posts: 1481171135

View Profile Personal Message (Offline)

Ignore
1481171135
Reply with quote  #2

1481171135
Report to moderator
1481171135
Hero Member
*
Offline Offline

Posts: 1481171135

View Profile Personal Message (Offline)

Ignore
1481171135
Reply with quote  #2

1481171135
Report to moderator
1481171135
Hero Member
*
Offline Offline

Posts: 1481171135

View Profile Personal Message (Offline)

Ignore
1481171135
Reply with quote  #2

1481171135
Report to moderator
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 09, 2011, 03:15:41 PM
 #22

Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.

Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).

I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3.
Hmmm... any idea what I am missing?  I double checked it, and I did find one mistake in the net profit if traded daily... I wasn't including the uptime percentage in that calculation!  Other than that though, everything looked good.  To me, at least.
JJG
Member
**
Offline Offline

Activity: 70


View Profile
May 09, 2011, 03:21:59 PM
 #23

Yes you're right, i'm checking using the last few data points of difficulty increase.
this is what i obtain


around 1,7 mln difficulty for november, 6 months from now. i used the "gpu" historical data.
To match this new value, i've to use 18% instead of 8.6% as "Expected average change in difficulty" in the spreadsheet.


18% is still going to give you way optimistic results, especially in the near term.

You cannot use anything other than 40% if you want realistic results. If you're going to extrapolate that far out and assume that increases will fall in the future to 18%, then you're going to have to modify the spreadsheet to have a 'difficulty increase' that decreases by a % every month.
phelix
Legendary
*
Offline Offline

Activity: 1680


nmc:id/phelix


View Profile
May 09, 2011, 03:41:46 PM
 #24

Updated to 1.3... includes all of JJG's suggestions and phelix's suggestion to include calculations for selling immediately (or in this case, daily, since hourly would be a bit insane and impractical.

Next update, I'm going to notate all of the calculations in comments on each calculated field, so that others can more easily double-check my work (and I can double-check it myself while writing out the notations as well).

I think you forgot to add/subtract some cells in the sums for "total net profit" and "total net profit daily" in version 1.3.
Hmmm... any idea what I am missing?  I double checked it, and I did find one mistake in the net profit if traded daily... I wasn't including the uptime percentage in that calculation!  Other than that though, everything looked good.  To me, at least.

for short time frames the traded daily value gets much better than the stashed total profit. I think the cost of the cards is missing from the "total net profit daily". in the "total net profit" is the salvage hardware value included?


blockchained.com ■ bitcointalk top posts
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 09, 2011, 03:51:07 PM
 #25

You're right, thanks!  The latest spreadsheet should fix all of those issues.  Salvage value was not being included on the total net profit calculation, and initial capital expense was not being included in the total net profit if traded daily calculation.
sniper_sniperson
Full Member
***
Offline Offline

Activity: 124


View Profile
May 12, 2011, 10:41:59 PM
 #26

Is it possible to lower the requirements for this spreadsheet ie to work on Excel 2003 without installing compatibility addon?
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 12, 2011, 10:46:10 PM
 #27

Is it possible to lower the requirements for this spreadsheet ie to work on Excel 2003 without installing compatibility addon?
Here you go:  http://www.justinbporter.com/bitcoin_mine_or_invest_1.32.xls

It gave a warning about the conditional formatting, so I'm not sure if the red/green highlights will still work, but the numbers themselves should be ok.
sniper_sniperson
Full Member
***
Offline Offline

Activity: 124


View Profile
May 13, 2011, 06:29:42 AM
 #28

Error 404 - Not Found Cheesy
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 13, 2011, 06:33:32 AM
 #29

Gah, my bad.  Try it again.
phelix
Legendary
*
Offline Offline

Activity: 1680


nmc:id/phelix


View Profile
May 13, 2011, 11:28:30 AM
 #30

With OpenOffice it works like a charm  Cheesy

blockchained.com ■ bitcointalk top posts
sniper_sniperson
Full Member
***
Offline Offline

Activity: 124


View Profile
May 13, 2011, 01:01:17 PM
 #31

I'm refusing to install JRE Grin
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 13, 2011, 04:25:34 PM
 #32

I'm refusing to install JRE Grin
Lolwut?  Office requires JRE?
Raize
Donator
Legendary
*
Offline Offline

Activity: 1375


View Profile
May 13, 2011, 07:51:00 PM
 #33

OpenOffice has and does. Although I think there is a way to install it without installing JRE as well if you're willing to unpack the installation files yourself.

OrganofCorti's Neighbourhood Pool Watch - The most informative website on blockchain health
DavinciJ15
Hero Member
*****
Offline Offline

Activity: 750


Bitcoin - helping to end bankster enslavement.


View Profile WWW
May 24, 2011, 06:40:35 PM
 #34

Your spreadsheet is very depressing.  It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency.  In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?

What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.



SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 24, 2011, 06:42:47 PM
 #35

Your spreadsheet is very depressing.  It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency.  In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?

What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.
Sorry to be the bearer of bad news...  Sad

I would advise people against investing in new mining hardware at this point.  It is still very profitable TODAY, but with the exponential growth not expected to decline any time soon, mining is going to have slim margins, at best, in the not-so-distant future.
darbsllim
Sr. Member
****
Offline Offline

Activity: 294


Founder, Filmmaker, Fun Guy


View Profile WWW
May 24, 2011, 06:49:55 PM
 #36

Your spreadsheet is very depressing.  It's so easy to forget how fast an exponential growth moves, I guess that's how we got a debt based currency.  In 6 months my 6 Giga hashes will get me 0.08 bitcoins per day!?

What makes no sense is bitcoins need to be $1000 in 6 months for me to continue mining.





Thats why I think the best place to profit is with BitCoin Business Davinci =)  BTW this is Brad from email we've been chatting back and forth about silver and bitcoins.

Brad Mills
Former miner - Former Bitcoin Business Owner - Victim of the Great Bitcoin Crashes of 2011 and 2012
Dobrodav
Full Member
***
Offline Offline

Activity: 140


View Profile
May 26, 2011, 05:53:03 AM
 #37

404 errors.

We will  meet in not-so-distant future.
Today`s strange music :
http://www.youtube.com/watch?v=V8mCgjbBPMk
Yesterday`s  strange music:
http://www.youtube.com/watch?v=-uCTyC1FGLw
SgtSpike
Legendary
*
Offline Offline

Activity: 1344



View Profile
May 26, 2011, 06:24:54 AM
 #38

Should be fixed.  I am in the middle of switching web hosts.
Tally-ho
Newbie
*
Offline Offline

Activity: 19


View Profile
May 31, 2011, 01:12:39 AM
 #39

Very nice tool, thanks!
evlew
Sr. Member
****
Offline Offline

Activity: 404



View Profile
June 04, 2011, 11:11:05 PM
 #40

cans someone explain the "expected average change in difficulty" and the "next difficulty starts in this many days" fields?

Thanks in advance.  What are realistic numbers to plug in here?
Pages: « 1 [2] 3 4 »  All
  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!