Back to Case Studies
Data AnalysisFinance

Stock Rulebook

Regulatory File Management Platform for Stock Exchanges & Suppliers

Stock Rulebook

The Challenge

Financial professionals managing stock exchanges and regulatory compliance face a significant challenge: critical rulebook files and regulatory updates are scattered across 30+ different suppliers, each with their own distribution methods, file formats, and update schedules.

Manually tracking regulatory changes across dozens of supplier sources is time-consuming, error-prone, and risky. Missing a regulatory update can result in compliance violations, financial penalties, and operational disruptions. Comparing different versions of rulebooks to identify what changed requires painstaking manual review of hundreds of pages.

There's no centralized system to consolidate all supplier rulebooks, automatically detect when files are updated, compare versions to highlight specific changes, and generate summaries of regulatory modifications.

The technical challenge was substantial: building custom crawlers for 30+ diverse supplier sources with different file formats and access methods, storing and managing large regulatory files efficiently in cloud storage, implementing intelligent file comparison algorithms to detect changes, automatically generating meaningful summaries of regulatory updates, providing role-based access for users and admins, and creating an intuitive interface for viewing suppliers, logs, and file changes.

Our Solution

We partnered with Aaron (Partner) and Andrew MacNeaney (CEO and Founder) to build Stock Rulebook, a comprehensive regulatory file management platform that transforms how financial professionals manage compliance. We started working together 2 years ago and continue to maintain a strong partnership as the platform grows with multiple well-known financial institutions using our solution. Here's how we approached it:

Custom Crawler Architecture

The foundation of Stock Rulebook lies in its sophisticated data collection system. We developed 30+ custom crawlers, each tailored to a specific supplier's data source:

Adaptive Scraping: Each crawler is designed to handle the unique structure, authentication, and file format of its target supplier. Some suppliers provide APIs, others require web scraping, and some use FTP or email-based distribution.

Automated Scheduling: Crawlers run on intelligent schedules, checking for new files and updates automatically. The system monitors supplier websites 24/7, ensuring no regulatory update goes unnoticed.

S3 Storage Integration: All collected files are stored in AWS S3 buckets with organized directory structures by supplier, date, and file type. This provides scalable, reliable storage for thousands of regulatory documents.

Error Handling & Monitoring: Comprehensive logging tracks every crawler execution, capturing success, failures, and changes detected. Alerts notify administrators when crawlers encounter issues or when critical updates are found.

Intelligent File Comparison Engine

We built sophisticated comparison algorithms that go beyond simple file differencing:

Change Detection: When a supplier releases a new version of a rulebook, our system automatically compares it to the previous version, identifying exactly what changed—whether it's a single paragraph, a new section, or modified regulations.

Visual Difference Highlighting: The platform presents changes in an intuitive visual format, making it easy to see additions, deletions, and modifications at a glance. Users can quickly focus on what matters without reading entire documents.

Summary Generation: Our intelligent summarization engine analyzes detected changes and generates concise summaries highlighting the most important regulatory updates. This transforms hours of manual review into minutes of focused reading.

Historical Tracking: Complete version history for every supplier file, allowing users to view changes over time and understand the evolution of regulatory requirements.

FastAPI Backend Architecture

We chose Python FastAPI as the backend framework for its exceptional performance and modern capabilities:

RESTful API Design: Clean, well-documented endpoints for user management, supplier data, file access, change logs, and comparison results.

PostgreSQL Database: Efficient database schema storing supplier metadata, file references, change logs, user accounts, and access permissions.

Role-Based Access Control: Secure authentication system with granular permissions. Administrators manage suppliers and users, while standard users access relevant files and change summaries.

Background Task Processing: Asynchronous task queue handling crawler executions, file comparisons, and summary generation without blocking user requests.

AWS Integration: Seamless integration with S3 for file storage and retrieval, ensuring fast access to regulatory documents.

React-Based User Interface

We designed and built a comprehensive web interface with React, serving both administrators and end users:

User Dashboard: Financial professionals can browse suppliers, view available rulebooks, track recent changes, access file comparisons with highlighted differences, and read auto-generated summaries of regulatory updates.

Admin Dashboard: Administrators have full control over supplier management (add, edit, remove suppliers), user onboarding and access control, crawler monitoring and logs, system health and performance metrics, and manual crawler execution when needed.

Supplier Management: Detailed supplier profiles with contact information, file categories, update frequency, and historical change logs.

Change Log System: Comprehensive audit trail showing when files were fetched, what changed, and who accessed the information.

Intuitive Navigation: Clean, organized interface prioritizing ease of use for busy financial professionals who need quick access to critical regulatory information.

Technology Stack

Our implementation leverages modern, reliable technologies:

Python & FastAPI for high-performance backend API
React for responsive, modern frontend interface
PostgreSQL for robust relational data storage
AWS S3 for scalable file storage and management
Docker for containerized deployment and consistency
BetterStack for monitoring, logging, and observability
Custom web crawlers for 30+ diverse supplier sources
Automated file comparison algorithms for change detection
RESTful API architecture for clean integration
Role-based access control for security and compliance

Ongoing Partnership & Growth

Our relationship with Aaron and Andrew MacNeaney has been exceptional over the past 2 years. We started by building Stock Rulebook from scratch, and we've continuously enhanced the platform as their user base has grown.

