|
Title: VBA - Implementing Websockets for Bitcoin API Post by: dehhh on November 17, 2014, 03:26:08 AM Hi,
Currently I'm using HTTP queries to get market data from Bitcoin exchanges and it's a pain because the requests take too long to execute sometimes. Apparently, we can get real time data using the Websocket protocol. I recently came across this on Bitstamp's website: https://www.bitstamp.net/websocket/. I've also seen OKCoin using the same protocol: https://www.okcoin.com/about/ws_getStarted.do I would like to use that in Excel using VBA. Do you guys think that's possible? These websites have examples of code in Java...maybe running JavaScripts from VBA would do the trick? Thanks! Andre Title: Re: VBA - Implementing Websockets for Bitcoin API Post by: bloodDiamond on November 18, 2014, 10:01:17 AM Hi, Currently I'm using HTTP queries to get market data from Bitcoin exchanges and it's a pain because the requests take too long to execute sometimes. Apparently, we can get real time data using the Websocket protocol. I recently came across this on Bitstamp's website: https://www.bitstamp.net/websocket/. I've also seen OKCoin using the same protocol: https://www.okcoin.com/about/ws_getStarted.do I would like to use that in Excel using VBA. Do you guys think that's possible? These websites have examples of code in Java...maybe running JavaScripts from VBA would do the trick? Thanks! Andre you can try to find VB or VB.Net code and then port it in VBA for excel... VBA is really closest to VB and VB.NET... Title: Re: VBA - Implementing Websockets for Bitcoin API Post by: brant on March 03, 2015, 02:47:56 AM Hi! I'm willing to make some stuff with websockets in order to trade at BlinkTrade exchanges. Did you make any progress in this already?
|