Topic: Google Scripts and Spreadsheet code and examples (Read 2752 times)
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.
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!
such as the LTC/BTC value and the LTC/USD value? they would be greatly useful and apreciated!
Looks good, thanks.
sweet! now we just need BTC/USD price to scroll by on Wall Street
Great work! Very useful thank you
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!
np. beh, when will i have contributed enough to the community to get out of purgatory?
Awesome, thanks!
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!
Whitelisted and welcome to the community!
yes i updated the examples and libraries. let me know if you have any issues with it.
since MtGox updated their api endpoints recently any changes?
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.
interesting, any plans to turn this into a web app?
yes this looks very interesting - thanks for the share
hey thanks for posting this, I'm sure there are a few people who will find it useful. Welcome to the community!
I developed a google scripts library and example spreadsheet. All data (pricing, orderbooks) are pulled directly from exchanges. Supports:
Will pull price or orderbook. Simple interface for code or spreadsheet. See example spreadsheet or the library .
Ps. could someone allow me into the normal forums? Would also be happy to post my google spreadsheet arbitrage code
- 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
Jump to: