I know Christmas is around the corner so I started to think of what I want from Santa. I thought about the usual things I would like for Christmas such as peace on earth and good will toward all men. But then I figured out want I really want. An industry-standard loan export format!
P2PXML – DRAFT
<?xml version="1.0" encoding="UTF-8"?> <DataExport platform="Platform Name" timestamp="2011-12-01 12:00:00 CST"> <Loans> <Loan> <LoanId>1000</LoanId> <!-- Platform Loan ID --> <AmountRequested>25000</AmountRequested> <AmountFundedByInvestors>25000</AmountFundedByInvestors> <TotalAmountFunded>25000</TotalAmountFunded> <Status>Current</Status> <Term>60</Term> <!-- In months --> <Title>Title of Loan</Title> <Purpose>Debt Consolidation</Purpose> <Description>Loan Description</Description> <LoanGrade>B</LoanGrade> <InterestRate>10.0</InterestRate> <MonthlyPayment>531.18</MonthlyPayment> <Fees>26.55</Fees> <InterestPaid>1,014.54</InterestPaid> <!-- Total to date --> <PrincipalPaid>1641.34</PrincipalPaid> <!-- Total to date --> <PrincipalRemaining>23,358.66</PrincipalRemaining> <CreationDate>2011-11-025</CreationDate> <OriginationDate>2011-12-01</OriginationDate> <ModifiedDate>2012-04-01</ModifiedDate> <LatePayments>2</LatePayments> <PaymentCycle>5</PaymentCycle> <AgeInMonths>5</AgeInMonths> <PaymentHistory> <Entry date="2011-12-01"> <Status>Current</Status> <PaymentCycle>1</PaymentCycle> <InterestPaid>208.33</InterestPaid> <!-- Total to date --> <PrincipalPaid>322.84</PrincipalPaid> <!-- Total to date --> <Fees>5.31</Fees> </Entry> </PaymentHistory> </Loan> </Loans> </DataExport>
I’ve spent a lot of time with both platforms, Lending Club and Prosper. I’ve combined the best of both worlds into the P2PXML format. If both platforms could agree on a standard format, developers would write libraries that were platform agnostic. I’ve created my first attempt at a standard XML format. I would love to hear your feed back. The payment history was not filled in completely to save space. Come one Prosper and Lending Club, make my Christmas wishes come true!