https://www.lemonfool.co.uk/viewtopic.php?f=87&t=33178
Anyway, enjoy! What is most instructive about this version of the spreadsheet is to see what has changed, eg the complete reversal with Tritax Big Box.
MDW1954
![Image](https://i.imgur.com/IvLmD6c.png)
Thanks to Anonymous,bruncher,niord,gvonge,Shelford, for Donating to support the site
funduffer wrote:I have British Land, which doesn't seem to be on the spreadsheet for some reason. Maybe I am confusing REITs and property companies?
FD
MDW1954 wrote:funduffer wrote:I have British Land, which doesn't seem to be on the spreadsheet for some reason. Maybe I am confusing REITs and property companies?
FD
It simply means that British Land isn't a member of the AIC. If they don't quote the data, I can't use it!
MDW1954
dealtn wrote:MDW1954 wrote:funduffer wrote:I have British Land, which doesn't seem to be on the spreadsheet for some reason. Maybe I am confusing REITs and property companies?
FD
It simply means that British Land isn't a member of the AIC. If they don't quote the data, I can't use it!
MDW1954
You chose not to use it - it is available elsewhere.
Dod101 wrote:Well MDW, fact is that you did not say where your data came from. What it shows of course is that those REITs in favour are at a premium and those not are at a discount, but the other fact is that this list is far from a comprehensive view of the REIT universe so it does throw into question just how useful the spreadsheet is. Most of the big property companies, although REITs, are missing, for instance. Just because they are not members of the AIC, should not disqualify them.
Dod
monabri wrote:Dod101 wrote:Well MDW, fact is that you did not say where your data came from. What it shows of course is that those REITs in favour are at a premium and those not are at a discount, but the other fact is that this list is far from a comprehensive view of the REIT universe so it does throw into question just how useful the spreadsheet is. Most of the big property companies, although REITs, are missing, for instance. Just because they are not members of the AIC, should not disqualify them.
Dod
Didn't MDW's post outline his source ( Google Finance & AIC) ?
MDW said..
"Same caveats as with the previous posting, here:
viewtopic.php?f=87&t=33178"
Dod101 wrote:Thanks. You are much more attentive about these matters than I am, apparently. That caveat does though remove quite a lot of the usefulness of the spreadshheet as it misses swathes of REITs (or at least quite a number of the important ones) The result for me at least is to doubt the usefulness of using it as a guide to REITs in general.
Dod
MDW1954 wrote:Dod101 wrote:Thanks. You are much more attentive about these matters than I am, apparently. That caveat does though remove quite a lot of the usefulness of the spreadshheet as it misses swathes of REITs (or at least quite a number of the important ones) The result for me at least is to doubt the usefulness of using it as a guide to REITs in general.
Dod
I really don't know what I can do here. I find a way to data-scrape useful-looking data of interest to HYPers, and post it.
Instantly up pop a host of people carping that that I've not posted the right data, or that I've got some kind of agenda, through exhibiting biased selection.
In vain, I trawl the forum for their own data-scraping exercises, but draw a strange blank...
Forget it. That will be be the last of my REIT spreadsheets posted here.
MDW1954
Wasron wrote:Thanks for posting this MDW.
Tritax Big Box and Eurobox are looking interesting to me, the latter even more so as I understand that online retail is far less developed in the rest of Europe (than the UK).
Wasron
MDW1954 wrote:Dod101 wrote:Thanks. You are much more attentive about these matters than I am, apparently. That caveat does though remove quite a lot of the usefulness of the spreadshheet as it misses swathes of REITs (or at least quite a number of the important ones) The result for me at least is to doubt the usefulness of using it as a guide to REITs in general.
Dod
I really don't know what I can do here. I find a way to data-scrape useful-looking data of interest to HYPers, and post it.
Instantly up pop a host of people carping that that I've not posted the right data, or that I've got some kind of agenda, through exhibiting biased selection.
In vain, I trawl the forum for their own data-scraping exercises, but draw a strange blank...
Forget it. That will be be the last of my REIT spreadsheets posted here.
MDW1954
Property investors use a variety of different legal entities to own property depending on who their investors are and what their investment aims are, including:
Limited companies – like those used by businesses across the economy. These can be public (i.e. listed on a stock exchange) or private.
REITs – these are listed property companies subject to special tax rules that mean they pay no corporation tax. In exchange, they have to comply with a number of conditions like distributing most of their income to investors every year and withholding tax on those distributions.
Open-ended property funds – these funds can issue new shares or units at any time. This means that the process of raising new capital for investment is much easier than it is for listed companies and REITs. However, like REITs, they are subject to special rules of their own.
Closed-ended property funds – these funds typically require investors to commit to a minimum holding period and offer only limited opportunities to sell their shares or units. This gives the fund long term certainty about the capital available to it and this model is often used by private equity real estate (PERE).
Limited companies are typically managed “internally”, i.e. by employees of the company or group of companies that owns the property investments. Many REITs are also internally managed.
Open-ended and closed-ended funds (and also some REITs) are typically “externally” managed, i.e. by a specialist property fund manager with whom they have a contract for fund management services.
MDW1954 wrote:Dod101 wrote:Thanks. You are much more attentive about these matters than I am, apparently. That caveat does though remove quite a lot of the usefulness of the spreadshheet as it misses swathes of REITs (or at least quite a number of the important ones) The result for me at least is to doubt the usefulness of using it as a guide to REITs in general.
Dod
I really don't know what I can do here. I find a way to data-scrape useful-looking data of interest to HYPers, and post it.
Instantly up pop a host of people carping that that I've not posted the right data, or that I've got some kind of agenda, through exhibiting biased selection.
In vain, I trawl the forum for their own data-scraping exercises, but draw a strange blank...
Forget it. That will be be the last of my REIT spreadsheets posted here.
MDW1954
CryptoPlankton wrote:MDW1954 wrote:Dod101 wrote:Thanks. You are much more attentive about these matters than I am, apparently. That caveat does though remove quite a lot of the usefulness of the spreadshheet as it misses swathes of REITs (or at least quite a number of the important ones) The result for me at least is to doubt the usefulness of using it as a guide to REITs in general.
Dod
I really don't know what I can do here. I find a way to data-scrape useful-looking data of interest to HYPers, and post it.
Instantly up pop a host of people carping that that I've not posted the right data, or that I've got some kind of agenda, through exhibiting biased selection.
In vain, I trawl the forum for their own data-scraping exercises, but draw a strange blank...
Forget it. That will be be the last of my REIT spreadsheets posted here.
MDW1954
That's a shame, but completely understandable. FWIW, I for one find such contributions far more interesting and informative than the abundance of bumptious opinions and criticisms that some posters scatter across these boards. Sadly, I am sure you aren't alone in feeling deterred in this way, and I feel the appeal of the site is slowly becoming diminished as a result.
P.S. To me, constructive responses like that just made by funduffer are a great example of how to build a more cooperative and enjoyable community. Maybe there's hope yet...
Dod101 wrote:However if we are to look at REITs, we need to look at all of them, not just those which happen to be members of the AIC. As it happens the two REITs that I hold are not on MDW's list of scrapings anyway, Segro and Primary Health Properties. That is why commented as i did.
Dod
MDW1954 wrote:Dod101 wrote:However if we are to look at REITs, we need to look at all of them, not just those which happen to be members of the AIC. As it happens the two REITs that I hold are not on MDW's list of scrapings anyway, Segro and Primary Health Properties. That is why commented as i did.
Dod
So, Dod:
Where would you go for (say) discount and yield information?
Let's take the two you mention, Segro and PHP, temporarily overlooking Segro's minusule yield. Where DO you go?
MDW1954
Return to “REITs & Property Companies”
Users browsing this forum: No registered users and 2 guests