fredeq (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
January 07, 2017, 12:32:50 AM |
|
|
|
|
|
clipto
Member
Offline
Activity: 311
Merit: 10
|
|
January 07, 2017, 12:53:37 AM |
|
Perfect, thanks!
|
|
|
|
clipto
Member
Offline
Activity: 311
Merit: 10
|
|
January 07, 2017, 07:22:30 PM |
|
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?
|
|
|
|
|
clipto
Member
Offline
Activity: 311
Merit: 10
|
|
January 07, 2017, 08:27:48 PM |
|
Sounds right, but still won't work S10 is =SUM(S2,S4,S6,S8)
|
|
|
|
fredeq (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
January 07, 2017, 08:40:03 PM |
|
Works for me, maybe put all those fields back to auto?
|
|
|
|
clipto
Member
Offline
Activity: 311
Merit: 10
|
|
January 07, 2017, 08:43:06 PM |
|
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
Member
Offline
Activity: 311
Merit: 10
|
|
January 07, 2017, 08:50:31 PM |
|
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 (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
January 07, 2017, 10:29:05 PM |
|
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
Newbie
Offline
Activity: 5
Merit: 0
|
|
January 07, 2017, 10:34:44 PM |
|
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 (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
January 07, 2017, 10:45:12 PM |
|
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
Member
Offline
Activity: 311
Merit: 10
|
|
January 15, 2017, 09:23:19 PM |
|
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.
|
|
|
|
|
disodium
Newbie
Offline
Activity: 16
Merit: 0
|
|
January 23, 2017, 02:14:57 AM |
|
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 (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
January 23, 2017, 08:41:10 AM Last edit: January 23, 2017, 08:54:07 AM by 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.
|
|
|
|
|
bughatti
|
|
February 05, 2017, 03:58:49 PM |
|
@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 (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
February 05, 2017, 08:36:34 PM |
|
@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
|
|
February 05, 2017, 10:23:19 PM |
|
@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 (OP)
Legendary
Offline
Activity: 1537
Merit: 1005
|
|
February 05, 2017, 11:03:59 PM |
|
@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.
|
|
|
|
|