Bitcoin Forum
June 17, 2024, 11:05:58 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
  Home Help Search Login Register More  
  Show Posts
Pages: [1]
1  Economy / Service Discussion / Re: Getting mtgox values into google spreadsheets 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
Pages: [1]
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!