AI Analysis: International transactions in securities, portfolio transactions in Canadian and foreign securities, by type of instrument and issuer, monthly

Executive Summary

Statistics Canada's Table 36100028 tracks 38 years of monthly Canadian international portfolio investment flows (January 1988 to February 2026), encompassing 46,074 records across 35 instrument types with values ranging from -$900,875M to +$915,949M CAD. The data reveals a heavily right-skewed distribution — mean of $727M versus median of $113M — driven by large-scale cross-border transactions in bonds, equities, and government securities. Long-term trends show sustained structural patterns in foreign investment flows, punctuated by sharp anomalies tied to major global events such as the 2008 financial crisis and the COVID-19 pandemic.

Key Findings

• The dataset spans 458 monthly periods from January 1988 to February 2026, containing 46,074 records across 35 unique instrument/issuer types and 105 distinct data series.
• Transaction values range from -$900,875M to +$915,949M CAD — a total spread of over $1.8 trillion — with a standard deviation of $68,880M, reflecting extreme volatility in cross-border portfolio flows.
• The mean transaction value ($727M) is more than six times the median ($113M), confirming a heavily right-skewed distribution where a small number of very large transactions dominate the averages.
• Nearly 46% of all transaction records represent negative values (net outflows or sales), while 54% are positive, indicating a modest but consistent long-term bias toward net inflows across the full historical period.
• The strongest correlation in the dataset was between Canadian Securities Purchases and Sales at r = -0.999, a near-perfect inverse relationship reflecting the netting effect; overall, 248 pairs showed strong positive correlations (r > 0.8) and 258 pairs showed strong negative correlations (r < -0.8).
• 330 data points (approximately 2.1% of all net flow records) were flagged as extreme outliers using a Z-score threshold of |Z| > 3, with anomalies concentrated around major economic disruptions including the 2008 financial crisis and the 2020 COVID-19 pandemic.
• Bonds and debentures and equity/investment fund shares consistently dominate transaction volumes, reflecting their central structural role in Canada's international portfolio investment activity over the nearly four-decade period.