HI
got this working.
for 12x gtx1070: {"coins":{"Zcash":{"id":166,"tag":"ZEC","algorithm":"Equihash","block_time":"147.0","block_reward":10.0,"block_reward24":10.0,"last_block":267299,"difficulty":8569198.1546495,"difficulty24":7099938.66248758,"nethash":477543342,"exchange_rate":0.044693,"exchange_rate24":0.0420029894957983,"exchange_rate_vol":1153.463661852,"exchange_rate_curr":"BTC","market_cap":"$941,994,815.39","estimated_rewards":"0.06351","estimated_rewards24":"0.07665","btc_revenue":"0.00283836","btc_revenue24":"0.00342573","profitability":87,"profitability24":106,"lagging":false,"timestamp":1517880992}


A few questions
1) is importing this into excel the best way via a power query?
2) how do I get it to extract the top first three most profitable - and is this locked to the coin ID on the original import, or is it dynamic?
3) I don't see "rev$ / Profit" in the json results, can i find it else where, or is there another query that is connected to power usage?

Thanks

I was also looking for this.
Thanks for asking and answering.

Also, regarding coins.json how is revenue or reward determined without a hash rate, or does it take some assume/ arbitrary (1000h/s?) hash rate?

I assume that with that information, i could calculate my profit using my own hash rates and electricity rate? (and do this in excel)

Thanks

Thanks for answering!

Just to confirm - Rev vs Profit.
Rev is pure coins mined, whilst profit = rev - power consumption ($)?

Thanks

Hi fredeq
Thank you so much for your website.

Just wondering, is there a guide on what all your column headings mean?

If you can point me to it, then I can read and understand.

Otherwise, I had a few questions:
what is the base of the 'est rewards'? Is this in BTC, or the coin in question?
Wouldn't it make sense to make this standardised?

Also
What does Rev. BTC vs Rev. 24h vs Rev $ vs Profit (under rev $ in bold)

Thanks