CE Data Blog
This new monthly newsletter highlights the latest updates and additions to our data product.
Last updated 12th December 2024
December 2024
New Dashboards
China Activity Proxy
We’ve enhanced our China Activity Proxy (CAP) to provide an even more accurate view of what’s happening in the world’s second biggest economy. This widely followed indicator – which deliberately bypasses government GDP data to provide an untainted estimate of activity - can be explored on our new CAP dashboard by all CE Essential and CE Advance clients.
Global Property Returns and Valuations
How do commercial property returns stack up against other asset classes over the next 3, 5 and 10-year windows? CE Advance clients can now compare and download these forecasts on our new Global Property Returns and Valuations dashboard. Our proprietary valuation scores also provide further insight into whether different property classes are under, over, or fairly valued.
Euro-zone Debt Sustainability
An interactive guide to the fiscal sustainability challenges faced by euro-zone economies. CE Advance clients can explore the bloc's debt dynamics and our latest fiscal projections.
Updated Dashboards
-
Global Fracturing - updated to include the most up-to-date data and new analysis based on United Nations General Assembly voting data.
-
GDP Nowcasts - Australia has been added to our suite of Nowcasts for advanced economies.
-
CE Formula Generator -redesigned to make it even simpler to generate a formula to use with the CE Connect Excel plug-in. Functionality added to create a formula for commodities series and make use of two new CAPEC.DATA() parameters.
New Data
We have added more sub-national data to the database. These series are available to clients with access to the CE Connect Excel plug-in or the CE API.
| Indicator | Coverage | Source |
|---|---|---|
| Regional Private Rents |
UK Regions and local authorities |
Office for National Statistics (United Kingdom) |
|
Regional Real GDP Growth (% y/y) |
All US States and the 30 Metro areas covered by our Commercial Property Team |
U.S. Bureau of Economic Analysis |
| Nominal Income |
All US States and the 30 Metro areas covered by our Commercial Property Team |
U.S. Bureau of Economic Analysis |
Updates to the CE Connect Excel Plug-in
New Sidebar
The sidebar has been redesigned to be easier to use and include more information. The new “Quick Actions” section makes it easier to retrieve and refresh data. We have also added an “example formulae” section that allows you to paste some pre-written formulae into you spreadsheets.
New Functionality
We have introduced “decorator” functions to allow you to query more of the data and metadata you want.
CAPEC.METADATA():
Decorators:
In place of a series ID, you can now use:
-
“@ADVANCE” - return all series available as part of a CE Advance subscription.
-
“@ADVANCE-ONLY” - return series that are exclusively available as part of a CE Advance subscription.
-
“@ESSENTIAL” - return all series that are available as part of a CE Essential subscription.
-
“@API” - return all series accessible via the CE API.
-
“@INDICATOR-CODE” - return all series with the indicator code specified, e.g. “@RGDPYY” will return all Real GDP (% y/y) series in the CE dataset.
CAPEC.DATA():
Decorators:
In place of a series ID, you can now use:
-
“@INDICATOR-CODE” - return all series with the indicator code specified, e.g. “@RGDPYY” will return all Real GDP (% y/y) series in the CE dataset.
Other new arguments:
-
Show Type (TRUE/FALSE) - Displays a type column for every series selected for discerning actuals and forecasts.
-
Show Tooltip (TRUE/FALSE) - Displays a column containing extra information about a series, e.g GDP Nowcast period.