skittixch (OP)
Newbie
Offline
Activity: 57
Merit: 0
|
|
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?
|
|
|
|
|
Flexystar
|
|
September 13, 2011, 11:06:54 PM |
|
So how now i can import this values? Upper templates does't work at this time.
|
|
|
|
bombo999
Member
Offline
Activity: 107
Merit: 10
|
|
July 16, 2012, 05:44:23 PM |
|
Does anyone have a working link to allow current mtgox in usd spot price in google docs?
|
|
|
|
|
bombo999
Member
Offline
Activity: 107
Merit: 10
|
|
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
|
|
|
|
John (John K.)
Global Troll-buster and
Legendary
Offline
Activity: 1288
Merit: 1227
Away on an extended break
|
|
July 17, 2012, 08:08:25 AM |
|
I use bitcoincharts with the function: =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
Member
Offline
Activity: 107
Merit: 10
|
|
July 17, 2012, 02:23:52 PM |
|
thank you
|
|
|
|
farfiman
Legendary
Offline
Activity: 1449
Merit: 1001
|
|
July 19, 2012, 04:11:32 PM Last edit: July 20, 2012, 07:39:40 AM by 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
|
"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
Activity: 1288
Merit: 1227
Away on an extended break
|
|
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 If you're using my code above, please remember that if bitcoincharts changes their site layout, it'll throw the script crazy.
|
|
|
|
niko
|
|
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?
|
They're there, in their room. Your mining rig is on fire, yet you're very calm.
|
|
|
farfiman
Legendary
Offline
Activity: 1449
Merit: 1001
|
|
April 11, 2013, 01:30:07 PM |
|
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
Newbie
Offline
Activity: 33
Merit: 0
|
|
July 26, 2013, 09:48:35 PM |
|
I use bitcoincharts with the function: =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
Newbie
Offline
Activity: 31
Merit: 0
|
|
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.msg2649736It'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
|
|
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..
|
|
|
|
tzinger
Newbie
Offline
Activity: 1
Merit: 0
|
|
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
|
|
|
|
|