|
PureBytes Links
Trading Reference Links
|
Walter and others,
I have not been following these threads on VB for Excel but I presently am
learning it so as to be able to perform backtesting of Mechanical screens
for stock selection. I have found a very good book that you guys might want
to look into:
Microsoft Excel 2000 power programming with VBA by John Walkenbach
I just upgraded to 2000 so this is the one for me but he has written similar
versions for Excel 95 and Excel 97. Check out amazon for some descriptions
on his books. It was available at my local Chapters.
I'm about 1/4 of the way through the book at have found the read very easy
with great examples. The 2000 version (I'm not sure about the others) comes
with a CD full of examples organized by the chapter in the book. I highly
recommend this book.
Ed
----- Original Message -----
From: Walter Lake <wlake@xxxxxxxxx>
To: Metastock bulletin board <metastock@xxxxxxxxxxxxx>
Sent: Friday, September 03, 1999 7:34 AM
Subject: VB
> Hi Adam, Lars, et al
>
> Here's a free Chapter 1 that will help to give you a very quick "dunking"
> into the world of actually programming a project.
>
> http://www.murach.com/books/VB60/chapter.htm
>
> When you print it out ... it's set up so that the text goes on the left
and
> the instructions and screens go on the right.
>
> VBA is getting harder, the more that I get into it. Mainly because of the
> multiple ways that Microsoft has included to do anything. VBA in Excel is
> very flexible and powerful ... now all I have to do is remember all of the
> possibilities.
>
> Learning VB in a limited way has really helped me understand VBA much
> better.
>
> Have recovered from a system and monitor crash last week. Now that was
> interesting to have both go at once. Have spent the last week preparing
for
> the "next" crash. <G>
>
> For some reason ... the only files lost were my custom indicator files in
MS
> ... I know that I had wanted to spend less time / emphasis on technical
> analysis ... but this is ridiculous. Luckily ... one of my friends on the
> list sent me a file to get back up again. What a shock to see nothing but
> stock indicators on the indicator list. That sight will haunt me for a
> while.
>
> Best regards
>
> Walter
>
>
>
>
>
>
>
|