-- CostusWorx © 2026 — offshore-equity-in-GBP series (BEST-EFFORT, VERIFY).
-- Generated by _tooling/build_offshore_series.php. Run AFTER 2026_06_13_market_data_offshore.sql.
-- offshore_gbp = (1+MSCI World USD) x (GBP/USD move). Inputs are approximate.
START TRANSACTION;
UPDATE market_data SET offshore_equity_return = -0.0594, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2000;
UPDATE market_data SET offshore_equity_return = -0.1456, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2001;
UPDATE market_data SET offshore_equity_return = -0.2761, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2002;
UPDATE market_data SET offshore_equity_return = 0.1981, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2003;
UPDATE market_data SET offshore_equity_return = 0.0720, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2004;
UPDATE market_data SET offshore_equity_return = 0.2231, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2005;
UPDATE market_data SET offshore_equity_return = 0.0524, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2006;
UPDATE market_data SET offshore_equity_return = 0.0772, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2007;
UPDATE market_data SET offshore_equity_return = -0.1952, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2008;
UPDATE market_data SET offshore_equity_return = 0.1765, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2009;
UPDATE market_data SET offshore_equity_return = 0.1577, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2010;
UPDATE market_data SET offshore_equity_return = -0.0506, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2011;
UPDATE market_data SET offshore_equity_return = 0.1059, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2012;
UPDATE market_data SET offshore_equity_return = 0.2443, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2013;
UPDATE market_data SET offshore_equity_return = 0.1150, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2014;
UPDATE market_data SET offshore_equity_return = 0.0466, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2015;
UPDATE market_data SET offshore_equity_return = 0.2843, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2016;
UPDATE market_data SET offshore_equity_return = 0.1182, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2017;
UPDATE market_data SET offshore_equity_return = -0.0327, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2018;
UPDATE market_data SET offshore_equity_return = 0.2281, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2019;
UPDATE market_data SET offshore_equity_return = 0.1252, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2020;
UPDATE market_data SET offshore_equity_return = 0.2296, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2021;
UPDATE market_data SET offshore_equity_return = -0.0824, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2022;
UPDATE market_data SET offshore_equity_return = 0.1722, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2023;
UPDATE market_data SET offshore_equity_return = 0.2097, offshore_equity_index = 'MSCI World (GBP)' WHERE year = 2024;
COMMIT;