Post
Topic
Board Pools
Re: [10000Th] Eligius: 0% Fee BTC, 105% PPS NMC, No registration, CPPSRB
by
RealMalatesta
on 23/12/2014, 15:53:18 UTC

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


Have you checked this site:
http://ramblings.mcpher.com/Home/excelquirks/json/excel-json-conversion
?