Reference Data
JoelLewis/finance_skills/plugins/data-integration/skills/reference-databy JoelLewis5c498eacf7057e31238c4c5a8012a1afe9ec7c8aNo licenseListed Oct 9, 2026Updated Oct 9, 2026
Design and manage reference data systems — security master, client master, account master, identifier mapping, pricing data sources, golden source designation, and governance. Use when building or evaluating a security master database, mapping identifiers across systems (CUSIP to ISIN, SEDOL to FIGI), designing client master models for onboarding or KYC, defining account master attributes across custodians, designating golden sources and MDM patterns across systems, establishing a pricing vendor hierarchy with fallback order, establishing reference data governance and stewardship, handling identifier changes from corporate actions, or troubleshooting issues traced to missing or changed identifiers. Trigger on: security master, CUSIP, ISIN, SEDOL, FIGI, client master, account master, pricing data, reference data, golden source, MDM, master data, identifier mapping, data governance, vendor hierarchy.
- 5c498eacf7057e31238c4c5a8012a1afe9ec7c8aCurrentcommit 5c498eaPublished Oct 9, 2026
Source and attribution
Source:JoelLewis/finance_skillsinplugins/data-integration/skills/reference-dataat commit5c498ea
License: No license
Content belongs to its original authors. SourceWeft indexes it from a public repository.
More from JoelLewis/finance_skills
Tax Loss Harvesting
JoelLewis
Guides a full tax-loss harvesting workflow: candidate screening, gain/loss budgeting, replacement selection, wash-sale compliance and monitoring.
Trade Execution
JoelLewis
Guides design, evaluation, and monitoring of trade execution quality and best execution practices for equities and fixed income.
Qualitative Valuation
JoelLewis
Assesses economic moats, competitive positioning and management quality, then maps findings to valuation adjustments.
Settlement Clearing
JoelLewis
Reference guide to US trade settlement and clearing: T+1 cycles, DTCC/NSCC/FICC infrastructure, CNS netting, DVP/RVP and fails.
Pre Trade Compliance
JoelLewis
Guides design and implementation of automated pre-trade compliance systems that validate orders before execution.
Investment Policy
JoelLewis
Guides construction of Investment Policy Statements covering return objectives, risk tolerance, constraints, allocation, and benchmarks.
More in Business & Finance
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.
Sector Overview
anthropics
Produces industry and sector landscape reports covering market size, competitive positioning, valuation and investment implications.
Lbo Model
anthropics
Fills and validates leveraged buyout model templates in Excel, producing formula-driven, formatted financial workbooks.
Dcf Model
anthropics
Builds institutional-quality DCF equity valuation models as Excel workbooks with projections, WACC, and sensitivity analysis.
Comps Analysis
anthropics
Builds institutional-grade comparable company analyses as Excel spreadsheets with operating metrics, valuation multiples and statistics.
Audit Xls
anthropics
Audits spreadsheet formulas and financial models for errors, hardcodes, and integrity issues, then reports findings.