loadsahope
Member of DD Central
Posts: 84 
Likes: 44
|
Post by loadsahope on Oct 8, 2018 20:01:45 GMT
Thanks Steve. I would still call it a "bonus", as I receive £101 of the loan for a cost of just £100. Yes, OK, pot-ay-toe, pot-ah-toe, but I am getting more than I paid for, rather than paying less for what I ordered.
But semantics aside, it would still be nice to know if and when this was going to be applied, else (and at the risk of shooting myself in the foot) - why are they bothering if we don't know about it? Just hoping we'll go in for the lucky-dip? That doesn't really seem to equate to someone wanting to shift stock quickly.
Because it puts them ahead of all those people selling at par, that's why. If you only want to buy a loan that is discounted then just put a bid in at -1% (do it before it draws or you may miss out). On the upcoming loans page, 833 will have units available at a discount while 835 won't. How can you tell if an upcoming loan will be discounted? I had a look at 833 but couldn't find it anywhere.
|
|
loadsahope
Member of DD Central
Posts: 84
Likes: 44
|
Post by loadsahope on Oct 8, 2018 20:03:37 GMT
Because it puts them ahead of all those people selling at par, that's why. If you only want to buy a loan that is discounted then just put a bid in at -1% (do it before it draws or you may miss out). On the upcoming loans page, 833 will have units available at a discount while 835 won't. How can you tell if an upcoming loan will be discounted? I had a look at 833 but couldn't find it anywhere.
Ok - read more of the thread so I now know the answer. Thanks for the info.
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 14, 2018 7:15:25 GMT
Latest:-
Loan # Discounted
833 252,855
830 38,280
824 8,607
776 336
774 235,919
766 80,310
768 220,846
756 8,654
730 18,438
581 9,206
388 5,994
295 7,573
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 17, 2018 6:55:08 GMT
Note #824 has £46k for sale at a 1.5% discount
Loan # LTV Rate Term Discounted
838 42.1 6.5 9 of 9 260,463
833 68.5 8 12 of 12 243,608
830 57 7.5 18 of 18 27,509
826 50.7 7 11 of 12 13,373
824 69.7 8.5 16 of 17 51,794
816 59 9 14 of 15 13,876
774 69 7 15 of 18 234,417
766 70.8 7 57 of 60 58,693
768 55 6.5 57 of 60 198,493
758 68.6 8 12 of 15 2
756 47.9 6 9 of 12 5,233
730 68.2 7 19 of 24 16,265
601 67 6.5 52 of 60 2,239
581 45 7 7 of 17 8,644
295 57.3 9 9 of 36 9,994
|
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Oct 17, 2018 10:15:30 GMT
Anyone using linux, mac OS or other command line system with grep and sed available might find the following command useful grep 'discount\|loan-id' Desktop/Browse\ Loans\ _\ Assetz\ Capital.html | grep --no-group-separator -B1 'discount ' | sed 's/<small\ class\=\"//g' | sed 's/\">/\ /g' | sed 's/<\/small>//g' | sed 's/<span\ cl.*content\=\"//g' | sed 's/\&pou.*//g'I save the (HTML) source of the Browse Loans page (replace Desktop/Browse\ Loans\ _\ Assetz\ Capital.html with your file and location). Unfortunately it is only possible to do 100 loans at a time, so use the filter if you can, Interest might come in very useful, and then save the page source. The first grep finds either loan-id or discount and preserves the order, the second grep keeps the loan id and discount message of any loan with a discount. The sed commands tidy the HTML code away. loan-id #826
£93,103.90 available for investment between -1.0% discount and par value
loan-id #833
£612,112.28 available for investment between -1.0% discount and par value
loan-id #581
£194,159.28 available for investment between -1.0% discount and par value
loan-id #824
£448,942.62 available for investment between -1.5% discount and par value
...etcUnfortunately it doesn't show the amount available at a discount, we need bg to keep up his good work for that. |
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 23, 2018 6:53:24 GMT
Amount for sale at a discount has reduced but quite a lot now discounted to 1.5%
Loan # Discounted Best Rate
282 553 -1
295 9,687 -1
304 452 -1
328 55 -1
355 644 -1
388 91 -1
389 1,156 -1.5
531 302 -1
540 29 -1
592 1 -1
623 1,145 -1
730 5,086 -1
766 61,222 -1.5
768 196,307 -1
769 1,516 -1
774 233,963 -1
776 470 -1
796 190 -1.5
797 3 -1
816 2,992 -1
820 1,270 -1
824 23,369 -1.5
830 2 -1.5
833 168,001 -1.5
838 115,537 -1.5
839 367 -1.5
|
|
|
|
Post by Ace on Oct 23, 2018 7:21:52 GMT
Thanks bg, any chance of adding an interest rate column? |
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 23, 2018 7:26:46 GMT
Thanks bg , any chance of adding an interest rate column? I have all the loan data in a table which is automatically produced. The problem is posting it ton the forum. When I paste in from excel/text editor it loses all formatting and I have to manually align the columns which is a pain (hence I reduce the columns). If someone can tell me how to paste it so I don't lose the formatting, I can add all the data on a more regular basis. I think there is a forum add in that does it but I couldn't install it. This is how it looks when I paste currently:- Loan # Status Amount LTV Rate Term Available Discounted Best Rate Drew 389 Live 1,518,750 75 11.2 2 of 23 85,907 1,156 -1.5 19-Dec-16 388 Live 1,882,500 75 11.2 2 of 23 124,380 91 -1 19-Dec-16 592 Live 1,279,057 68.1 7 2 of 12 233,897 1 -1 22-Dec-17 820 Live 809,795 56.7 7 5 of 7 483,926 1,270 -1 06-Sep-18 295 Live 1,720,000 57.3 9 9 of 36 92,941 9,687 -1 28-Jun-16 838 Live 1,071,500 42.1 6.5 9 of 9 608,497 115,537 -1.5 16-Oct-18 833 Live 757,307 68.5 8 12 of 12 488,504 168,001 -1.5 09-Oct-18 816 Live 1,999,999 59 9 14 of 15 1,073,253 2,992 -1 31-Aug-18 774 Live 488,200 69 7 15 of 18 320,655 233,963 -1 13-Jul-18 824 Live 1,153,108 69.7 8.5 16 of 17 419,827 23,369 -1.5 13-Sep-18 797 Live 133,154 70 8.5 16 of 18 89,171 3 -1 14-Aug-18 830 Live 650,000 57 7.5 18 of 18 270,818 2 -1.5 01-Oct-18 839 Live 471,572 71.4 8 18 of 18 176,055 367 -1.5 17-Oct-18 730 Live 761,400 68.2 7 19 of 24 594,533 185 -1 14-May-18 282 Live 520,000 50.2 8.8 33 of 60 12,145 598 -1 30-Jun-16 304 Live 1,350,000 73 9 34 of 60 616 452 -1 29-Jul-16 328 Live 315,000 74.1 7 36 of 60 10,074 1,055 -1 22-Sep-16 355 Live 717,000 71.7 8 37 of 60 121,443 251 -1 18-Nov-16 531 Live 857,000 70 8 47 of 60 106,812 302 -1 22-Aug-17 540 Live 370,000 69.8 7 47 of 60 218,821 29 -1 18-Sep-17 623 Live 191,250 74.6 7 53 of 60 9,574 1,145 -1 28-Feb-18 766 Live 255,000 70.8 7 57 of 60 144,298 61,222 -1.5 09-Jul-18 768 Live 715,000 55 6.5 57 of 60 530,780 196,307 -1 09-Jul-18 769 Live 325,000 50 7.3 58 of 60 4,386 1,516 -1 10-Jul-18 776 Live 205,000 49.4 6 57 of 60 81,207 470 -1 17-Jul-18 796 Live 330,000 66.7 7 58 of 60 235,366 190 -1.5 10-Aug-18
|
|
locutus
Member of DD Central
Posts: 1,059
Likes: 1,622
|
Post by locutus on Oct 23, 2018 8:26:45 GMT
|
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Oct 23, 2018 9:41:02 GMT
I have all the loan data in a table which is automatically produced. The problem is posting it ton the forum. When I paste in from excel/text editor it loses all formatting and I have to manually align the columns which is a pain What I usually do is include the formatting in my spreadsheet. Start each row with [tr][td] and then put [/td][td] in between each item and then end each row with [/td][/tr]. I normally stick those three things near the top of my sheet and then combine into one cell per row all the columns of that row with the separators above. This just needs a [table][tbody] on top and [/tbody][/table] at then end.Some more advanced options are in my post in the test area.
|
|
|
|
Post by dan1 on Oct 23, 2018 10:11:24 GMT
If you don't want to mess with bbcode then you can highlight the cells in excel/sheets and paste to an image editor, save it and post the image (via imgur or similar).
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 23, 2018 11:03:18 GMT
Thanks for the help guys...saves a load of hassle. I have used locutus suggestion for now but will automate in a spreadsheet when I get round to it. Loans sorted by drawdown date (as that's how I like to view them) | Loan # | Amount | LTV | Rate | Term | Available | Discounted | Best Rate | Drew | | 837 | 535,800 | 63 | 6.5 | 12 of 12 | 461,698 | 102,283 | -1.5 | 23-Oct-18 | | 839 | 471,572 | 71.4 | 8 | 18 of 18 | 176,055 | 367 | -1.5 | 17-Oct-18 | | 838 | 1,071,500 | 42.1 | 6.5 | 9 of 9 | 608,497 | 115,537 | -1.5 | 16-Oct-18 | | 833 | 757,307 | 68.5 | 8 | 12 of 12 | 488,504 | 168,001 | -1.5 | 9-Oct-18 | | 830 | 650,000 | 57 | 7.5 | 18 of 18 | 270,818 | 2 | -1.5 | 1-Oct-18 | | 824 | 1,153,108 | 69.7 | 8.5 | 16 of 17 | 419,827 | 23,369 | -1.5 | 13-Sep-18 | | 820 | 809,795 | 56.7 | 7 | 5 of 7 | 483,926 | 1,270 | -1 | 6-Sep-18 | | 816 | 1,999,999 | 59 | 9 | 14 of 15 | 1,073,253 | 2,992 | -1 | 31-Aug-18 | | 797 | 133,154 | 70 | 8.5 | 16 of 18 | 89,171 | 3 | -1 | 14-Aug-18 | | 796 | 330,000 | 66.7 | 7 | 58 of 60 | 235,366 | 190 | -1.5 | 10-Aug-18 | | 776 | 205,000 | 49.4 | 6 | 57 of 60 | 81,207 | 470 | -1 | 17-Jul-18 | | 774 | 488,200 | 69 | 7 | 15 of 18 | 320,655 | 233,963 | -1 | 13-Jul-18 | | 769 | 325,000 | 50 | 7.3 | 58 of 60 | 4,386 | 1,516 | -1 | 10-Jul-18 | | 766 | 255,000 | 70.8 | 7 | 57 of 60 | 144,298 | 61,222 | -1.5 | 9-Jul-18 | | 768 | 715,000 | 55 | 6.5 | 57 of 60 | 530,780 | 196,307 | -1 | 9-Jul-18 | | 730 | 761,400 | 68.2 | 7 | 19 of 24 | 594,533 | 5,001 | -1 | 14-May-18 | | 623 | 191,250 | 74.6 | 7 | 53 of 60 | 9,574 | 1,145 | -1 | 28-Feb-18 | | 592 | 1,279,057 | 68.1 | 7 | 2 of 12 | 233,550 | 1 | -1 | 22-Dec-17 | | 540 | 370,000 | 69.8 | 7 | 47 of 60 | 218,821 | 29 | -1 | 18-Sep-17 | | 531 | 857,000 | 70 | 8 | 47 of 60 | 106,812 | 302 | -1 | 22-Aug-17 | | 389 | 1,518,750 | 75 | 11.2 | 2 of 23 | 85,907 | 1,156 | -1.5 | 19-Dec-16 | | 388 | 1,882,500 | 75 | 11.2 | 2 of 23 | 124,380 | 91 | -1 | 19-Dec-16 | | 355 | 717,000 | 71.7 | 8 | 37 of 60 | 121,443 | 251 | -1 | 18-Nov-16 | | 328 | 315,000 | 74.1 | 7 | 36 of 60 | 10,074 | 1,055 | -1 | 22-Sep-16 | | 304 | 1,350,000 | 73 | 9 | 34 of 60 | 616 | 452 | -1 | 29-Jul-16 | | 282 | 520,000 | 50.2 | 8.8 | 33 of 60 | 12,145 | 598 | -1 | 30-Jun-16 | | 295 | 1,720,000 | 57.3 | 9 | 9 of 36 | 92,941 | 9,687 | -1 | 28-Jun-16 |
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 28, 2018 12:45:49 GMT
| Loan # | Amount | LTV | Rate | Term | Available | Discounted | Best Rate | Drew | | 837 | 535,800 | 63 | 6.5 | 12 of 12 | 348,362 | 89,055 | -1 | 23-Oct-18 | | 838 | 1,071,500 | 42.1 | 6.5 | 9 of 9 | 584,283 | 86,577 | -1 | 16-Oct-18 | | 833 | 757,307 | 68.5 | 8 | 12 of 12 | 435,728 | 153,536 | -1.5 | 9-Oct-18 | | 824 | 1,153,108 | 69.7 | 8.5 | 16 of 17 | 361,964 | 2,324 | -1 | 13-Sep-18 | | 775 | 320,000 | 58.2 | 6 | 57 of 60 | 159,331 | 1,854 | -1 | 17-Jul-18 | | 776 | 205,000 | 49.4 | 6 | 57 of 60 | 77,712 | 4,407 | -1 | 17-Jul-18 | | 774 | 794,766 | 69 | 7 | 15 of 18 | 320,384 | 233,657 | -1 | 13-Jul-18 | | 766 | 255,000 | 70.8 | 7 | 57 of 60 | 143,750 | 58,640 | -1 | 9-Jul-18 | | 768 | 715,000 | 55 | 6.5 | 57 of 60 | 527,962 | 194,424 | -1 | 9-Jul-18 | | 756 | 340,000 | 47.9 | 6 | 9 of 12 | 186,873 | 880 | -1 | 28-Jun-18 | | 730 | 961,629 | 68.2 | 7 | 19 of 24 | 594,374 | 3,254 | -1 | 14-May-18 | | 463 | 3,585,843 | 69.1 | 7.5 | 13 of 30 | 974,010 | 202 | -1 | 28-Apr-17 | | 389 | 1,518,750 | 75 | 11.2 | 2 of 23 | 86,818 | 327 | -1 | 19-Dec-16 | | 352 | 150,000 | 49.2 | 9 | 37 of 60 | 6 | 6 | -1 | 26-Oct-16 | | 328 | 315,000 | 74.1 | 7 | 36 of 60 | 9,763 | 955 | -1 | 22-Sep-16 |
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Oct 31, 2018 6:54:24 GMT
With the end of the cashback promotion approaching there has been a surge in buying of discounted loans..... | Loan # | Amount | LTV | Rate | Term | Available | Discounted | Best Rate | Drew | | 833 | 757,307 | 68.5 | 8 | 12 of 12 | 445,408 | 133,146 | -1.5 | 9-Oct-18 | | 774 | 794,766 | 69 | 7 | 15 of 18 | 318,635 | 229,898 | -1 | 13-Jul-18 | | 766 | 255,000 | 70.8 | 7 | 57 of 60 | 139,995 | 55,438 | -1 | 9-Jul-18 | | 768 | 715,000 | 55 | 6.5 | 57 of 60 | 520,114 | 185,127 | -1 | 9-Jul-18 | | 730 | 961,629 | 68.2 | 7 | 19 of 24 | 596,229 | 4,638 | -1 | 14-May-18 |
|
|
bg
Member of DD Central
Posts: 1,368
Likes: 1,929
|
Post by bg on Nov 3, 2018 15:00:46 GMT
| Loan # | Amount | LTV | Rate | Term | Available | Discounted | Best Rate | Drew | | 833 | 757,307 | 68.5 | 8 | 12 of 12 | 432,252 | 111,650 | -1.5 | 9-Oct-18 | | 774 | 794,766 | 69 | 7 | 15 of 18 | 308,847 | 220,833 | -1 | 13-Jul-18 | | 766 | 255,000 | 70.8 | 7 | 57 of 60 | 146,872 | 79,581 | -1 | 9-Jul-18 | | 768 | 715,000 | 55 | 6.5 | 57 of 60 | 520,967 | 187,632 | -1 | 9-Jul-18 | | 730 | 961,629 | 68.2 | 7 | 19 of 24 | 595,805 | 1,936 | -1 | 14-May-18 | | 531 | 857,000 | 70 | 8 | 47 of 60 | 37,219 | 86 | -1.5 | 22-Aug-17 | | 363 | 923,000 | 60.8 | 8 | 38 of 60 | 109,397 | 55 | -2 | 9-Dec-16 | | 357 | 721,000 | 66.9 | 8 | 37 of 60 | 37 | 9 | -2 | 15-Nov-16 |
|
|
