|
PureBytes Links
Trading Reference Links
|
I have spent hundreds, if not thousands of hours writing and testing systems
in Excel. My suggestion is to spend the time to learn VBA. It takes a while,
but without it, you will eventually get frustrated because you will be
limited. With VBA, you have complete control over Excel in addition to all
the nice things a programming language gives you. The VBA debugger is great.
You can step through your system, see all the variables, whatever. If I only
had a debugger for EL...
The macro recorder is a great learning tool. Record a macro and then look at
the VBA code generated.
Finally, Murray Riggario (sp?) had a series of articles in Futures mag (I
think) a while back about using Excel to test systems.
SH
----- Original Message -----
From: <grehert@xxxxxxxxx>
To: <omega-list@xxxxxxxxxx>
Sent: Monday, October 15, 2001 1:29 PM
Subject: Fw: Need help with Excel system
> Could anyone send me a spreadsheet that converts data into trading
signals?
> I guess I could inefficiently figure this out myself but why reinvent the
> wheel. I'm moderately experienced with Excel, but my main concern is
which
> functions do I use that look at a column of data and, if criteria aren't
> met, skip down to the next cell to do the same criteria check. Also any
> help with system optimization in Excel. If you have such a spreadsheet, I
> would appreciate a copy just to get me started on this project. Or can
> anyone recommend a book on Excel that features trading systems.
>
|