|
|
Post by max47 on May 6, 2014 14:31:43 GMT
Can someone advise if there is a way of listing your loan parts by numerical order rather than alphabetical ( present default)
|
|
|
|
Post by aloanatlast on May 6, 2014 14:38:25 GMT
By part ID, click on ID. By loan ID, sadly no.
|
|
markr
Member of DD Central
Posts: 766 
Likes: 426
|
Post by markr on May 6, 2014 17:23:36 GMT
Loan IDs are allocated sequentially when the loan is listed, Part IDs are allocated sequentially when the loan is drawn down by the borrower so sorting by part ID approximately sorts by Loan ID (the difference is some loans draw down quicker, so a Loan ID could be as much as 100 or so out of sequence but possibly close enough to find it by eyeball).
Alternatively, if you hold a loan part and it is saleable (not downgraded, processing, late, etc) then the search box on the sell individually page allows searches by loan ID.
|
|
|
|
Post by GSV3MIaC on May 6, 2014 22:14:35 GMT
I've suggested before, part ID =OUGHT= to be loan ID plus a sequence number, eg loan 6543 ought have parts 6543_0001 to whatever, but that would be too sensible. For real horror look at the sale page details and you'll find there is a bid ID for each part too .. Yep, unrelated number again.
|
|
ianb
Posts: 161
Likes: 54
|
Post by ianb on May 7, 2014 5:02:19 GMT
You can do it thru Excel, if you export the Loan Parts. Under the Excel Data tab, highlight the column and do 'text to columns', go thru the wizard for that and specify the dash as the delimiter. With this, you will have created 3 columns from the original one and then you can sort by the inserted Loan ID column (which is, I think, the third one). Voila !
|
|
|
|
Post by GSV3MIaC on May 7, 2014 7:49:28 GMT
Until you get to yesterday's loan which had a - as part of their loan title! You really need the VBA split function, and use ubound to find the last part of the split. 'Right' might work, except if the loan has 1% cashback' on the end of the title. I still think an easy bid number-> loan part number -> loan number, mapping should be possible.
|
|
|
|
Post by bracknellboy on May 7, 2014 7:56:33 GMT
b*****Y whizzo. Never knew about that function.
Only problem: in creating 2 new columns, it overrides the content of the original columns. Anyway of getting it to automatically insert new columns ?
|
|
jm72
Posts: 109
Likes: 2
|
Post by jm72 on May 7, 2014 10:19:54 GMT
I use a number of formulae - depending on the report as you need a Macro to insert two columns automatically (or do this manually before do the text to columns).
For 'current bids', I use: =VALUE(RIGHT(B2;LEN(B2)-FIND("- ";B2)-1))
For the transaction download, I use: =IFERROR(ABS(VALUE(RIGHT(B2;8)));IFERROR(ABS(VALUE(RIGHT(B2;6)));ABS(VALUE(RIGHT(B2;4))))). This will pull out either the loan ID (for bids) or Loan Part ID (for all other transactions). Needs the ABS in order to capture the old loans which have less than 4 digits.
The first one works as the '-' between the Name and Industry in the Current bids download has no spaces. The second should work for all others (which have spaces around the first '-').
It would be so, so much easier if all reports had the same format, with Loan ID and Loan Part ID both being present!
|
|
ianb
Posts: 161
Likes: 54
|
Post by ianb on May 7, 2014 13:37:28 GMT
I must've avoided loans with a dash within the title as didn't see that on my results! On the above point about retaining the original column, if you wish to do this (simply) I would suggest just copying it first so you have two of them, and then do the 'text to column' thing on one of them. Alternatively, the above formula - though I'd have got a serious headache trying to think that thru so cheers for putting that up there.
|
|
|
|
Post by GSV3MIaC on May 7, 2014 16:52:23 GMT
6058 .. Not actually a loan yet, but will maybe choke a few systems when it is. 8>.
|
|
