|
|
Post by mrclondon on Sept 21, 2016 11:22:31 GMT
Possibly I am the only person on the planet that wishes all websites had the option for a simple text only rendering with simple database style tables. The Abundance bulletin board webpages I find especially frustrating. However, relief is at hand. The bulletin board webpages are rendering the json data objects returned by API calls, which means its possible to make the same API calls from something other than a web browser, and render the data in that .... which is exactly what I have done in Excel. AI Bulletin Board.xlsm (238.1 KB) Ver 2.1 18-07-2017 (updated API url) All Windows and Mac Excel Versions 2007 Onwards AI Bulletin Board.xlsm (110.91 KB) Ver 1.2 18-07-2017 (updated API url) All Windows Excel Versions 2000 Onwards The workbook contains macros so you may need to 'enable content' depending on the security settings of your installation of Excel. When the workbook is opened, the macro will run automatically to refresh the bulletin board list, and deduce the current highest ratio of Price bid : Face Value from the bids made (but not withdrawn). A link against each entry takes you to the full bid table. Some of the ratios are bewildering - I saw a 116% of face value being bid last week, and there is a 118% being bid currently which is a premium of around 3 to 4 years income at this stage in the yield curve for the debentures.  If I can reproduce any reported bugs, I'll attempt to fix them; and will update the attachment on this post with the latest version. For Excel 2000/XP/2003 you may need to install the "Microsoft Office Compatibility Pack" to allow the opening of .xlsx / .xlsm file formats. See www.microsoft.com/en-gb/download/details.aspx?id=3
|
|
Steerpike
Member of DD Central
Posts: 1,977 
Likes: 1,687
|
Post by Steerpike on Sept 21, 2016 11:40:02 GMT
Very nice.
It may be my version of EXCEL (I'm slightly proud that I managed to get 2002 working on Windows 10) but it is barfing Variable not defined (xlSortOnValues)
|
|
|
|
Post by mrclondon on Sept 21, 2016 12:06:25 GMT
Very nice. It may be my version of EXCEL (I'm slightly proud that I managed to get 2002 working on Windows 10) but it is barfing Variable not defined (xlSortOnValues) Yes thats a Excel 2007 and later construct. I'm using a 3rd party open source library for the json handling which I thought was not Excel 2000/XP/2003 compatible so I hadn't bothered to make my own code backwardly compatible. Can you try the new version that is on my original post - I've now edited the sort code to (hopefully) make it backwardly compatible. And let us know if its all working correctly on Excel 2000.
|
|
Steerpike
Member of DD Central
Posts: 1,977
Likes: 1,687
|
Post by Steerpike on Sept 21, 2016 12:16:01 GMT
Success!
I had got the previous version working by simply commenting out the sort, but this new sparkly version is much more super.
|
|
jonah
Member of DD Central
Posts: 2,031
Likes: 1,113
|
Post by jonah on Sept 23, 2016 5:06:24 GMT
I'll be looking at this in the next week or so. I've half written the code to add abundance to my availability tracker but I suspect your approach could be much more elegant!
|
|
|
|
Post by mrclondon on Jul 18, 2017 19:40:29 GMT
OP edited to add new versions to reflect the change to the API url a few hours ago. I have now included a Mac OS/X compatible version, but have maintained the previous Windows only version for compatibility with Excel 2000 to 2003.
|
|
|
|
Post by justdabbling on Oct 29, 2017 8:39:07 GMT
I don't visit the Abundance board very often even though it is by some margin my biggest board for P2P, so I have only just discovered your spreadsheet which is so useful in tracking the premiums being paid. It has been very tedious clicking through to each bid. Your spreadsheet enables liquidity and selling premiums to be easily monitored, and also if I wanted to sell the most advantageous chunking.
Today's biggest premium is 29.4% on U**** P********* W****** but only on a tiny £9.27!
In case you are interested in technical feedback I downloaded with no trouble at all on my MC which uses the standard Office for Mac software - that is about as technical as I can do - but it works a treat. Thank you.
|
|
shimself
Member of DD Central
Posts: 2,563
Likes: 1,171
|
Post by shimself on Nov 3, 2017 15:47:15 GMT
Pardon the impoliteness, but aren't all AI SM offerings madly overpriced?
|
|
Steerpike
Member of DD Central
Posts: 1,977
Likes: 1,687
|
Post by Steerpike on Nov 3, 2017 16:15:39 GMT
Pardon the impoliteness, but aren't all AI SM offerings madly overpriced? That depends on whether you are selling or buying
|
|
shimself
Member of DD Central
Posts: 2,563
Likes: 1,171
|
Post by shimself on Nov 3, 2017 16:29:56 GMT
Pardon the impoliteness, but aren't all AI SM offerings madly overpriced? That depends on whether you are selling or buying Thinking more about it, aren't they liable to early redemption which could easily leave a buyer substantially out of pocket. I just looked and the average price is about 110% of capital, requiring about 18months of interest to break even. I think AI should make an explicit warning. I'm going to have a look at my portfolio, I might sell those that I think are prone to early redemption.
|
|
Steerpike
Member of DD Central
Posts: 1,977
Likes: 1,687
|
Post by Steerpike on Nov 3, 2017 16:39:07 GMT
That depends on whether you are selling or buying Thinking more about it, aren't they liable to early redemption which could easily leave a buyer substantially out of pocket. I just looked and the average price is about 110% of capital, requiring about 18months of interest to break even. I think AI should make an explicit warning. I'm going to have a look at my portfolio, I might sell those that I think are prone to early redemption. I had one redeem early, I was satisfied with the payout, I think that most debentures have relevant protective clauses.
|
|
|
|
Post by GentlemansFamilyFinances on Aug 14, 2021 8:49:27 GMT
The marketplace is over as we know it.
Seems that there is going to be a new set-up whereby you can more easily buy or sell.
The old marketplace was not fit for purpose and very frustrating to use especially if you didn't want to spend 16:55 - 17:00 every day to ensure that you are not outbid by a penny.
I don't know what this will do to prices but on some of the projects with accrued interest, have really high IRRs at average trading prices (not without risk I might add) while others have low single digit IRRs (perhaps also not without risk).
Perhaps more steady / less variable prices.
As someone who's tried buying and was frustrated and selling and was frustrated, if I can get an acceptable price, trade quickly and do this without much stress it'll be a big improvement.
|
|
|
|
Post by GentlemansFamilyFinances on Sept 28, 2021 14:25:33 GMT
After a few weeks of the new marketplace, it's clear that Abundance have done a great job.
It's much easier to buy and sell and to check what price you are offering or bidding on.
On the downside. There are a large number of sellers who i would call kite flyers who won't sell anytime soon. One person is offering a 0% return on one project.
So to sell, you need to know what the right price is and even then, it could take days to find a buyer.
|
|
