Need to modify existing macro to get correct data - history odds: 1X2 and O/U (Over/Under) 2.5 from betexplorer.com.
Everything except O/U 2.5 works fine.
Problem with O/U is that the scraper takes first meanings (picture 1), which are wrong because they are not the odds for O/U 2.5, but 0.5 and they are not the odds from the bookie I want.
Scraper should check: 1) if the bookie is a chosen one and 2) if the odds are for O/U 2.5 (picture 2 - orange marks).
Correct result (picture 2 - green mark) should then be translated to columns N and O in the DATA Sheet.
In the attachment:
- an example spreadsheet with wrong data in columns N and O,
- 2 pictures for understanding.
Any questions - feel free to ask.
Reading the project description, it looks like a simple fix. However, your workbook contains over 2,000 lines of code. This makes the job somewhat harder. Regards, Svet.