I would like an Excel Add-In/Macro or Desktop Tool that can provide updated single-day hotel prices for each of the next 180 days for 4 specified hotels (Residence Inn Charlotte Uptown, Courtyard Charlotte City Center, The Westin Charlotte, Hilton Charlotte Center City) in Charlotte, NC, USA. The deliverable should clearly state the hotel, date and daily price for each of the next 180 days and be able to refresh prices. I would like the data to come from the websites or API of either Google, Expedia, or Booking.com.
[url removed, login to view] [url removed, login to view]
The data can come from individual hotel websites as well, but I require the add-in/macro/tool to be able to refresh on a daily basis and pull in the next 180 days of daily pricing for the four hotels.