*** Solved.
*** Solved. If anyone would like a copy of the spreadsheet, join Slush's Pool and drop by our IRC. Look up "Eidolonius" or ask for a link to his site.
*** Solved.

The calculator atop your difficulty page is fabulous and it's really helped me get a handle on ROI for equipment purchases. To use it, however, I've got to hand copy difficulty predictions I make from my own spreadsheet into your form and hand-copy the BTC/mo result back. Any chance you'd be willing to share the equation with me so I can automate it?

The bottom part of my spreadsheet is this:

Date.....Difficulty.....MH/s......BTC/day

The top half of my spreadsheet generates the first two columns, I enter the third based on delivery dates of equipment. What I need is the formula for the fourth.

Put more simply, for a given Difficulty (D) and a given hashrate (H), what's the Excel formula to calculate BTC/day?

Thanks again for a great tool and double thanks if you can help me out with the math here.

Thanks,
D

P.S.: FYI, if you're considering adding more technical analysis tools, you might consider On Balance Volume next. I think that would be very useful to get a picture of the volume-based movement. (I do technical analysis of stocks for a living, so I especially appreciate having these tools applied to BTC.)


(Edit: Changed the desired output to BTC/day)

Thanks for the reply. It looks like I had the wrong formula for K and D before.

The Android app seems has been removed. Hope it won't bring too much trouble.

Can we have it added to the top bar as a mini ticker as well? Since BTCChina is there it'd make sense to have Huobi too.

What does the 1 in SMA(RSV,3,1); mean? I took the SMA of RSV over 3 periods and get a similar result to yours but it's still not quite right. For my SMA calc I just did a simple SMA = (day1 + day2 + day3) 3

Some change made about 3 days ago has broken the update script in firefox.  The page now loads and shows the loading box but never loads so the orderbook and transactions never show up.  This is probably the same problem several others have noted.

TaggedYa

I have a request... Can you please put "Huobi" as the primary "China value", since BTCChina is essentially a wash-out of an exchange. Using BTCChina as the "source of CNY value", would be like using BTCe as the source of USD value for comparison.

Also, for the alternate exchanges, that are of another currency, can you put the (Your preferred currency) value next to the actual currency value we are looking at. Just like you do for BTCChina, but on all, and at the chart-level also. That would make the charts more useful for comparison.

Last suggestion, the ability to "overlap" two charts values would be great. (Perhaps showing the "shadow-chart" as shades of blue, behind the chart we are using for comparison.)

Thank-you, JD

P.S. Love the charts and setup. Just wish it showed more volume depth on the side of the graph, or had an option to adjust QTY of volume, for the volumes we trade at. (EG, I trade by 100's, so I need to see 1000's of volume, not only 400 volume.)

good site, i like the real time stuff

Sorry for misleading. I fogot SMA is not Simple Moving Average in this formula.
The formula I used is
Y=SMA(RSV,n,m)=(m*RSV+(n-m)*Y')/n
Y' means previous Y
when n = 3 and m = 1
Y=SMA(RSV,3,1)=(RSV+2*Y')/3
when m = 2, it close to EMA