Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Aug 17, 2016 22:43:54 GMT
I've made an interactive report using the July Open House data and some other data from elsewhere on the Property Partner site. I've calculated a £ weighted daily average share price going back through all the historical data to 2014. You can use this to see explore trends along with filters for gearing, current dividend yield, current discount/premium and location. You can see trading volume in £ too. Property Partner Analysis
|
|
beh
Member of DD Central
Posts: 174
Likes: 76
|
Post by beh on Aug 18, 2016 16:22:10 GMT
Again, interesting to see. I don't see any upward trend but perhaps it's early yet What's causing the blip on 21st April? I like that PP have added a couple graphs but it still feels quite limited compared to what you've generated. PP also seem inconsistent, for example why for propertypartner.co/properties/UKE18JX001 does it only go back as far as June this year when it's been active for over a year and while some more recent properties go back further.
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Aug 18, 2016 17:26:22 GMT
Again, interesting to see. I don't see any upward trend but perhaps it's early yet What's causing the blip on 21st April? I like that PP have added a couple graphs but it still feels quite limited compared to what you've generated. PP also seem inconsistent, for example why for propertypartner.co/properties/UKE18JX001 does it only go back as far as June this year when it's been active for over a year and while some more recent properties go back further. This property you link to has data back to July 2015, but when PP plot it in their chart they just take the last 100 trades. I had a look at that April 21st blip too. My guess is perhaps a new investor wanting to buy into some properties on the secondary market that didn't quite understand how it worked? Or someone's elementary trading robot that went on a buying spree?
|
|
|
Post by reeknralf on Aug 18, 2016 18:26:32 GMT
Nice analysis.
I've seen people referring to the 'open house data' on here previously. What is it and how do I get hold of it?
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Aug 18, 2016 19:23:54 GMT
|
|
beh
Member of DD Central
Posts: 174
Likes: 76
|
Post by beh on Aug 18, 2016 21:12:41 GMT
This property you link to has data back to July 2015, but when PP plot it in their chart they just take the last 100 trades. Ah, that might explain. Would be better if they allowed it to be filtered by date. I think it's an odd situation that they've taken so long to create some relatively mediocre charts given the ambition of the platform. Just looking at the blip, 4 trades at ~100% premium. Very odd as only £3k in total which would seem unlikely to hit that sort of premium on the SM. Can you go into a bit more detail as to how you're using the open house data to create those graphs. Is it relatively straight forward stuff beyond sticking it into a DB?
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Aug 18, 2016 22:05:16 GMT
This property you link to has data back to July 2015, but when PP plot it in their chart they just take the last 100 trades. Ah, that might explain. Would be better if they allowed it to be filtered by date. I think it's an odd situation that they've taken so long to create some relatively mediocre charts given the ambition of the platform. Just looking at the blip, 4 trades at ~100% premium. Very odd as only £3k in total which would seem unlikely to hit that sort of premium on the SM. Can you go into a bit more detail as to how you're using the open house data to create those graphs. Is it relatively straight forward stuff beyond sticking it into a DB? In the end the main reason for the DB was to calculate the daily weighted average price more easily. I had also intended to use the DB to generate a list of all possible days that each property was on the market, for cases when there were no transactions on a particular day. I scrapped that though as it made more questions than it answered ie. what value to put in its place. Also I did basic calculations for £volume rather than just the count of shares traded as in the open house, and the max and min share price each day. Everything else is just straight from PP (the main property page propertypartner.co/s/uk and the July open house) with a join in Tableau (the software used to make the report).
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Aug 18, 2016 22:22:30 GMT
Looking back at the original open house data for April 21st it was a handful of large trades at very high prices that skews the data (between transaction 10786 and 10792)
|
|
beh
Member of DD Central
Posts: 174
Likes: 76
|
Post by beh on Oct 19, 2016 16:39:42 GMT
I know tableau is quite widely used but do you think they've been looking at your site? - resources.propertypartner.co/brick-mining-a-guide-to-finding-resale-deals/Quite liking a lot of the recent improvements on the PP site, I just wish they'd publish a changelog as I often don't spot them at a glance. I only found the "data view" bit last week and wondering if the "download dashboard" function been there for long.
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Oct 19, 2016 17:39:11 GMT
Nice spot beh - would like to think I had something to do with them starting to use it
|
|