The project mostly entails extracting information from web pages into Excel and then automatically filling a series of forms on web pages. The aim is to automate my betting. Currently I import data into Excel which together with odds calculates bet sizes which I then place manually. Want I want is a macro that extracts odds from a single bookmaker, inputs them into the spreadsheet and then places the bets with the bookie by filling fields in a form. This project is quite simple, the mathematical work is ready; the important part is getting the sequence of web requests and data maniuplation correct. The four main tasks are: 1. Checking the balance on the bookmaker's site 2. Importing data from a webpage and checking against previous data 3. Extract odds from the bookmaker's site and matchup to data. Existing formulas calculate bet size 4. Place bets. There is a series of forms to fill, and the sequence may have to be repeated for each bet because of bet size limits. A bigger overview of the requirements is attached. If the project is successful you are likely to be hired again to repeat the project for other sports, or extend it to include other bookmakers. If that were to happen I might consider porting the whole project into a standalone VB application.
## Deliverables
Complete and fully-functional VBA macro.
## Platform
Microsoft Excel 2003 running on Windows XP