|
|
Post by thereverendofsurrey on Apr 19, 2014 13:10:42 GMT
Hi all. I see people talking about having owned a loan for x days, x hrs, x minutes. Where do you get this info? I can only see when I have bought units. Thx
|
|
|
|
Post by Ton ⓉⓞⓃ on Apr 19, 2014 18:57:56 GMT
Hi all. I see people talking about having owned a loan for x days, x hrs, x minutes. Where do you get this info? I can only see when I have bought units. Thx Hi & welcome to the forum. I must say that I don't know other than going through your Statement finding when it was bought it and subtracting today's date from that; I should've said that the other way round. I hadn't seen anyone actually say how long they had a loan but someone might say "I bought loan Y 20/03/2014 18:18:17" which is simply a copy and paste from my statement of the date, hours, mins, secs exactly when I bought something but not how long I've held it.  Are you looking at your interest and making calculations?
|
|
walktall7
Member of DD Central
Posts: 184 
Likes: 35
|
Post by walktall7 on Apr 19, 2014 19:46:02 GMT
Hi, I have a spreadsheet set up with my loans which I update from the statement every 14 days. Some other lenders do a similar thing so as to keep track of there investments
|
|
|
|
Post by Ton ⓉⓞⓃ on Apr 19, 2014 20:30:58 GMT
Hi, I have a spreadsheet set up with my loans which I update from the statement every 14 days. Some other lenders do a similar thing so as to keep track of there investments I'm completely changing my system right now, what do you include in your spread sheet?
|
|
spockie
Member of DD Central
Posts: 299 
Likes: 84
|
Post by spockie on Apr 19, 2014 20:34:35 GMT
I would think most of us keep spreadsheets to keep on top of the investments, and that's certainly how I know how long I've had a loan for.
|
|
|
|
Post by thereverendofsurrey on Apr 19, 2014 21:43:33 GMT
That sounds like a good idea, I am useless at spreadsheets as they presumably need macros etc? Anyone offering up a blank pro forma as a help?
wp
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Apr 20, 2014 0:37:53 GMT
Hi, I have a spreadsheet set up with my loans which I update from the statement every 14 days. Some other lenders do a similar thing so as to keep track of there investments I can see how that might work reasonably well where a lender makes one investment in a loan and just holds it. But I find I seem to make pre-bid, and then maybe further bids when an auction goes live, and then maybe pick up some more loan parts in the AM. So I'd end up with a rather extensive spreadsheet. But I've never tried it, so perhaps that isn't a problem at all.
|
|
|
|
Post by Ton ⓉⓞⓃ on Apr 20, 2014 8:01:50 GMT
That sounds like a good idea, I am useless at spreadsheets as they presumably need macros etc? Anyone offering up a blank pro forma as a help? wp No one has been offering it up til now. AC have said, I think, that it's likely they will produce a "My Loan Book" feature sometime in the future. No timescale given. But thereverendofsurrey what do you actually want to achieve? I'm using a spread sheet (XL) but there are as many words and drawdown dates in it as there are amounts in Pounds Sterling. In fact I'm not using XL to add anything up at all, I'm not using it for doing the maths. It's just a way to store info in small boxes in lines. That's not entirely true as I'm stopping using what I was doing and starting the above one. (I've always ignoring interest.) How does everyone else keep track of what they buy, sell, flip and hold, or does all that bookkeeping get in the way of the fun?
|
|
spockie
Member of DD Central
Posts: 299
Likes: 84
|
Post by spockie on Apr 20, 2014 8:19:01 GMT
Simple spreadsheet listing loan, type, expected drawdown date, how much invested. Then when it draws down, I use Excel to calculate overall interest rate for my holding, annual and monthly interest both separately and across all loans amongst other things. I arrange them by day of the month of expected payment as they are alphabetical on the AC site. Different people want to know different information about their loans so you just set up the calculations according to what information you want.
|
|
duck
Member of DD Central
Posts: 2,864
Likes: 6,898
|
Post by duck on Apr 20, 2014 9:13:39 GMT
Hi, I have a spreadsheet set up with my loans which I update from the statement every 14 days. Some other lenders do a similar thing so as to keep track of there investments I can see how that might work reasonably well where a lender makes one investment in a loan and just holds it. But I find I seem to make pre-bid, and then maybe further bids when an auction goes live, and then maybe pick up some more loan parts in the AM. So I'd end up with a rather extensive spreadsheet. But I've never tried it, so perhaps that isn't a problem at all. With the relatively small number of loans on Assetz I don't find this to be a problem since a new column can be used for each 'possibility'. I find 'LOOKUP', 'IF' & 'SUMPRODUCT' to be my best friends so you hold the data on one (or more) sheets and end up with an easily readable summary front sheet. My spreadsheet reads directly from the downloadable file to minimise manual intervention. The total spreadsheet is below 2,000 lines.
In contrast my Bondora spreadsheet currently runs to over 700,000 lines!
|
|
|
|
Post by Ton ⓉⓞⓃ on Apr 20, 2014 9:22:29 GMT
I can see how that might work reasonably well where a lender makes one <snip> In contrast my Bondora spreadsheet currently runs to over 700,000 lines!
700,000 I didn't know numbers went that high... thereverendofsurrey that's something I forgot about; the downloadable summary that duck mentions might be quite useful. I've never really looked at it tho'.
|
|
duck
Member of DD Central
Posts: 2,864
Likes: 6,898
|
Post by duck on Apr 20, 2014 9:36:13 GMT
In contrast my Bondora spreadsheet currently runs to over 700,000 lines!
700,000 I didn't know numbers went that high. thereverendofsurrey that's something I forgot about; the downloadable summary that duck mentions might be quite useful. I've never really looked at it tho'. The latest versions of Excel allow 'unlimited' lines ....... it used to fall over at approx. 37,000!
|
|
|
|
Post by Ton ⓉⓞⓃ on Apr 20, 2014 9:45:31 GMT
700,000 I didn't know numbers went that high. thereverendofsurrey that's something I forgot about; the downloadable summary that duck mentions might be quite useful. I've never really looked at it tho'. The latest versions of Excel allow 'unlimited' lines ....... it used to fall over at approx. 37,000! My cat's very well behaved isn't it, there's a fluffy cute little bird right there...
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Apr 20, 2014 20:50:26 GMT
The latest versions of Excel allow 'unlimited' lines ....... it used to fall over at approx. 37,000! I think my Zopa spreadsheet has about 30,000 lines. It's never fallen over, but it takes a fair while to recalculate even on a reasonably powerful PC -- it's so bad I've had to turn off automatic recalculation.
|
|
