Backtesting with VBA

[msusilo 10]

Hi guys,

 

I am new to this forum and to backtesting trading strategies.

 

I have a basic understanding of VBA and am always trying to learn more. I was just wondering if anyone in this forum has ever back tested using VBA and could give me some pointers as to how to structure my coding and potential data providers on continuous tick data?

 

Also, any references to useful books will be much appreciated. I am looking for books that incorporates VBA into trading and not really a VBA programming book as such.

 

Thanks

 

Marco

[JonWayn 10]

Hey, like you, I am new here. However, I am a VB programmer looking to automate the use of this software for a friend. Opening a Microsoft Access database, I can see that installing Trade Center Pro, did add an OpenEcry type library to my system. I could probably be of help to you if you are of help to me. So far, I havent found a way to capture a session of trade center so I can watch for events and use vb code to respond to them. Have you gotten that far? If you have, and can share that know-how with me, Id be happy to give insights on coding the beast

[Avarice 10]

Hi guys,

 

I am new to this forum and to backtesting trading strategies.

 

I have a basic understanding of VBA and am always trying to learn more. I was just wondering if anyone in this forum has ever back tested using VBA and could give me some pointers as to how to structure my coding and potential data providers on continuous tick data?

 

Also, any references to useful books will be much appreciated. I am looking for books that incorporates VBA into trading and not really a VBA programming book as such.

 

Thanks

 

Marco

 

Marco,

 

I can't help you regarding VBA, but did you check out NinjaTrader? Its programming language (for both indicators and strategies) is C# which, given your working knowledge of VBA, shouldn't be too hard to get into. Plus you won't have to worry about importing / converting your data or developing your own trade execution engine.

 

Hope this helps,

A

[Tams 20]

Hi guys,

 

I am new to this forum and to backtesting trading strategies.

 

I have a basic understanding of VBA and am always trying to learn more. I was just wondering if anyone in this forum has ever back tested using VBA and could give me some pointers as to how to structure my coding and potential data providers on continuous tick data?

 

Also, any references to useful books will be much appreciated. I am looking for books that incorporates VBA into trading and not really a VBA programming book as such.

 

Thanks

 

Marco

 

don't waste your time with VBA.

use a "real" trading program, you won't regret it.

 

for example,

here are some of the reports you can get from MultiCharts.

Edited January 11, 2011 by Tams