Pages:
Author

Topic: Profitability of Mining + Excel Workbook (Read 5440 times)

member
Activity: 84
Merit: 10
May 23, 2011, 01:19:18 AM
#33
Ha, I did the same thing but with different assumptions, I even measured the actual Wattage being used on the machine with a kill-a-watt meter.  Here is what I came up with (tl;dr = 3.5 months to recoup hardware if the difficulty doesn't change).

Note: all of the hardware was extra gear I had and/or snagged for a bargain locally, usually used via Craigslist so my hardware cost is low vs. retail.

I could send the spreadsheet to anyone interested.



Yes please!

Me too please Smiley
member
Activity: 112
Merit: 100
"I'm not psychic; I'm just damn good"
Sorry for reviving an old tread. I was doing some excel calculation of my own, Albeit different from what is going on here, I'm not an avid programmer and would like to ask a few questions.

Where do I fetch the information of the difficulty, network calculation power and etc. I'm very new to bitcoin and have been doing a lot of reading. But not that technically inclined like most of the people here.

After the where comes the how, I want my excel sheet to fetch some of these numbers from the net. But I really do not know how and where. Some of the things I'll probably be putting in my excel sheet will be like the
 - BTC/USD exchange rates (I don't know but I've been going to this bitcoinchart to see it although I hasn't really understood how to do exchanges yet)

 - USD to other currency rates
 - Current Difficulty
 - Current Network Power
 - Trading Charges
 - Mining Charges from different pool
 - etc.

I don't know how to just fetch numbers from websites I find and have been updating them manually, if any of you guys may please help because it's been exhausting these few days following all these different information from different sites. I'm sorry if I sound stupid to some but I'm trying. All help is appreciated.
sr. member
Activity: 714
Merit: 250
A 5970 is ~$500 and can earn about 750mhash/s
That's 1.5mhash/$1


A 5850 is ~$150 and can earn about 350mhash/s. It can overclock a bit better than the 5970 due to less heat restrictions.
That's 2.33mhash/$1

I'm going to say you can fit either card on a motherboard, since they are both dual slots. The ASUS super computer mobo can fit 4 but is $400, and I can't think of any other atm.

So let's say...
Mobo $200
HDD $50
RAM $50
CPU $75
PSU for 5970's needs to be close to 1kw PSU as a rough estimate, so ~$200
PSU for 5850's needs to be around 750w PSU as a rough estimate, so ~$100

3x 5970's is around $2075 just for the parts.
2250mhash/s.
1.084mash/$1

3x 5850's is around $925 just for the parts
1050mhash/s.
1.135mash/$1

This all takes into account some modest overclocks. I'd have to say the 5850 is the better choice here. It's a smaller investment and a little more efficient than the 5970's. Not to mention there is more room for overclocking on the 5850 build.

sr. member
Activity: 350
Merit: 250
I'm so sick and tired of what I call "I hope" calculations. Where is the next difficulty rise of ~50% included with this?

I guess if you already had a lot of bitcoins then you want more miners to just jump in and help increase btc value you already have, but new miners really need to look and think twice.

Noone would have believed two weeks ago if someone said next increase will be 50%. Do you believe it now? I bet a lot of people already have bunch of hardware in transit sitting on the next rise in difficulty. Profit more or less cut in half. 

Would you believe it if I said we are past the point of no return and will be seeing exponential increases in difficulty from this point onwards for rest of bitcoin release? Noone knows, but I think we are very near this point or a News report or two away from it. I noticed first hand what one stupid forum thread does to a difficulty. I wonder what one cnn new report might do to it.

All I'm trying to say is people are throwing around all these "I hope" charts and tables filled with their flawed assumptions and I wonder what their intentions are. All they have to say in their argument is "don't worry the btc value will go up with difficulty" but reality doesn't guarantee it so. If anything it will only create a larger bubble following that simple logic. It's more like "don't worry and mine so btc I already have will go up in value faster now because it's becoming harder and harder to make for everyone even faster".

No matter how much you want to think that you didn't miss the rush yet, the initial rush of bitcoin early adopting is old news at this point. Think about what is benefiting who how now and later.


JJG
member
Activity: 70
Merit: 20
For anyone considering using this spreadsheet: Don't use it to make forecasts longer than a few days out. Difficulty is rising rapidly, and as far as I can tell this spreadsheet assumes difficulty will stay flat. None of these predictions will work more than a few days out.
newbie
Activity: 6
Merit: 0
We need to make more and more spreadsheets and guide like this so everyone can make free money. OCN represent!!
member
Activity: 99
Merit: 10
If only I could find a 5970 for $400 on ebay like the spreadsheet says Sad
member
Activity: 63
Merit: 10
Quote

Ok.  900mhz and 330M is fine with me then.  I do not want to push my cards over 900mhz.  

Just a random comment: you can turn down the memory clock to 300Mhz without loosing hashes, and the temps are approx. 5C lower.

I just tried this on the machine listed in the spreadsheet above, I still had the watt-o-meter connected, not only did it drop the temps by 3C per GPU it reduced the power load by 40W, that is almost 10% which really adds up over time - like $40 in savings if I run this machine for a full year!

Thanks for the hint!
member
Activity: 69
Merit: 10
ASICMINER shares: Havelockinvestments.com
Quote

Ok.  900mhz and 330M is fine with me then.  I do not want to push my cards over 900mhz. 

Just a random comment: you can turn down the memory clock to 300Mhz without loosing hashes, and the temps are approx. 5C lower.
legendary
Activity: 800
Merit: 1001
Ha, I did the same thing but with different assumptions, I even measured the actual Wattage being used on the machine with a kill-a-watt meter.  Here is what I came up with (tl;dr = 3.5 months to recoup hardware if the difficulty doesn't change).

Note: all of the hardware was extra gear I had and/or snagged for a bargain locally, usually used via Craigslist so my hardware cost is low vs. retail.

I could send the spreadsheet to anyone interested.



Yes please!
member
Activity: 63
Merit: 10
Ha, I did the same thing but with different assumptions, I even measured the actual Wattage being used on the machine with a kill-a-watt meter.  Here is what I came up with (tl;dr = 3.5 months to recoup hardware if the difficulty doesn't change).

Note: all of the hardware was extra gear I had and/or snagged for a bargain locally, usually used via Craigslist so my hardware cost is low vs. retail.

I could send the spreadsheet to anyone interested.

newbie
Activity: 56
Merit: 0
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.
My first thought
 Cheesy

 Cheesy This is the funniest thing I have seen on these forums. 
newbie
Activity: 23
Merit: 0
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.

What does it require?  I get 330 with 900mhz clocks, i know i could go higher on the clock a bit but choose not too. 

It requires going higher on the clocks!   Cheesy

Playing with other settings. Finding the right combo of drivers / sdk. Reading the forum and see what works for others. Basically try different things until you see an improvement.

Ok.  900mhz and 330M is fine with me then.  I do not want to push my cards over 900mhz. 

I usually run my clocks around 910 for Gigabyte 5870 and 965 for XFX 5870. Mem clocks are near 300.
legendary
Activity: 1386
Merit: 1004
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.

What does it require?  I get 330 with 900mhz clocks, i know i could go higher on the clock a bit but choose not too. 

It requires going higher on the clocks!   Cheesy

Playing with other settings. Finding the right combo of drivers / sdk. Reading the forum and see what works for others. Basically try different things until you see an improvement.

Ok.  900mhz and 330M is fine with me then.  I do not want to push my cards over 900mhz. 
full member
Activity: 154
Merit: 100
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.

What does it require?  I get 330 with 900mhz clocks, i know i could go higher on the clock a bit but choose not too. 

It requires going higher on the clocks!   Cheesy

Playing with other settings. Finding the right combo of drivers / sdk. Reading the forum and see what works for others. Basically try different things until you see an improvement.
newbie
Activity: 23
Merit: 0
You are overly optimistic and you are rounding all costs down and all benefits up.

Ebay 5970 prices are rather $450 than $400. You would need a better case (or build one yourself). This one will not give you enough airflow. You need way more ventilation and a few good fans ($15-20 each). If not, you will not be able to overclock the cards, at least not to all way up. The system will not need 294x2 W but 700-750W depending on the PSU efficiency. Depending on your climate, you will need to air condition this 700W. The BTC bid price is, last time I checked, $0.87, not $1.00  and nobody knows, where it is headed (it was $0.6x just a few days ago). And if it is indeed $1.00 or more, you can be certain of a significant difficulty increase. Before you even order these parts, the difficulty is going to be 10-15% more and when you have it all running, you will be half way to another 10% of difficulty increase. Taking all that into account (especially the difficulty increase of 10% every 2016 blocks which may be conservative but during all my time with Bitcoin, difficulty increased faster than I always expected), you are going to get 1500 BTC before electricity costs in 180 days (minus 3 BTC a day of electricity costs with AC=540 BTC) which is not going to pay for this system at current BTC prices. Then, another 90 days will bring you only 300 BTC before electricity (but maybe the difficulty increase will slow and it will be a bit more). Did I mention that your eBay card may fail after a few weeks of constant use and you are out of warranty?

In my opinion, it is well worth mining with a system you already have. And it is also worth building a mining rig if you like building computer systems and monitoring it because it's fun. And the mining will eventually pay for the system (but not for the time you spend on it so consider it a hobby). But profit? Not so much unless the BTC price increase well beyond 1$ (and better yet not now but later so it does not impact the current difficulty). And for the prices, we are in the "tea leaves reading" territory. And if you expect higher prices, it is much simpler to just buy BTC, instead of the mining rig.
The dedicated mining rig is the riskiest option out of the two that I posed. The fact that this market can gain/lose 40% of it's value in the course of a week is insane, and makes it a risky investment. I absolutely recommend just upgrading, as you have less time (and therefore less risk) until you hit the break even point. And even then, you can "get out" at any time by just selling the card itself.

Trust me, I don't have the capital nor the balls to build a dedicated mining rig. I have upgraded two computers and nearly have them paid off (sold off all of my BTC in the last day). This just shows that it is possible to make a short term profit mining bitcoins. Is it a risky investment? Hell yeah, as there are a number of things that could go wrong. Is it safer than speculating in BTC itself? In my opinion, absolutely. I would rather put $1000 into a mining rig and have the fallback option of selling it if the market tanks, rather than owning a lot of worthless currency.

And to all of the people attacking me on difficulty: can you recommend a way to "guess" at a better break even point using a difficulty estimate? I'm not concerned with anything past the break even point (~45 days), as that is when it becomes purely profitable to run your rig regardless.

And also, yes, I get 370,000 khash on my 5870 on air through overclocking. The average between my two currently is about 360000 khash, and the hottest temp I have is 70 degrees celcius.
full member
Activity: 154
Merit: 100
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.
My first thought

 Cheesy

This is before my time (computer wise), but awesome none-the-less!
member
Activity: 112
Merit: 11
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.
My first thought

 Cheesy
legendary
Activity: 1386
Merit: 1004
And by the way, 5870's @ 370 Mhash/s?  Did you kill something to achieve this?

This doesn't require voodoo.

What does it require?  I get 330 with 900mhz clocks, i know i could go higher on the clock a bit but choose not too. 
full member
Activity: 154
Merit: 100
over here I pay 30 cent per kw/h power. A 300 MHashes/sec GPU consumes 300W.

That's very expensive electricity. And there are cards that can do 350MHash/s at 180W.
Pages:
Jump to: