I downloaded the 2014 - 06/30/14 all loan statistics on 9/24 and 9/25. What I would like to do is to start automatically downloading these statistics files daily and track changes in such things as status, recent credit score, etc.
The downloaded files are LoanStatus3c_secure1_1409240125.csv and ....0126.csv (attached).
However when comparing the two files it seems strange that the loan status changes in one day don't seem to make sense. Example loan id 20127968 moves from a status of 'Current' to 'Late (16-30 days). If the snapshoting is done daily, it should move from 'Current' to 'In Grace Period'. Then loan 19687844 moves from 'Fully Paid' to 'Current' which makes no sense.
The combined statistics file is LoanStats3c_serure...._comb.xlsx. There is a column at the top ORIG_140924 for the original loan status from 9/24 and NEW_140925 for the new loan status from 9/25.
One other related question. Is there a way to pull up a screen with loan details/payment history of loans not in our own account, just by the loan ID?
I well might be doing something wrong, or not understanding the statistics file. What I am hoping to accomplish is to freeze daily changes in a larger pool of loans that I have in my account and then do analysis on such questions as when to sell a loan, etc.
[attachments contain first 700 lines of each file because of size constraints]
