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 : TA- Scans and System Tests
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Paul Beattie who wrote (388)3/3/1997 1:09:00 PM
From: Sean W. Smith   of 989
 

Derek, Grabbing a Web page and import it into Excel - My suggested approach uses
the following tools:

1. An offline browser to fetch the web page and store it. I use Surfbot, but I think that
routines are available in perl. Surflogic's web site is surflogic.com. You
can download an evaluation copy of Surfbot which will do the job. I use Surfbot 2.02.
They have a new release (3.0) which may have more features.

2. A perl script to parse the html fetched, and extract the numbers into a text file
(either delimited or fixed column format). Perl 5.0 is available free for Windows95.
Details on how to download it were posted in the QuotesPlus thread.

3. A macro (part of an Excel spreadsheet) to read the text file into a worksheet
where you can do additional work. The macro will simply read the text file into a
worksheet. It can be created with the record macro facility in Excel. You may want
to add the Macro to the "Tools" dropdown menu in the spreadsheet for convenience

4. WinBatch to automate these steps. This is a bit complex, but really only runs these
3 steps sequentially to save you having to do it manually.

I use this process to collect data from stock quote sites and analyze for hedging
opportunities.

Regards,

Paul


FYI.... Winbatch can do the function of number #1 very nicely. I use
the HttpRecvFile command get the QP Data from their web page
and turn it into a file works well. They also have some additional
string functions on their page but still seems to lack the regular
expression capabilities of unix tools like awk,ksh, and perl.

Sean
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

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