When a new stock quote arrives, changing the price is only the first step. That price feeds the dollar and percentage changes, the market summary, and the trend line next to the quote. At a high update rate, the spreadsheet has to keep those results in sync while users scroll, select cells, and inspect formulas.

Our Live Stock Market sample puts TX Sheet Control through that workflow. It streams simulated quotes for 16 fictional companies into an editable worksheet, with controls for the feed speed and a readout that shows how long each batch takes to apply and recalculate.

A Market Watch Built in the Worksheet

Each row shows an embedded company logo and ticker alongside the company name, last price, trading volume, open, session high and low, and previous close. Native conditional formatting adds data bars for volume and directional arrows for percentage change. A sparkline shows the last 18 prices for each company.

The simulation writes inputs such as the last price, accumulated volume, and rolling price history. Worksheet formulas calculate the change from the previous close and the corresponding percentage. They also estimate turnover by multiplying the last price by accumulated volume. The summary row uses COUNTIF to count advancing, declining, and unchanged stocks, and SUM to total estimated turnover.

Why Fast Updates and Recalculation Matter

Spreadsheet performance depends on the whole update path. The control must accept incoming values, recalculate formulas that depend on them, and redraw the indicators and charts users rely on. A lag anywhere in that sequence can leave someone looking at a fresh quote alongside an older percentage change or trend.

The sample groups each tick into one Workbook.batch() and writes the updated inputs with Range.setValues(). It then awaits workbook.calculation.recalculateAsync() before scheduling the next tick. The formulas stay in the workbook, so the same dependencies also update when a user pauses the feed and edits a price. Waiting for each batch to finish keeps batches from piling up when recalculation takes longer than the selected interval.

Batch + calc shows the time spent writing a batch and waiting for its calculations to finish. Quotes / sec measures completed quote updates over recent ticks, including the selected delay between batches. The interval ranges from 1,000 ms down to 50 ms. Actual throughput varies with the browser, device, and workbook workload.

Put the Feed Under Load

Switch the feed to 50 ms and trigger a volatility burst to see larger price and volume swings for the next 12 ticks. Watch the data bars, directional icons, sparklines, and summary figures respond. You can pause at any time, change a last price to see its dependents update, or advance one tick to follow the simulation batch by batch.

Try the Live Stock Market Demo

All our online demos have been updated to the latest release candidate of TX Sheet Control. Stay tuned to our blog for the official release announcement coming soon!