TrueData Sheets Release Notes | Updates & New Features

NEW

new Added EXPIRY, EXPIRIES, LOTSIZE, COMPANYNAME, ATMSTRIKE and STRIKESTEP formulas
improved Renamed formulas for consistency by dropping the GET prefix: GETTICKS to TICKS, GETBARS to BARS, GETLASTNTICKS to LASTNTICKS, GETLASTNBARS to LASTNBARS, GETOPTIONCHAIN(+WITHGREEKS) to OPTIONCHAIN(+WITHGREEKS), GETTOPNGAINERS/LOSERS/VOLUMEGAINERS to TOPNGAINERS/TOPNLOSERS/TOPNVOLUMEGAINERS, GETOIGAINERS to OIGAINERS, GETOILOSERS to OILOSERS, GETINDEXGAINERS to INDEXGAINERS, GETINDEXLOSERS to INDEXLOSERS, GETINDUSTRYGAINERS to INDUSTRYGAINERS, GETINDUSTRYLOSERS to INDUSTRYLOSERS, GETMOSTACTIVEBYTURNOVER to MOSTACTIVEBYTURNOVER, GETMOSTACTIVEBYVOLUME to MOSTACTIVEBYVOLUME, GETPNLRESULTS to PNLRESULTS, GETBALSHEET to BALSHEET, GETCASHFLOW to CASHFLOW
improved Existing sheets using the old GET-prefixed formula names continue to work without changes

1.4.0

new Multi-cell and range locking/unlocking, with accurate undo across the whole selection
new Merge confirmation dialog before merging cells with existing data
new Row and column unhide interactivity improved, with cleaner expand controls
new Additional security hardening, including a more secure sign-in and session flow that stays reliably in sync across tabs
improved Freeze/unfreeze actions apply more reliably and no longer clutter undo history unnecessarily
improved Row/column move and resize now respect merged cell boundaries, preventing invalid drops
fixed Cell flash state not restoring correctly on undo
fixed Row resize losing existing row metadata
fixed Sheet rename occasionally failing to update or reverting incorrectly
fixed Chart editor not updating correctly when switching chart types
fixed Conditional formatting panel could crash on malformed rules

1.3.0

new Cross-sheet data validation — rules can reference other sheets, and now shift correctly on row/column insert, delete, or sheet rename
new GETLOTSIZE formula — fetch F&O lot sizes directly for a symbol
new New formulas: AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF, SUMIFS
new Redesigned toolbar font-size selector with a searchable dropdown
new New icons added across the Help menu
new Protection against dragging rows or columns that would cross merged or locked cells
improved Selection and grid rendering performance significantly improved on very large sheets (40k+ rows)
improved Conditional formatting rules are sanitized and serialized more efficiently, reducing file size and sync overhead
improved Auto-save is faster and more responsive, with an immediate \"Saving...\" indicator
improved Charts (including undo/redo) now stay in sync when rows or columns are added, removed, or reordered
improved Underlying formula engine upgraded for more robust criteria-based formula
improved Chart editor's data-range field is smoother to type in, with keyboard-accessible controls
improved Additional security hardening against unauthorized inspection or tampering
fixed Inconsistent number-format handling between the toolbar and format menu
fixed Editor unexpectedly scrolling the sheet when focused

1.2.0

new Dynamic cell references now supported in GETEXPIRY (e.g., =GETEXPIRY(A1))
new Direct "Empty Trash" action in the sidebar
new AI Help now opens in its own dedicated window
improved Formula recalculation is smarter — dependent cells update automatically, and historical/market-data changes write only the affected cells instead of reprocessing the whole sheet
improved Cell flash highlighting now syncs directly with value changes for more accurate visual feedback
improved Escape key now closes menus and popups in the correct order instead of all at once
improved Auto-scroll and selection now correctly account for sticky headers and footers
fixed Sheet names with special characters no longer break cross-sheet cell references
fixed Sheet info (name, color) occasionally showing stale data when switching tabs quickly

1.1.0

new GETEXPIRY formula — fetch a symbol's expiry dates by exchange and symbol
new Extended keyboard selection shortcuts (Ctrl+Shift+Arrows, Shift+Home/End/Page Up/Down)
new Cross-sheet and nested symbol resolution for market-data formulas, including references across sheets and concatenated symbol expressions
new Folder search and breadcrumb navigation in the Save/Move dialog
new Unsaved-changes tracking, so files with nothing to save close instantly
improved Live connection reliability improved with a token-based authentication flow, resolving connection race conditions
improved Viewport scroll alignment during cell navigation and paging
improved Storage usage now refreshes automatically across your dashboard, spreadsheets, and trash panels
fixed Clipboard state not restoring correctly during external paste operations

1.0.1

new Multiple row/column symbol subscriptions supported within a single conditional formatting rule
improved Conditional formatting engine enhanced for more reliable rule syncing
improved Redesigned platform and input dialog modals, with new cloud storage icons
improved Feed connections now resolve automatically at runtime for better reliability
improved Dashboard card re-rendering on the home screen
fixed Chart restoration and absolute cell-reference bugs
fixed Total volume (totVol) formula accuracy
fixed Match formula cell-shift reference issue

1.0.0

