Getting mtgox values into google spreadsheets

[skittixch]

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?

[1714974998]

1714974998

[1714974998]

1714974998

[1714974998]

1714974998

[1714974998]

1714974998

[mikegogulski]

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.

[Flexystar]

So how now i can import this values?
Upper templates does't work at this time.

[bombo999]

Does anyone have a working link to allow current mtgox in usd spot price in google docs?

[n8rwJeTt8TrrLKPa55eU]

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

[bombo999]

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

[John (John K.)]

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. 

[bombo999]

thank you

[farfiman]

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

[John (John K.)]

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

If you're using my code above, please remember that if bitcoincharts changes their site layout, it'll throw the script crazy.

[niko]

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?

[farfiman]

John  :  Any chance you can check why your solution doesn't work anymore?  thnx!

[LevLion]

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.

[cverity]

I made a Google Spreadsheet that retrieves MtGox values (and several other API sources): 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.

[akipfer]

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..

[tzinger]

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