DeafEater
Member of DD Central
Extremely Moderate
Posts: 218
Likes: 292
|
Post by DeafEater on Mar 2, 2018 10:32:07 GMT
I'm just trying to get my spreadsheet in order in case it comes to a punch-up with the administrator over what loans and cash I was holding when the music stopped and I was wondering if anyone can help me with a couple of gaps. I haven't bought anything for a while but all of my bling loans were set to auto-renew and I was holding some of BB00589 and BB00588 which according to Col's loan update sent on 16/02, were both due to mature on 23/02/2018. My spreadsheet said 24/02 but let's not split hairs. Col said that BB00589 (borrower ACC00045) would redeem and they were still waiting to hear what was going to happen with BB00588 (borrower ACC00044). Can anyone confirm whether BB00589 DID pay back (because if it did I have an extra 400 quid + interest in my possibly unsegregated cash account)? Also does anyone know what happened with BB00588? dan1 kindly uploaded to DDC a dump of Col loans as of early evening on 25/02 and that said that the remaining term on BB00588 was -1 days implying that it neither paid back nor renewed but does anyone have any more concrete information? R
|
|
|
Post by dan1 on Mar 2, 2018 10:39:11 GMT
I'm just trying to get my spreadsheet in order in case it comes to a punch-up with the administrator over what loans and cash I was holding when the music stopped and I was wondering if anyone can help me with a couple of gaps. I haven't bought anything for a while but all of my bling loans were set to auto-renew and I was holding some of BB00589 and BB00588 which according to Col's loan update sent on 16/02, were both due to mature on 23/02/2018. My spreadsheet said 24/02 but let's not split hairs. Col said that BB00589 (borrower ACC00045) would redeem and they were still waiting to hear what was going to happen with BB00588 (borrower ACC00044). Can anyone confirm whether BB00589 DID pay back (because if it did I have an extra 400 quid + interest in my possibly unsegregated cash account)? Also does anyone know what happened with BB00588? dan1 kindly uploaded to DDC a dump of Col loans as of early evening on 25/02 and that said that the remaining term on BB00588 was -1 days implying that it neither paid back nor renewed but does anyone have any more concrete information? R I don't believe that 595 (motorhome not held in secure storage), 588 (3 watches held by COL) or 589 (diamond AoC/SAA) were redeemed before the web site went offline around 19:30. I have no evidence to support this though.
|
|
hantsowl
Member of DD Central
Posts: 672
Likes: 546
|
Post by hantsowl on Mar 2, 2018 10:41:56 GMT
I'm just trying to get my spreadsheet in order in case it comes to a punch-up with the administrator over what loans and cash I was holding when the music stopped and I was wondering if anyone can help me with a couple of gaps. I haven't bought anything for a while but all of my bling loans were set to auto-renew and I was holding some of BB00589 and BB00588 which according to Col's loan update sent on 16/02, were both due to mature on 23/02/2018. My spreadsheet said 24/02 but let's not split hairs. Col said that BB00589 (borrower ACC00045) would redeem and they were still waiting to hear what was going to happen with BB00588 (borrower ACC00044). Can anyone confirm whether BB00589 DID pay back (because if it did I have an extra 400 quid + interest in my possibly unsegregated cash account)? Also does anyone know what happened with BB00588? dan1 kindly uploaded to DDC a dump of Col loans as of early evening on 25/02 and that said that the remaining term on BB00588 was -1 days implying that it neither paid back nor renewed but does anyone have any more concrete information? R I also have investments in BB00588 and BB00589. My spreadsheet shows them both at -6 days and as far as I am aware they were both still 'active' when the lights went out.
|
|
stub8535
Member of DD Central
personal opinions only. Not qualified to advise on investment products.
Posts: 1,442
Likes: 945
|
Post by stub8535 on Mar 2, 2018 10:51:21 GMT
I'm just trying to get my spreadsheet in order in case it comes to a punch-up with the administrator over what loans and cash I was holding when the music stopped and I was wondering if anyone can help me with a couple of gaps. I haven't bought anything for a while but all of my bling loans were set to auto-renew and I was holding some of BB00589 and BB00588 which according to Col's loan update sent on 16/02, were both due to mature on 23/02/2018. My spreadsheet said 24/02 but let's not split hairs. Col said that BB00589 (borrower ACC00045) would redeem and they were still waiting to hear what was going to happen with BB00588 (borrower ACC00044). Can anyone confirm whether BB00589 DID pay back (because if it did I have an extra 400 quid + interest in my possibly unsegregated cash account)? Also does anyone know what happened with BB00588? dan1 kindly uploaded to DDC a dump of Col loans as of early evening on 25/02 and that said that the remaining term on BB00588 was -1 days implying that it neither paid back nor renewed but does anyone have any more concrete information? R I don't believe that 595 (motorhome not held in secure storage), 588 (3 watches held by COL) or 589 (diamond AoC/SAA) were redeemed before the web site went offline around 19:30. I have no evidence to support this though. 588 and 589 did not redeem. As they were both overdue at 15:30 on 26th.
|
|
DeafEater
Member of DD Central
Extremely Moderate
Posts: 218
Likes: 292
|
Post by DeafEater on Mar 2, 2018 10:57:09 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. Edit: crossed with stub8535 - sounds like BB00588 was missing from the download because screen scraping one page at a time is such an error prone process. Shame there isn't/wasn't a better way of doing it.
|
|
|
Post by dan1 on Mar 2, 2018 11:04:31 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. This may be explained by the method I extracted the data. The live loans are/were split across the Active and Fully Funded pages and to extract the data I had to ctrl-c on the Active Loans page and ctrl-v on my spreadsheet, then go back and do the same on the Fully Funded Loans page. 588 could have moved between pages in the intervening period (seconds worth). Btw, I only extracted the data to prune my positions in birriwer ACC00007 (I'd already sold out of 588 and 589).
|
|
hantsowl
Member of DD Central
Posts: 672
Likes: 546
|
Post by hantsowl on Mar 2, 2018 11:04:59 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. Edit: crossed with stub8535 - sounds like BB00588 was missing from the download because screen scraping one page at a time is such an error prone process. Shame there isn't/wasn't a better way of doing it. They are both there. Don't forget, there are 2 spreadsheets. One for 'Available' loans and the other for 'Fully Funded' loans. 588 is in FFL. 589 is in AL.
|
|
DeafEater
Member of DD Central
Extremely Moderate
Posts: 218
Likes: 292
|
Post by DeafEater on Mar 2, 2018 11:08:54 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. Edit: crossed with stub8535 - sounds like BB00588 was missing from the download because screen scraping one page at a time is such an error prone process. Shame there isn't/wasn't a better way of doing it. They are both there. Don't forget, there are 2 spreadsheets. One for 'Available' loans and the other for 'Fully Funded' loans. 588 is in FFL. 589 is in AL. Ah sorry - never occurred to me to look at the other sheet because I assumed they would both be classed as fully funded or would no longer be active.
|
|
|
Post by dan1 on Mar 2, 2018 11:12:06 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. Edit: crossed with stub8535 - sounds like BB00588 was missing from the download because screen scraping one page at a time is such an error prone process. Shame there isn't/wasn't a better way of doing it.
I did raise this with Collateral Rep in this request. All platforms should allow you to download your transactions, current investments, current loan book, and past loan book to csv and pdf as far as I am concerned.
|
|
|
Post by dan1 on Mar 2, 2018 11:14:01 GMT
Thanks both dan1 and hantsowl . If BB00588 didn't repay as expected then it's curious as to why it's missing from the data download taken on 25/02 when BB00589 IS in there and showing as overdue. I think I'll go and have lie down because this lot is going to be a bit unfathomable until/unless we see the website reappear. Edit: crossed with stub8535 - sounds like BB00588 was missing from the download because screen scraping one page at a time is such an error prone process. Shame there isn't/wasn't a better way of doing it. They are both there. Don't forget, there are 2 spreadsheets. One for 'Available' loans and the other for 'Fully Funded' loans. 588 is in FFL. 589 is in AL. Thanks hantsowl. I obviously didn't look at my own data!
|
|
star dust
Member of DD Central
Posts: 2,998
Likes: 3,531
|
Post by star dust on Mar 2, 2018 11:53:37 GMT
Mod Hat On/ Think I'm going thread creation mad here, but I'm sure the contents of the final loan book may surface as a query at a later date, and I feared these posts might get lost in the more general and very lengthy thread. This is the link to some spreadsheets containing loan book information from the 25th February 2018 kindly supplied by dan1 and viewable in DDC
|
|
|
Post by dan1 on Mar 2, 2018 12:41:11 GMT
I've now redacted the csv files I placed on DD Central yesterday. The quote below is taken from my post on DD Central... Attached is a capture of the Active Loans and Fully Funded Loans page tables in csv format minus the invested column (for obvious reasons). They were captured in quick succession in case a loan moved between the pages. They were captured.... after 25 February 2018 at 17:50 before 25 February 2018 at 21:27 This is according to the timestamps on my email corresponding between transactions. I hope the attached are useful in determining the loan book and status of drawndown of loans. If anyone has any later records please post them here, thanks. Link to the unredacted csv files on DD Central
|
|
ash83
Posts: 33
Likes: 13
|
Post by ash83 on Mar 2, 2018 12:54:19 GMT
I've now redacted the csv files I placed on DD Central yesterday. The quote below is taken from my post on DD Central... Attached is a capture of the Active Loans and Fully Funded Loans page tables in csv format minus the invested column (for obvious reasons). They were captured in quick succession in case a loan moved between the pages. They were captured.... after 25 February 2018 at 17:50 before 25 February 2018 at 21:27 This is according to the timestamps on my email corresponding between transactions. I hope the attached are useful in determining the loan book and status of drawndown of loans. If anyone has any later records please post them here, thanks. Link to the unredacted csv files on DD Central thanks for the list of loans. This is very helpful.
|
|
iren
Member of DD Central
Posts: 302
Likes: 300
|
Post by iren on Mar 2, 2018 18:02:19 GMT
I’ve come across a number of issues when going through my various records to review how I keep track of P2P investments.
Many records I’ve screenscraped or downloaded have nothing on them to indicate that they are mine (no name, address or even account reference), or information can only be pulled together from multiple documents, all of which would need to be, completely impracticably, saved every day if I was to maintain an accurate up to date record of my holdings that’s independent of the provider website.
I would like to see all P2P lenders do what Growth Street do, and provide a monthly pdf statement, including my personal details and account references as evidence of ownership, listing all transactions, and giving present holdings. My view is that the FCA should make this a requirement as they do with equivalent documentation produced by other types of financial institution.
|
|
|
Post by charliebrown on Mar 2, 2018 22:03:44 GMT
I had a 5 figure sun in COL. For tax return do I report the full amount as a total loss?
|
|