Whattomine - profitability website with basic json.

[Mikanoshi]

It's just how results are presented. At least there is a coin name Most services just return an array of objects (like coinwarz), because there are coins that have same names or same tickers, so you cannot use that as an unique field. You have to iterate through all the objects of an array (or in this case another object), no idea how it's done in PS. Example in PHP:

Code:

$wtms = json_decode($api_response);
if ($wtms !== NULL)
foreach ($wtms->coins as $coin_name => $wtm)
if ($coin_name == 'Cannabiscoin') {
	$reward = 86400 * $wtm->block_reward24 * 1000000 / $wtm->difficulty24 / 4294967296;
	break;
}

[Raymond_B]

It's just how results are presented. At least there is a coin name Most services just return an array of objects (like coinwarz), because there are coins that have same names or same tickers, so you cannot use that as an unique field. You have to iterate through all the objects of an array (or in this case another object), no idea how it's done in PS. Example in PHP:

Code:

$wtms = json_decode($api_response);
if ($wtms !== NULL)
foreach ($wtms->coins as $coin_name => $wtm)
if ($coin_name == 'Cannabiscoin') {
	$reward = 86400 * $wtm->block_reward24 * 1000000 / $wtm->difficulty24 / 4294967296;
	break;
}

Thanks for the idea, yeah for now I am going to narrow my scope in filter like you said. Maybe in future updates the JSON will be changed up a bit, but no big deal. Still an awesome resource.

[Raymond_B]

Well it took a while, but I now have what I wanted working. Hourly (so it goes easy on the WTM website) updates to my phone for SHA-256 profitability. I stood up a small MS SQL VM at home, use it pull down JSON with PowerShell and then use SQL to manipulate it and send me the update. Not pretty, but it gets the job done as all I wanted to know is what comes up as more profitable than BTC I can add more, but I think it's all I need for now.

https://imgur.com/a/dvoy2FT

[fredeq]

Hello, super noob SQL import question. I'd like to import the JSON output in to SQL, but I am struggling with the structure. I can select "coins", but none of the other headers seems available. Anyone done this that might have tips or pointers?  

Edit to be a bit more clear.

I am struggling with the structure of the JSON output. Coins is declared as the top level, but then it gets tough to find the fields and headers so I can properly import them in to columns. Coinwarz is easy to import, but your data and site is MUCH better Is this just the state of things or am I not referencing the JSON correctly?

As a reference https://www.coinwarz.com/content/images/profitability-api-output.png

Hey, this is based on ruby where you can have any json structure you want, cause its getting parsed as a simple nested hash with key => value pairs.
Unfortunately its not possible to change the json structure now, hope you are good with your workaround

@Mikanoshi
All json calls without params will use the same defaults as seen in the UI.
For coins and asic you can check those by pressing defaults and for single calcs - reset.

Rewards increase differently from hashrate increase which is best observed on small nethash coins.
"BTC", "LTC", "SC", "BCH" will use current diff for single calcs and the rest uses 24h average.

[Mikanoshi]

Rewards increase differently from hashrate increase which is best observed on small nethash coins.

How do you calculate that? And why it should be different?

[fredeq]

Rewards increase differently from hashrate increase which is best observed on small nethash coins.

How do you calculate that? And why it should be different?

Imagine a low nethash coin of 100Mh/s, where 1Mh/s could be produced by just one card.
You have 100 cards and throw all onto that coin.

Nethash has just doubled to 200Mh/s, diff raised. You now have 50% of nethash, but before you did that it was a 100% of nethash.

[Mikanoshi]

Imagine a low nethash coin of 100Mh/s, where 1Mh/s could be produced by just one card.
You have 100 cards and throw all onto that coin.

Nethash has just doubled to 200Mh/s, diff raised. You now have 50% of nethash, but before you did that it was a 100% of nethash.

No, all profit calcs use history to calculate rewards. Your hashrate is a part of the nethash which is immutable, because it already happened.
You cannot have hashrate more than the entire network had for the past 24h (if you calc for 24h), because then nethash would've been higher.

[wh3n14mbo]

I'm looking on profitability calculator.

When I put 1000000.0 Mh/s (1Th/s), it shows daily reward as 0.086373 BTC ($710.65).
But when I put x10 = 10000000.0 Mh/s (10Th/s), it shows daily reward as 0.741514 BTC ($6,100.95).

I expect x10 power gives x10 reward, but it isn't the case.

Could someone explain those calculations?

Thank you and appreciate your feedback!

[Mikanoshi]

Could someone explain those calculations?

Can you read just a couple of posts above yours?
I also agree it should be linear, adding your hashrate to nethash is a try to predict future, it's not what profit calcs are about.

