Whattomine - profitability website with basic json.

[fredeq]

Is it possible to fetch json data other than the default 280x data?

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

[1714140474]

1714140474

[1714140474]

1714140474

[1714140474]

1714140474

[1714140474]

1714140474

[1714140474]

1714140474

[clipto]

Perfect, thanks! 

[clipto]

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?

[fredeq]

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?

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

[clipto]

Sounds right, but still won't work  



S10 is =SUM(S2,S4,S6,S8)

[fredeq]

Works for me, maybe put all those fields back to auto?

[clipto]

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.

[clipto]

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!!

[fredeq]

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!!

Hmm strange indeed.
You can share yours with me, curious whats wrong.
Cheers!

[Forumz]

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.

[fredeq]

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.

[clipto]

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!!

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.

[fredeq]

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

[disodium]

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.

[fredeq]

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.

Not possible atm.
I am planning to add a proper API authorized with tokens, but will see if I can get the data you requested into existing json.

[fredeq]

Added single calculator for PASC Pascalcoin
http://whattomine.com/coins/172-pasc-pascal

[bughatti]

@fredeq

Is it possible for a user to change what coins show on the front page.  Alot of the coins on the front I dont mine so I have to check single coins.  Can you make the ability for me to go in the coin section and check just what I want to show?  I can see how this would make the front page grow so keeping a static limit would still be good but currently I only have 2 algo's checked on the front and have to check a few other single coins.

[fredeq]

@fredeq

Is it possible for a user to change what coins show on the front page.  Alot of the coins on the front I dont mine so I have to check single coins.  Can you make the ability for me to go in the coin section and check just what I want to show?  I can see how this would make the front page grow so keeping a static limit would still be good but currently I only have 2 algo's checked on the front and have to check a few other single coins.

All of this is possible, but without real user accounts it will mean more and more cookies.
I like the idea though, it would solve the problem of not enough spots to list algos.

I am curious what other algos do you browse?
I can only think of pascal tbh. Will add it when nicehash releases support for it in a miner btw.

[bughatti]

@fredeq

Is it possible for a user to change what coins show on the front page.  Alot of the coins on the front I dont mine so I have to check single coins.  Can you make the ability for me to go in the coin section and check just what I want to show?  I can see how this would make the front page grow so keeping a static limit would still be good but currently I only have 2 algo's checked on the front and have to check a few other single coins.

All of this is possible, but without real user accounts it will mean more and more cookies.
I like the idea though, it would solve the problem of not enough spots to list algos.

I am curious what other algos do you browse?
I can only think of pascal tbh. Will add it when nicehash releases support for it in a miner btw.

Pascal is the main one over the course of the last few weeks, but i check decred and etherium.  Since Im still new to mining i dont know if I can use the others on the main page currently as examples, I guess I would just like the ability to select what coins matter and watch them

[fredeq]

@fredeq

Is it possible for a user to change what coins show on the front page.  Alot of the coins on the front I dont mine so I have to check single coins.  Can you make the ability for me to go in the coin section and check just what I want to show?  I can see how this would make the front page grow so keeping a static limit would still be good but currently I only have 2 algo's checked on the front and have to check a few other single coins.

All of this is possible, but without real user accounts it will mean more and more cookies.
I like the idea though, it would solve the problem of not enough spots to list algos.

I am curious what other algos do you browse?
I can only think of pascal tbh. Will add it when nicehash releases support for it in a miner btw.

Pascal is the main one over the course of the last few weeks, but i check decred and etherium.  Since Im still new to mining i dont know if I can use the others on the main page currently as examples, I guess I would just like the ability to select what coins matter and watch them

I dont get it then, both DCR and ETH are present on the main page.