Topic: Whattomine - profitability website with basic json. - page 43. (Read 94955 times)
Is there a way to fetch 3 or 7 days average values of difficulty/profitability? I see them in web interface but cannot find them in JSON.
I have reduced ETH and ETC block reward to 4.85 due to uncles lowered reward.
Followed number presented by vitalik here https://blog.ethereum.org/2016/10/31/uncle-rate-transaction-fee-analysis/
Will try to find the same for EXP, but it might be negligible, as the block time is much higher at 1m15s.
Added Sibcoin with X11Gost algo. http://whattomine.com/coins/169-sib-x11gost
Site it now a part of newmine affiliate program, where you can buy rigs with 50$ discount (and help to run WTM as well) using "whattomine" code.
http://www.newminerigs.com/shop.html
Followed number presented by vitalik here https://blog.ethereum.org/2016/10/31/uncle-rate-transaction-fee-analysis/
Will try to find the same for EXP, but it might be negligible, as the block time is much higher at 1m15s.
Added Sibcoin with X11Gost algo. http://whattomine.com/coins/169-sib-x11gost
Site it now a part of newmine affiliate program, where you can buy rigs with 50$ discount (and help to run WTM as well) using "whattomine" code.
http://www.newminerigs.com/shop.html
Well I'm clueless, won't work when I create a new file either.
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
Hmm strange indeed.
You can share yours with me, curious whats wrong.
Cheers!
Keep struggling with this, can you PM your emailaddress to me, I'll share a document where I can't get functions on the imported JSON values working.
Hello, API page for one currency (for example whattomine.com/coins/166.json) returns "estimated_rewards" and "btc_revenue" calculated for 24h interval. Is there way to get this calculated for current values on this page? This values are on page with all coins (whattomine.com/coins.json), there are both "estimated_rewards" and "estimated_rewards24" estimates. Also I try to use get-parameter "166.json?revenue=current" or "revenue=24h" but it not works there.
If you would like to calculate it for other set of values, then you just need to send them.
To check the param names you could enable all fields via UI and press calculate.
I guess you want to send in current_difficulty. You could also customize BTC price.
Hello, API page for one currency (for example whattomine.com/coins/166.json) returns "estimated_rewards" and "btc_revenue" calculated for 24h interval. Is there way to get this calculated for current values on this page? This values are on page with all coins (whattomine.com/coins.json), there are both "estimated_rewards" and "estimated_rewards24" estimates. Also I try to use get-parameter "166.json?revenue=current" or "revenue=24h" but it not works there.
Well I'm clueless, won't work when I create a new file either.
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
Hmm strange indeed.
You can share yours with me, curious whats wrong.
Cheers!
Well I'm clueless, won't work when I create a new file either.
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
I'll take your file and work everything back there, no clue what's going wrong in my file.
Thanks for helping out!!
requested access to your file, won't work setting them back to auto here.
I see, works in your file perfectly.
I'll create a whole new file, let's see if that fixes things.
I see, works in your file perfectly.
I'll create a whole new file, let's see if that fixes things.
Works for me, maybe put all those fields back to auto?
Sounds right, but still won't work 
S10 is =SUM(S2,S4,S6,S8)
S10 is =SUM(S2,S4,S6,S8)
Working command was:
=ImportJSON("http://whattomine.com/coins/166.json?hr=185&p=105.0&fee=0.0&cost=0.076&hcost=0.0")
A bit offtopic maybe, as I have some difficulties with Google docs.
Imported the json values in google spreadsheet, but how to do calculation with them?
Whatever I do the BTC revenue value (R2), revenue value (S2), profit (U2), none of them can be used?
Setting them formatted as 'number' won't work either.
Running out of options here, anyone got any clue?
=ImportJSON("http://whattomine.com/coins/166.json?hr=185&p=105.0&fee=0.0&cost=0.076&hcost=0.0")
A bit offtopic maybe, as I have some difficulties with Google docs.
Imported the json values in google spreadsheet, but how to do calculation with them?
Whatever I do the BTC revenue value (R2), revenue value (S2), profit (U2), none of them can be used?
Setting them formatted as 'number' won't work either.
Running out of options here, anyone got any clue?
Problem comes from the fact that spreadsheet does not recognize "." as a valid delimiter due to regional settings.
Change your regional settings under "File -> spreadsheet settings" to any country using decimal point:
https://en.wikipedia.org/wiki/Decimal_mark#Countries_using_Arabic_numerals_with_decimal_point
Working command was:
=ImportJSON("http://whattomine.com/coins/166.json?hr=185&p=105.0&fee=0.0&cost=0.076&hcost=0.0")
A bit offtopic maybe, as I have some difficulties with Google docs.
Imported the json values in google spreadsheet, but how to do calculation with them?
Whatever I do the BTC revenue value (R2), revenue value (S2), profit (U2), none of them can be used?
Setting them formatted as 'number' won't work either.
Running out of options here, anyone got any clue?
=ImportJSON("http://whattomine.com/coins/166.json?hr=185&p=105.0&fee=0.0&cost=0.076&hcost=0.0")
A bit offtopic maybe, as I have some difficulties with Google docs.
Imported the json values in google spreadsheet, but how to do calculation with them?
Whatever I do the BTC revenue value (R2), revenue value (S2), profit (U2), none of them can be used?
Setting them formatted as 'number' won't work either.
Running out of options here, anyone got any clue?
Perfect, thanks! 
Is it possible to fetch json data other than the default 280x data?
http://whattomine.com/coins/166.json
http://whattomine.com/coins/166.json
Sure. You can use params from browser url, just drop the utf.
For example http://whattomine.com/coins/166.json?hr=2000&p=660.0&fee=0.0&cost=0.1&hcost=0.0
Is it possible to fetch json data other than the default 280x data?
http://whattomine.com/coins/166.json
http://whattomine.com/coins/166.json
I see! That worked a treat, Thanks
Stats are broken when selecting 1070...
Eth hr must be greater than 0
Eq hr must be greater than 0
Eth hr must be greater than 0
Eq hr must be greater than 0
Hmm not sure how checking 1070 could insert those zeroes for you... Are you sure you use correct number of cards in the field next to it?
Btw I have added values for 470.
Yep I just changed 280x to 0 and 1070 to 1 and now it says..
''Eth hr must be greater than 0''
and defaults back to 3 x 280x, When I select 1 x 1070 and 0 x 280x, Before i press calculate I notice all the hashrates go to 0 for 1070 if that makes sense.
Beside inputting a number for a card type you also need to activate it by clicking on a name. This is how it should look for 1070:
Stats are broken when selecting 1070...
Eth hr must be greater than 0
Eq hr must be greater than 0
Eth hr must be greater than 0
Eq hr must be greater than 0
Hmm not sure how checking 1070 could insert those zeroes for you... Are you sure you use correct number of cards in the field next to it?
Btw I have added values for 470.
Yep I just changed 280x to 0 and 1070 to 1 and now it says..
''Eth hr must be greater than 0''
and defaults back to 3 x 280x, When I select 1 x 1070 and 0 x 280x, Before i press calculate I notice all the hashrates go to 0 for 1070 if that makes sense.
Stats are broken when selecting 1070...
Eth hr must be greater than 0
Eq hr must be greater than 0
Eth hr must be greater than 0
Eq hr must be greater than 0
Hmm not sure how checking 1070 could insert those zeroes for you... Are you sure you use correct number of cards in the field next to it?
Btw I have added values for 470.
Stats are broken when selecting 1070...
Eth hr must be greater than 0
Eq hr must be greater than 0
Eth hr must be greater than 0
Eq hr must be greater than 0
Jump to: