Quote from: AlienBoy on March 23, 2014, 03:04:29 AM

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!

currently im working on this project, would you provide me some info how to call cryptonator exchange rates for any coin in excel