Author Topic: Funded Amount?  (Read 11816 times)

core

  • Hero Member
  • *****
  • Posts: 1790
  • Your loss is my gain
    • View Profile
Re: Funded Amount?
« Reply #30 on: December 01, 2014, 04:21:02 PM »
Now I'm wondering about the architecture of LC's servers.  Likely they have more than one server, and perhaps different servers get the data at slightly different times.

Since my last post on this I have done some poking around regarding this, without being a registered API user.  I found no interesting headers from api.lendingclub.com while they were in the process of delivering my 401 unauthorized responses.

api.lendingclub.com resolved _every_ time for me to 216.115.73.155.  That belongs to this subnet:

Lending Club LENDINGCLUB-73 (NET-216-115-73-144-1) 216.115.73.144 - 216.115.73.159
SWITCH Communications Group LLC SWITCH-COMMUNICATIONS (NET-216-115-64-0-1) 216.115.64.0 - 216.115.95.255


*.144 to *.159 is quite a tight block.  And this is obviously not Edgecast and obviously not where their site is being served from.  It could be that complex in Nevada or wherever.  (Zach once mentioned the URL to their employee test site, might be interesting to see that falls in the same subnet.)  No matter.  The point is, you're not going to get anywhere here looking at IPs.  The best you could hope for is try all 16 (14? whatever) IPs in that range and see if anyone else answers to the virtual host api.lendingclub.com.  You could find a spare server which is more "lively", or you might even find the origin which is being proxied.  Likely not.

If they were using Edgecast for the API requests I might have some suggestions.  Because the Edgecast crap definitely _did_ have a timewarp, no doubt about it.  But here, they still could be handing off the requests to separate machines and you'd never know it because the HTTP headers are lean & mean and give no clues.

You guys are kinda behind, thinking about all this stuff just now.  I'm sure the institutional guys here on this forum have been at this for years.  It's too bad I never had reason to get into it; it might have been fun.

sociallender

  • Sr. Member
  • ****
  • Posts: 273
    • View Profile
    • Email
Re: Funded Amount?
« Reply #31 on: December 05, 2014, 10:46:10 AM »
It appears something has changed in a good way at LC.  The past 3 loan lists, I have been able to download the notes via the API and the percent funded has been 0%.  I am not sure if this is a reporting error or if I hit the API at the optimal time for each.  I will keep an eye on it but so far so good.  For example, here are the notes from the last list for one of my accounts.  Note the download time of the notes via API took 2.43 seconds.  This leads me to believe the I hit the API at the right time but took a while to process during heavy load.  Also, notice that the API list was at 2 seconds after the hour which is typically sooner than normal.  I am used to around 6 to 10 seconds after the hour.

Total New Notes: 116
Total Filtered Notes: 7
Ordered Notes: 5
Maximum Notes Per Order: 5
Requested Amount: $125.00
Investment Amount: $125.00
   
API Note Download Time: 2.43 seconds
Note List Time: 2014-12-04 14:00:02 PST
Processing Time: 0.13 seconds
API Order Time: 0.82 seconds
Total Time: 0.95 seconds



Fred93

  • Hero Member
  • *****
  • Posts: 2245
    • View Profile
Re: Funded Amount?
« Reply #32 on: December 05, 2014, 01:06:49 PM »
I can verify sociallender's recent good result.  (I can't verify his earlier difficulties, because by the time I got my test program running, he had declared success.)

So here are the first few and last few of this morning's 10AM batch, fresh off the press.  You can see they were all 0% funded as they first appeared.

 99 loans asOfDate 12/5/2014 10:00:02 AM
 id              loan amnt  funded     funded% posting time
 37077254  01200.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37137335  01500.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37137331  02000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36201362  02375.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37217208  02500.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 31206959  02900.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37317213  03500.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37137352  03500.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36330661  03625.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37217221  04000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37287253  04000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37107271  05000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37207219  05000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
...
 37147227  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 35874002  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36049533  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37147265  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36950381  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37167229  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36641316  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37117240  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36661316  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37147239  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 36341700  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37267150  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
 37187266  35000.00  00000.00  00.00%  12/5/2014 10:00:00 AM
end

Pardon the unusual leading zeros.  Was my trick for making the table line up nicely.

rawraw

  • Hero Member
  • *****
  • Posts: 2795
    • View Profile
Re: Funded Amount?
« Reply #33 on: December 05, 2014, 01:39:51 PM »
Good news indeed

Kombinator

  • Full Member
  • ***
  • Posts: 193
    • View Profile
Re: Funded Amount?
« Reply #34 on: December 05, 2014, 01:46:39 PM »
This is really excellent news and a very positive development. Makes me able to forgive them a little bit for taking away a lot of useful screening criteria (not forgive completely of course,just a little bit :)