Closed

Compile data from web source to excel

This project received 19 bids from talented freelancers with an average bid price of $84 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
19
Project Description

I need a tool created for excel in order to download tables from a stream of webpages from the same website that are all configurated the same way and are already in table format.

Basically means compiling information gathered at the following address:
[url removed, login to view]

Each of the links presented opens a webpage with a table content and I want the excel to retrieve it. Final presentation should be in a list and the collumns should be as follows:

Name of the fund | Bond | Size | Price | Acc. Interest | Total
Text | Text | Number | Number | Number | Number

From all the content in the table I only want the macro to retreive the data corresponding (under) to chapters:

111
112
113
121
131
132
133
141
151
153
173
223
231

Also, the macro should be able to convert the raw data into valid information (transform text into numbers, validate the "." to work as a comma/point and automatically clean blank cells/lines (any line that has a blank cell is to be eliminated as I won't need that info, namely the chapter's info). After compiling, results should be presented sorted alphabetically based on the cell "Designação".

Attached is an example of the final product I want with this project, based on two of the links/funds.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online