SEC EDGAR MCP Server
- sec-mcp
- scripts
demo-fact-table.js•8.7 kB
#!/usr/bin/env node
// Demonstration of the generic fact table building capability
const { buildFactTable } = require('../src/edgar-api.js');
async function demonstrateFactTable() {
console.log('📊 DEMONSTRATION: Building $638M Level Fact Table');
console.log('═══════════════════════════════════════════════════');
console.log('');
console.log('🎯 TARGET: Find all facts around $638M level with dimensional breakdowns');
console.log(' Company: Johnson & Johnson (JNJ)');
console.log(' Target Value: $638,000,000');
console.log(' Search Range: ±$50M ($588M - $688M)');
console.log(' Expected: Electrophysiology Non-US revenue and related facts');
console.log('');
try {
console.log('🔍 Building comprehensive fact table...');
console.log(' This would parse XBRL instance documents to find:');
console.log(' • Facts with values around $638M');
console.log(' • Dimensional context (Geography, Segment, Subsegment)');
console.log(' • Period information');
console.log(' • Business classification');
console.log('');
// Demonstrate the structure without actual API call
console.log('📋 EXAMPLE TABLE STRUCTURE:');
console.log('');
const exampleTable = {
company: '0000200406',
targetValue: 638000000,
tolerance: 50000000,
searchRange: { min: 588000000, max: 688000000 },
table: [
{
rowNumber: 1,
concept: 'RevenueFromContractWithCustomerExcludingAssessedTax',
value: 638000000,
valueFormatted: '$638.0M',
exactMatch: true,
deviationFromTarget: 0,
deviationFormatted: '$0.0M',
periodType: 'duration',
periodStart: '2025-01-01',
periodEnd: '2025-03-30',
dimensions: {
'us-gaap:StatementGeographicalAxis': 'us-gaap:NonUsMember',
'us-gaap:StatementBusinessSegmentsAxis': 'jnj:MedTechMember',
'us-gaap:SubsegmentsAxis': 'jnj:ElectrophysiologyMember'
},
hasGeographicDimension: true,
hasSegmentDimension: true,
hasSubsegmentDimension: true,
businessClassification: 'Subsegment Revenue',
contextRef: 'c-123',
unitRef: 'USD',
decimals: '6'
},
{
rowNumber: 2,
concept: 'RevenueFromContractWithCustomerExcludingAssessedTax',
value: 645000000,
valueFormatted: '$645.0M',
exactMatch: false,
deviationFromTarget: 7000000,
deviationFormatted: '+$7.0M',
periodType: 'duration',
periodStart: '2025-01-01',
periodEnd: '2025-03-30',
dimensions: {
'us-gaap:StatementGeographicalAxis': 'us-gaap:UsMember',
'us-gaap:StatementBusinessSegmentsAxis': 'jnj:MedTechMember',
'us-gaap:SubsegmentsAxis': 'jnj:ElectrophysiologyMember'
},
hasGeographicDimension: true,
hasSegmentDimension: true,
hasSubsegmentDimension: true,
businessClassification: 'Subsegment Revenue'
}
],
summary: {
totalFacts: 2,
exactMatches: 1,
conceptTypes: ['RevenueFromContractWithCustomerExcludingAssessedTax'],
factsWithGeography: 2,
factsWithSegments: 2,
factsWithSubsegments: 2,
valueRange: {
min: 638000000,
max: 645000000,
minFormatted: '$638.0M',
maxFormatted: '$645.0M'
},
businessTypes: {
'Subsegment Revenue': 2
}
}
};
console.log('🎯 EXACT MATCH FOUND:');
console.log(` 💰 Value: ${exampleTable.table[0].valueFormatted}`);
console.log(` 📊 Concept: ${exampleTable.table[0].concept}`);
console.log(` 📅 Period: ${exampleTable.table[0].periodStart} to ${exampleTable.table[0].periodEnd}`);
console.log(' 🏷️ Dimensions:');
Object.entries(exampleTable.table[0].dimensions).forEach(([dim, member]) => {
console.log(` • ${dim}: ${member}`);
});
console.log(` 🏢 Classification: ${exampleTable.table[0].businessClassification}`);
console.log('');
console.log('📊 TABLE SUMMARY:');
console.log(` 📋 Total Facts Found: ${exampleTable.summary.totalFacts}`);
console.log(` 🎯 Exact Matches: ${exampleTable.summary.exactMatches}`);
console.log(` 🌍 Facts with Geography: ${exampleTable.summary.factsWithGeography}`);
console.log(` 🏢 Facts with Segments: ${exampleTable.summary.factsWithSegments}`);
console.log(` 🔬 Facts with Subsegments: ${exampleTable.summary.factsWithSubsegments}`);
console.log(` 💰 Value Range: ${exampleTable.summary.valueRange.minFormatted} - ${exampleTable.summary.valueRange.maxFormatted}`);
console.log('');
console.log('📋 FORMATTED TABLE OUTPUT:');
console.log('═'.repeat(120));
console.log('# │ Concept │ Value │ Match │ Period │ Dimensions │ Classification');
console.log('─'.repeat(120));
console.log('1 │ RevenueFromContract...Tax │ $638.0M │ 🎯 │ 2025-01-01 to 30 │ 3 dims │ Subsegment Revenue');
console.log(' │ 🏷️ us-gaap:StatementGeographicalAxis: us-gaap:NonUsMember');
console.log(' │ 🏷️ us-gaap:StatementBusinessSegmentsAxis: jnj:MedTechMember');
console.log(' │ 🏷️ us-gaap:SubsegmentsAxis: jnj:ElectrophysiologyMember');
console.log('');
console.log('2 │ RevenueFromContract...Tax │ $645.0M │ 📍 │ 2025-01-01 to 30 │ 3 dims │ Subsegment Revenue');
console.log(' │ 🏷️ us-gaap:StatementGeographicalAxis: us-gaap:UsMember');
console.log(' │ 🏷️ us-gaap:StatementBusinessSegmentsAxis: jnj:MedTechMember');
console.log(' │ 🏷️ us-gaap:SubsegmentsAxis: jnj:ElectrophysiologyMember');
console.log('═'.repeat(120));
console.log('');
console.log('🚀 BUSINESS INTELLIGENCE EXTRACTED:');
console.log('');
console.log('✅ DIMENSIONAL ANALYSIS:');
console.log('• $638M = J&J Electrophysiology Non-US Revenue (Q1 2025)');
console.log('• $645M = J&J Electrophysiology US Revenue (Q1 2025)');
console.log('• Total EP Revenue = $1.283B (Q1 2025)');
console.log('• Geographic Split: 50.3% Non-US, 49.7% US');
console.log('');
console.log('📊 MARKET INSIGHTS:');
console.log('• Electrophysiology is reported as distinct subsegment');
console.log('• International markets represent slight majority');
console.log('• Q1 2025 growth vs Q1 2024 can be tracked');
console.log('• Competitive positioning vs Abbott, Medtronic, BSX');
console.log('');
console.log('🎯 MCP SERVER CAPABILITIES:');
console.log('');
console.log('Your enhanced SEC EDGAR MCP server can now:');
console.log('• 📊 Build comprehensive fact tables around any value level');
console.log('• 🏷️ Extract full dimensional context (Geography, Segment, Subsegment)');
console.log('• 📋 Classify business facts automatically');
console.log('• 🔍 Search with customizable tolerance ranges');
console.log('• 📈 Generate formatted table outputs');
console.log('• 🎯 Highlight exact matches and close values');
console.log('');
console.log('💡 USAGE IN CURSOR:');
console.log('Method: build_fact_table');
console.log('Parameters: cik_or_ticker, target_value, tolerance, accession_number, options');
console.log('Returns: Comprehensive dimensional fact table with business intelligence');
console.log('');
console.log('🔧 GENERIC EXAMPLES:');
console.log('• Search any company around any value:');
console.log(' {method: "build_fact_table", cik_or_ticker: "AAPL", target_value: 100000000}');
console.log('• Find facts with custom tolerance:');
console.log(' {method: "build_fact_table", target_value: 638000000, tolerance: 25000000}');
console.log('• Filter by specific concepts:');
console.log(' {method: "search_facts_by_value", target_value: 500000000, filters: {concept: "Revenue"}}');
console.log('• Custom table formatting:');
console.log(' {method: "build_fact_table", options: {maxRows: 10, sortBy: "value"}}');
} catch (error) {
console.error('❌ Demo failed:', error.message);
}
}
demonstrateFactTable();
Latest Blog Posts
- MCP Moves to the Linux Foundation: Neutral Stewardship for Agentic InfrastructureBy Om-Shree-0709 on .mcpanthropicLinux Foundation
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/openpharma-org/sec-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server