My question is more about how to exploit the Eligius API using an HTTP capable JSON API, as direct JSON calls are a problem for vanilla Excel. Eligius seems to allow for HTTP/JSON calls as with the Last Blocks Found call below. And this HTTP/JSON works well with Excel.

When you go to the main landing page for Eligius, in the top right there are 3 variables I’m hoping to extract and utilize the raw values as published by Eligius.
Hashrate:   11,637.39 Th/s    Round Time:   00:30:53
Round Shares:   5368401920    Round Luck:   735%

http://eligius.st/~wizkid057/newstats/api.php?cmd=getblocks&limit=1&format=csv&csvastext=1 is the “type” of call that works fine but it’s not the “livedata”.
Can anyone offer assistance with how to call "HTTP" accessible JSON API call from Eligius to gather the same 3 variables listed on main Eligius landing page. At a minimum, I need Eligius "current round time" and "current hashrate" to do the calculation. 

thanks!!!

The desire is to use any unmodified Excel without the need for Macro's. Using all Excel Function()s and the Web Query Import. The process is intended to be automated so the call has to be direct as well as the returned output. No human in the middle.

It might help is I could attach the XLS to see that I trying to accomplish.
Are attachments allowed?

So here’s where I’m needing HELP!

The limited Excel Browser that is used to “bounce” the raw data to does not natively handle JSON calls directly. When called, the process is interrupted wanting to “save” the JSON file locally. HOWEVER… it DOES handle HTTP JSON calls as with:
http://eligius.st/~wizkid057/newstats/api.php?cmd=getblocks&limit=1&format=csv&csvastext=1
which outputs:
luck,confirmations,blockhash,height,duration,age,roundstart,roundend,hashrate,...
36.825168438117,1,000000000000000007a3c7c6791d1a28241620035d4677fbe65c97853efa48a4,335277,...
And Excel handles fine.

[Edited] to add...
I just talk to my teenager... He said Dropbox...
So here's the Bitcoin_Mining.xlsx
https://www.dropbox.com/s/qqz64t1b1qtumgu/Bitcoin_Mining.xlsx?dl=0

https://dl.dropboxusercontent.com/s/s7jbgc969hpwms4/Bitcoin_Mining.jpg
Mining Estimates Tab...

https://dl.dropboxusercontent.com/s/7hcha9lol7io18e/Bitcoin_Mining_Slush.jpg
And one of the Pool Tabs (Slush)...


To help shed light what I’m trying to accomplish in detail I’ve attached my Excel XLS.  

And probably more detail than you need (in case you find the XLS useful and want to use it):
It’s created using Office365 but all functions should work thru Excel 2010.
While I’m trying not to use any Macros, it will prompt you when loaded that it wants to use “External Information” in order to run the Blockchain and Pool Excel Web Query’s.
The XLS is sized to be best viewed with a screen resolution of 1600x900.
It’s built to require few manually entered data fields. There is an AutoImport Tab that is intended to be where all Excel Web Query data is placed. This tab is also where any data is tailored prior to being used on any of the other Tabs.
All Tabs EXCEPT the AutoImport Tab are locked to prevent overwriting so to modify the XLS. Password is “blank”. Be sure to relock it to protect yourself from overwriting the formulas used.
The Queries enqueue Excel for a few seconds while the queries are updating. Currently set to 5 and 10 min.
If you'd like to use it... just "clear content" in each of the BTC Payments on each of the Pool Tab's. It also allows some flexibility with changing the Pools if your desired Pool is not one if the 6 I've been using.

*Note... I've not finished working on the Web Queries. Tasks are to find better HTTP/JSON calls to only return what I need rather than screen scraping. Up until now my efforts have been with the "Excel" Tabs and formulas. PLEASE let me know if you find any errors so I can alter my copy.
[/End EDIT]

What I’m looking for is the real time current Pool Hashrate; Round Time(duration); and current Round Luck as displayed on the main Eligius page. The data from the query above is last block/round, not current round.
(My hope is to perfect my knowledge of using the Pool API calls and the many parameters available to be a bit more efficiently.)
Would anyone have the correct URL and parms for getting this from Eligius.st?

thanks in advance,

I'm importing into Excel. From what I'm learning Excel does not handle the "wrapper" for the direct JSON calls therefor any call asks "Do you want to open or save filename.json (nnn bytes) from eligius.st".
So, the PAST Blocks API from eligius.st works fine. http://eligius.st/~wizkid057/newstats/api.php?cmd=getblocks&limit=1&format=csv&csvastext=1 seems to be an "HTTP" call to the JSON API which Excel can handle. For reference, all of the general queries at http://blockexplorer.com/q all work fine and return data in the format Excel can handle.

I'm struggling finding an HTTP/JSON call to gather eligius.st current Pool Hashrate; current Round Time(duration); and current Round Luck as displayed on the main Eligius page.  Seems the "format=csv&csvastext=1" is key but does not work with http://eligius.st/~wizkid057/newstats/instant.php/livedata.json.

Any talent out there know if eligius.st has and "HTTP" accessible JSON API call for the current Pool Hashrate; current Round Time(duration); and current Round Luck data?

thanks in advance...
Happy Holidays

