|
PureBytes Links
Trading Reference Links
|
Of interest in the new Excel 2000 is the new "retrieve data from a web page"
wizard. All that free data and now a very, very easy way to get it.
The wizard is very straight forward. No more programming and ".igy's", all
you do is enter the address of the site. (It includes a browser button for
easy access for those like me, who can't spell or remember web addresses)
Specify the data table(s), or parts of tables that you want to download from
the site, etc. It's a pretty simple operation! Click the refresh button
anytime that you want new data. The web query can be easily programmed using
VBA for refresh times and site sequences for simple edits using "Edit Query"
on the "External Data" toolbar.
Several very good books re Excel 2000 VBA programming have come out
recently. Not a lot of changes to VBA between 97 and 2000. Wallenbach's VBA
1,000 pager is more integrated with Excel user tips and tricks, the 21 day
VBA course 1,000 pager is a "hand-holder" for non-programmers like myself.
One unique book is the Excel VBA programmers reference manual at
http://www.wrox.com/Store/Details.asp?Code=2548. Over 300 pages of
Appendices listing all of the VBA objects and methods, etc. It also includes
another Appendix on programming the objects and methods of the VBE which I
didn't know that you could do.
What an amazing program Excel is. Imagine manually adding combinations of
indicators to your charts in Metastock and have the System Tester
automatically write code for you. Maybe some day.
Best regards
Walter
|