TA in excel

["Walter Lake" <wlake@xxxxxxxxx>]

Thanks for the email Dale.

As you probably know, we need all of the help we can get around here.

The first serious piece of business I need help with is

- 0 -

If you downloaded Dave Steppan's stock/fund downloader from

http://www.geocities.com/SiliconValley/Network/1030/ExcelTop.html

go into the Macro and Visual Basic file to see how he uses them.

go to "tools ---> macro --> visual basic editor"

in the top left box -- click on "VBA project (MutFunds.xls)"

then press print, you'll get 10 to 12 pages of all of the code

One page one of the "Module 1" Sub GetFundQuotes()
you'll see that he uses the "\GetWebData.igy" query file

- 0 -

I don't understand the "GetWebData.igy" usage, where as the Excel web query
file in the program files\excel\queries is "GetMoreWebQueries.igy". Is that
just a general usage? Where is his "igy" file?

- 0 -

Jim's going to love this paragraph from the web site you provided.

"Stock data or software vendors can be here today and gone tomorrow or can
undergo changes sufficient to warrant termination of the use of their
products. Consequently, one should be careful about making any significant
investment of method development, time, or emotion in a particular vendor's
product. Such investment could hold one in bondage to a vendor when any
objective outside observer could plainly see it's time to cut one's losses
and leave. With Excel Visual Basic as a platform for technical analysis, you
will not be held hostage to any stock data or software vendor's proprietary,
peculiar, unpredictable, or cryptic scan language or data format."

Best regards

Walter