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
Project Budget$30 - $250 USD
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:
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online