Laravel EIX Pricing

Laravel package for streaming EIX pre-trade data into a database and exposing the latest quote by ISIN.

This package is under active development and is not ready for production.

Architecture

The package discovers EIX sources from the last 30 minutes, streams each file through local and configured transient storage, parses gzip/CSV records lazily, and conditionally upserts current quotes in bounded batches. Import metadata and cache locks make retries and overlapping scheduler instances safe. The host application only provides Laravel, database, cache, filesystem and scheduler infrastructure.

Requirements

• PHP 8.4 or newer
• Laravel 13

Installation

composer require gybra/laravel-eix-pricing

Laravel discovers the package service provider automatically. Publish the configuration when application-specific values are needed:

php artisan vendor:publish --tag=eix-pricing-config

Configuration

Runtime settings use the EIX_ environment prefix. Source objects are removed after every import attempt.

Route middleware is configurable in the published config/eix-pricing.php.

Database

Package migrations load automatically and use EIX_DB_CONNECTION, falling back to the application's default connection. Run them with:

php artisan migrate

The package keeps one current quote per ISIN using bounded conditional upserts. See docs/persistence.md for ordering and transaction semantics.

Importing

Run an import manually with:

php artisan eix:import

Each run imports every uncompleted source whose timestamp falls inside EIX_IMPORT_LOOKBACK_MINUTES (default 30). The package schedules the same command every 30 minutes on weekdays with overlap protection. At 01:00 on weekdays it also runs eix:prune-quotes, deleting quotes whose imported_at is older than EIX_PRUNE_RETENTION_DAYS (default 2). Saturday and Sunday skip both import and prune because markets are closed. Set EIX_SCHEDULE_ENABLED=false to disable both schedules. Enable EIX_SCHEDULE_ON_ONE_SERVER=true only when every application instance shares a lock-capable cache store.

php artisan eix:prune-quotes

The host application must run Laravel's scheduler. No queue worker or Redis is required.

Quote API

GET /api/quotes/{isin}

{"data":{"isin":"IE000EOFR2K5","price":4.5425,"bid":4.4615,"ask":4.6235,"quoted_at":"2026-09-07T20:41:00.000000Z"}}

The endpoint is public and throttled. Invalid ISINs return 422 and missing quotes return 404. Route enablement, prefix, middleware and throttle are configurable.

Google Apps Script

Add this custom function to a Google Sheet through Extensions → Apps Script, replacing the base URL with the Laravel host URL:

function EIXPRICE(isin) {
  const baseUrl = 'https://example.com/api/quotes/';
  const response = UrlFetchApp.fetch(baseUrl + encodeURIComponent(isin), {
    muteHttpExceptions: true,
  });
  const payload = JSON.parse(response.getContentText());
  return payload.data.price;
}

Use it from a cell:

=EIXPRICE("IE00B3VTMJ91")

Invalid or unavailable ISINs surface the API's non-success response in the sheet instead of returning an arbitrary value.

Source contract

The verified EIX discovery, download and CSV formats are documented in docs/eix-source-contract.md. The source provides ISINs but no authoritative ticker mapping, so the initial release is ISIN-only.

Supabase PostgreSQL and Cloudflare R2

Use Laravel's normal PostgreSQL and S3-compatible filesystem configuration. See docs/deployment.md for placeholder-only Supabase and R2 examples. R2 objects are transient and the credentials require delete permission.

Large-file troubleshooting

The importer never loads a complete gzip or CSV source into memory. Ensure the local temporary volume has enough free space for the compressed source and set the download timeout and import lock lifetime above the measured import time. See docs/troubleshooting.md.

Development

composer install
composer test
composer format:check
composer analyse
composer audit --locked

See CONTRIBUTING.md, SECURITY.md and CHANGELOG.md for project policies.

License

Laravel EIX Pricing is open-source software licensed under the MIT License.