Talk:US equity REIT index returns

Reader feedback: define "CAGR", "compound ret...
24.44.13.120 posted this comment on 13 February 2015 (view all feedback).

"define 'CAGR', 'compound return link-info is not clear"

I believe the comment relates to the "compound returns" tab on the spreadsheet. This tab is used to calculate the CAGR on the "annual returns" tab. I tried renaming the tab to "CAGR Scratch Pad". It looks OK in Google, but I don't see the update in the wiki (checked with 2 browsers). LadyGeek 13:30, 13 February 2015 (CST)


 * Often you need to republish the spreadsheet to update changes. I have republished it --Blbarnitz 15:29, 13 February 2015 (CST)

Update failing
For some reason the spreadsheet is not updating to reflect the input of 2015 returns. Note all recent 2015 edits of other spreadsheets successfully updated--Blbarnitz 18:02, 14 January 2016 (EST)


 * (I inserted my comments above the table.)
 * I made some innocuous changes to force the spreadsheet revision to change (add a space character in an used section, then deleted it), the spreadsheet did not update. Additionally, I purged the page by adding "?action=purge" to the URL and cleared my browser cache, but the spreadsheet still did not update. I will investigate further. --LadyGeek 22:35, 14 January 2016 (EST)

This problem is due to the spreadsheet URL, not the wiki. This spreadsheet is several years old and Google has revised their format several times. I have copied the spreadsheet, published, then shared the link so anyone can view. The revised version is now displayed.

Here is the URL of the new copy (example only):

The key is the part between the slashes:

The widget and template will therefore look like this:

''Indexes: Dow Jones U.S. REIT Index; FTSE NAREIT Real Estate 50 Index; MSCI US REIT Index; S&P U.S. REIT Index; Wilshire U.S. REIT Index. Also included are returns of the NAREIT Equity REIT Index (tab 2)'' CAGR is Compound Annual Growth Rate.

''Indexes: Dow Jones U.S. REIT Index; FTSE NAREIT Real Estate 50 Index; MSCI US REIT Index; S&P U.S. REIT Index; Wilshire U.S. REIT Index. Also included are returns of the NAREIT Equity REIT Index (tab 2)'' CAGR is Compound Annual Growth Rate.

The solution would be to make a new copy of the spreadsheet, publish, share (with appropriate access for editors and everyone else view only), then update the wiki page with the new key as described above.

There's no need to revise all of the existing spreadsheets; only when the spreadsheet fails to update in the wiki.

--LadyGeek 23:09, 14 January 2016 (EST)

Wiki table:

''Indexes: Dow Jones U.S. REIT Index; FTSE NAREIT Real Estate 50 Index; MSCI US REIT Index; S&P U.S. REIT Index; Wilshire U.S. REIT Index. Also included are returns of the NAREIT Equity REIT Index (tab 2)'' CAGR is Compound Annual Growth Rate. --Blbarnitz 21:15, 14 January 2016 (EST)