Bitcoin Forum
December 05, 2016, 02:37:26 PM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: Getting mtgox values into google spreadsheets  (Read 4608 times)
skittixch
Jr. Member
*
Offline Offline

Activity: 57



View Profile
April 24, 2011, 03:46:35 AM
 #1

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?
1480948646
Hero Member
*
Offline Offline

Posts: 1480948646

View Profile Personal Message (Offline)

Ignore
1480948646
Reply with quote  #2

1480948646
Report to moderator
1480948646
Hero Member
*
Offline Offline

Posts: 1480948646

View Profile Personal Message (Offline)

Ignore
1480948646
Reply with quote  #2

1480948646
Report to moderator
1480948646
Hero Member
*
Offline Offline

Posts: 1480948646

View Profile Personal Message (Offline)

Ignore
1480948646
Reply with quote  #2

1480948646
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480948646
Hero Member
*
Offline Offline

Posts: 1480948646

View Profile Personal Message (Offline)

Ignore
1480948646
Reply with quote  #2

1480948646
Report to moderator
mikegogulski
Sr. Member
****
Offline Offline

Activity: 360



View Profile WWW
May 02, 2011, 11:57:21 PM
 #2

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.

FREE ROSS ULBRICHT, allegedly one of the Dread Pirates Roberts of the Silk Road
Flexystar
Full Member
***
Offline Offline

Activity: 166


Linux for open minds.


View Profile
September 13, 2011, 11:06:54 PM
 #3

So how now i can import this values?
Upper templates does't work at this time. Embarrassed
bombo999
Member
**
Offline Offline

Activity: 107


View Profile
July 16, 2012, 05:44:23 PM
 #4

Does anyone have a working link to allow current mtgox in usd spot price in google docs?
n8rwJeTt8TrrLKPa55eU
Hero Member
*****
Offline Offline

Activity: 588



View Profile
July 16, 2012, 06:21:36 PM
 #5

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
Member
**
Offline Offline

Activity: 107


View Profile
July 16, 2012, 06:49:20 PM
 #6

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.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1092


Will read PM's. Have more time lately


View Profile
July 17, 2012, 08:08:25 AM
 #7

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

My BTC Tip Jar: 1Pgvfy19uwtYe5o9dg3zZsAjgCPt3XZqz9 , GPG ID: B3AAEEB0 ,OTC ID: johnthedong
Escrow service is available on a case by case basis! (PM Me to verify I'm the escrow!)

bombo999
Member
**
Offline Offline

Activity: 107


View Profile
July 17, 2012, 02:23:52 PM
 #8

thank you
farfiman
Legendary
*
Offline Offline

Activity: 1449



View Profile
July 19, 2012, 04:11:32 PM
 #9

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

"We are just fools. We insanely believe that we can replace one politician with another and something will really change. The ONLY possible way to achieve change is to change the very system of how government functions. Until we are prepared to do that, suck it up for your future belongs to the madness and corruption of politicians."
Martin Armstrong
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1092


Will read PM's. Have more time lately


View Profile
July 20, 2012, 10:35:24 AM
 #10

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.

My BTC Tip Jar: 1Pgvfy19uwtYe5o9dg3zZsAjgCPt3XZqz9 , GPG ID: B3AAEEB0 ,OTC ID: johnthedong
Escrow service is available on a case by case basis! (PM Me to verify I'm the escrow!)

niko
Hero Member
*****
Offline Offline

Activity: 742


There is more to Bitcoin than bitcoins.


View Profile
February 14, 2013, 03:39:28 AM
 #11

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?

They're there, in their room.
Your mining rig is on fire, yet you're very calm.
farfiman
Legendary
*
Offline Offline

Activity: 1449



View Profile
April 11, 2013, 01:30:07 PM
 #12

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

"We are just fools. We insanely believe that we can replace one politician with another and something will really change. The ONLY possible way to achieve change is to change the very system of how government functions. Until we are prepared to do that, suck it up for your future belongs to the madness and corruption of politicians."
Martin Armstrong
LevLion
Jr. Member
*
Offline Offline

Activity: 33



View Profile
July 26, 2013, 09:48:35 PM
 #13

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

SO MANY THANKS!

Have a great day! Will tip soon when I get my next reward!

l.
cverity
Jr. Member
*
Offline Offline

Activity: 31


View Profile
July 28, 2013, 02:06:04 AM
 #14

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.

BTC: 1L86EDpwUSm5GiJPZvXeCSXA2ebbEbBGBh
akipfer
Sr. Member
****
Offline Offline

Activity: 294



View Profile WWW
November 30, 2013, 10:58:37 PM
 #15

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

BTC 1LDZwmLNULuEKPANry5DTbH5seLKwph8ua         | [WebSite off] coopersite.com.br | Aceitaremos Moedas como pgto | Procurando franqueados!
LTC  LYMQwZbBHK2kdD7SJnxCnn8NcwbiFAmgnV        | [Twitter] https://twitter.com/allankipfer
[M.B.] Rules - [M.B.]-[Mercado Bitcoin] Esta da hora!   | [Facebook] http://www.facebook.com/allan.kipfer.tbo
tzinger
Newbie
*
Offline Offline

Activity: 1


View Profile
January 29, 2014, 07:47:59 PM
 #16

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
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!