UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 2886 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 10238 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 10912 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'SLNG.L^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 10981 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermQuoteRetireDate = '2025-12-22' WHERE SecCode = 27994 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'GLBZ.PK', RkdDisplayRIC = 'GLBZ.PK', RkdExchCode = 'OTC' WHERE SecCode = 30238 AND Type_ = 1;
UPDATE data_universe SET Name = 'ONE BULLION LTD COM' WHERE SecCode = 35648 AND Type_ = 1;
UPDATE data_universe SET RkdIssueStatus = 0.0 WHERE SecCode = 43703 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MACO.I', QuotePermID = 21475575870.0, ExchCode = 'CCH', PermQuoteRetireDate = '2008-11-03', endDate = '2008-11-03' WHERE SecCode = 45892 AND Type_ = 10;
UPDATE data_universe SET Name = 'FON SE NPV (POST REV SPLIT)' WHERE SecCode = 59068 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'NSUG.I', QuotePermID = 21475572974.0, ExchCode = 'CHI', PermQuoteRetireDate = '2008-01-23', endDate = '2008-01-23' WHERE SecCode = 60647 AND Type_ = 10;
UPDATE data_universe SET Name = 'MR BRICOLAGE SA EUR3.4' WHERE SecCode = 65667 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 69136 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC', PermInstrStatus = 'DC', PermQuoteRetireDate = '2025-12-22' WHERE SecCode = 70947 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 75207 AND Type_ = 10;
UPDATE data_universe SET PermQuoteRetireDate = '2025-12-29' WHERE SecCode = 76248 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951465.0 WHERE SecCode = 77031 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 77804 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951694.0 WHERE SecCode = 81461 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951991.0 WHERE SecCode = 85740 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 85890 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 87281 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951782.0 WHERE SecCode = 90439 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951544.0 WHERE SecCode = 91212 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 95355 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 96847 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL WHERE SecCode = 97510 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA7629131011', RkdTicker = 'RIC', RkdSEDOL = 'BVN4HS', RkdCUSIP = '76291310', RkdRIC = 'RIC.TO', RkdDisplayRIC = 'RIC.TO', DsPrimQtSedol = 'BVN4HS2', InstrClass = 'ORD' WHERE SecCode = 98668 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, RkdRIC = 'SUP.V^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 99774 AND Type_ = 1;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 122937 AND Type_ = 10;
UPDATE data_universe SET Name = 'SYLPH INDUSTRIES INR1(POST SUBD)' WHERE SecCode = 136222 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'N2Fk.MU^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 141806 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 146694 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '2150.T^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 214808 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 251973 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA00792K2065', RkdSEDOL = 'BVN4HF', RkdCUSIP = '00792K20', DsPrimQtSedol = 'BVN4HF9' WHERE SecCode = 316714 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'INE333I01044', RkdTicker = 'NEUEON', PermIDTicker = 'NEUEON', RkdSEDOL = 'BTCFWR', RkdCUSIP = 'Y6S5UY10', DsPrimQtSedol = 'BTCFWR6' WHERE SecCode = 317135 AND Type_ = 10;
UPDATE data_universe SET Name = 'FUTUREGEN INDUSTRIES CORP COM' WHERE SecCode = 340320 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 342502 AND Type_ = 10;
UPDATE data_universe SET Name = 'ISRAEL CDA HTL S NPV' WHERE SecCode = 343767 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 683597 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 684743 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SD1.HNO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 779799 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 928424 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 961800 AND Type_ = 10;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 1111347 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 1151589 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'YOL.WA^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-22', PermQuoteRetireDate = '2025-12-22', endDate = '2025-12-22' WHERE SecCode = 1253090 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 1583310 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'MIDTOWN', PermIDTicker = 'MIDTOWN', RkdRIC = 'MIDT.KL', RkdDisplayRIC = 'MIDT.KL' WHERE SecCode = 1660236 AND Type_ = 10;
UPDATE data_universe SET Name = 'MACAU LEGEND DEVEL HKD1 (BERMUDA)', Country = 'BMU', IncCntry = 'BMU' WHERE SecCode = 2271010 AND Type_ = 10;
UPDATE data_universe SET Name = 'AXENTRA CORP LTD INR10(POST SPLT)' WHERE SecCode = 2338222 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'TKTT.PA^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 2397385 AND Type_ = 10;
UPDATE data_universe SET RkdIssueStatus = 1.0, PrimaryIssueType = 'PVT' WHERE SecCode = 2533369 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'SARJ.J^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 2536099 AND Type_ = 10;
UPDATE data_universe SET Name = 'CHINA GREEN BROAD HKD0.25' WHERE SecCode = 2586474 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 2708934 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21762568152.0, ExchCode = 'MUN', PermQuoteRetireDate = '2022-06-07', endDate = '2022-06-07' WHERE SecCode = 2944460 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21667488199.0, ExchCode = 'QTX' WHERE SecCode = 2982615 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '1COVG.DE^L25', RkdIssueStatus = 0.0 WHERE SecCode = 2987267 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3040839 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = NULL, QuotePermID = 21610513041.0, ExchCode = 'SIG', PermQuoteRetireDate = '2024-11-23' WHERE SecCode = 3320065 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'BRAZULA02PR3', RkdTicker = 'AZUL54', RkdRIC = 'AZUL54.SA', RkdDisplayRIC = 'AZUL54.SA' WHERE SecCode = 3322264 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'BAMBUSER AB NPV (POST SPLIT)' WHERE SecCode = 3341128 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3374537 AND Type_ = 10;
UPDATE data_universe SET ISIN = NULL, Name = 'CT VISION (INTL) H HKD0.01' WHERE SecCode = 3377753 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2014-12-15' WHERE SecCode = 3390477 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2017-12-06' WHERE SecCode = 3407098 AND Type_ = 10;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 3408964 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 21747653407.0, ExchCode = 'BER', PermQuoteRetireDate = '2024-01-18' WHERE SecCode = 3436782 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'BSGR.AS^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 3441370 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = 'POLX.L^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, DsSecDelistDate = '2025-12-23', PermQuoteRetireDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 3441725 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 3445039 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = '1FX', RkdSEDOL = 'BP0V6Z', RkdRIC = '1FX.SG', RkdDisplayRIC = '1FX.SG', RkdIssueStatus = 1.0, RkdExchCode = 'BWB', RkdExchCtry = 'DEU', PriValQuotePermID = 21897100243.0, PermQuoteStatus = 'DC' WHERE SecCode = 3543285 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 3554989 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 3747822 AND Type_ = 10;
UPDATE data_universe SET RkdRIC = '6764.TWO^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', PermInstrStatus = 'DC', DsSecDelistDate = '2025-12-23', endDate = '2025-12-23' WHERE SecCode = 4026041 AND Type_ = 10;
UPDATE data_universe SET PermQuoteStatus = 'DC' WHERE SecCode = 4092151 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4337006 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4423820 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'AU0000448102', RkdTicker = 'ERE', PermIDTicker = 'ERE', RkdSEDOL = 'BVPJRK', RkdRIC = 'ERE.AX', RkdDisplayRIC = 'ERE.AX', DsPrimQtSedol = 'BVPJRK7' WHERE SecCode = 4429670 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4451122 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4451253 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4457143 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 4462843 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL, startDate = '2021-01-13' WHERE SecCode = 4466617 AND Type_ = 10;
UPDATE data_universe SET RkdTicker = 'NOSN', PermIDTicker = 'NOSN', RkdRIC = 'NOSN.OL', RkdDisplayRIC = 'NOSN.OL' WHERE SecCode = 4481098 AND Type_ = 10;
UPDATE data_universe SET Name = 'KNOWLEDGE MARINE & INR5 (POST SUBD)' WHERE SecCode = 4539149 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4611010 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 4627839 AND Type_ = 10;
UPDATE data_universe SET PermIDTicker = 'MCH', PermQuoteStatus = 'AC', PermInstrStatus = 'AC', ExchCode = 'HSX', PermQuoteRetireDate = NULL WHERE SecCode = 4687568 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4689958 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 4707151 AND Type_ = 10;
UPDATE data_universe SET Name = 'WAY 2 VAT LTD NPV DFD 24/12/25(EX-SPLIT)' WHERE SecCode = 4709587 AND Type_ = 10;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 4812221 AND Type_ = 10;
UPDATE data_universe SET ShPerListing = 14770173.0 WHERE SecCode = 4873567 AND Type_ = 10;
UPDATE data_universe SET PermOrgIPODate = NULL WHERE SecCode = 5065052 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5262913 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'A' WHERE SecCode = 5410102 AND Type_ = 10;
UPDATE data_universe SET QuotePermID = 236778108786.0, ExchCode = 'FRA' WHERE SecCode = 5458395 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe SET IncCntry = 'BMU' WHERE SecCode = 6394290 AND Type_ = 10;
UPDATE data_universe SET COATypeCode = 'IND' WHERE SecCode = 6522462 AND Type_ = 10;
UPDATE data_universe SET Name = 'PRINCES GP PLC ORD GBP0.10' WHERE SecCode = 6528927 AND Type_ = 10;
UPDATE data_universe SET Name = 'PSI SOFTWARE SE NPV (ASD 02/01/2026 WARBURG' WHERE SecCode = 6562598 AND Type_ = 10;
UPDATE data_universe SET DsCtryQtStatus = 'S' WHERE SecCode = 6603583 AND Type_ = 10;
UPDATE data_universe SET PriTRBCIndPermID = 4294951997.0 WHERE SecCode = 6605892 AND Type_ = 10;
UPDATE data_universe SET RkdISIN = 'CA8629522076', RkdSEDOL = 'BTBKSK', RkdCUSIP = '86295220', DsPrimQtSedol = 'BTBKSK7' WHERE SecCode = 10912525 AND Type_ = 1;
UPDATE data_universe SET Name = 'MINAURUM SILVER INC COM SHS' WHERE SecCode = 10924593 AND Type_ = 1;
UPDATE data_universe SET ModelCntry = 'TH', DomCntry = 'THA' WHERE SecCode = 10964022 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA0156071049', RkdTicker = 'ALGR', RkdSEDOL = 'BVN4J4', RkdCUSIP = '01560710', RkdRIC = 'ALGR.V', RkdDisplayRIC = 'ALGR.V', DsPrimQtSedol = 'BVN4J42', RkdExchCode = 'CVE' WHERE SecCode = 10988860 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA05478T3064', RkdSEDOL = 'BVN4HH', RkdCUSIP = '05478T30', DsPrimQtSedol = 'BVN4HH1' WHERE SecCode = 11028342 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA96810C2004', RkdSEDOL = 'BVN4HV', RkdCUSIP = '96810C20', DsPrimQtSedol = 'BVN4HV5' WHERE SecCode = 11140985 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'US1031974066', RkdSEDOL = 'BVN4HD', RkdCUSIP = '10319740', DsPrimQtSedol = 'BVN4HD7' WHERE SecCode = 11151885 AND Type_ = 1;
UPDATE data_universe SET Name = 'HIGH TEMPLAR TECHNOLOGY LTD SPON ADS' WHERE SecCode = 11177866 AND Type_ = 1;
UPDATE data_universe SET ShPerListing = 13.33333 WHERE SecCode = 11188115 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG399731218', RkdSEDOL = 'BVP9QQ', RkdCUSIP = 'G3997312', DsPrimQtSedol = 'BVP9QQ6' WHERE SecCode = 11189991 AND Type_ = 1;
UPDATE data_universe SET DsTypeCode = 'EQ' WHERE SecCode = 11192485 AND Type_ = 1;
UPDATE data_universe SET DsCtryQtStatus = 'D', DsSecDelistDate = '2025-12-22', endDate = '2025-12-22' WHERE SecCode = 11199020 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11204015 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'CA48344L3056', RkdSEDOL = 'BP9N1J', RkdCUSIP = '48344L30', DsPrimQtSedol = 'BP9N1J0' WHERE SecCode = 11205621 AND Type_ = 1;
UPDATE data_universe SET RkdRIC = 'QS.O', RkdDisplayRIC = 'QS.OQ', RkdExchCode = 'NASD' WHERE SecCode = 11211048 AND Type_ = 1;
UPDATE data_universe SET PermIDTicker = NULL, PermQuoteStatus = 'DC' WHERE SecCode = 11237069 AND Type_ = 1;
UPDATE data_universe SET RkdISIN = 'KYG8924F1211', RkdSEDOL = 'BVN4BC', RkdCUSIP = 'G8924F12', DsPrimQtSedol = 'BVN4BC4' WHERE SecCode = 11237445 AND Type_ = 1;
UPDATE data_universe SET PermInstrStatus = 'DC' WHERE SecCode = 11248072 AND Type_ = 1;
UPDATE data_universe SET PrimaryIssueType = 'EQU' WHERE SecCode = 11249078 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = NULL, PermIDTicker = NULL, RkdRIC = 'ZK.N^L25', DsCtryQtStatus = 'D', RkdIssueStatus = 0.0, PermQuoteStatus = 'DC', DsSecDelistDate = '2025-12-22', PermQuoteRetireDate = '2025-12-22', endDate = '2025-12-22' WHERE SecCode = 11265114 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2024-09-30' WHERE SecCode = 11269673 AND Type_ = 1;
UPDATE data_universe SET DsExchQtStartDate = '2024-09-25', startDate = '2024-09-25' WHERE SecCode = 11269754 AND Type_ = 1;
UPDATE data_universe SET RkdTicker = 'EPWKF', RkdRIC = 'EPWKF.PK', RkdDisplayRIC = 'EPWKF.PK', RkdExchCode = 'OTC' WHERE SecCode = 11275065 AND Type_ = 1;
UPDATE data_universe SET IsPrimaryInstr = 0.0 WHERE SecCode = 11288759 AND Type_ = 1;
