I need a robust yet lightweight script that connects to a specific online-auction platform and captures every live bid event. For each event I must see two fields only—the current bid price and the bidder’s (party) name—and have them appear automatically inside an Excel file as the auction progresses. Near-instant updates (a few seconds at most) are essential so I can analyse bidding behaviour on the fly. There is a range of price ie betwenn L1 and H1. I want to know which parties are bidding at which prices and their last bid price. The site uses dynamic content so the solution will likely rely on Python with Selenium, Playwright, or direct WebSocket/API interception—whichever achieves stable real-time capture without breaching the site’s terms. Please build in sensible error handling for session expiry, connection drops, or captchas and keep resource usage low so the script can run continuously during long auctions. Deliverables • Fully commented source code • Step-by-step setup guide (Windows) • A sample Excel workbook showing live population during a short test run • Brief README on how to adapt the scraper if the website layout changes Acceptance criteria 1. When I start the script and open the provided workbook I see new rows appear automatically as bids are placed. 2. Each row contains the exact bid price and bidder name shown on the site, with no missing or duplicate entries. 3. The solution runs for at least three hours straight without manual intervention. If you have prior experience with live-data scraping or Excel streaming, that will help, but clear, maintainable code is my top priority.