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 : Jim's Nasdaq100 Special as a basket. -- Ignore unavailable to you. Want to Upgrade?

To: James F. Hopkins who wrote (185)	3/18/1999 11:20:00 AM
From: Les H	Respond to of 2103

In Navigator 3, you can save it as text file using the Save As option under the File menu. There may be more options in other browsers.

To: James F. Hopkins who wrote (185)	3/18/1999 11:26:00 AM
From: Monty Lenard	Respond to of 2103

Jim, copy it and use "Paste Special" in Excel and select html. I think that will work for you

To: James F. Hopkins who wrote (185)	3/18/1999 4:03:00 PM
From: eWhartHog	Read Replies (1) \| Respond to of 2103

Quarterly adjustment to the composition of the NDX: nasdaqtrader.com./Trader/News/nasdaq100index/990322qtrly.stm

To: James F. Hopkins who wrote (185)	3/18/1999 10:45:00 PM
From: Diana Schilke	Read Replies (1) \| Respond to of 2103

I have been pasting html data into excel files and manipulating the data in many ways. I currently have excel 97 and also Netscape 3.0 on a win 95 system. I will give you instructions on how to do this if the data is in a table in a frame. View the page in Netscape that you want to get in the spread sheet. Wait for the page to fully load. Click on the View menu and select frame source (or document source if not in frame mode). Now scan through the html file in the frame source window looking for the table where the data is. When you find the beginning of the table (&lt table&gt), set the insertion point just to the left of that. Now left click the mouse and hold it down to highlight all the html data until the end of the table (all the way through to the end of &lt/table&gt) and do a CTRL C to copy the data. note - Sometimes you can do the copy from the web page itself but it's very hard to get exactly the right stuff. By going to the source itself, you can be very specific about which data you are selecting. Now open your excel program and paste the data into the spreadsheet. From here, you ready to do what ever you want to do with the data. Often the stock symbols may be hyperlinks themselves, so what I do then if I am looking for the symbols only is to highlight the column of symbols and paste them in the same column using the paste special value option. If you are still working with the previous version of excel (95??), I used to paste the source in a Word file and prune the html source of the html tags and make the file into the csv format that excel could read and make a spreadsheet from.