Author Topic: Recovery Payment Received for Charged Off Loans  (Read 1097 times)

AnilG

  • Hero Member
  • *****
  • Posts: 1095
    • View Profile
    • PeerCube
Recovery Payment Received for Charged Off Loans
« on: February 19, 2019, 12:15:46 AM »
Hello,

Do any readers have notes from following loans in their portfolio? I am looking for information on how much recovery amount were they paid on these charged off loans. Original amount lent, amount charged off, and recovery amount paid information on any notes from following list of Loan ID is appreciated.

Thanks.

Code: [Select]
[1]   187383   365044   446879   545408   628186   667933   722727   786973   801181   820963   834642
[12]   888558   985214  1125962  1334517  1390923  1469058  1548720  1587199  1606429  2234851  2286330
[23]  3158374  3216977  3635121  3919282  4255787  4282031  6707722  7059592  7648944  8614949  9845644
[34] 10597591 12987029 19256502 24055069 30836182 32069035 32280008 33201307 35004113 35733650 36099806
[45] 37741722 39531903 39977574 40776754 41071468 41388698 44056470 46764136 48181956 48556047 51978290
[56] 55987171 57015193 60025467 60246818 63919895 64037882 64967871 65611490 65821312 66491455 67446038
[67] 70702343 70841513 71744763 75304312 75427297 76403791 80662890 84051666 88084249 88402158 90244701
[78] 90835542 91575843
---
Anil Gupta
PeerCube Thoughts blog https://www.peercube.com/blog
PeerCube https://www.peercube.com

jheizer

  • Sr. Member
  • ****
  • Posts: 472
    • View Profile
    • LC Tools
Re: Recovery Payment Received for Charged Off Loans
« Reply #1 on: February 19, 2019, 10:17:41 AM »
Could you dump them into a single column so its easier to get into excel to match?  Doesn't go in cleanly as is.  Curious where this is going.
Replacement to P2P Quant's Percentile Tool http://lc.geekminute.com

lascott

  • Hero Member
  • *****
  • Posts: 1423
    • View Profile
    • Appreciate my post and want to try LendingRobot? URL below
Re: Recovery Payment Received for Charged Off Loans
« Reply #2 on: February 19, 2019, 12:43:41 PM »
Could you dump them into a single column so its easier to get into excel to match?  Doesn't go in cleanly as is.  Curious where this is going.
I think I got them all. I didn't have any.

187383
365044
446879
545408
628186
667933
722727
786973
801181
820963
834642
888558
985214
1125962
1334517
1390923
1469058
1548720
1587199
1606429
2234851
2286330
3158374
3216977
3635121
3919282
4255787
4282031
6707722
7059592
7648944
8614949
9845644
10597591
12987029
19256502
24055069
30836182
32069035
32280008
33201307
35004113
35733650
36099806
37741722
39531903
39977574
40776754
41071468
41388698
44056470
46764136
48181956
48556047
51978290
55987171
57015193
60025467
60246818
63919895
64037882
64967871
65611490
65821312
66491455
67446038
70702343
70841513
71744763
75304312
75427297
76403791
80662890
84051666
88084249
88402158
90244701
90835542
91575843
« Last Edit: February 19, 2019, 12:50:01 PM by lascott »
Tools I use: (main) BlueVestment: https://www.bluevestment.com/app/pricing + https://www.interestradar.com/ , (others) Lending Robot referral link: https://www.lendingrobot.com/ref/scott473/  & Peercube referral code: DFVA9Y

jheizer

  • Sr. Member
  • ****
  • Posts: 472
    • View Profile
    • LC Tools
Re: Recovery Payment Received for Charged Off Loans
« Reply #3 on: February 19, 2019, 01:41:36 PM »
Thanks lascott.  No matches here either.
Replacement to P2P Quant's Percentile Tool http://lc.geekminute.com

Fred93

  • Hero Member
  • *****
  • Posts: 2166
    • View Profile
Re: Recovery Payment Received for Charged Off Loans
« Reply #4 on: February 19, 2019, 01:46:03 PM »
Thanks for putting them in one column.

No matches here.

Rob L

  • Hero Member
  • *****
  • Posts: 2065
    • View Profile
Re: Recovery Payment Received for Charged Off Loans
« Reply #5 on: February 20, 2019, 12:21:07 PM »
None of them in here.

.Ryan.

  • Jr. Member
  • **
  • Posts: 70
    • View Profile
Re: Recovery Payment Received for Charged Off Loans
« Reply #6 on: February 20, 2019, 12:53:04 PM »
No matches from my 10k+ loans.

For those excel challenged (like myself), I simply pasted this list to the first column of the bottom of my latest notes_ext.csv, then  highlighted the column, and selected "Conditional Formatting", then "Highlight Cell Rules", then "Duplicate Values". Duplicate values will show up colored.

Let me (everyone) know if there is an easier way.

rawraw

  • Hero Member
  • *****
  • Posts: 2768
    • View Profile
Re: Recovery Payment Received for Charged Off Loans
« Reply #7 on: February 20, 2019, 08:06:41 PM »
You can put the list in Excel and use this formula: =match(AnilLoanID,RangeofLoanIDs,0).    Rank by the result. Things with numbers are matches

For example, =match(187383,A:A,0)