TX Sheet Control

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.

Download the demo video Watch the simulated stock market worksheet in action. 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.

Pause the feed and select F5 to see =IFERROR(E5/L5,0) in the formula bar. The cell divides the price change by the previous close. 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.

The expanded editor shows all 16 companies and the rolling price history during a volatility burst. 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!

Featured Product

AI Development

Text Control MCP Server

Text Control Agent Skills

Server and Web Document Processing

TX Text Control .NET Server

Client-Side Packages - works together for web apps

DS Server

ReportingCloud

Desktop Document Processing

Windows Forms

TX Text Control .NET

TX Spell .NET

WPF

TX Text Control .NET

TX Spell .NET

ActiveX

TX Text Control ActiveX

Featured Projects

SignFabric

AI-Powered Documents

HEDBridge

Core Technologies

​

Latest Posts

​

Support

Getting Started

​

Other Resources

Company

Contact

Newsletter

Legal

Text Control Account

​

​

TX Sheet Control

Post tagged with TX Sheet Control in 2026 ​

November 2026

Post tagged with TX Sheet Control in 2026