Data Scraping Hotel Prices in VBA

$30-250 USD

Completed

Posted

about 4 years ago

$30-250 USD

Paid on delivery

I would like an Excel Macro that can provide single-day hotel prices given a set of hotel names/addresses and dates. In other words, within Excel, in Column A will be a list of hotels, Column B will be addresses, and row 1 will have various dates. Upon running the macro, the cells will automatically update with the price of each hotel for the given dates. In the attached Excel file, upon running the macro, the highlighted cells will be filled in with the prices for the given dates. The hotel names, addresses, and dates will change, so the macro must be able to run off the data in the given cells. Ideally, the macro will use a free API from a trusted source (Google, Expedia, [login to view URL], etc.) However, I realize these API's may not be available. As such, data scraping from one of these websites is acceptable. The programming must be done in VBA.

Excel

Visual Basic

Web Scraping

Visual Basic for Apps

Project ID: 24738938

About the project

15 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

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:

@akritisood94

Hi I am well experienced in vba. You can have a look over my reviews. I can create macro according to your need. I will wait for your response. Regards

$40 USD in 1 day

4.9

(120 reviews)

6.2

15 freelancers are bidding on average $125 USD for this job

@datakillers

Hi i really interested in this job am expert with excel macro , can we discuss the details in chat please .It will be great pleasure to work with you

$100 USD in 1 day

4.9

(460 reviews)

7.9

@khushh07

Hello.... Greetings to you !! I have in-dept professional experience and have the ability to provide quality services to my clients.I understood ur requirements,please talk to me about te project * Ms Excel ( Proficient) ( Pivot table, Charts, Advance formulas, VB Code) * Web scraping * Data Entry and Research * Conversion (PDF to Excel, JPEG, XML, DOC,etc) * Virtual Assistant * Data processing My aim is to keep my client happy with providing accurate work within the time frame provided. There is no compromise on the quality and accuracy of work. Thanks & Regards Khushi

$140 USD in 2 days

4.8

(328 reviews)

7.3

@DavidLindon

I will write a macro to use an API where available with the name and dates reads from cells. I have 11 years experience in software development

$167 USD in 5 days

4.9

(49 reviews)

6.3

@liveexperts123

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..

$250 USD in 5 days

5.0

(5 reviews)

5.5

@MonisZafar

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA. It will be quick and accurate. If interested, we can discuss this further on chat.

$80 USD in 1 day

4.5

(23 reviews)

4.8

@agupta2812

Hi, I am an experienced VBA developer and expert in data scrapping. I have understood your requirements and I can complete this project in 2 days with 100% accuracy within minimum budget. I can showcase few other projects for VBA for data scrapping. Do let me know if you are interested to discuss this project with me. Thanks Ashish Gupta

$45 USD in 2 days

4.6

(5 reviews)

3.1

@Jahangirg

Ok ready

$156 USD in 3 days

0.0

(0 reviews)

0.0

@JAIDEEPKHURANA78

Time is money for me. Work on time. Accurate timing. All types of work is done by me. Nothing is impossible.

$150 USD in 7 days

0.0

(0 reviews)

0.0

@Oliullah94

I will deliver this project I. Time Relevant Skills and Experience Data entry

$133 USD in 2 days

0.0

(0 reviews)

0.0

@Bilalryk

Hi i am expert in M.s Excel and a lot of experience in this field. Ms. office. I am a professional Person. I have a Experience in the field of 5 years. I am Interested with your work. I am waiting your reply thanks

$80 USD in 2 days