|
PureBytes Links
Trading Reference Links
|
I would like to test systems with Excel.
Could you please recommend books about Excel and VBA ?
Thank you.
----- Original Message -----
From: "Scott Hoffman" <trader20@xxxxxxxxxxxxxx>
To: "omega-list" <omega-list@xxxxxxxxxx>
Sent: Tuesday, October 16, 2001 1:33 AM
Subject: Re: Need help with Excel system
> 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
|