EXCEL FOR BACKTESTING

Who knows " BACKTEST WIZARD " software ?
Know you programs of backtesting using Excel ?
Thank you.

 

I'm using Excel for backtesting. If you know a bit about programming Visual Basic isn't that hard to learn. Then you can test everything. I don't know other Backtesting Sofware, but Excel and Visual Basic really satisfies me.
A disadvantage is that you have to programm all the indicators you want to use by yourself.

 

Backtest Wizard is available at http://option-wizard.com

I haven't used the program...

 

Take a look at :www.crontech.com

 

Here are other softwares that use the QFEED (Quote.com) realtime datasource:

www.lynnsoft.com (makers of Invert/RT)
www.wealth-lab.com
www.neuroshell.com
www.stratagem1.com (smartrader/RT)
www.tickquest.com (Neoticker 2.2 RT) <-- Very powerful 650$
www.crontech.com <-- makers of StockWatch Pro 2.1

All the above software I mentioned can support indicator programming and system backtesting using Real time Qfeed source.

Companies that will be releasing Real Time (QFEED) versions of their software soon:

www.tarnsoft.com (Byte Into the market) will release BITM RT for QFEED

www.amibroker.com (is scheduled to release RT version of their software early next year)

These are miscellaneous:

www. hquotes.com <-- for Realtime/OED historical Quotes FREE ! !
www.winterra.com <-- Fine Tech Analysis Charting software, no Real Time support but does read Intraday historical ASCII quotes
www.mechtrading.com <-- get historical quotes into files from QFEED
www.dandill.com <-- Freelance programmer of QFEED tools
www.tradingsolutions.com <-- Neural Network software for trading
www.nd.com <-- Neural Network software supplier



Hope these links help ! ! !
hsanson

 

docartz, could you share info on using excel for backtesting?
maybe send a file to look at?

 

Would appreciate any links or advice you guys might have on programming and formula building using Excel.

Any good formulas on the 'net I could find as "examples" to work with?

I'm trying to link Excel to TradeStation using DDE.

What language would be most useful for a beginner to start messing with?

Thanks in advance.

IndexTrader

 

IndexTrader,
I think you should try Visual Basic, because it's the build in language for Excel and it's really easy to use native Excelfunctions.

wesman,
I started with my "Excel-project" about 10 months ago, now it is an own program with several thousand lines of code. It is still written in Visual Basic for Excel and it is still using Excel for in- and output, but at his point I can't call it an Excel-program any more.
Sharing the sourcecode wouldn't help you a lot, there is almost no documentation and it is also in german.

 

Here are some links:

http://www.medianline.com/excel_utilities.html

http://www.analyzerxl.com

I remember a mailing-list where complete testing system had been delevoped in Excel. Unfortunately I do no longer have the address. If you use some search engine I'm sure you will find a lot of useful links.

regards

Bernd Kuerbs

 

docarzt:

Do you mean VBA, "Visual Basic for Applications", or just Visual Basic?


BKuerbs:
Thanks for the links. I was hoping to find something with "real time" working samples but no luck. Looking at different sites right now.

Thanks guys.