Today, multiple well-known financial institutions rely on Stock Rulebook for regulatory compliance management. We continue to work closely with the team, adding new suppliers, optimizing performance, and implementing features based on user feedback.

This is a partnership we're committed to maintaining for the long term, ensuring Stock Rulebook continues to evolve and serve the financial industry's regulatory compliance needs.

Stock Rulebook User Dashboard
Codeaza Watermark

Comprehensive user dashboard for viewing suppliers and regulatory file changes

Stock Rulebook Suppliers Management
Codeaza Watermark

Supplier management interface with 30+ integrated data sources

Stock Rulebook Supplier Detail View
Codeaza Watermark

Detailed supplier view with file history and change logs

Stock Rulebook PDF Comparison
Codeaza Watermark

Intelligent PDF comparison for regulatory files

Stock Rulebook HTML Difference Finder
Codeaza Watermark

HTML difference detection with visual highlighting

Stock Rulebook Sign In
Codeaza Watermark

Secure authentication with role-based access

Stock Rulebook Help & Support
Codeaza Watermark

Comprehensive help and support system

Implementation Highlights

30+ Custom Crawlers

Sophisticated data collection system with custom crawlers for each supplier, handling diverse file formats and access methods.

Intelligent File Comparison

Advanced comparison algorithms detecting changes between file versions with visual highlighting and automated summaries.

FastAPI Backend Architecture

High-performance Python FastAPI backend with PostgreSQL database and AWS S3 integration for scalable file storage.

Dual Dashboard System

Comprehensive React dashboards for both administrators and users with role-based access control and granular permissions.

Automated Change Detection

24/7 monitoring system automatically detecting regulatory updates and generating summaries to highlight critical changes.

Financial Industry Solution

Built from scratch for regulatory compliance, serving multiple well-known financial institutions with 2+ years partnership.

The Results

30+ supplier integrations with custom crawlers fetching regulatory files automatically
AWS S3 storage providing scalable, reliable repository for thousands of regulatory documents
Automated change detection comparing file versions and highlighting specific modifications
Intelligent summary generation transforming hours of manual review into minutes of focused reading
Dual dashboard architecture serving both administrators and end users with role-specific features
FastAPI backend delivering high-performance API with secure authentication and authorization
React frontend providing intuitive interface for viewing suppliers, logs, and file changes
PostgreSQL database efficiently managing supplier metadata, file references, and user accounts
24/7 automated monitoring ensuring no regulatory update goes unnoticed
Complete audit trail tracking file fetches, changes detected, and user access
Role-based access control ensuring proper security and compliance with granular permissions
Historical version tracking allowing users to view regulatory evolution over time
Visual difference highlighting making it easy to identify additions, deletions, and modifications
BetterStack integration providing comprehensive monitoring and observability
Docker containerization ensuring consistent deployment and scalability
Multiple well-known institutions using the platform for regulatory compliance
2 years of ongoing partnership with continuous enhancement and feature additions
Built from scratch with commitment to long-term maintenance and growth

How Stock Rulebook Works

Custom Crawler Execution: 30+ specialized crawlers run on automated schedules, fetching regulatory files from diverse supplier sources and storing them in AWS S3 buckets with organized directory structures.

Automated Change Detection: When new file versions are detected, intelligent comparison algorithms analyze differences, identifying specific changes in regulatory text, sections, and requirements.

Summary Generation: Advanced summarization engine processes detected changes and generates concise summaries highlighting critical regulatory updates, transforming hours of manual review into actionable insights.

User Dashboard Access: Financial professionals log in to React-based dashboards to browse suppliers, view file changes with visual highlighting, access comparison reports, and read automated summaries.

Admin Control Panel: Administrators manage supplier configurations, monitor crawler logs, onboard new users with role-based permissions, and oversee system health through BetterStack monitoring.

Partnership with Aaron & Andrew MacNeaney: Built from scratch 2 years ago with ongoing collaboration, continuous enhancement, and commitment to serving multiple well-known financial institutions.

Technologies Used

Python & FastAPIReactPostgreSQLAWS S3DockerBetterStackCustom Web CrawlersFile Comparison AlgorithmsChange Detection SystemsAutomated SummarizationRESTful API DesignRole-based Access Control (RBAC)User Authentication & AuthorizationBackground Task ProcessingCloud Storage IntegrationAutomated SchedulingError Handling & LoggingData AggregationVersion Control SystemsRegulatory Compliance Tools

"Working with Codeaza for the past 2 years has been transformative for our business. They built Stock Rulebook from scratch and turned our vision into a powerful platform that serves multiple well-known financial institutions. The custom crawlers seamlessly collect data from 30+ suppliers, and the automated change detection saves our users countless hours. The file comparison and summary features are exactly what the industry needed. Codeaza has been more than a development partner—they've been true collaborators committed to our long-term success. We look forward to continuing this partnership for years to come."

A

Andrew MacNeaney

CEO & Founder, Stock Rulebook

Key Metrics

30+

Supplier Integrations

2+

Years Partnership

24/7

Automated Monitoring

AWS S3

Cloud Storage

FastAPI

Backend

React

Frontend

Finance

Industry

RBAC

Security

Partnership with Aaron & Andrew MacNeaney serving well-known financial institutions

Ready to achieve similar results?

Let's discuss how our data + AI solutions can help you transform your business and achieve your goals.