Title: Getting mtgox values into google spreadsheets Post by: skittixch on April 24, 2011, 03:46:35 AM I'm trying to make a template for google spreadsheets that pulls the latest figures from mtgox over to use. I've gotten as far as getting
"=importData("http://mtgox.com/code/data/ticker.php")" into my spreadsheet, but I'd like it to give me simply one value, like just ask, or just buy, rather than what it outputs now, which is {"ticker":{"high":1.95,"low":1.3202,"vol":70274,"buy":1.7132,"sell":1.7499,"last":1.7475}} I know I saw some raw, plaintext links out somewhere a while back that'd be perfect for this, but I just can't remember where they are. Thoughts? Title: Re: Getting mtgox values into google spreadsheets Post by: mikegogulski on May 02, 2011, 11:57:21 PM Since your query intrigued me, check out https://spreadsheets.google.com/ccc?key=0Aqu-ecSaIXQZdHJEQXpNUFpidGtqM0U2eWxDY09MRVE&hl=en&authkey=CLCS44cK
To do this properly, though, you're going to have to get into script/macro programming, and on Google Docs you're probably going to have to set up an external event driver to execute the polling script periodically. Title: Re: Getting mtgox values into google spreadsheets Post by: Flexystar on September 13, 2011, 11:06:54 PM So how now i can import this values?
Upper templates does't work at this time. :-[ Title: Re: Getting mtgox values into google spreadsheets Post by: bombo999 on July 16, 2012, 05:44:23 PM Does anyone have a working link to allow current mtgox in usd spot price in google docs?
Title: Re: Getting mtgox values into google spreadsheets Post by: n8rwJeTt8TrrLKPa55eU on July 16, 2012, 06:21:36 PM Not an expert on Google docs, but some time ago I created the following Yahoo pipe to dynamically feed the "Last Trade" value from MtGox into an Excel spreadsheet via XML/WebQuery. If Google Docs won't take XML as data input, you can likely massage its output further via Pipes into a format that Google will like.
http://query.yahooapis.com/v1/public/yql?q=select%20return.last.value%20from%20json%0AWHERE%20url%3D'https%3A%2F%2Fmtgox.com%2Fapi%2F1%2FBTCUSD%2Fticker'&diagnostics=true (http://query.yahooapis.com/v1/public/yql?q=select%20return.last.value%20from%20json%0AWHERE%20url%3D'https%3A%2F%2Fmtgox.com%2Fapi%2F1%2FBTCUSD%2Fticker'&diagnostics=true) Title: Re: Getting mtgox values into google spreadsheets Post by: bombo999 on July 16, 2012, 06:49:20 PM I think it might be related to the change in the mtgox api when they switched to ssl security ... the old http importdata function worked ... but the updated https address does not work within google docs
Title: Re: Getting mtgox values into google spreadsheets Post by: John (John K.) on July 17, 2012, 08:08:25 AM I use bitcoincharts with the function:
Code: =Index(ImportHTML("http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),2,2) That'll cause the newest price to be downloaded, and be refreshed damn fast. ;) Title: Re: Getting mtgox values into google spreadsheets Post by: bombo999 on July 17, 2012, 02:23:52 PM thank you
Title: Re: Getting mtgox values into google spreadsheets Post by: farfiman on July 19, 2012, 04:11:32 PM thank you +1 !edit : strange but today it isn't working - giving me 7.81865 instead of 9.11 (current rate)? Back to working again.... weird Title: Re: Getting mtgox values into google spreadsheets Post by: John (John K.) on July 20, 2012, 10:35:24 AM thank you +1 !edit : strange but today it isn't working - giving me 7.81865 instead of 9.11 (current rate)? Back to working again.... weird Title: Re: Getting mtgox values into google spreadsheets Post by: niko on February 14, 2013, 03:39:28 AM Revamping this old thread - has anyone been successful querying the Gox http api from google spreadsheet? I can get it in excel no problem, but google fails to retrieve the same link. Possibly banned by gox?
Title: Re: Getting mtgox values into google spreadsheets Post by: farfiman on April 11, 2013, 01:30:07 PM John : Any chance you can check why your solution doesn't work anymore? thnx!
Title: Re: Getting mtgox values into google spreadsheets Post by: LevLion on July 26, 2013, 09:48:35 PM I use bitcoincharts with the function: Code: =Index(ImportHTML("http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),2,2) That'll cause the newest price to be downloaded, and be refreshed damn fast. ;) SO MANY THANKS! Have a great day! Will tip soon when I get my next reward! l. Title: Re: Getting mtgox values into google spreadsheets Post by: cverity on July 28, 2013, 02:06:04 AM I made a Google Spreadsheet that retrieves MtGox values (and several other API sources): https://bitcointalk.org/index.php?topic=249522.msg2649736 (https://bitcointalk.org/index.php?topic=249522.msg2649736)
It's designed to keep track of wallet and pool btc and altcoin balances, but feel free to pull the mtgox code out for your purpose. Title: Re: Getting mtgox values into google spreadsheets Post by: akipfer on November 30, 2013, 10:58:37 PM how do i do that with Microsoft Office 2010 -> Excel
cause i wanna do some seriously stuff on it, and i like to be dinamyc, fully automatic, i wanna get real time value from mtgox, and real time value of the dollar value(i live in Brazil, if u are wondering...That's why..) and them i only put manually the price of those other coins...to see how much i'm making a day...real data u know.. Title: Re: Getting mtgox values into google spreadsheets Post by: tzinger on January 29, 2014, 07:47:59 PM Hello,
Does anybody have a way to get private MTGOX wallet data ( Balance-BTC / USD) and pending orders into Google docs/spreadsheet? I have a private API key and secret from MT GOX. I just don't know how to write a script to access it. I am looking to get Google docs to act like a trading bot. I have successfully brought in bitcoincharts data using =Index(ImportHTML("http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),3,2) as well as MT GOX public API data =importdata("https://data.mtgox.com/api/2/BTCUSD/money/ticker") Many Thanks, tzinger |