Author

Topic: Setting up BTC-E trading bot in Excel (Read 4520 times)

newbie
Activity: 9
Merit: 0
August 05, 2013, 03:53:28 AM
#9
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....
sr. member
Activity: 420
Merit: 250
August 05, 2013, 03:08:15 AM
#8
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?
newbie
Activity: 9
Merit: 0
August 04, 2013, 10:57:10 PM
#7
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.
legendary
Activity: 2058
Merit: 1431
April 23, 2013, 11:29:36 PM
#6
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.
sr. member
Activity: 422
Merit: 250
April 23, 2013, 10:48:39 PM
#5
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
legendary
Activity: 2058
Merit: 1431
April 23, 2013, 10:46:07 PM
#4
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.
sr. member
Activity: 422
Merit: 250
April 23, 2013, 09:38:09 PM
#3
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?
full member
Activity: 218
Merit: 100
April 23, 2013, 05:34:34 PM
#2
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?
sr. member
Activity: 422
Merit: 250
April 23, 2013, 02:18:16 PM
#1
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?
Jump to: