Skip to main content

Template Release Notes

To ensure the tradeGIST add-on functions correctly, your spreadsheet must be compatible with the latest version of our template. This page tracks all versions, improvements, and breaking changes.

Current Version

The latest stable version of the template is 1.0.1.

v1.0.1​

Bug Fixes & Refinements​

  • Removed internal functions: The TSX() and TT() custom functions have been removed. These were internal helpers and are no longer available.
  • Real-time update fixes: Updated many formulas across the template to fix real-time update issues, so your sheets now recalculate reliably as your data changes.

v1.0.0​

This release moves the general settings into a dedicated ⚙️ Settings dialog and introduces comprehensive cash tracking, full dividend income tracking with a new Dividends sheet, sector/industry breakdowns, per-account tax groups, automated wash sale detection, and under-the-hood formula improvements.

New Features & Improvements​

  • Settings Dialog: The general settings that used to live in the "General Configuration" section of the Configuration sheet now have their own ⚙️ Settings dialog (tradeGIST menu), with per-field validation and Test buttons for your API keys. Your license and app information are now tabs inside the same dialog. The Configuration sheet keeps the per-asset and per-account data (assets, accounts, tax rates, etc.). See the Configuration guide.
  • Dashboard Settings: Configure your Dashboard sheet's header change-window and its three performance charts (Overall performance, Assets ROI, Assets performance) from the new Dashboard tab in the ⚙️ Settings dialog, instead of editing cells on the Configuration sheet.
  • Wash Sale Detection: Added automatic tracking and adjustment for wash sales across stocks and options. A new "Wash Sale Adj." column in the "Trades" sheet properly defers disallowed capital losses. Rules and windows can be customized in the ⚙️ Settings dialog. See the Wash Sale Detection guide for details.
  • Cash Asset Type: Added support for a new "cash" asset type in the "Transactions" sheet, which allows you to log deposit and withdraw operations (leave Ticker and Price blank, set Volume to the cash amount, and explicitly set the Currency).
  • Automated Cash Balances: Updated the "Cash" sheet to automatically calculate cash balances. It now features built-in formulas that aggregate your deposits, withdrawals, and trading activity across accounts and currencies natively from the "Transactions" sheet.
  • Dividend Tracking & Dividends Sheet: Added a new "dividend" asset type in the "Transactions" sheet with income (cash dividends) and drip (reinvested dividends) operations, plus a brand-new Dividends sheet showing income received, an upcoming-payments calendar, your dividend-paying holdings, and a year-over-year growth chart. The new "Update dividends info" menu action auto-fills per-share amounts and upcoming dates. See the Dividends guide.
  • Sector & Industry: Added Sector and Industry columns to the asset configuration, surfaced as new columns on the "Trades" sheet so you can break down performance by sector.
  • Per-Asset Price Source: Each asset and option contract now has a "Data entry" column (Auto, GoogleFinance/CoinMarketCap/Massive, or Manual) so "Update prices" only updates the assets you want and never overwrites prices you maintain yourself.
  • Account Tax Groups: Each account can now be assigned a tax group (set in the Accounts section) so accounts are taxed by the entity that owes the tax, with both shared and isolated matching modes, plus a leading "Tax group" column in the Tax Rates section. See the Configuration guide.
  • Richer Snapshots: Snapshots now also capture your open option contracts and their value per ticker (<ticker>_op_contracts and <ticker>_op_value).
  • Expired Options & Auto-Detection: Expired option contracts now close automatically, and an option entered with the equity asset type is auto-detected from its ticker format.
  • Analysis Filters: Added a new "Asset class" filter in the "Analysis" sheet to narrow down to specific asset classes (like seeing all options or crypto trades for a specific year) and a "Performance" filter to show P&L in the asset or base currency.
  • New Named Functions: Added the OPTION_ROOT_SYMBOL, OPTION_EXPIRY_DATE, and OPTION_STRIKE_PRICE named functions to replace the previous PT_EXTRACT_ROOT_SYMBOL, PT_EXTRACT_OPTION_TYPE, PT_EXTRACT_OPTION_EXPIRY_DATE, and PT_EXTRACT_OPTION_STRIKE_PRICE. Also added SMART_SUM_COL to efficiently sum column ranges.
  • License Management: Removed the license_key setting from the Configuration sheet. Licensing is now fully managed directly through the ⚙️ Settings dialog (License tab) for a cleaner setup experience.

