Capture web data and put in Excel

The web site [[url removed, login to view]][1] has a free trail. I want to collect data form this site and export it to Excel automatically.

From MS Excel I want to create an icon in the menu bar with my initial F on it, that when clicked:

goes to this web site, goes to "calenders" section, then "Earnings Guidance" Section. There are 4 tabs of data in this section: 30 Day upside, downside, inline and mixed.

Create VBA to Export the data from each of the 4 sections into one Excel worksheet

Create 2 new columns to the left of the data. Column A will be the appropriate date, and Column B will contain a Code representing from which of the 4 aforementioned tabs the data is from, upside, downside, in-line or mixed. Eg. if from Upside, then use U, from downside use D, in-line use IL, mixed use M.

You will notice that each section of the site contains most current data going back to 30 days ago. I want the VBA to only put the most recent data in the Excel spreadsheet and sort it from most current date downwards.

I intend to update the spreadsheet every day or couple of days, so it should be capable of grabbing just the most current data from the 30 day data.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Monday Nov 14, 2005 3:52:06 PM:

I'm realizing as many of you have pointed out, that this site [url removed, login to view] requires a credit card for the "free trial". (I'm a long time user and I auto-login, so I didn't realize this)

My understanding is that your card does not get charged if you cancel within 30 days. I'm sorry I didn't realize that when I posted this project.

I can confirm that the site is a very well established heavily used by the financial community.

* * *This broadcast message was sent to all bidders on Tuesday Nov 15, 2005 12:08:18 PM:

After emailing, the facilitator of this site, I've decided to do the folllowing:

I will only accept a bid if the bidder acknowledges that they have registered and gone to the section of the site that I requested

(this requires a credit card, but its free if you cancel within 30 days)

Briefings customer service is very very good, I've subscribed, upgraded my subscription, downgraded my subscritption etc, with no problems.

I will not accept any bid where the bidder does not acknowledge that they have registered to the site and therefore understand what needs to be accomplished.

Lastly, as a goodwill gesture, I will add $20 to those who have already bid to accomodate for this inconvenience. For those who have not yet bid, please factor in this need to register with a credit card into your bid ammount Thanks all.

## Platform

MS Excel

PHP

Project ID: #3091499

About the project