A commercial broker held risk information one client at a time. Schedules in spreadsheets, surveys as PDFs, material detail in broker notes. Nothing could be queried across the book.
Portfolio questions took three to four days to approximate. The approximations rested on client assertions that had never been verified.











