[{"_1":2,"_176":-5,"_177":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58,"_59":60,"_61":62,"_63":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","d5f757b780a022bc6624fd27fe562bc7d587159d","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_151":152,"_173":174,"_175":-5},"handle","MRPRRSIDENT","name","CDMBenchmarking","path","backend/services/external-data.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":111,"_112":-5,"_12":113,"_114":115,"_116":117,"_118":117,"_119":-5,"_120":32,"_14":121,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":131,"_134":135,"_137":138,"_150":20},"id","181b65cc-5ba7-11f0-9a49-f69ea79377d9","createdAt",["D",1751943367054],"deletedAt","legacyEnvVars","privacy","unlisted","description","Model benchmarking tool for IMM, CDM ISDA plus mapping ","imageUrl","682f125d-0e14-4a34-baf0-cd336faaaea9","pinnedFileId","bc561f68-cfa3-11f0-8a00-42dde27851f2","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","68e9dfdf-cb88-426a-b619-6e75fb5e7dfa","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_132":133},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJwcTVjemR4RFVBdnRsajFGMTFlRFp3UFZ6OSJ9","org",{"_94":95,"_136":133,"_12":113},"avatar","branch",{"_139":140,"_96":44,"_102":141,"_142":103,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":-5,"_148":97,"_149":95},"version",52,"181bcb52-5ba7-11f0-9a49-f69ea79377d9","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":153,"_96":154,"_155":156,"_157":158,"_159":141,"_160":161,"_162":117,"_104":163,"_139":32,"_164":165,"_166":167,"_168":20,"_169":-5,"_98":170},"0d8a599a-cfa3-11f0-bb93-42dde27851f2","external-data.ts","fileId","0d8a5a4e-cfa3-11f0-bb93-42dde27851f2","parentId","41e85e3b-ef05-43d6-9ffe-f13d0a806c3f","branchId","branchVersion",6,"latest",["D",1764695966221],"fileType","script","content","// External data source integration for CDM field validation and mapping\n\nimport type { ExternalValidationResult } from '../../shared/types.ts';\n\nexport class ExternalDataService {\n private static instance: ExternalDataService;\n \n static getInstance(): ExternalDataService {\n if (!ExternalDataService.instance) {\n ExternalDataService.instance = new ExternalDataService();\n }\n return ExternalDataService.instance;\n }\n\n // Validate currency codes against ISO 4217\n async validateCurrency(currency: string): Promise {\n try {\n // Using a free currency API for validation\n const response = await fetch(`https://api.exchangerate-api.com/v4/latest/${currency.toUpperCase()}`);\n \n if (response.ok) {\n return {\n source: 'ExchangeRate-API',\n isValid: true,\n standardizedValue: currency.toUpperCase(),\n };\n } else {\n // Fallback to static list of common currencies\n const commonCurrencies = [\n 'USD', 'EUR', 'GBP', 'JPY', 'CHF', 'CAD', 'AUD', 'NZD', \n 'SEK', 'NOK', 'DKK', 'PLN', 'CZK', 'HUF', 'SGD', 'HKD'\n ];\n \n const isValid = commonCurrencies.includes(currency.toUpperCase());\n const alternatives = isValid ? [] : this.findSimilarCurrencies(currency, commonCurrencies);\n \n return {\n source: 'Static Currency List',\n isValid,\n standardizedValue: isValid ? currency.toUpperCase() : undefined,\n alternatives,\n };\n }\n } catch (error) {\n console.error('Currency validation error:', error);\n return {\n source: 'Error',\n isValid: false,\n alternatives: ['USD', 'EUR', 'GBP'],\n };\n }\n }\n\n // Validate business centers against ISDA standards\n async validateBusinessCenter(center: string): Promise {\n const standardBusinessCenters = [\n 'GBLO', 'USNY', 'JPTO', 'FRPA', 'DEFF', 'CHZU', 'CATO', 'AUSY',\n 'NZWE', 'SGSI', 'HKHK', 'SEST', 'NOOS', 'DKCO', 'PLWA', 'CZPR',\n 'HUBU', 'BRSP', 'MXMC', 'INJA', 'KRSE', 'CNSH', 'CNBE', 'RUMO',\n 'ZAJO', 'EGCA', 'ILTA', 'TRST', 'SAAB', 'AEAD', 'KWKC', 'QADO',\n 'BHMA', 'OMMU', 'JOAM', 'LBBE', 'MAMU', 'TNTU', 'DZAL', 'MACC',\n 'NGLA', 'KENA', 'GHAC', 'CIAB', 'SNDA', 'MLBA', 'BFOU', 'NENI',\n 'TGLO', 'BJPO', 'CFBA', 'CGBR', 'CMYA', 'GALIB', 'GQMA', 'GWBI',\n 'KMMO', 'MGTA', 'MLBA', 'MRNO', 'MZMA', 'NENI', 'REKI', 'RWKI',\n 'SCMA', 'SLBO', 'STGE', 'SZMA', 'TDND', 'TZDA', 'UGKA', 'ZMLU',\n 'ZWHA'\n ];\n\n const normalizedCenter = center.toUpperCase();\n const isValid = standardBusinessCenters.includes(normalizedCenter);\n const alternatives = isValid ? [] : this.findSimilarBusinessCenters(center, standardBusinessCenters);\n\n return {\n source: 'ISDA Business Centers',\n isValid,\n standardizedValue: isValid ? normalizedCenter : undefined,\n alternatives: alternatives.slice(0, 5), // Limit to top 5 suggestions\n };\n }\n\n // Validate floating rate indices\n async validateFloatingRateIndex(index: string): Promise {\n const standardIndices = [\n 'USD-LIBOR-BBA', 'EUR-LIBOR-BBA', 'GBP-LIBOR-BBA', 'JPY-LIBOR-BBA',\n 'CHF-LIBOR-BBA', 'CAD-LIBOR-BBA', 'AUD-LIBOR-BBA', 'NZD-LIBOR-BBA',\n 'SEK-LIBOR-BBA', 'NOK-LIBOR-BBA', 'DKK-LIBOR-BBA',\n 'USD-SOFR', 'EUR-ESTR', 'GBP-SONIA', 'JPY-TONA', 'CHF-SARON',\n 'CAD-CORRA', 'AUD-AONIA', 'NZD-NZIONA', 'SEK-SWESTR', 'NOK-NOWA',\n 'USD-Federal Funds-H.15', 'EUR-EONIA', 'GBP-WMBA-SONIA-COMPOUND',\n 'JPY-MUTANCALL', 'CHF-TOIS', 'CAD-BA-CDOR', 'AUD-BBR-BBSW',\n 'NZD-BBR-FRA', 'SEK-STIBOR-SIDE', 'NOK-NIBOR-NIBR', 'DKK-CIBOR2-DKNA13'\n ];\n\n const normalizedIndex = index.toUpperCase();\n const isValid = standardIndices.some(stdIndex => stdIndex.toUpperCase() === normalizedIndex);\n const alternatives = isValid ? [] : this.findSimilarIndices(index, standardIndices);\n\n return {\n source: 'Standard Rate Indices',\n isValid,\n standardizedValue: isValid ? standardIndices.find(idx => idx.toUpperCase() === normalizedIndex) : undefined,\n alternatives: alternatives.slice(0, 5),\n };\n }\n\n // Validate day count fractions\n async validateDayCountFraction(dayCount: string): Promise {\n const standardDayCounts = [\n 'ACT/360', 'ACT/365', 'ACT/ACT', '30/360', '30E/360', 'ACT/365.FIXED',\n 'ACT/ACT.ISDA', 'ACT/ACT.AFB', '30/360.ISDA', '30E/360.ISDA',\n 'ACT/365L', 'ACT/ACT.ICMA', 'BUS/252', '1/1', 'ACT/364'\n ];\n\n const normalizedDayCount = dayCount.toUpperCase();\n const isValid = standardDayCounts.includes(normalizedDayCount);\n const alternatives = isValid ? [] : this.findSimilarDayCounts(dayCount, standardDayCounts);\n\n return {\n source: 'ISDA Day Count Conventions',\n isValid,\n standardizedValue: isValid ? normalizedDayCount : undefined,\n alternatives: alternatives.slice(0, 3),\n };\n }\n\n // Validate business day conventions\n async validateBusinessDayConvention(convention: string): Promise {\n const standardConventions = [\n 'FOLLOWING', 'MODFOLLOWING', 'PRECEDING', 'MODPRECEDING', 'NONE'\n ];\n\n const normalizedConvention = convention.toUpperCase();\n const isValid = standardConventions.includes(normalizedConvention);\n const alternatives = isValid ? [] : standardConventions.filter(conv => \n conv.includes(normalizedConvention.substring(0, 3))\n );\n\n return {\n source: 'ISDA Business Day Conventions',\n isValid,\n standardizedValue: isValid ? normalizedConvention : undefined,\n alternatives,\n };\n }\n\n // Validate party identifiers (LEI, etc.)\n async validatePartyIdentifier(identifier: string, scheme: string): Promise {\n if (scheme.toUpperCase() === 'LEI' || scheme.toLowerCase().includes('lei')) {\n return this.validateLEI(identifier);\n }\n \n // For other schemes, perform basic validation\n return {\n source: 'Basic Validation',\n isValid: identifier.length > 0,\n standardizedValue: identifier.toUpperCase(),\n };\n }\n\n private async validateLEI(lei: string): Promise {\n // LEI format: 20 alphanumeric characters\n const leiRegex = /^[A-Z0-9]{20}$/;\n const normalizedLEI = lei.toUpperCase();\n \n if (!leiRegex.test(normalizedLEI)) {\n return {\n source: 'LEI Format Validation',\n isValid: false,\n alternatives: ['Format should be 20 alphanumeric characters'],\n };\n }\n\n try {\n // Try to validate against GLEIF API (if available)\n const response = await fetch(`https://api.gleif.org/api/v1/lei-records/${normalizedLEI}`);\n \n if (response.ok) {\n const data = await response.json();\n return {\n source: 'GLEIF API',\n isValid: true,\n standardizedValue: normalizedLEI,\n };\n } else {\n return {\n source: 'LEI Format Validation',\n isValid: true, // Format is correct even if not found in registry\n standardizedValue: normalizedLEI,\n };\n }\n } catch (error) {\n return {\n source: 'LEI Format Validation',\n isValid: true, // Format is correct\n standardizedValue: normalizedLEI,\n };\n }\n }\n\n private findSimilarCurrencies(input: string, currencies: string[]): string[] {\n const inputLower = input.toLowerCase();\n return currencies\n .filter(currency => \n currency.toLowerCase().includes(inputLower) || \n this.levenshteinDistance(inputLower, currency.toLowerCase()) <= 2\n )\n .slice(0, 3);\n }\n\n private findSimilarBusinessCenters(input: string, centers: string[]): string[] {\n const inputUpper = input.toUpperCase();\n return centers\n .filter(center => \n center.includes(inputUpper.substring(0, 2)) ||\n this.levenshteinDistance(inputUpper, center) <= 2\n )\n .slice(0, 5);\n }\n\n private findSimilarIndices(input: string, indices: string[]): string[] {\n const inputUpper = input.toUpperCase();\n return indices\n .filter(index => \n index.includes(inputUpper.substring(0, 3)) ||\n this.levenshteinDistance(inputUpper, index) <= 3\n )\n .slice(0, 5);\n }\n\n private findSimilarDayCounts(input: string, dayCounts: string[]): string[] {\n const inputUpper = input.toUpperCase();\n return dayCounts\n .filter(dayCount => \n dayCount.includes(inputUpper.substring(0, 3)) ||\n this.levenshteinDistance(inputUpper, dayCount) <= 2\n )\n .slice(0, 3);\n }\n\n private levenshteinDistance(str1: string, str2: string): number {\n const matrix = [];\n \n for (let i = 0; i <= str2.length; i++) {\n matrix[i] = [i];\n }\n \n for (let j = 0; j <= str1.length; j++) {\n matrix[0][j] = j;\n }\n \n for (let i = 1; i <= str2.length; i++) {\n for (let j = 1; j <= str1.length; j++) {\n if (str2.charAt(i - 1) === str1.charAt(j - 1)) {\n matrix[i][j] = matrix[i - 1][j - 1];\n } else {\n matrix[i][j] = Math.min(\n matrix[i - 1][j - 1] + 1,\n matrix[i][j - 1] + 1,\n matrix[i - 1][j] + 1\n );\n }\n }\n }\n \n return matrix[str2.length][str1.length];\n }\n}","deleted","label",[171,172,154],"backend","services","permalink","https://www.val.town/x/MRPRRSIDENT/CDMBenchmarking/code/backend/services/external-data.ts","extension","actionData","errors"]