Live Builders Merchants Price Tracker -- 2
Budget: £250 – £750 GBP
I need an Excel workbook that automatically pulls the latest daily prices for lumber, cement, bricks and other common building materials directly from Jewson and Travis Perkins. The sheet should refresh on schedule (once every 24 hours is fine) without any manual copy-and-paste.
Core functions I’m expecting:
• A clean, user-friendly dashboard that shows today’s price alongside yesterday’s and a simple % change.
• Behind the scenes, a reliable connection—Power Query, a public API, or a well-behaved web-scraper—to both merchants’ sites so the data flow keeps working even if product counts grow.
• Simple controls for me to add or remove SKUs or whole categories as my project list changes.
• No macros that trigger endless security warnings; keep the workflow as native to Excel as possible so any colleague can open it.
Acceptance is straightforward: when I open the file tomorrow morning it should fetch fresh Jewson and Travis Perkins prices without errors, update every product row, and recalculate the change columns automatically. Once that is stable for a full week, we’re done.
Core functions I’m expecting:
• A clean, user-friendly dashboard that shows today’s price alongside yesterday’s and a simple % change.
• Behind the scenes, a reliable connection—Power Query, a public API, or a well-behaved web-scraper—to both merchants’ sites so the data flow keeps working even if product counts grow.
• Simple controls for me to add or remove SKUs or whole categories as my project list changes.
• No macros that trigger endless security warnings; keep the workflow as native to Excel as possible so any colleague can open it.
Acceptance is straightforward: when I open the file tomorrow morning it should fetch fresh Jewson and Travis Perkins prices without errors, update every product row, and recalculate the change columns automatically. Once that is stable for a full week, we’re done.
Related categories:
PHP
Visual Basic
Excel
Web Scraping
Data Scraping
Data Analysis
API Development
Data Management