carlos
I'm short Bondora and long p2p.
Posts: 104 
Likes: 21
|
Post by carlos on Aug 15, 2015 12:29:19 GMT
Hello, we have just started new price discovery service. It will help you analyse secondary market on Bondora. http:// Web-Site up for sale, link disabledI hope you'll like it. It may be little bit hard to read if you're not used to statistics or financial charts. But with some patience, I'm sure you'll get used to it  . Let me introduce few features to give you examples... In few seconds, you can find that overall trade volumes shrinked during holidays and for whole 2015 it's been stagnating. You can realize that in past week bonds were sold at 2.4% discount (in volume weighted average). Of course there is more than that, you can follow price trends, relations between markup and potential XIRR, breakdown each grade of bonds and display full history since trading began. tl;dr BondPicking.com offers regularly updated graphical overview of Bondora secondary market. It will help you price your investments accordingly.I'm looking forward to your comments and ideas in this forum thread! We are dedicated to improve it and have other features under development. Stay tuned! If you want to get in touch privately use: info-bondpicking.com |
|
|
|
Post by coolrunning on Aug 16, 2015 21:37:13 GMT
My thanks to Carlos and his friends The site looks interesting, if still somewhat confusing. Worth a visit.  |
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Aug 17, 2015 22:23:06 GMT
Hello, I've updated the site. You can now search for Loan SM history using loanNumber or loan_id (36 character string) . Search box is on the homepage http://Web-Site up for sale, link disabledYou can also use bookmarklet to display loan history directly from Bondora secondary market page! How to use this bookmarklet?Create New bookmark, name it for example "BondPicking" and add following code in the place of location. You can place it in some bookmarks folder or as a button directly in browser's toolbar. javascript:(function(){ var xx = document.querySelectorAll("tr"); var yy = document.querySelectorAll("h3"); var detail_index = 0; var url = 'http://bondpicking.com/search.php?url='; for (var i = 0; i < xx.length; i++) { if (xx[i].className == 'details-row') {detail_index++;if (xx[i].style.display == "table-row") { text_h3 = yy[detail_index-1].textContent; window.open(url + text_h3);} } } })();Then visit secondary market www.bondora.com/en/invest/secondary-marketExpand loan details clicking on loan number (Loan details will load). Repeat and expand any other loans. Now click the bookmarklet. New tab/window will open for each of "expanded" loan with graph statistics of previous trades. Enjoy! P.S. There is no need to afraid as the code is very simple and straightforward so you can see there is nothing more going on than I've described in this post. Bookmarklet is absolutely harmless. |
|
|
|
Post by coolrunning on Aug 19, 2015 11:37:10 GMT
Hello, I've updated the site. You can now search for Loan SM history using loanNumber or loan_id (36 character string) . Search box is on the homepage http://Web-Site up for sale, link disabledYou can also use bookmarklet to display loan history directly from Bondora secondary market page! How to use this bookmarklet?Create New bookmark, name it for example "BondPicking" and add following code in the place of location. You can place it in some bookmarks folder or as a button directly in browser's toolbar. javascript:(function(){ var xx = document.querySelectorAll("tr"); var yy = document.querySelectorAll("h3"); var detail_index = 0; var url = 'http://bondpicking.com/search.php?url='; for (var i = 0; i < xx.length; i++) { if (xx[i].className == 'details-row') {detail_index++;if (xx[i].style.display == "table-row") { text_h3 = yy[detail_index-1].textContent; window.open(url + text_h3);} } } })();Then visit secondary market www.bondora.com/en/invest/secondary-marketExpand loan details clicking on loan number (Loan details will load). Repeat and expand any other loans. Now click the bookmarklet. New tab/window will open for each of "expanded" loan with graph statistics of previous trades. Enjoy! P.S. There is no need to afraid as the code is very simple and straightforward so you can see there is nothing more going on than I've described in this post. Bookmarklet is absolutely harmless. Yes it is quite safe. It works OK. But I am still trying to work out how to make use of it !
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Aug 20, 2015 21:09:18 GMT
Basic advise could be summarized as: when buying try to buy below current market Markup. When selling sell above market Markup. When finding market rate please mind the rating which can be described by this example: A+ Borrower has never been late with payment. See graph of bond class markupA- Borrower has been overdue for 1 - 29 days. A-- Borrower has been late with payment 30+ days. |
|
|
|
Post by coolrunning on Aug 22, 2015 13:02:07 GMT
Bondora's Data Export for the SM is up to date.
Can we get a new "Bondora Secondary Market Analysis" please?
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Aug 23, 2015 0:31:00 GMT
Bondora's Data Export for the SM is up to date. Can we get a new "Bondora Secondary Market Analysis" please? Hello, I'd really love to.. But if you download ResaleArchive.xlsx you will see that Report EOD is still 27.7.2015. File timestamp is 28.7.2015. Lets everybody email Bondora so they know we care about promised daily updates!
|
|
|
|
Post by coolrunning on Aug 23, 2015 7:34:17 GMT
Bondora's Data Export for the SM is up to date. Can we get a new "Bondora Secondary Market Analysis" please? Hello, I'd really love to.. But if you download ResaleArchive.xlsx you will see that Report EOD is still 27.7.2015. File timestamp is 28.7.2015. Lets everybody email Bondora so they know we care about promised daily updates! Whoops - looks like I may have it wrong. I have successfully downloaded a file ResaleArchive_20150822142803 which is clearly up to date. But it is quite small and may only be a selection from the full ResaleArchive with only my SM operations. Now why should Bondora update the master file for ResaleArchive (must be done or you cannot have a selection) and not make it available?
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Sept 18, 2015 11:18:23 GMT
Finally ! BondPicking.com is updating automatically each day. Looks like there is last published SM trade with about 48 hours delay (from Bondora dataset), what is I think great...
Check the latest dataset from 16.9.2015:
http://Web-Site up for sale, link disabled
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Apr 6, 2016 13:18:22 GMT
Site updated to finally take into account both ResaleArchive.xlsx datasets (2013 - 2015 and current one).
You can now see full loan transaction history: e.g. http://Web-Site up for sale, link disabled/loan.php?loan=38367
You can track each loan by inserting its id or loanNumber into field on homepage. There is also defaulted loans only section: http://Web-Site up for sale, link disabled/market-defaulted.php
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on Apr 11, 2016 11:50:03 GMT
Sorry but XLS import to site is broken again....  this time Bondora switched to zipped CSV files... I'm thinking about switching to API access instead of Data Export page, but it is unresponsive part of time (empty response to request). This makes any development time consuming. |
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on May 14, 2016 15:42:58 GMT
I've worked with API for the first time and came with this tool as demonstration. I noticed there are some better opportunities on the secondary market than we usually find on primary market (measured by XIRR). But I hated how you cannot sort loan parts by Return on Investment (XIRR) through Bondora site. So I tried to get this info through the API. Sometimes you can find gems there...
http://Web-Site up for sale, link disabled/secondary_market_tips.php
|
|
|
|
Post by wiseclerk on May 14, 2016 15:51:03 GMT
Carlos, the table misses the username in many cases.
Also as an example
"C 4.33 EUR 25.22% 2/59 months completed (3%) current, never paid late"
Surely this is a rescheduled loan? Are you sure it was never late before it was rescheduled? Otherwise the never paid late is misleading.
I am wary of buying rescheduled loans.
|
|
carlos
I'm short Bondora and long p2p.
Posts: 104
Likes: 21
|
Post by carlos on May 14, 2016 16:08:33 GMT
Obviously you are right, thank you for pointing this out! I've now updated filter to exclude Rescheduled loans completely. I don't know if there is any way to check payment morale of rescheduled loans. I think documentation in API is missing these details (as how are data fields treated on reschedule).
Usernames will be updated of course...
|
|
|
|
Post by rahafoorum on May 15, 2016 10:17:07 GMT
Obviously you are right, thank you for pointing this out! I've now updated filter to exclude Rescheduled loans completely. I don't know if there is any way to check payment morale of rescheduled loans. I think documentation in API is missing these details (as how are data fields treated on reschedule). Usernames will be updated of course... Haven't checked for any updates, but initially when API was launched, there was no details about the payment issues as far as I understood. That's why I found it not too useful way to invest on SM, 'cause that'd be very relevant information to have.
|
|
.
this time Bondora switched to zipped CSV files...