Bug Fixes & Refinements​

  • Analysis Formula Accuracy: Updated the formulas in the "Analysis" sheet to accurately display open and close prices in the base currency.
  • Formulas Optimization: Updated the formulas in the Configurations sheet > Option contracts to use MAP formulas that automatically populate the values for every row.
Breaking Change

The legacy PT_* option functions (PT_IS_VALID_OPTION_SYMBOL, PT_EXTRACT_OPTION_*) have been removed. Replace any cell still using them with the new Named functions above, otherwise they will show #NAME?.

v0.6.0​

This update introduces a licensing system for high-volume traders and refines the data-entry experience.

New Features & Improvements​

  • License Key Configuration: Added a new license_key setting in the General Configuration section. tradeGIST now requires a valid license key when your spreadsheet contains more than 30 transactions.
  • Improved Transactions Sheet UI: Reordered the columns in the Transactions sheet for better clarity. The "Amount" column has been moved to the far right, as this value is auto-calculated and should not be entered manually.

v0.5.0​

This version introduces significant structural updates to the Transactions and Trades sheets to provide more granular financial data and better automation for options traders.

New Features & Improvements​

  • New Analysis Sheet: An interactive dashboard for deep-dive performance reviews.
    • Dynamic Filtering: Filter trades by Asset (ticker or root symbol), Realization Status (Open/Closed), Year, or Custom Date Ranges.
    • Header Vital Signs: Real-time calculation of Success Rate, ROI, P&L, Estimated Tax, and FX Impact for any filtered subset.
  • Automated Options Handling: The template now automatically handles option exercises and assignments. When an option is exercised/assigned, the template will automatically generate the corresponding buy or sell transactions for the underlying shares.
  • Enhanced Trade Analytics: We’ve added several new columns to the Trades sheet to give you a deeper look at your performance:
    • Realized P&L: Track locked-in profits separately.
    • Total Fees (Base Currency): Improved cost tracking by normalizing all fees to your base currency.
    • Asset ROI & P&L: See performance breakdown per specific asset.
    • FX Impact & FX Return: Isolate how much of your profit (or loss) was caused by currency fluctuations.
  • Advanced Options Configuration: Added "Current delta" and "Type" columns to the options contracts configuration for better risk tracking.
  • Transaction UX: Reorganized the Transactions sheet columns. Required fields are now grouped at the beginning, followed by optional columns, to speed up manual data entry.
  • FX Rate Management: Added a new menu item: Update selected FX rates. This allows you to manually refresh or update the exchange rates for specific transaction rows.
  • New Named Functions: Added OPTION_TYPE and OPTION_DELTA to simplify formula management and user customization.

Bug Fixes & Refinements​

  • Dashboard Robustness: Updated core formulas in the Dashboard sheet to prevent errors and improve calculation stability.
  • Asset Performance Chart: Fixed a calculation bug where asset performance was being compared to the total asset value in base currency instead of the asset currency.
  • Simplified Configuration: Removed the "In Summary" option from the asset configuration sheet to streamline the setup process.

v0.4.0​

Improvements​

  • Performance Optimization: Migrated the Asset Performance formulas to use ArrayFormula. This significantly reduces the number of formulas in the sheet, resulting in faster loading times and smoother scrolling.
Migration Notice

If you are using a version older than v0.5.0, some features of the add-on may not display correctly. We recommend downloading the latest version from the official template page and migrating your data from your Configuration and Transactions sheets.