The Sector by Year is a pre-built layout. When I open it I can see data columns for 2007, 2008,..., 2017 and YTD%Chg.

But 2018 is missing. Please help.

Thank you,

Corto 

The way that layout is constructed it is not going to automatically add a new year as it happens.

What you would need to do is create a formula for 2018, set it to a yearly time frame, and add it as a WatchList column.

100 * (C'12/31/18' / C'12/29/17' - 1)

If you wanted this to automatically update each year instead, you could create columns for for 1 year ago (all of these need to be set to a yearly time frame as well).

100 * (C1 / C2 - 1)

Two years ago:

100 * (C2 / C3 - 1)

Three years ago:

100 * (C3 / C4 - 1)

Etc... just change the periods to match the number of years ago and create as many WatchList columns as desired.

I understand how to build it myself and succeeded to do it, but the other ones I have for 2007 ... 2017 were always there so I thought some default settings exist.

Thanks.

No, once you have downloaded the layout it isn't going to change unless you change it.