Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : LastShadow's Position Trading -- Ignore unavailable to you. Want to Upgrade?

To: LastShadow who wrote (80)	8/30/1998 12:15:00 PM
From: LastShadow	Respond to of 43080

Web files: At home.earthlink.net I have posted a couple of files. This URL is incorrectly listed on the thread description as 'www' instead of 'home' - sorry. There are three links there - one is for a download of Microsoft Excel97 web query files. This file is in a Zip compression, and I have discovered that WinZip does not always decompress them correctly, so you might want to get PKZip (freeware somewhere on web) if you don't have it. At any rate, these files work ONLY with the web query function in Excel 97 for PC/Windows 95, 98 and NT. Once you download the file and decompress it, put the files in your excel documents. Under Data menu item in Excel, select the second last item, Get External Data, and then select the first item in the sub menu titled Run Web Query. It will present you with a folder selection window - find where you put the queries folder and select that. This will present you with about 30 web query routines, such as Quote.com, etc. Select one of them and tell it to place the data in the default cell it chooses for the blank excel file. A window will then ask you for a specific symbol or set of symbols to retrieve data for. Depending on the query, some sites return as little as the last close to detailed fundamental data. I would note that some of them are probably not functioning, and you can discard those files - some sites change addresses or stop providing data. At any rate, explore and enjoy. I am working on some other web queries for both Excel 97 and stand-alone Visual Basic 5 programs, and will post them there as they become available. The second file is just a display of a jpg about Trading Channels using a six month window of AOL. The third buton takes you to a currently blank page I maintain if I can't ever get onto SI and for other posts. lastshadow