Write a macro dashboard and three scenarios

Build a one-page macro dashboard and write three scenarios that connect it to your holdings.

Open your workbook to a blank page and write today's date at the top. The first version of this page takes about forty minutes to build, and keeping it current takes about ten minutes a month.

Once you can read each piece of macro data on its own, the risk is ending up with eight browser tabs open, plenty of opinions and no record of what you thought the month before. Professional investors deal with this by keeping a dashboard, a short list of indicators updated on a schedule, alongside a few written scenarios they come back to. You'll put both on this one page, and finish it with a written rule for when the page is allowed to prompt a change to your portfolio.

Choosing six to eight indicators

Pick indicators that cover the ground of this module, one or two per area. Aim for six to eight in total. With more than eight, you're likely to stop updating the dashboard. A slow-changing item such as the MAS policy stance can sit in a notes line under the table instead of taking a row, because it changes only when MAS publishes a statement.

Marcus, an investor used as the example throughout (his figures and choices are invented), chose eight indicators: Singapore GDP growth, US core PCE inflation, MAS core inflation, the federal funds rate, the US ten-year minus two-year spread, the US ten-year TIPS yield, the Fed's broad dollar index, and the ICE BofA US high-yield spread. He keeps the MAS policy stance in a notes line under the table.

Filling in source, value, direction and date

Each indicator row has four fields: source, latest value, direction over the past three to six months, and date checked.

Use official sources where you can. For Singapore data, that means the Ministry of Trade and Industry and the Department of Statistics. MAS is the source for its own policy statements and for SGS yields. For US data, use the US Bureau of Economic Analysis and the Bureau of Labor Statistics. The Federal Reserve publishes the federal funds rate and the dollar index. FRED is useful for series that are hard to find elsewhere.

The direction field records whether the indicator has been rising, falling or flat over the past three to six months. It matters more than the value itself, because regimes are about change, as Lesson 3.1, "Growth and inflation: four regimes and what tends to do well in each", explained. Stick to those three labels only, so you can compare one month with another at a glance.

The date field protects you from trusting stale data. GDP figures arrive quarterly and get revised later, while a spread changes every day. When you update the page, change the date even if the value hasn't moved, so you can see that you checked.

Writing three scenarios with rough likelihoods

Below the table, write three scenarios for the next twelve to eighteen months. A scenario is a named possible future with four parts: a name, what the indicators would show, a rough likelihood, and the holdings it would help or hurt most.

The likelihoods are your own rough weights and should add up to 100%. They aren't forecasts and nobody grades them. Their purpose is to make you hold more than one future in mind at once. Scenarios do the same work as risk premia in Lesson 2.7: each one names the conditions in which part of your portfolio fails.

On the day Marcus built his dashboard, he wrote three scenarios against it, with likelihoods based on his own judgment:

Gentle slowdown, 50%. Growth eases, inflation keeps falling, the Fed and MAS loosen gradually, and spreads stay calm. His SGD bond fund and S-REIT would benefit from lower yields, and his shares would probably be flat to modestly positive. Recession, 30%. Unemployment rises, spreads widen sharply, and the yield curve steepens as rate cuts are priced in. His chip stocks, bank shares and STI ETF would be hurt most, while his bond fund and T-bills would help. A stronger US dollar would soften the fall in his US holdings when measured in SGD, as Lesson 3.5 showed. Inflation returns, 20%. Core inflation turns back up, real yields rise, and central banks hold or tighten. His bond fund and REIT would suffer through duration, and his chip designer would suffer through the discount rate effect from Lesson 3.3, "Real rates and breakeven inflation from inflation-linked bonds". Only his T-bills would hold up well.

His three weights add up to 100%, and Gentle slowdown, the highest, is his base case.

The rule that decides when you act

The last line on the page is the most important one. It states what would make you change your portfolio, so that headlines alone can't. The principle behind it is that the dashboard may trigger a review of your portfolio but may never trigger a trade. Your macro work feeds your scenarios, and your investment policy statement decides what you actually do. That statement is the one you wrote in the course "Build and run an ETF portfolio", module 8, "Write your investment policy and review it every year", and your rule should point back to it.

Marcus wrote his rule like this: the dashboard can trigger a review but never a trade; he reviews his allocation when three or more indicators move against his base case in the same month, or at his yearly review; and any change must follow the rules in his investment policy statement.

His finished page holds eight indicators with four fields each, three named scenarios totalling 100% with the holdings each would hit, and his one rule at the bottom. All of it fits on a single screen.

If your version spills past one screen, cut indicators until it fits, starting with any you haven't looked at in the last month. Then fill in the latest values from the sources you listed, dated today.

Set up the macro tab with your indicators and their sources, write three scenarios and mark which of your holdings each one would hurt most.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).