Skip to main content

Author Topic: stale incorrect data in notes-ext.csv file

  • *****
  • Hero Member
  • Posts: 608
stale incorrect data in notes-ext.csv file
OP: November 25, 2016, 12:00:00 AM
I sent a message to LC tonite, complaining about stale data in the notes-ext.csv file.  Some on this forum have noted that the last credit pull field shows data to be a month old.  The gist of that discussion has usually been that LC hasn't gotten around to pulling new data.  Turns out they have new data, and show it on the web page BUT JUST DON'T PUT THE NEW DATA INTO THE NOTES_EXT.CSV FILE!  On the same day, you can pull a notes_ext.csv file containing FICO scores more than a month old while the web page has the new data.  So, for example, if you have software that relies on the notes_ext.csv file for current FICO numbers, it will be using old stale data, while the people buying from you see the web page, and its new data.

My message to LC...

Today I sold a note, thinking that the borrower's FICO score had dropped significantly.  Turns out, that wasn't quite right.  I relied on the last-FICO fields in the notes-ext.csv file.  Rather, my software used these fields to decide which notes to sell.

However, I have learned that data is stale.  I noticed this first for note 46821141, (from loan 16041120) but I see that the same situation exists for many notes.

The notes-ext.csv file says that the last fico is 650-654, and the last credit update date is 10/20/2016.  That's just wrong.  Most of the current notes in the notes-ext.csv file contain a last credit pull date of 10/20/2016, but in all the cases I checked, the web page has november data.



If you look on the web page for this note, which my software cannot do of course, you see that the FICO score has been updated in November, and the new score is 700-704 !!!  A move of 50 points up is a substantial increase.  This data point is shown as dated 11/16/2016 on the graph.  That's 9 days ago.  However, the notes-ext.csv file pulled this evening, which sellers rely on, has not been updated.





I believe you should cancel this note sale, because you provided stale incorrect data.  I have no idea how many other note sales suffer this same condition.

You should be able to provide consistent data between the web pages and the notes-ext.csv file.  Both buyers and sellers should be given the same data.
  • IP logged

R
  • Posts: 484
stale incorrect data in notes-ext.csv file
#1: November 25, 2016, 12:00:00 AM
FWIW I just downloaded the file containing all notes currently for sale:

https://resources.lendingclub.com/SecondaryMarketAllNotes.csv

There are two notes for sale now for your loan; one was listed on 11/18 and the other listed on 11/19.
The column titled FICO_End_Range has the value 700-704 and DaysSinceLastPayment column has the value 8.
So, automated buyers using this file also have the latest updated FICO (in addition to manual buyers using the web site).

It's interesting that notes-ext.csv does not have a NeverLate column but  AllNotes.csv does.
If LC were to fix the staleness problem they should also add NeverLate to notes-ext.csv as well.

The absence of NeverLate in notes-ext.csv forced me to "pre-list" my notes at a ridiculously high markup just to obtain NeverLate, then list them for real. As a work around you could do the same and get the latest FICO from your "pre-listed" notes in AllNotes.csv rather than from notes-ext.csv. Yeah, I know it shouldn't have to to work like that but how long will it be before (if ever) LC fixes the problem. As a bonus you will get the NeverLate flag too.
  • IP logged






g
  • Posts: 3
stale incorrect data in notes-ext.csv file
#7: December 07, 2016, 12:00:00 AM
Even the web page is not up to date. When a payment is just made, the payment history is updated but remaining payments is not updated. It takes a few days for remaining payments to catch up. Screen scraping is not a bad idea if you don't sell it too frequently.
  • IP logged