Bump…
http://eligius.st/~wizkid057/newstats/api.php?cmd=getblocks&limit=1&format=csv&csvastext=1 returns "PAST" block info. Does anyone know if there is a call to extract current Pool Hashrate; current Round Time(duration); and current Round Luck as displayed on the main Eligius page.

Pardon if I'm posting in the wrong section... Looking for help with Eligius API.

With no JSON expertise at all, my objective is to return "raw" comma delimited *CURRENT* public stats.

I found "PAST" block info using:
http://eligius.st/~wizkid057/newstats/api.php?cmd=getblocks&limit=1&format=csv&csvastext=1
luck,confirmations,blockhash,height,duration,age,roundstart,roundend,hashrate,...
36.825168438117,1,000000000000000007a3c7c6791d1a28241620035d4677fbe65c97853efa48a4,335277,...
And the format it returns is what I want... but...

I'm looking for real time current Pool Hashrate; Round Time(duration); and current Round Luck as displayed on the main Eligius page. The data from the query above is last block/round, not current round.

I wanting to call directly from a browser and return raw data exactly as with the "getblocks" above using the cvsastext format.

Would anyone have the correct http://eligius.st/~wizkid057/newstats/api.php?cmd= I would use for CURRENT info?

Thanks in advance for any direction you can provide.

I saw the block flagged at Blockchain.info as found by Bitminter.
(I think Bitminter found a block at the same time and the Chain was longer...)

I have an Antminer S3 and an S4.

S3 came first and was running fine around 480-500 GH/s when I pointed to either Slush or BTC Guild.
At both Pools my S3 setting is set within their UI Worker tab to use 256 Min Diff.

Antminer S4 arrived ,setup, configured, pointed it to the Slush Pool and the S4 runs FINE at around 2.1TH/s at both Slush and BTC Pools.
Antminer S4 Done...

Now back to the S3… still running at 480-500 GH/s at the Slush Pool… at this point S3/S4 both are reporting 2.6TGH/s at Slush. Full expected power. Great!
HOWEVER, when I now point the “S3” to BTC Guild, it won’t run past 80GH/s (all chips show fine in the UI, no “x” or “-“)
Switch bask to Slush... 500GH/s... back to BTC Guild... 80GH/s... consistent test...
S3 was running 480-500 at BTC Guild before I added the S4...

Is there a problem running both an S4 and S3 on the same network pointing to BTC Guild? Works fine at Slush (I've not tried it anywhere else... my objective is to use Guild)

thanks for any help you can share

I tried reseating the SD card with same results.

I’m still not sure of the order of pressing the power button, pushing the reset within the LED component hole, I did it in so many combinations. After 20 or so retries, it finally rebooted past a blank screen and displayed an accessible DHCP IP address. 

It’s humming at around 2010 GH/S(avg) stock. I’ll leave it be until I get more familiar with it.

Many thinks to all that contribute here.

Dang, I had it up and running and then had to go change something.
First start had no display and forum help said to pop out card, back in, reboot. This worked… DHCP assigned an IP and it was displayed in the LED. So far so good.

I logged in, changed the password, and Hostname to AntMinerS4 (I also have an S3 so I added S4 as not to conflict with DNS name).
Changed Pools and all worked great all night.

So here’s where it goes wrong. I went to the NETWORK tab and changed the Subnet to 255.255.255.0 and the Gateway and DNS to my Router, 192.168.1.1. I had NOT yet changed the setting from DHCP to STATIC before hitting SAVE and APPLY. Once the S4 rebooted the LED displayed the local loopback 127.0.0.1 instead of an allocated IP. So, I rebooted again and this time I have no display again.
I’m trying to do a factory reset on it and just leave the NETWORK setting alone but can’t seem to get the unit to reset. Not 100% sure how to do this. From what I’ve read, you press a paper clip into the small hole at the bottom left of the LED panel for 3+ seconds to reset. I’ve also read the red light will blink and then it should restart. With the unit on, when I press the paper clip in and hold for 10 seconds and remove, nothing happens…

Am I doing something wrong in order to get the unit to factory reset all settings?

FIXED!
Thank to the folks that support forums...

Hope I'm in the right location for S4 technical help.
Any idea's if the unit arrived defective?

The new Antminer S4 arrived today. I purchased the required 16AMP cord and plugged it up and all fans came on.

However, while the LED “did” Illuminated but the DISPLAY DID NOT SHOW ANY CHARATERS. Total blank.
The 2 lights on the same LED component (red and green) DO NOT appear to be light up.

On the positive side, all fans run (load); the light next to the Power Button lights up green. and on the other side of the chassis, the Ethernet plug DOES light up with a solid yellow light and blinking green (which typically mean data is transmitting, right) however, the lighted display has NO TEXT.

I’m anxious to get the unit up and running but am hopeful your support can point out a quick fix.   

:-(
Please advise.

Thanks for the quick response.
I figured that thread was simply for the Sale and not official trouble shooting. I'll send my details there in hopes for guidance. Thanks again.

Pardon folks,
Is there an official ANTMINER "S4" Discussion and Support Thread>
I purchased an S4 directly from BITMAIN. It arrived today and while the LED lights up, it doesn’t display any writing. It’s completely blank.
I’m hoping some experienced folks here might be able to help but need to land in the right forum for S4 help.
thanks