Custom WordPress plugin integrating the EOD Historical Market Data API to build automated global market reports with cached daily HTML, CSV, and PDF output.
Currently running on WorldMarketWindow.com.
EOD Historical Data – Financial data from around the world. One-stop shop for API endpoints that provide 30+ years of historical and live data for stocks, forex, and more.
Overview
WorldMarketWindow.com offers global financial dashboards built on top of the EOD Historical Market Data API, delivering historical prices and macro-economic data for stocks, forex, indices, and more.
This custom WordPress plugin allows the site owner to build complex multi-country reports, automate data retrieval, and serve fast, pre-generated dashboards to subscribers.
How It Works
Custom Report Builder (Admin Interface)
I developed a dedicated admin dashboard where the site owner can create and manage reports without touching code. Each report can include:
- Country selection
- Multiple data categories (indices, commodities, currencies, ETFs, futures, etc.)
- Optional sub-categories
- Unique report names and slugs
- Activation/deactivation controls
This interface is fully powered by jQuery and AJAX, making it fast and easy to assemble complex API endpoints from structured options.
Cron-Driven Data Pipeline
Because the EODHD API returns very large data sets and enforces strict daily call limits, the plugin handles data asynchronously:
- Nightly cron jobs fetch fresh data for each active report
- API responses are cached in the database for 24 hours
- HTML versions of each report are also generated during cron runs
- The frontend displays these pre-rendered HTML files, not live API calls
This approach keeps the system fast, stable, and predictable — and it avoids wasting API credits.
Front-End Report Experience
On the public site, subscribers see polished, full-screen financial dashboards that load instantly. Each report includes:
- Pre-generated HTML for near-zero load times
- CSV export for analysts
- PDF output for clean, single-page snapshots
- Printer-friendly layouts
- A large-screen layout optimized to show the entire report at once when possible
Reports feel like professional research tools, not slow API-driven pages.
Outcome
The site owner can now build new global market reports in minutes from the WordPress admin with no technical steps required.
Data updates automatically every 24 hours, reports are always fresh, and subscribers see fast-loading dashboards that don’t depend on live API calls.
Tech Stack
- CSV and PDF report generation
- WordPress (custom plugin)
- EOD Historical Market Data API
- PHP + MySQL
- jQuery + AJAX
- Cron-based data ingestion and caching