[fredeq]

I'm looking on DGB-Qubit (DGB) profitability calculator.

When I put 1000000.0 Mh/s (1Th/s), it shows daily reward as 0.086373 BTC ($710.65).
But when I put x10 = 10000000.0 Mh/s (10Th/s), it shows daily reward as 0.741514 BTC ($6,100.95).

I expect x10 power gives x10 reward, but it isn't the case.

Could someone explain those calculations?

Thank you and appreciate your feedback!

Same question as mikanoshi raised.
WTM treats the calculation as new hashrate added to the network.

@Mikanoshi
Vast majority of people is using it as a way to predict the future. (attempt at least)
Without this default, every calculation for a coin you are not already mining would be bogus.

[wh3n14mbo]

Mikanoshi, fredeq, thanks!

Didn't read above, because just found this thread and it's huge.

Have a nice day!

[Mikanoshi]

Vast majority of people is using it as a way to predict the future. (attempt at least)
Without this default, every calculation for a coin you are not already mining would be bogus.

Those people are stupid and doing things wrong
Profit calc is for checking your rewards, not predicting future, because it's impossible.
Let's say I was mining with 50% of nethash for the last 24 hours and then went to WTM to check my rewards, WTM shows 1.5 times lower values. Encouraging, but totally incorrect.
There should be at least an option to disable that.
How do you even calculate average nethash? Based on average diff you are calculating using questionable mathematically-unverified time-weighted method?
Nethash should be based on simple average diff (or sum of avg hashrates of ALL pools and somehow solo miners).

[wh3n14mbo]

Those people are stupid and doing things wrong
Profit calc is for checking your rewards, not predicting future, because it's impossible.
Let's say I was mining with 50% of nethash for the last 24 hours and then went to WTM to check my rewards, WTM shows 1.5 times lower values. Encouraging, but totally incorrect.

From the other side, I would like to mine with my spare rigs which power amounts to +50% of nethash and WTM calculations are right for me

[whittle]

@whittle
Not sure if you are saying or asking, but yes the links in the api docs are not working. Still not working.
http://api.arabianchain.org/v1/dbix/main for example

https://api.arabianchain.org/v1/dbix/main/network - this works

[akroma_io]

I believe this is the place to request a coin to be added. Please let me know if I am wrong or there is other information required:

• Coin: Akroma
• Homepage: akroma.io
• Age: 9 months
• CMC: https://coinmarketcap.com/currencies/akroma/
• Stats: https://stats.akroma.io/
• API (with misc info): http://api.akroma.io/docs
• Mining Info: http://akroma.minerpool.net/

Thanks,
Akroma Team.

[fredeq]

I believe this is the place to request a coin to be added. Please let me know if I am wrong or there is other information required:

• Coin: Akroma
• Homepage: akroma.io
• Age: 9 months
• CMC: https://coinmarketcap.com/currencies/akroma/
• Stats: https://stats.akroma.io/
• API (with misc info): http://api.akroma.io/docs
• Mining Info: http://akroma.minerpool.net/

Thanks,
Akroma Team.

Actually the contact form is the right place for it, but I have made it for you and placed it into research queue.

[whittle]

@fredeq

I do not know what else to say. dbix is always in the top 3 of the best coins to mining and most days is the most profitable. just wanted all of Ethash miners to know this possibility of gaining more and of course increasing the community of miners in dbix.

APIs are working.
Is not this information you need? https://api.arabianchain.org/v1/dbix/main/network

Net Avg HashRate is 470.858 GH and dbix has not yet done marketing and is not known by most miners.

https://explorer.dbix.info/home

if you need more information, say that the dbix community or devs provide.

[fredeq]

@fredeq

I do not know what else to say. dbix is always in the top 3 of the best coins to mining and most days is the most profitable. just wanted all of Ethash miners to know this possibility of gaining more and of course increasing the community of miners in dbix.

APIs are working.
Is not this information you need? https://api.arabianchain.org/v1/dbix/main/network

Net Avg HashRate is 470.858 GH and dbix has not yet done marketing and is not known by most miners.

https://explorer.dbix.info/home

if you need more information, say that the dbix community or devs provide.

Thanks for the direct link, but the difficulty is missing from the response.
Maybe explorer has some api to provide it?

[Mikanoshi]

GRLC lagging? Explorer problem?
https://www.reddit.com/r/garlicoin/comments/9af79q/garlicoin_explorer_api/

[fredeq]

GRLC lagging? Explorer problem?
https://www.reddit.com/r/garlicoin/comments/9af79q/garlicoin_explorer_api/

Saved me some time, thanks