A practical spreadsheet could use one row per home: precise area, first seen, original and current price, condition, reductions, withdrawn date, relisting and final known outcome. Leave the outcome as unknown when it is unknown; that is better than treating every removal as sold.
A simple spreadsheet should settle most of this. Use the same loan amount and completion date for every lender, then enter: cash fees at the start, monthly payments, remaining balance at chosen comparison dates, and any early-repayment charge shown in each offer. Run it at several dates rather...