Stable API Migration Guide (v2.0)
What changed in the Tickerdata v2.0 stable-API migration, which formulas need updating, and how to fix them step by step.
Find and replace broken formulas
Open your sheet and use Edit → Find and replace (Ctrl+F / ⌘F) to search for each attribute below. These are the only attributes that now return errors:
| Function | Removed attribute | Replace with |
|---|---|---|
TICKERDATA | Debt Repayment | Net Debt Issuance (or Long Term Net Debt Issuance / Short Term Net Debt Issuance) |
TICKERDATA | POCF Ratio | Price To Operating Cash Flow Ratio |
TICKERDATA | PFCF Ratio | Price To Free Cash Flow Ratio |
TICKERDATA | PTB Ratio | Price To Book Ratio (closest equivalent — the old ratio used tangible book value, so values differ slightly) |
TICKERDATA | Link, Final Link | None (SEC filing URLs were removed) |
TICKERDATALIVE | PE | =TICKERDATA(symbol, "Price To Earnings Ratio", "TTM") |
TICKERDATALIVE | EPS | =TICKERDATA(symbol, "EPS", "TTM") |
TICKERDATALIVE | Shares Outstanding | =TICKERDATA(symbol, "Weighted Average Shares Outstanding", year) |
Attribute names ignore spaces and capitalization, so search for whichever form your sheet uses — Debt Repayment, debtRepayment, and debt repayment are all the same attribute.
Recheck Earnings Announcement date handling
Earnings Announcement was removed in v2.0 and has since been restored — the formula works again, so there is nothing to find and replace. What changed is the value it returns.
| Before v2.0 | Now | |
|---|---|---|
| Value | 2026-07-30T20:00:00.000+0000 | 2026-07-30 |
| Before/after market close | Implied by the time portion | Not available |
| No date scheduled yet | Returned a stale past date | Returns an error |
If a formula reads the time portion — for example =RIGHT(TICKERDATALIVE(A1, "Earnings Announcement"), 13) to test for an after-close report — it no longer works, and the underlying signal is no longer available. Plain date use is unaffected: the value is still text, so wrap it in DATEVALUE() for any date math, exactly as before.
Check comparisons against Exchange Short Name
Exchange Short Name now returns full exchange names — "NASDAQ Global Select" instead of "NASDAQ", "New York Stock Exchange" instead of "NYSE".
The attribute itself still works, so no error will appear — but any formula that compares its value to a short code (for example =IF(TICKERDATALIVE(A1, "Exchange Short Name") = "NASDAQ", …)) will silently stop matching. Update those comparisons to the full names, and prefer the new canonical name Exchange Short Name renamed to Exchange Full Name in new formulas.
Recheck TTM ratio values
Five income-statement ratios with "TTM" were previously returning inflated values (roughly 4× too high, because quarterly percentages were being summed): grossProfitRatio, operatingIncomeRatio, incomeBeforeTaxRatio, netIncomeRatio, and ebitdaRatio.
They now return correct trailing-twelve-month values. Nothing to fix in your formulas — but if a model or alert was calibrated against the old inflated numbers, expect the values to drop to their true level.
Renamed attributes — no action required
Many attributes were renamed to clearer, canonical names in v2.0. Old names continue to work indefinitely — no removal is scheduled. Use the new names in new sheets; existing sheets need no changes.
Show the full rename list
Cash flow
commonStockIssuedrenamed tocommonStockIssuancedividendsPaidrenamed tocommonDividendsPaidnetCashUsedForInvestingActivitiesrenamed tonetCashProvidedByInvestingActivitiesnetCashUsedProvidedByFinancingActivitiesrenamed tonetCashProvidedByFinancingActivities
Key metrics
enterpriseValueOverEbitdarenamed toevToEbitdadaysSalesOutstandingrenamed todaysOfSalesOutstandingdaysPayablesOutstandingrenamed todaysOfPayablesOutstandingdaysOfInventoryOnHandrenamed todaysOfInventoryOutstandingroerenamed toreturnOnEquityroicrenamed toreturnOnInvestedCapital
Ratios
peRatiorenamed topriceToEarningsRatiopbRatiorenamed topriceToBookRatiopriceBookValueRatiorenamed topriceToBookRatiodebtToEquityrenamed todebtToEquityRatiodebtToAssetsrenamed todebtToAssetsRatiointerestCoveragerenamed tointerestCoverageRatiopayoutRatiorenamed todividendPayoutRatiopriceCashFlowRatiorenamed topriceToOperatingCashFlowRatiopriceToOperatingCashFlowsRatiorenamed topriceToOperatingCashFlowRatiopriceToFreeCashFlowsRatiorenamed topriceToFreeCashFlowRatiopriceEarningsToGrowthRatiorenamed topriceToEarningsGrowthRatiocashFlowCoverageRatiosrenamed tooperatingCashFlowCoverageRatiocashFlowToDebtRatiorenamed tooperatingCashFlowCoverageRatio
Income-statement margins
grossProfitRatiorenamed togrossProfitMarginoperatingIncomeRatiorenamed tooperatingProfitMarginincomeBeforeTaxRatiorenamed topretaxProfitMarginnetIncomeRatiorenamed tonetProfitMarginebitdaRatiorenamed toebitdaMargin
Statements & general
totalLiabilitiesAndStockholdersEquityrenamed tototalLiabilitiesAndTotalEquitycalendarYearrenamed tofiscalYearfillingDaterenamed tofilingDate
Analyst estimates
The estimated prefix was dropped across all estimate attributes — for example estimatedRevenueAvg renamed to revenueAvg and estimatedEpsHigh renamed to epsHigh. The same pattern applies to the low/high/average variants of revenue, EBITDA, EBIT, net income, SG&A expense, and EPS. Analyst-count attributes were renamed too: numberAnalystEstimatedRevenue renamed to numAnalystsRevenue and numberAnalystsEstimatedEps renamed to numAnalystsEps.
TICKERDATALIVE
volAvgrenamed toaverageVolume(also `avgVolume`)dividendrenamed tolastDividendchangesrenamed tochangechangesPercentagerenamed tochangePercentageExchange Short Namerenamed toExchange Full Name— values changed, see Step 3
Dividend yield units
What’s new in v2.0
Tickerdata v2.0 adds more than 50 new attributes: EBIT, free cash flow to firm and to equity, DuPont factors (taxBurden, interestBurden), capital-lease line items, debt-issuance breakdowns, cash-conversion and operating cycles, solvency and coverage ratios, and more.
Browse them in the Attribute Explorer — new attributes carry a teal New pill, and renamed attributes show their previous name. The full release notes live in the changelog.
Previously broken, now fixed