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.xlsxhttps://www.dropbox.com/s/qqz64t1b1qtumgu/Bitcoin_Mining.xlsx?dl=0https://dl.dropboxusercontent.com/s/s7jbgc969hpwms4/Bitcoin_Mining.jpgMining Estimates Tab...
https://dl.dropboxusercontent.com/s/7hcha9lol7io18e/Bitcoin_Mining_Slush.jpgAnd 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,