Post
Topic
Board Pools (Altcoins)
Re: █▓▒░-< [ZPOOL.CA][FlexFee™][SegWit] The miners multipool >-░▒▓█
by
cornercafe
on 30/01/2018, 01:15:30 UTC
Anybody has leveraged the API to get data from ZPOOL in a Google Sheet?

I tried but got lost in the proceed.   Huh I believe though that should I have something to start with I could achieve what I want.

Thanks for your support...


I was able to get LibreOffice Calc to make an external data link to the WhatToMine.com website. It gives me real-time info without all the stupid flashing pop-ups and extra crap no one wants to see. It's rough going, since I'm not a VB programmer. I had to write some macros to fire when the sheet opens, closes, and updates the highest-paying coin.



So this is working in Excel then?  Can I have a look at it?  Maybe I can leverage this for me and the community.


Not excel, LibreOffice Calc. I can send you a copy of the sheet if you tell me where to send it. It's pretty simple. It should work OK in excel, though. I opened Calc, added a sheet or two, and went to the last sheet, top menu  sheet > link to external data, and give it Whattomine's ASIC url:
(https://whattomine.com/asic?utf8=%E2%9C%93&factor%5Bsha256_hr%5D=14000.0&factor%5Bsha256_p%5D=1370.0&scryptf=true&factor%5Bscrypt_hash_rate%5D=500.0&factor%5Bscrypt_power%5D=800.0&factor%5Bx11_hr%5D=15000.0&factor%5Bx11_p%5D=1200.0&factor%5Bqk_hr%5D=450.0&factor%5Bqk_p%5D=75.0&factor%5Bqb_hr%5D=450.0&factor%5Bqb_p%5D=84.0&factor%5Bcost%5D=0.1&sort=Profitability24&volume=0&revenue=24h&factor%5Bexchanges%5D%5B%5D=&factor%5Bexchanges%5D%5B%5D=abucoins&factor%5Bexchanges%5D%5B%5D=bitfinex&factor%5Bexchanges%5D%5B%5D=bittrex&factor%5Bexchanges%5D%5B%5D=bleutrade&factor%5Bexchanges%5D%5B%5D=cryptopia&factor%5Bexchanges%5D%5B%5D=hitbtc&factor%5Bexchanges%5D%5B%5D=poloniex&factor%5Bexchanges%5D%5B%5D=yobit&dataset=&commit=Calculate)

then select html_1 for the ASIC table. If you're interested in SHA, or other algorithm, you can go to that page, and use that url instead. There are 3 different types of tables. if you select 'all', it'll bog-down your app when it refreshes from updating so many fields. It works pretty well so far. I've checked it against WhatToMine for several days and it works. It's easy to get the sheet corrupted though, and not update the fields. I use LO Calc to keep track of the pools, addresses, and coins, receive addresses, the profits, etc.  It's pretty handy if you don't have Awesome Miner. I'd like to use it to profit-switch. You can capture the current top coin name, pull the url from a table and pass it all to SSH I guess -- I'm giving it a try anyway. It'd have to be easier than doing all that coding, plus, you have the added functionality of tracking the pools, etc. 

So, I guess I'm screwed on those Linx Coins from zpool? The txid's
about 3am, CST 1-24-18
http://zpool.ca/explorer/LINX?txid=bf2455649aeaec5a6c5371a1e0e1d6e1d2d63463627efe55da4bd5862f372c0f
about 11pm, CST 1-23-18
http://zpool.ca/explorer/LINX?txid=816092d16724e26e87ebb4afb86cb0973b3a6be343d11ac50435cf6d083f54f2
about 8pm CST, 1-23-18
http://zpool.ca/explorer/LINX?txid=a4923f735eae04785fa02c8eb26fd3f8a7856f284362c07e3d1e32504f93b292
about 4pm CST, 1-23-18
http://zpool.ca/explorer/LINX?txid=536b009638d636efdf5b8a6fe4bed1fd495c5f2e2df94d02c11146185dcf7c1f

don't show up in https://chainz.cryptoid.info/linx/.  So, is this a common occurrence in mining pools? Can I get those coins back somehow?