Explore the API
Live stock market
Change the feed interval or trigger a volatility burst. Pause the feed to inspect formulas in the formula bar, edit a price, or step through a single quote batch.
Feed controls
Quote interval
1,000 ms 400 ms 100 ms 50 ms
Pause feed
Advance one tick
Trigger volatility burst
Result Live API output Batch + calc measures the workbook write and recalculation time on this device. Quotes per second reflects completed ticks, including the selected interval.
Preparing sample...
Keep exploring Reset or save Reset restores this sample's starting document. TXWB retains its spreadsheet, dashboard, and reporting definitions.
Reset sample Download TXWB
Ready to try Use the controls above to interact with this demo.
What this demonstrates
Live stock market
Each tick writes prices, trading volumes, session highs and lows, and rolling price history for 16 fictional companies in one workbook batch. Cell formulas calculate price change, percentage change, and estimated turnover at the last price. Summary formulas count advancing, declining, and unchanged stocks and sum their estimated turnover. The worksheet uses embedded company logos, native directional icons, volume data bars, and rolling price sparklines.
APIs used
Workbook.batch()
Range.setValues()
Range.setFormulas()
Workbook.calculation.recalculateAsync()
Workbook.addConditionalRule()
Worksheet.addSparklines()
Worksheet.drawings.addPicture()
How to explore
Change the feed interval or trigger a volatility burst. Pause the feed to inspect formulas in the formula bar, edit a price, or step through a single quote batch.
Batch + calc measures the workbook write and recalculation time on this device. Quotes per second reflects completed ticks, including the selected interval.
Document ownership
The ready event supplies the initialized editor. Each action resolves document objects from the current workbook. Reset loads a clean TXWB snapshot; worksheet, range, chart, and dashboard handles must be acquired again after loading.
The Code panel shows this sample's actual implementation and the shared hosting code. Downloads contain the current document; changes are not stored on the server.
NuGet packages
TXTextControl.TXSheetControl.AspNetCore
2.0.0
Provides the Razor spreadsheet editor, browser APIs, and packaged fonts.
dotnet add package TXTextControl.TXSheetControl.AspNetCore --version 2.0.0
