Hotel Prices Data Scraping -- 2
Budget: $30 – $250 USD
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, Booking.com, etc.) However, I realize these API's may not be available. As such, data scraping from one of these websites is acceptable.
The macro must be fast (no more than 0.50 seconds per pull) and also durable (don't want it breaking if scraping and the data source changes their website).
Thanks!
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, Booking.com, etc.) However, I realize these API's may not be available. As such, data scraping from one of these websites is acceptable.
The macro must be fast (no more than 0.50 seconds per pull) and also durable (don't want it breaking if scraping and the data source changes their website).
Thanks!