Ninjastic
Search content
Sort by
Showing 5 of 5 results by AlienBoy
Post
Topic
Board Altcoin Discussion
Re: Setting up CGMiner with an Nvidia and AMD GPU installed, specifically GPU map
by
AlienBoy
on 02/04/2014, 06:35:53 UTC
Quote from: skeeterskeeter on November 02, 2013, 08:59:59 PM

And how can I see the temperature of the card?


I encountered the same problem, I'm running on Win7 and have two displays connected to NVIDIA card and no display to AMD. Seems that Win7 assumes there is no need to have signal output through AMD card and somehow causes the AMD APP not returning info of fan speed/temp.

Here's my workaround:
  • Go to Control Panel -> Display -> Screen Resolution
  • Hit "Detect" button -> you will see a ghost display showed up (not connected)
  • Click on the ghost display -> under "Multiple displays" drop down, select "Try to connect anyway on : VGA" -> apply settings
  • Again, under "Multiple displays" drop down, select Extend these displays -> apply settings
  • Now you have a hidden desktop on the ghost display
  • Run cgminer normally, you should get your stats readings

Hope that helps!
Post
Topic
Board Altcoin Discussion
Re: [How-To] Pull BTC-E Ticker API into a Google Spreadsheet - Apps Script code
by
AlienBoy
on 23/03/2014, 03:04:29 UTC
Quote from: palm12341 on February 26, 2014, 06:01:30 AM
If you want a method without using scripts, you can just paste the following function into a cell
=LEFT((LEFT(RIGHT(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),LEN(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"))-(SEARCH("last",IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),"1")+5)),6)),SEARCH(",",(LEFT(RIGHT(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),LEN(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"))-(SEARCH("last",IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),"1")+5)),14)),"1")-1)

Only thing is it doesn't have auto-refresh.

If you want to display the time when it was most recently updated, you can use the function below. Just make sure to set the cell to the date/time format of your choice using the number menu under format
=((LEFT(RIGHT(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),LEN(IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"))-(SEARCH("updated",IMPORTDATA("https://btc-e.com/api/2/btc_usd/ticker"),"1")+8)),"10"))/(60*60*24)+"1/1/1970")-(8/24)


Thanks palm12341! But I think the function you gave me is based on Google spreadsheet, I'm looking for a solution for Excel...

Anyway, I found the ticker URL you provided can actually fetched by Excel! It just display text data on web page instead of returning .json file, so by combining the function you provided, I successfully got the data I need! Thanks to you!

Question: how you found the specific text-based BTC-e ticker URL? I couldn't find it through its homepage!
Post
Topic
Board Altcoin Discussion
Re: [How-To] Pull BTC-E Ticker API into a Google Spreadsheet - Apps Script code
by
AlienBoy
on 26/02/2014, 05:55:59 UTC
Quote from: ny2cafuse on February 21, 2014, 03:09:41 PM
Hey, mate.  No need for apologies, it's a good question.  I think with Excel, you could use get external data from web and just use the actual page to fetch the data from.  I think excel just looks at the webpage, breaks it into it's xpath data, and then uses that xpath data to import into the spreadsheet.

I'd have to verify, but I think that would be the way to go.  I'll test it at work and report back.

-Fuse

Thanks for the response, Fuse!

I'm currently using the method you mentioned, so I can confirm it will work! But the problem with this method is it doesn't work well with many exchange web pages which will update itself dynamically. I haven't tried it with BTC-e - and I doubt it will work, but it can't read the page data normally on bitcoinaverage.com and cryptonator.com (main page only, the "all rates" page works fine).

Just thinking that if Excel can achieve the same with Google spreadsheet, then it will be very useful since many cryptocoin exchanges/sites usually support various API info in .json format!
Post
Topic
Board Beginners & Help
Re: Getting market's API (Ticker) data into Excel 2007 without Copy and Paste?
by
AlienBoy
on 21/02/2014, 07:02:42 UTC
Quote from: David Rabahy on April 26, 2013, 04:18:38 PM
In Excel; Data->From Web->Address (http://bitcoincharts.com/)->Go
if Script Error popup comes up then click No
click black right-pointing arrow in yellow box to select the Market table
click Import
click OK

to manually refresh; Data->Refresh

to automatically refresh periodically; right click on table cell->Data Range Properties->Refresh every
enter number of minutes (I use 1)->OK

I know this method to get data from a web page, thanks. But it will be nice to know how to import data from JSON into Excel, in that way we can have wider range of application!

Sorry to revive an old thread, is there anyone knows how to import API JSON data into Excel? I searched many places but all in vain...
Post
Topic
Board Altcoin Discussion
Re: [How-To] Pull BTC-E Ticker API into a Google Spreadsheet - Apps Script code
by
AlienBoy
on 21/02/2014, 06:14:00 UTC
Very nice!

Is this possible in Excel? I tried to use "get external data from web" but excel doesn't recognize .json data! Please shed some light on me...

I apologize because this is not related to google spreadsheet / reviving an old thread!

Thanks!