Real-Time Market Data Integration & Advanced Trading Features
Live market intelligence and full trading visibility — all inside the platform, with no manual data transfer between tools.
Managers needed live prices and full options tracking without leaving the platform
Grain marketing managers needed live commodity futures prices visible at all times while working within the platform — corn, soybeans, and wheat for grain operations, and feeder cattle and live cattle for the beef insurance module. They also required full options/hedging position tracking with automatic P&L calculations for 11 different option types used in agricultural commodity trading.
A product-aware live ticker and a complete options tracking module
We implemented a live market ticker bar at the top of the application, powered by the Twelve Data API (grain) and Yahoo Finance API (cattle). The ticker displays real-time futures prices with automatic refresh and is product-aware: it shows grain futures (Soybeans, Wheat, Corn) when users are in BushelView and cattle futures (Feeder Cattle, Live Cattle) when in Beef View. The switching is automatic based on the active product context.
The Options Tracking module supports all 11 option types used in agricultural commodity trading: Puts, Calls, Put Spreads, Call Spreads, 3-Way Calls, 3-Way Puts, Butterflies, Spread Trades, Risk Reversals, Long Futures, and Short Futures. Each position tracks purchase price, contracts, commissions, and exit date. The “Close Position” action automatically calculates P&L using the formula: (sale price - purchase price) × contracts × 5,000 bushels minus commissions.
A summary dashboard shows open/closed position counts, total contracts, and aggregate P&L with color-coded profit/loss indicators. Critically, closed options P&L feeds directly into the profitability calculator, ensuring that hedging gains and losses are reflected in the client’s overall financial picture. Positions are filterable by status (open/closed), crop type, crop year, and client, with manager scoping so each manager only sees their own clients’ positions.
Additional data features include CSV export on Orders, Options, and Clients pages, bulk order import via CSV upload with validation and error reporting, and a delivery calendar with status filter buttons, clickable delivery chips, and color-coded status indicators.
Live Market Ticker: Persistent ticker bar at the top of the application, pulling grain futures from Twelve Data API and cattle futures from Yahoo Finance API. Auto-refresh with product context switching — no manual toggling.
Options Tracking: All 11 agricultural option types supported. Each position tracks purchase price, contracts, commissions, and exit date. Automatic P&L calculation on close: (sale price − purchase price) × contracts × 5,000 bushels − commissions.
Manager Scoping: Full data isolation per manager — each manager sees only their own clients’ positions. Filterable by status (open/closed), crop type, crop year, and client.
P&L Integration: Closed options P&L automatically flows into the profitability calculator, ensuring hedging activity is always reflected in the client’s bottom line without manual data entry.
Data Import/Export: CSV export on Orders, Options, and Clients pages. Bulk order import via CSV upload with validation and error reporting. Delivery calendar with status filter buttons, clickable delivery chips, and color-coded status indicators.
How we built it
Live Market Ticker: Persistent ticker bar at the top of the application, pulling grain futures from Twelve Data API and cattle futures from Yahoo Finance API. Auto-refresh with product context switching — no manual toggling.
Options Tracking: All 11 agricultural option types supported. Each position tracks purchase price, contracts, commissions, and exit date. Automatic P&L calculation on close: (sale price − purchase price) × contracts × 5,000 bushels − commissions.
Manager Scoping: Full data isolation per manager — each manager sees only their own clients’ positions. Filterable by status (open/closed), crop type, crop year, and client.
P&L Integration: Closed options P&L automatically flows into the profitability calculator, ensuring hedging activity is always reflected in the client’s bottom line without manual data entry.
Data Import/Export: CSV export on Orders, Options, and Clients pages. Bulk order import via CSV upload with validation and error reporting. Delivery calendar with status filter buttons, clickable delivery chips, and color-coded status indicators.
Live market intelligence and full trading visibility without leaving the platform
Managers now have commodity prices, options positions, P&L, and profitability all in one place — with no manual data transfer between tools.
Market Data Integration, Options Tracking, Real-Time UI, P&L Automation, CSV Import/Export
Agricultural Technology