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
Topic: Getting mtgox values into google spreadsheets (Read 4908 times)
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..
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..
I made a Google Spreadsheet that retrieves MtGox values (and several other API sources): https://bitcointalksearch.org/topic/m.2649736
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.
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.
I use bitcoincharts with the function:
That'll cause the newest price to be downloaded, and be refreshed damn fast.
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.
John : Any chance you can check why your solution doesn't work anymore? thnx!
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?
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
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
thank you
I use bitcoincharts with the function:
That'll cause the newest price to be downloaded, and be refreshed damn fast.
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.
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
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
Does anyone have a working link to allow current mtgox in usd spot price in google docs?
So how now i can import this values?
Upper templates does't work at this time.
Upper templates does't work at this time.
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.
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.
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?
"=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?
Jump to: