All-Weather Portfolio Optimizer (Google Sheets)

Description

Build more robust portfolios — without predicting the market.

The All-Weather Portfolio Optimizer is a professional Google Sheets tool designed for long-term investors who want to construct portfolios that are prepared for different economic environments, not dependent on a single market outcome.

Inspired by All-Weather and risk-parity investing principles, the tool helps you balance portfolio risk, not just capital, across different macroeconomic regimes such as rising or falling growth and inflation, and minimizing portfolio correlation.

What this tool helps you do

• Build diversified portfolios across four economic regimes

• Allocate based on risk contribution, not headline weights

• Avoid hidden concentration and unintended bets

• Combine ETFs and individual stocks in a structured way

• Apply practical constraints (leverage, caps, minimum sizes, volatility bands)

• Support for up to 100 assets in a portfolio

The optimizer suggests portfolio weights that aim for robustness and balance, rather than return maximization or market timing.

Key features

• Regime-based portfolio construction (growth & inflation aware)

• Risk-balanced allocations using volatility and correlations

• Optional leverage and long/short support

• Per-asset caps and asset-class (“sleeve”) constraints

• Optional portfolio volatility range

• Clear diagnostics and feasibility checks

• Fully transparent — no black-box formulas

Runs entirely in Google Sheets using built-in automation.

Who this is for

This tool is ideal for:

• DIY retail investors

• Macro-aware investors

• Long-term, diversified portfolio builders

• Users of ETFs, funds, and selected stocks

• Investors who want structure and discipline rather than predictions

No programming knowledge required.

How it works

You receive a view-only Google Sheets file.
Simply make a copy to your own Google Drive, enter your assets and assumptions, and run the optimizer. First-time setup requires a one-time Google authorization (standard for all Sheets automation).

Full instructions and conceptual background are included.

Important note

This tool is provided for educational and informational purposes only and does not constitute investment advice. Markets are uncertain, and results are not guaranteed.