SI
SI
discoversearch

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.
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: James F. Hopkins who wrote (185)3/18/1999 10:45:00 PM
From: Diana Schilke  Read Replies (1) 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.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2026 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News