Bitcointalk Mobile Browser presented by IRLBTC™

<< >> (p.2)

Author

Topic: Spreadsheet: Invest in BTC or mining hardware? (Read 58760 times)

phelix

Legendary

Offline

Activity: 1708
Merit: 1020

Re: Spreadsheet: Invest in BTC or mining hardware?

May 09, 2011, 02:46:56 PM

#21

Quote from: SgtSpike on May 09, 2011, 06:23:25 AM

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.

SgtSpike (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 09, 2011, 03:15:41 PM

#22

Quote from: phelix on May 09, 2011, 02:46:56 PM

Quote from: SgtSpike on May 09, 2011, 06:23:25 AM

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

Activity: 70
Merit: 20

Re: Spreadsheet: Invest in BTC or mining hardware?

May 09, 2011, 03:21:59 PM

#23

Quote from: Enky1974 on May 09, 2011, 02:31:48 PM

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

Activity: 1708
Merit: 1020

Re: Spreadsheet: Invest in BTC or mining hardware?

May 09, 2011, 03:41:46 PM

#24

Quote from: SgtSpike on May 09, 2011, 03:15:41 PM

Quote from: phelix on May 09, 2011, 02:46:56 PM

Quote from: SgtSpike on May 09, 2011, 06:23:25 AM

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.

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?

SgtSpike (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

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

Activity: 124
Merit: 100

Re: Spreadsheet: Invest in BTC or mining hardware?

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 (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 12, 2011, 10:46:10 PM
Last edit: May 13, 2011, 06:33:20 AM by SgtSpike

#27

Quote from: sniper_sniperson on May 12, 2011, 10:41:59 PM

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

Activity: 124
Merit: 100

Re: Spreadsheet: Invest in BTC or mining hardware?

May 13, 2011, 06:29:42 AM

#28

Error 404 - Not Found Cheesy

SgtSpike (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 13, 2011, 06:33:32 AM

#29

Gah, my bad. Try it again.

phelix

Legendary

Offline

Activity: 1708
Merit: 1020

Re: Spreadsheet: Invest in BTC or mining hardware?

May 13, 2011, 11:28:30 AM

#30

With OpenOffice it works like a charm Cheesy

sniper_sniperson

Full Member

Offline

Activity: 124
Merit: 100

Re: Spreadsheet: Invest in BTC or mining hardware?

May 13, 2011, 01:01:17 PM

#31

I'm refusing to install JRE Grin

SgtSpike (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 13, 2011, 04:25:34 PM

#32

Quote from: sniper_sniperson on May 13, 2011, 01:01:17 PM

I'm refusing to install JRE Grin

Lolwut? Office requires JRE?

Raize

Donator
Legendary

Offline

Activity: 1420
Merit: 1024

Re: Spreadsheet: Invest in BTC or mining hardware?

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.

DavinciJ15

Hero Member

Offline

Activity: 779
Merit: 510

Bitcoin - helping to end bankster enslavement.

Re: Spreadsheet: Invest in BTC or mining hardware?

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 (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 24, 2011, 06:42:47 PM

#35

Quote from: DavinciJ15 on May 24, 2011, 06:40:35 PM

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

Activity: 297
Merit: 251

Founder, Filmmaker, Fun Guy

Re: Spreadsheet: Invest in BTC or mining hardware?

May 24, 2011, 06:49:55 PM

#36

Quote from: DavinciJ15 on May 24, 2011, 06:40:35 PM

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,
Investor - Former miner - Former Bitcoin Business Owner - Survivor of the Great Bitcoin Crashes of 2011 and 2012, the MtGox Heist of 2014 & the 2017 crypto bubble.
Bitrated user: bradmillscan.

Dobrodav

Sr. Member

Offline

Activity: 350
Merit: 250

Re: Spreadsheet: Invest in BTC or mining hardware?

May 26, 2011, 05:53:03 AM

#37

404 errors.

Poker [♠]]]]] Roulette ( +)
Pyramid ■□ Slots [◉◎◎]

───────────────────
777^COIN
─── C A S I N O ───

★ The Most Exciting Bitcoin Casino!
★ Secure and Provably Fair
★ Altcoins Accepted

SgtSpike (OP)

Legendary

Offline

Activity: 1400
Merit: 1005

Re: Spreadsheet: Invest in BTC or mining hardware?

May 26, 2011, 06:24:54 AM

#38

Should be fixed. I am in the middle of switching web hosts.

Tally-ho

Newbie

Offline

Activity: 19
Merit: 0

Re: Spreadsheet: Invest in BTC or mining hardware?

May 31, 2011, 01:12:39 AM

#39

Very nice tool, thanks!

evlew

Sr. Member

Offline

Activity: 406
Merit: 250

Re: Spreadsheet: Invest in BTC or mining hardware?

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

Page 1

Viewing Page: 2