CompanyIQ MCP Server

# Data Availability & Limitations ## What Data IS Available ✅ ### From Brønnøysund Enhetsregisteret API **URL:** `https://data.brreg.no/enhetsregisteret/api` **Status:** ✅ Fully working and integrated #### Available Fields: - ✅ **Company Name** (navn) - ✅ **Organization Number** (organisasjonsnummer) - ✅ **Organization Form** (organisasjonsform) - AS, ASA, NUF, etc. - ✅ **Employee Count** (antallAnsatte) - Current number of employees - ✅ **NACE Codes** (naeringskode1, 2, 3) - Industry classification - ✅ **Business Address** (forretningsadresse) - ✅ **Postal Address** (postadresse) - ✅ **Established Date** (stiftelsesdato) - ✅ **Registration Status** - MVA, Foretaksregisteret, etc. - ✅ **Bankruptcy Status** (konkurs, underAvvikling) - ✅ **Last Submitted Annual Accounts Year** (sisteInnsendteAarsregnskap) - ✅ **Website** (hjemmeside) - ✅ **Phone** (telefon) - ✅ **Subunits** (underenheter) - All subsidiaries #### Example: Equinor ASA (923609016) ```json { "navn": "EQUINOR ASA", "antallAnsatte": 21552, "sisteInnsendteAarsregnskap": "2024", "naeringskode1": { "kode": "06.100", "beskrivelse": "Utvinning av råolle" }, "forretningsadresse": "STAVANGER", "konkurs": false } ``` --- ## What Data IS NOT Available ❌ ### Financial Data NOT in Enhetsregisteret API The following financial data is **NOT available** from the public Enhetsregisteret API: - ❌ **Revenue/Omsetning** - Not available - ❌ **Profit/Resultat** - Not available - ❌ **Assets/Eiendeler** - Not available - ❌ **Equity/Egenkapital** - Not available - ❌ **Liabilities/Gjeld** - Not available - ❌ **Cash Flow** - Not available - ❌ **Financial Ratios** - Not available - ❌ **Detailed P&L** - Not available - ❌ **Balance Sheet Details** - Not available **What You Get Instead:** - Only the YEAR of last submitted accounts (e.g., "2024") - NOT the actual financial figures --- ## 📊 Regnskapsregisteret API (Accounting Registry) ### Status: ⚠️ Limited Public Access **URL:** `https://data.brreg.no/regnskapsregisteret/regnskap` **Documentation:** https://github.com/brreg/regnskapsregister-api ### What Should Be Available: According to official documentation, this API should provide: - ✅ Key figures from last submitted annual accounts - ❌ Historical data (3 years) - **Only for public authorities (closed API)** - ✅ Revenue, profit, assets for companies following standard accounting plan - ❌ Bank and insurance company financials - Not available ### Current Issues: - 🔴 **API endpoints return 404 errors** - 🔴 **Swagger UI doesn't show specification** - 🔴 **Correct endpoint structure unclear** - ⚠️ **Status: "Preview" - No SLA guarantees** **Possible Reasons:** 1. API may require authentication (not documented) 2. Endpoints may have changed 3. Service may be temporarily unavailable 4. May need special access request --- ## 🎯 Current CompanyIQ Implementation ### What We Use: 1. **Brønnøysund Enhetsregisteret** ✅ - Company registry data - Employee counts - Industry codes - Addresses and status 2. **SSB (Statistics Norway)** ✅ - High-growth enterprise statistics - Employment by industry - Production and income (aggregated) - Economic indicators 3. **Local Database** ✅ - Caches API responses - Stores company profiles - Financial snapshots table (currently empty/sample data) ### What We DON'T Have: - ❌ Individual company financial statements - ❌ Revenue/profit for specific companies - ❌ Detailed balance sheet data - ❌ Multi-year financial comparisons --- ## 💡 How to Get Financial Data ### Option 1: Commercial Services (Recommended) **Proff.no** - Norwegian business intelligence service - Complete financial statements - Credit ratings - Multi-year comparisons - Has a commercial API - Subscription required **Bisnode/Dun & Bradstreet** - Comprehensive financial data - Credit scores - Risk assessments - Commercial API available ### Option 2: Manual Access **Brønnøysund Web Portal** - Free access to annual reports - Manual download only - No bulk access - URL: https://www.brreg.no/ **Altinn** - Where companies submit their accounts - View individual company filings - No programmatic access ### Option 3: SSB Statistics (Already Integrated) **What SSB Provides:** - ✅ Aggregated industry statistics - ✅ Employment trends by sector - ✅ Production values by industry - ❌ NOT individual company financials **Good For:** - Industry benchmarking - Macro trends - Market sizing - Comparative analysis --- ## 🔧 CompanyIQ Financial Analysis ### Current Approach: The `analyze_financials` tool currently: 1. ✅ Checks company status (bankruptcy, liquidation) 2. ✅ Uses employee count changes as proxy for health 3. ✅ Assesses based on available registry data 4. ⚠️ Uses sample/estimated data for financial_snapshots table ### Disclaimer in Tools: All financial analysis tools include this notice: ``` ℹ️ Dette er estimerte/sample data. For nøyaktige regnskapstall, bruk Proff.no eller andre tjenester. ``` ### Risk Assessment Works With: - Company status (bankruptcy, liquidation) - Employee trends - Registration status - Industry sector risk factors - NOT detailed financials (not available) --- ## 📋 Data Availability Matrix | Data Type | Enhetsregisteret | Regnskapsregisteret | SSB | Commercial | |-----------|------------------|---------------------|-----|------------| | Company name | ✅ Yes | - | - | ✅ Yes | | Org number | ✅ Yes | - | - | ✅ Yes | | Employee count | ✅ Yes | - | ✅ Aggregated | ✅ Yes | | Industry (NACE) | ✅ Yes | - | ✅ Stats | ✅ Yes | | Address | ✅ Yes | - | - | ✅ Yes | | Revenue | ❌ No | ⚠️ Should be | ✅ Aggregated | ✅ Yes | | Profit | ❌ No | ⚠️ Should be | ✅ Aggregated | ✅ Yes | | Assets | ❌ No | ⚠️ Should be | ❌ No | ✅ Yes | | Credit rating | ❌ No | ❌ No | ❌ No | ✅ Yes | | Board members | ⚠️ Auth req | - | - | ✅ Yes | | Ownership | ⚠️ Limited | - | - | ✅ Yes | **Legend:** - ✅ Yes - Fully available - ⚠️ Limited - Partial or requires auth - ❌ No - Not available --- ## 🚀 Recommendations ### For Basic Company Intelligence ✅ **Current CompanyIQ is perfect!** - Company search and discovery - Industry analysis - Market landscape - Growth trends (based on SSB data) - Employee-based insights ### For Financial Analysis ❌ **Need commercial service** If you need actual financial statements: 1. **Subscribe to Proff.no** - Norwegian market leader 2. **Use Bisnode API** - International coverage 3. **Manual download** - Free but time-consuming ### For Industry Benchmarking ✅ **CompanyIQ + SSB is excellent!** - Industry growth trends - Employment statistics - Production values - Market concentration - High-growth enterprise data --- ## 🔄 Future Integration Options ### If Regnskapsregisteret API Becomes Accessible: 1. Create RegnskapsregisteretClient 2. Add methods for financial statement retrieval 3. Populate financial_snapshots table with real data 4. Enhance analyze_financials tool 5. Add multi-year comparisons ### Alternative: Proff.no API If you get Proff.no API access: 1. Create ProffClient 2. Integrate financial data 3. Add credit ratings 4. Enable full due diligence capabilities ### Keep Current Approach: Focus on what we DO well: - ✅ Company discovery and search - ✅ Industry analysis with SSB data - ✅ Market landscape - ✅ Ownership structure (basic) - ✅ Growth trends (SSB-based) --- ## 📝 Updated Documentation Needed ### Honest Data Disclosure: - [x] Update README with clear data limitations - [ ] Add disclaimer in financial tools - [ ] Document what IS available - [ ] Provide alternatives for missing data - [ ] Set realistic user expectations --- **Conclusion:** Brønnøysund Enhetsregisteret provides excellent **company registry data** but **NOT financial statements**. For actual financial data, commercial services or manual access is required. **CompanyIQ Focus:** Company intelligence, market analysis, and industry trends using available public data.