tx
Member of DD Central
Posts: 300 
Likes: 127
|
Post by tx on Jun 13, 2016 15:20:21 GMT
Hi, is there a way to extract the remaining days, or the loan expiry date, together with your loan part holdings in the excel download? Many thanks.
|
|
locutus
Member of DD Central
Posts: 1,059
Likes: 1,622
|
Post by locutus on Jun 13, 2016 15:26:11 GMT
Hi, is there a way to extract the remaining days, or the loan expiry date, together with your loan part holdings in the excel download? Many thanks. Add a new column with a formula in there to read as follows: =YourCellRef-TODAY() Obviously, replace YourCellRef with the correct cell reference. Don't forget to format the cell to display as a number.
|
|
tx
Member of DD Central
Posts: 300
Likes: 127
|
Post by tx on Jun 13, 2016 15:56:40 GMT
The problem is, although shown in the "my loans" section, the expiry date of a loan is actually not in the excel file downloaded. Did I do something wrong? Nor does the remaining days in the excel file exported. This is what I need help with. Appreciated.
|
|
locutus
Member of DD Central
Posts: 1,059
Likes: 1,622
|
Post by locutus on Jun 13, 2016 16:11:43 GMT
Hi, is there a way to extract the remaining days, or the loan expiry date, together with your loan part holdings in the excel download? Many thanks. Apologies, you're right. I suggest emailing SS with a feature request. They told me they are working on website updates so they could include this too.
|
|
spiral
Member of DD Central
Posts: 967
Likes: 486
|
Post by spiral on Jun 14, 2016 8:27:53 GMT
I paste the live loans page into excel and use the formula in the next available column to return the value for the loan in row 2.
=VALUE(LEFT(F2,FIND(" ",F2,1)))-TODAY()+$O$1
where F2 contains the days remaining field from the paste.
I then manually complete the field o1 with the date I completed the paste.
Drag this formula down and you get the days remaining.
|
|
|
|
Post by ladywhitenap on Jun 14, 2016 9:36:58 GMT
Of course, if you want the actual remaining days left then I think there is a random() function somewhere in excel  LOL! I'm not even confident that the "remaining days" figure even shows how far into the future interest has been paid and kept updated with extensions. Surely this would give a far better idea of the status of the loan. By all means state the original term for general interest as well. Trawling through the updates and trying to work out the new end date is very tedious. LW
|
|
tx
Member of DD Central
Posts: 300
Likes: 127
|
Post by tx on Jun 14, 2016 11:14:06 GMT
Thanks everyone's ideas. Seems copy paste is the way then. Thanks for the formula.
|
|
