Title: Setting up BTC-E trading bot in Excel Post by: mokimarket on April 23, 2013, 06:18:16 PM Is it possible to do this? I need 2 things
1) Pull in last traded prices/volumes from btc into Excel updated automatically 2) Update my limit orders based off of the last traded price? Can be be done? Title: Re: Setting up BTC-E trading bot in Excel Post by: w1R903 on April 23, 2013, 09:34:34 PM Is it possible to do this? I need 2 things 1) Pull in last traded prices/volumes from btc into Excel updated automatically 2) Update my limit orders based off of the last traded price? Can be be done? Yes, it probably *could* be done using a scripting language like Python or VBA, but why? Do you have some complex formulas that would be hard to port to a scripting language? Title: Re: Setting up BTC-E trading bot in Excel Post by: mokimarket on April 24, 2013, 01:38:09 AM Is it possible to do this? I need 2 things 1) Pull in last traded prices/volumes from btc into Excel updated automatically 2) Update my limit orders based off of the last traded price? Can be be done? Yes, it probably *could* be done using a scripting language like Python or VBA, but why? Do you have some complex formulas that would be hard to port to a scripting language? Nothing complex is it easier to do n VBA? Title: Re: Setting up BTC-E trading bot in Excel Post by: grue on April 24, 2013, 02:46:07 AM Nothing complex is it easier to do n VBA? Don't bother with VBA (it's bad). I still don't understand why you need excel involved. In fact, I don't even think you need a user interface. A simple C++/C#/python console program can do everything you want.Title: Re: Setting up BTC-E trading bot in Excel Post by: mokimarket on April 24, 2013, 02:48:39 AM Nothing complex is it easier to do n VBA? Don't bother with VBA (it's bad). I still don't understand why you need excel involved. In fact, I don't even think you need a user interface. A simple C++/C#/python console program can do everything you want.I see, and how would you recommend a newbie learn to set one up? I can program but no clue where to start Title: Re: Setting up BTC-E trading bot in Excel Post by: grue on April 24, 2013, 03:29:36 AM I see, and how would you recommend a newbie learn to set one up? I can program but no clue where to start I doubt there's a free public trading bot for btc-e, so you'll have to code one yourself. If you know the basics of any (popular) programming language, it should be pretty easy. Just a matter of pulling data from BTC-E's api, and executing trades according to your strategy. However, if you don't know any programming language, you either have to learn a language, or hire someone to do it for you. In either case, I don't see how you can execute trades without some sort of API.Title: Re: Setting up BTC-E trading bot in Excel Post by: The General on August 05, 2013, 02:57:10 AM Hi,
I've currently got an Excel live pricing feed (GOX and BTC-e) made up, so if you're interested, give me a shout. May well integrate order execution into it as well down the track. Also (re: VBA = bad) - what a senseless comment. Title: Re: Setting up BTC-E trading bot in Excel Post by: Jaxkr on August 05, 2013, 07:08:15 AM Yeah. And I strongly recommend doing it in Python. I wrote a trading bot a long time ago, feel free to use it as an example. https://github.com/Jaxkr/Tradexkr
Also, why do you want to use excel? Why not Sqlite? Title: Re: Setting up BTC-E trading bot in Excel Post by: The General on August 05, 2013, 07:53:28 AM You're assuming that the OP cared about storage (on a decent scale) as opposed to just live and recent data for the calculation of indicators etc..
In any case, you can use SQLite with Excel, so.... Title: Re: Setting up BTC-E trading bot in Excel Post by: bitpop on August 11, 2013, 08:09:01 AM http://stackoverflow.com/questions/8044423/json-import-to-excel
|