|
Post by dan1 on Mar 20, 2018 20:58:48 GMT
I've just finished trawling through the loan book to extract the newly listed Active Loans to the same borrower data (Cambridge Analytica have nothing on me ). Attached is a zip file containing two csv files which list the Loan References for each Borrower ID. I've used the flat file with my own current investment download to assess my exposure to each borrower. I've created the Borrower ID from the first loan number to the borrower. For example, the borrower of the upcoming loan secured by a 2nd charge on the borrowers property (see this thread) is Borrower ID #1521 because this was the borrowers first loan ( unbolted.com/uk/lenders/view-loan/1521/). Note that the Loan References include repaid as well as active loans. Borrower ID #38 has 69 loans listed of which only 9 are active. Because only active loans to the same borrower are listed there may be other repaid loans to the same borrower which are not identified. I've not attempted to renewed loans, i.e. loans linked by the same asset(s). ashwinp rito - may I suggest that investors would benefit from the introduction of both a Borrower ID and an Asset ID in the download? Attachments:Unbolted.zip (9.74 KB)
|
|