Awarded

Compile data from web source to excel

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.

Plz check attachment

Skills: Excel

See more: compile data website, compile website, excel compile data, compile raw data excel format, web source format, web pt, source format, sorted data, raw presentation, presentation of product example, on line presentation, namely, excel to web, convert excel to website, compile data excel, compile information excel web, final data, web to excel, validate excel, source product, Raw Data, product source, price excel, macro excel, macro + excel

About the Employer:
( 0 reviews ) Amsterdam, Netherlands

Project ID: #809670

18 freelancers are bidding on average $87 for this job

damitha78

pleas see pm

$95 USD in 2 days
(0 Reviews)
0.0
aravinda305

Dear Sir, Please check my PMB

$75 USD in 5 days
(0 Reviews)
0.0
mcnoj

Hi I have a tool for doing this [url removed, login to view] me know if you are interested.

$50 USD in 3 days
(0 Reviews)
0.0
bashir08

i m interested in ur project, please contact

$30 USD in 30 days
(0 Reviews)
0.0
zxvahsan1

This Is Very easy to complete this project.

$250 USD in 1 day
(0 Reviews)
0.0
khushi44

Please see p.m.

$80 USD in 4 days
(0 Reviews)
0.0
blonda

i am interested in your job

$250 USD in 1 day
(0 Reviews)
0.0
deshaliperera

Pls give this project to me.

$30 USD in 3 days
(0 Reviews)
0.0
janech

Hi there, I shall be happy to work on this. To place a bid I will need more details like what kind of data is to be entered? quantitative or descriptive and how much is the quantity? Is it a daily project? if so, by w More

$100 USD in 2 days
(0 Reviews)
0.0
SomnathTingare

Hello Sir, I have given sample tool as per your requirements. Please check PMB.. Regards, Somnath

$200 USD in 1 day
(0 Reviews)
0.0
pinky2406

hi I am Ready to do ths job work ya gone through the additional features i am ready to do this project work

$50 USD in 2 days
(0 Reviews)
0.0
angelmake

I am full time freelancer and I work at home all the time currently. I will always give customer the best image on my business services. I valued every customer in my business which mean 'what I done is what you ask fo More

$60 USD in 3 days
(0 Reviews)
0.0
ajira

hi... I can do it and I like to do work hard. thanks.

$85 USD in 15 days
(0 Reviews)
0.0
globalnature

we can do your work bcoz we are confident & dedicated to work and we will do your work with accuracy & dedication for complete ur project & earn money for us. it will delightful to u and us if u provide this oppurtunit More

$30 USD in 2 days
(0 Reviews)
0.0
shabbier

Hi, Gauranteed and honest work offered. Ready to go! Regards, Micheal.

$40 USD in 0 days
(0 Reviews)
0.0
amir708

hello, My six years experience in excel business field. i worked previous three years successfully. And i am a professional teacher of MS Office(excel, word, power point, access) And i have read your requirement , an More

$60 USD in 2 days
(0 Reviews)
0.0
LeeGia

Hello, I have experience.

$50 USD in 7 days
(0 Reviews)
0.0
kakaconsultancy

Please refer to PM.

$30 USD in 2 days
(0 Reviews)
0.0
sumit4sure

i have a lots of experience in excel.

$32 USD in 3 days
(0 Reviews)
0.0