Economic Data Web Scraper
Collects treasury yield curves, consumer price index series, personal consumption data and wage indices from public government websites straight into Excel, ready for analysis.
- Industry
- Finance / Research
- Deliverable
- Web Scraping.xlsm
- Built with
- Excel VBA, Web scraping, Power Query
Before
Yield curves, CPI and wage data were downloaded from several government sites by hand.
After
The data is collected straight into Excel, ready for analysis.
More like this
Related projects
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project
Multi-Language Expense Report Form
Manufacturing (Baltics)
An employee expense claim form used in several countries. The form switches between eight languages, converts currencies, validates accounts and cost centres and emails the finished…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project