new Save files directly to Google Drive and other cloud storage providers, and open files straight from the cloud, with a connect/disconnect status modal
new Choose to save at your drive's root or pick a specific folder
new Help menu with Help AI and documentation access, plus a direct link to pricing/upgrade plans
new Storage-limit checks before saving, copying files, or creating folders, so you know before you hit your plan's limit
improved Upgrade-plan prompts now show the correct plan name based on your current subscription
improved Google Drive picker now correctly shows files nested inside folders
improved Sidebar now stays open as you reopen files
improved TrueData branding finalized across the platform
fixed File-open issues when working from connected cloud drives

0.9.0

new Clock toggle switch in the header
improved Row/column auto-scroll behavior near screen edges
fixed Row/column delete keyboard shortcuts
fixed Scripting panel state restore issues after reopening a file
fixed Alert history panel intermittently failing to load on first open
fixed SSO login redirect loop on certain browsers

0.8.0

new Cloud storage provider integration (beta)
new Single sign-on — log in directly from truedata.in without a separate sign-in step
new Alert history panel — a collapsible stack showing all your triggered alerts over time
new Open files from the home screen or file menu via a file picker
improved Script console output throttled so heavy logging doesn't slow down the UI
improved Alert routing made stricter and more reliable
improved Chart editor: custom sorting with full undo/redo support, and symbols automatically re-link after sorting, copy-paste, or importing data
fixed Ctrl+A followed by Delete no longer freezes the sheet
fixed Cells linked to an active alert are now protected from accidental deletion

0.7.0

new Conditional formatting — automatically highlight cells based on rules you define
new Price alerts — set target-based alerts on any cell, with "once" or "every time" triggers and edge/interval conditions
new Sheet and script templates with thumbnail previews
new Plan-based feature access — Workspace now reflects your subscription plan, with upgrade prompts for locked features
new New logo and refreshed loading animation
improved Option chain formulas now accept exchange as a parameter
improved REST Call auto-refresh consolidated into one consistent mechanism across the app
improved Alert messages now dynamically show the selected cell's symbol and target value
fixed Chart drag/resize sync issues
fixed Conditional formatting rule sync problems

0.6.0

new Full chart editor: bar, line, area, pie, donut, scatter, and candlestick charts — each with its own axis, color, data-range, and series options
new AI Custom Gpt panel alongside the scripting panel, both collapsible and resizable
new Multi-tab scripting — run several scripts at once, each with its own console
new Move a chart to its own sheet or back to a floating window, with full-screen editing
new In-cell OI bar visualization
improved Dark theme coverage across all modals and the scripting panel
improved Drag handles and resize grips optimized for mobile/touch
improved Symbol subscription and mapping reliability across multiple cells
improved 5-minute bar streaming now seeds correctly from history, with a default 25-candle view
fixed Script tab state getting lost when switching between sheets
fixed Chart zoom position resetting unexpectedly
fixed Option chain expiry lookups for BSE
fixed Formula bar editing cursor glitches

0.5.0

new Fundamental data formulas for company fundamentals
new Storage usage indicator in your profile
new Sign up/log in with Google, or via email or phone with OTP verification
new Make a copy / copy link from the file menu
improved Fully responsive home screen, header, and sidebar for tablet and mobile
improved Row/column drag performance
improved Live connection now uses a lighter cross-tab sync method for better reliability across multiple open tabs
fixed Bulk "clear sheet" delay bug
fixed Storage usage error on profile load

0.4.0

new Live bar streaming with a live OHLC candlestick chart
new Header search across your workspace
new Analytics formulas
new TD Scripting engine — run JavaScript against live and historical data with tick, 1-min/5-min bar, Greeks, and heartbeat events, plus onStart/onStop hooks
new Option chain with Greeks, as both a formula and a scripting function
new Favorites — mark and quickly access your favorite files
new File thumbnail previews
improved New file-info design showing key metadata at a glance
improved Clearer formula menu and dropdown naming
improved Excel import/export fidelity
improved Multi-tab support — a shared live connection keeps data and cell flashing in sync across open tabs
fixed 5-minute bar streaming bug
fixed Chart window rendering issues

0.3.0

new Historical market data formulas (OHLC, OI change, and more)
new Exchange status indicator (open/closed)
new Move-file dialog for organizing files into folders
new Auto-save for your spreadsheets
improved Redesigned home page and header
improved Live connection indicator now clearly shows Live/Connected status
fixed File save path issues
fixed Chart window and modal rendering glitches
fixed Drag-and-drop scroll sync between rows and columns

0.2.0

new Draw and insert charts directly into your sheet with a floating chart panel
new Drag-and-drop reordering for columns and rows
new Formula suggestion dropdowns while typing
new Profile menu with workspace server switching
new Status bar with quick cell stats
improved Formula dropdown accuracy for market-data formulas
improved Visual consistency of the formula bar and dropdowns
fixed Cell flashing glitches during column/row drag
fixed Percentage value formatting
fixed Scrollbar rendering in menu dropdowns

0.1.0

new Sheets by TrueData initial launch — login, home dashboard, and spreadsheet editor
new Custom TrueData formulas built directly into the spreadsheet engine
new File management — create, rename, delete, and load spreadsheet files
new Import and export spreadsheet files
new Light and dark theme support
improved Faster, flicker-free live price cell flashing
improved List and grid view toggle for the file dashboard
fixed Sorting and add/remove row/column issues
fixed Undo/redo reliability

Release Notes

Resources

Support