Setting up BTC-E trading bot in Excel

[mokimarket]

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?

[w1R903]

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?

[mokimarket]

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?

[grue]

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.

[mokimarket]

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

[grue]

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.

[The General]

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.

[Jaxkr]

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?

[The General]

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....

[bitpop]

http://stackoverflow.com/questions/8044423/json-import-to-excel