Google Scripts and Spreadsheet code and examples

[vongesell]

I developed a google scripts library and example spreadsheet. All data (pricing, orderbooks) are pulled directly from exchanges. Supports:

• MTGox
• Bitstamp
• BTC-e
• Bitcoin Central
• Bitcoin-24
• Coinbase.

Will pull price or orderbook. Simple interface for code or spreadsheet. See example spreadsheet or the library .

• Example Spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AguYZ5-dWMgfdEhhWkNrR2pnMmhzMWcyb1FSbzZPSmc&usp=sharing
• Library documentation: https://script.google.com/macros/s/AKfycbxBLJGpX9Is2ZF5YfjR4XjqjEClHz_rogK-8wEup5N5LuuIGtMb /exec (you have to remove the space between the link and "/exec" -- forums remove the link otherwise)
• Library share link: https://script.google.com/d/1ZhP9mI0MLL8kMHizJ-5Uq-lB2ZaJJq96A62aRvOecf3nKsmPHh2FuQg1/edit
• Library import/project id: Mn6asBLgiBkIwY9lK-po6dDe4GsftYgT-

Ps. could someone allow me into the normal forums? Would also be happy to post my google spreadsheet arbitrage code

[baggyp]

hey thanks for posting this, I'm sure there are a few people who will find it useful. Welcome to the community!

[pixelized]

yes this looks very interesting - thanks for the share

[Node]

interesting, any plans to turn this into a web app?

[vongesell]

interesting, any plans to turn this into a web app?

of sorts. people have asked for MTGox integration to just grab balance and basic information. Will add this soon, after dealing with google's stupid HMAC function. But I guess this isnt exactly a web app. Everything is public so anyone could build a web app based on it.

[jordan.dev]

since MtGox updated their api endpoints recently any changes?

[vongesell]

yes i updated the examples and libraries. let me know if you have any issues with it.

[paraipan]

Whitelisted and welcome to the community!

[jordan.dev]

yes i updated the examples and libraries. let me know if you have any issues with it.

awesome ! Thank you. Any advice on getting the equation to run to update itself as the sheet is open? Right now it calculates when I insert the forumla but doesn't update.

Thanks again!

[lbr]

Awesome, thanks!

[vongesell]

np. beh, when will i have contributed enough to the community to get out of purgatory?

[paraipan]

np. beh, when will i have contributed enough to the community to get out of purgatory?

You're already out, quoting my post from 5 days ago 

Whitelisted and welcome to the community!

[grosminer]

Great work! Very useful thank you

[ironfalcon]

sweet!  now we just need BTC/USD price to scroll by on Wall Street

[EastcaostSix]

Looks good, thanks.

[shiek40]

What are the chances, or how hard would it be to set it up myself, to be able to pull LTC data off of BTC-e as well
such as the LTC/BTC value and the LTC/USD value? they would be greatly useful and apreciated!

[melon]

Awesome!...just posted about this topic earlier about needing a fetch of last price off the top 4 exchanges and using excel or spreadsheet to use an algo that sums the prices and divides by 4 to get a BTC global average exchange price... now if it could only be scripted into a desktop widget and served by a dedicated server every minute (or ten) since the blockchain needs time to be hashed correctly ! Thanks for posting that.