In Progress

Simple web data extraction, java site,using variables in URL

Hi,

i would like a scraping quote please, to extract data from a public website. I've tried using the Excel Web Query function, but the website uses Java so the data extracted comes through as blanks.

The data I need comes from a single Java web page only, and is always in a fixed place on the page. The data itself changes dependent on 2x string values that are within the URL, in the "[url removed, login to view]" format.

In an Excel file, I will provide a list of these URLs sorted by date. What I would like to do in Excel, is to be able to key in a date, click a macro button, and have the data pulled from the website for each of the URL's for the date selected - and have that inserted into my spreadsheet alongside the URL rows I have provided. If this data is already present, it should be overwritten/refreshed. There are likely to be a maximum of 100 URLs for each date, so it will need to loop through each of them until they are all extracted. There will be just one Excel file, that I will add to over time.

From the website, I need a total of 40 data items for each URL provided, to be inserted into the spreadsheet I will provide. 39 of the data items are simple % figures, the 40th item is a piece of text.

I hope that all makes sense, please let me know if you need me to clarify anything. I need this work done as soon as possible, I think it will be quite a simple task for someone with the correct understanding and skill-set required.

Cheers,

Martin

Skills: Data Mining, Excel, Web Scraping

See more: java web data extraction, need website data java, data extraction java, java extract data website, extract data website java, web data extraction java, java variables excel macro, excel web data java, web data extract java, website data java, using variables url, extract web data java, extract data url, web page spreadsheet, web page format, web anything, understanding quote, spreadsheet web page, sorted data set, sorted data, one key data, fixed web page, url data extraction java, java extraction site, uses excel

About the Employer:
( 1 review ) Woking, United Kingdom

Project ID: #1147333

Awarded to:

mike25

Hi - please check your inbox.

£100 GBP in 5 days
(12 Reviews)
4.3

28 freelancers are bidding on average £57 for this job

srinichal

I am an expert in scrapping and can deliver the project asap

£30 GBP in 3 days
(60 Reviews)
6.6
NishantBamb

Hello, please refer your Inbox. Thank you.

£100 GBP in 5 days
(72 Reviews)
6.7
panfreelancer

Please check PM. Thanks

£75 GBP in 3 days
(71 Reviews)
5.9
liviakecskes

Hello! Please check your PM!

£100 GBP in 2 days
(51 Reviews)
5.9
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

£95 GBP in 3 days
(53 Reviews)
6.7
vserv

Pls see your messages. Thanks

£40 GBP in 1 day
(65 Reviews)
5.9
Kamalkishover

Pls Check PM

£30 GBP in 1 day
(139 Reviews)
6.2
ineedWorkJob

sir plz check pm !

£30 GBP in 3 days
(29 Reviews)
5.4
£20 GBP in 0 days
(24 Reviews)
5.2
ahmedsobherfan

Hi, i have expereince in this kind of projects plz check pm Regards

£20 GBP in 0 days
(71 Reviews)
5.0
manageo

Hi, I can do it

£30 GBP in 1 day
(39 Reviews)
5.0
vbexcel

Web scraping expert.

£30 GBP in 1 day
(33 Reviews)
5.6
microk

Let's start..

£30 GBP in 2 days
(29 Reviews)
4.4
rajkavikumar

Hello, Please check PMB I have sent you sample of my past work.I have done similar work in past I am expert in creating macros, web application and have 3+ yrs of Experience in advance VBA programming, I ll deliver y More

£80 GBP in 3 days
(8 Reviews)
4.0
softwarevamp

Hello, i can do this in a timely manner look to work with you At your disposal for any query. Regards softwarevamp

£99 GBP in 1 day
(2 Reviews)
3.1
stechsun

Lets Start...

£50 GBP in 0 days
(1 Review)
2.5
msajaynath

CHECK PM FOR DETAILS.

£40 GBP in 2 days
(3 Reviews)
2.5
kanadyanako

For your consideration.

£20 GBP in 1 day
(1 Review)
1.7
rejithan

Sir, i've enough time for your work and expert in this field.100% accuracy is my peculiarity. Don't avoid me because of lack of online experience. pls give this work to me. You can check my ability first by giving sam More

£30 GBP in 1 day
(1 Review)
1.1
Olicom

Hello Sir! we're ready to start.

£80 GBP in 3 days
(0 Reviews)
0.0