Get the Fixed Investment for a variety of countries over time from the Global Macro Database (GMDB). Fixed Investment is gross fixed capital formation: what businesses, households and the government spend on fixed assets such as machinery, equipment, buildings and dwellings, without the change in inventories.

The level is annual and expressed in millions of national currency, so levels are not comparable across countries with different currencies, but growth rates are.

Data comes from the Global Macro Database (GMDB), further information about the variable can be found within https://www.globalmacrodata.com/documentation.html

Also known as: gross fixed capital formation, capital investment.

Total Fixed Investment in Python or via the MCP

Install the Finance Toolkit with:

pip install financetoolkit -U

Then call get_fixed_investment as shown below.

from financetoolkit import Economics

economics = Economics(start_date='2020-01-01', end_date="2025-12-31")

fixed_investment = economics.get_fixed_investment()

fixed_investment.loc[:, ['United Kingdom', 'Germany', 'France']]

Or, after setting up the Finance Toolkit MCP, ask:

How much did the United Kingdom, Germany and France spend on fixed investment, in national currency, from 2020 to 2025?

Which returns:

  United Kingdom Germany France
2020 387159 733569 519445
2021 430541 775371 587672
2022 490449 858069 622842
2023 520091 894583 647114
2024 539666 887571 645687
2025 573803 911184 658386

Parameters

get_fixed_investment accepts the following parameters.

ParameterTypeDescriptionExample
countrieslist[str] | str | NoneA list of countries or a single country to include in the results. Defaults to None.["United States", "Germany"]
usdboolWhether to return the values in millions of US dollars, converted by the Global Macro Database, instead of millions of national currency, which makes levels comparable across countries. Defaults to False.True
rollingintThe rolling window size to use for smoothing the data (simple moving average). Defaults to None.4
trailingintThe trailing window size to use for summing the data over trailing periods (e.g. a trailing-4-quarter sum). Defaults to None.4
growthboolWhether to return the growth data or the actual data. Defaults to False.True
lagintThe number of periods to lag the growth data. Defaults to 1.4
standardizeboolWhether to standardize (Z-Score) the result. When combined with growth=True, standardizes the growth values instead of the raw values. Defaults to False.True
roundingint | NoneThe number of decimals to round the results to. Defaults to None.2
gmdb_forecastsboolWhether to include the years the Global Macro Database projects, from the IMF’s World Economic Outlook, up to five years ahead. Only applies to data from the Global Macro Database. Defaults to False, which ends a series with its last observation.True
Share