Find Jobs
Hire Freelancers

Web scraping to Excel Scrape data from SEC.gov (DEF 14A flings)

£250-750 GBP

Completed
Posted over 11 years ago

£250-750 GBP

Paid on delivery
I would like to scrape data from the [login to view URL] website. I am interested in scraping the DEF 14A filings. I want to scrape data from at least 5000 reports, preferably more. I want to extract just two fields from each report: the name of the company and the percentage of the company owned by the board members. I would like this information to be scraped and sent to me in Excel format. Scraping this information will be fairly challenging because the HTML pages are unstructured. The target text does not appear at the same predicable location on each page. The only way to locate the relevant text is to make use of some kind of advanced Boolean proximity search. The target text is normally preceded by a number of recognizable terms. The target text is normally followed by a percentage symbol. Here is an example of a DEF 14A filing. [login to view URL] The relevant table appears on page 11. The table lists the names of the board members and the percentage of the company that they personally own. Collectively the board members own 9.46 percent of the company. In this example I would be looking to extract the word "Microsoft" and the number 9.46 and place this in Excel format. In this example I would be looking to extract data from the 2013 Microsoft filing and all previous Microsoft filings on record. The big problem is that not all the companies use the same language: Here is a list of different phrases that various companies use. In each case the percentage figure at the very end is what I would be aiming to extract: "All directors and current executive officers as a group (12 persons) 3,991,056 6,348,957 10,340,013 2.6%" "Executive officers and directors as a group (13 persons)(19) 1,490,847 6.7%" "All directors and executive officers as a group (18 persons) 661,671 1,440,299 269,802,371,776 4.3%" "All Company directors and executive officers as a group (19 persons) 433,960 596,312 1,030,272 1.5%" "All nominees, continuing directors and executive officers as a group (20 persons) 5,944,103 16,824,264 139,82 8,03,926,234 (4) 23%" "All directors, director nominees and executive officers as a group (12 persons) 13,412,40 17.0%" "All current executive officers and directors as a group (10 persons) (7)........ 19,059,809 1,275,405 52.1%" "All directors and executive officers as of November 13, 2012 as a group (13 persons) 17,011,477 624,969 17,636,446 54.8%" A program could be built that recognizes the term "as a group (?? persons)" A wildcard search would have to be used because the number of persons varies, but it is always a two digit figure. The proximity between the term and the relevant percentage varies, but it is normally less than 30 characters. The relevant percentage figure is normally preceded by the terms "as a group (?? persons)" and its normally followed by a % symbol. The program would not be 100% accurate, but that does not matter in my case.
Project ID: 4250082

About the project

29 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I have looked on your requirements, retrieved the data and applied the described algorithm. Please see the PM with a sample and more details. Thanks.
£250 GBP in 1 day
5.0 (2 reviews)
3.5
3.5
29 freelancers are bidding on average £293 GBP for this job
User Avatar
Hi sir, please check PM, thx Kimi.
£375 GBP in 6 days
5.0 (385 reviews)
8.0
8.0
User Avatar
Kindly check my PBM
£500 GBP in 3 days
5.0 (99 reviews)
7.6
7.6
User Avatar
I worked on many similar projects, I have big experience in data mining projects. I can finish this task in short time, with the best quality.
£250 GBP in 5 days
4.9 (79 reviews)
7.3
7.3
User Avatar
Hi, have experience with extracting data from sources with unregular/not fixed structure. Check PM, have some questions.
£300 GBP in 4 days
5.0 (67 reviews)
7.4
7.4
User Avatar
Hi, Here is ready to start and please check PMB for details
£250 GBP in 5 days
4.8 (198 reviews)
7.2
7.2
User Avatar
I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.
£250 GBP in 5 days
5.0 (50 reviews)
6.8
6.8
User Avatar
I am an expert in scrapping and can deliver the project
£320 GBP in 5 days
4.9 (62 reviews)
6.7
6.7
User Avatar
Hi Ned, please check my private message.
£325 GBP in 10 days
5.0 (32 reviews)
5.9
5.9
User Avatar
Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.
£250 GBP in 3 days
5.0 (44 reviews)
5.3
5.3
User Avatar
##### Expert Web Scraper here! Please check PM for details. #####
£250 GBP in 5 days
4.9 (40 reviews)
5.5
5.5
User Avatar
Hi, I'm ready to start right now. Please, check your PMB. Thanks in advance. ##### 5-star freelancer + 100% completion rate = 100% client satisfaction #####
£275 GBP in 2 days
5.0 (13 reviews)
5.1
5.1
User Avatar
Hello, bot expert ready! ,please check pm
£500 GBP in 2 days
5.0 (9 reviews)
4.5
4.5
User Avatar
Hi, We are experts in Web scraping. Please look at the PM. Thanks - Nutan
£250 GBP in 3 days
5.0 (3 reviews)
4.7
4.7
User Avatar
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
£250 GBP in 9 days
4.9 (22 reviews)
5.0
5.0
User Avatar
Hi, My offer is a desktop application. Please refer to my message in your inbox for samples and demo. Thanks
£250 GBP in 7 days
4.8 (13 reviews)
4.8
4.8
User Avatar
Hi, please find my solution attached to your inbox.
£250 GBP in 4 days
5.0 (3 reviews)
4.2
4.2
User Avatar
sir please see pm and reply.
£250 GBP in 10 days
4.8 (13 reviews)
3.8
3.8
User Avatar
Hello, I'm an expert in web scraping with over 8 years of experience. I'm new at freelancer.com, but I'm not newbie in this kind of work. Please take a look at my private message to check my full proposal.
£350 GBP in 2 days
5.0 (1 review)
3.3
3.3
User Avatar
I have experience in web scraping and have been doing it for years. Can start right away!
£250 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I would love to work on this with you. I have sent you a PM. Thanks Mark
£310 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
KENSINGTON AND CHELSEA, United Kingdom
5.0
51
Payment method verified
Member since Jul 1, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.