Excel/VBA Macros webscrapping

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

Looking for a simple VBA Macros which is able to perform following task:

A) Open Moody's .com Webpage corrresponding to the costumized ISIN link in excel (Collum B)

B) Scrap Long Term Rating (see printscreen, red)

C) Copy the rating to the corresponding Cell in Collum D

D) if page is not available or no rating found: "Error" in colum D

E) go throught all ISIN Numbers (up to 10'000 - file is only example)

Excel Visual Basic Data Entry Data Processing Visual Basic for Apps

Project ID: #23373553

About the project

11 proposals Remote project Active 4 years ago

Awarded to:

branislavm

Hello! I've created an account and I checked the source of the webpage. It is a standard language where the rating is within a class "ratingTypeCtrl subControl" and it can be read using Excel. I can start right away a More

$50 USD in 1 day
(107 Reviews)
6.9

11 freelancers are bidding on average $115 for this job

sergiuloghin

Hello! I can build a VBA scraper for you. It will take me 1-2 days. I did many simillare scrapers I am available. Can you award me? Thank you!

$250 USD in 2 days
(462 Reviews)
8.3
MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA and Selenium script. It will be quick and accurate. If interested, we can discuss this further on cha More

$80 USD in 1 day
(26 Reviews)
4.9
hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS More

$30 USD in 1 day
(19 Reviews)
4.7
mmehdi786

Hi, I have read the requirements and start working on it in no time. I will create a VBA macro that interacts with the site, allows you to login with your credentials, and get the information into your sheets for each More

$175 USD in 4 days
(3 Reviews)
3.7
faiiz

Hi Sir I am interrested in this project. My name is Faiz and im a statistician and a professional data scientist, a combination that provides me with the full suite of tools to do data analysis, data modelling and data More

$35 USD in 1 day
(6 Reviews)
3.0
gollard007

Hello. I've read your job description. I can do your job with my rich experience in Excel VBA. You can check my last review. I'll be great for an interview and will finish asap. Looking forward to hearing from you soon More

$140 USD in 7 days
(2 Reviews)
1.6
Sammym05

Dear Client, I have gone through your requirements and yes I can do it for you. I am new at freelancer but I have completed more than 50 VBA automation projects in my organization. I am specialized in Excel automation More

$170 USD in 3 days
(0 Reviews)
0.0