Stable API Migration Guide (v2.0)

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`	`debtRepayment`	`netDebtIssuance` (or `longTermNetDebtIssuance` / `shortTermNetDebtIssuance`)
`TICKERDATA`	`pocfRatio`	`priceToOperatingCashFlowRatio`
`TICKERDATA`	`pfcfRatio`	`priceToFreeCashFlowRatio`
`TICKERDATA`	`ptbRatio`	`priceToBookRatio` (closest equivalent — the old ratio used tangible book value, so values differ slightly)
`TICKERDATA`	`link`, `finalLink`	None (SEC filing URLs were removed)
`TICKERDATALIVE`	`pe`	`=TICKERDATA(symbol, "peRatio", "TTM")`
`TICKERDATALIVE`	`eps`	`=TICKERDATA(symbol, "eps", "TTM")`
`TICKERDATALIVE`	`earningsAnnouncement`	None currently
`TICKERDATALIVE`	`sharesOutstanding`	`=TICKERDATA(symbol, "weightedAverageSharesOutstanding", year)`

Check comparisons against exchangeShortName

exchangeShortName 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, "exchangeShortName") = "NASDAQ", …)) will silently stop matching. Update those comparisons to the full names, and prefer the new canonical name exchangeShortName renamed to exchangeFullName 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

commonStockIssued renamed to commonStockIssuance
dividendsPaid renamed to commonDividendsPaid
netCashUsedForInvestingActivities renamed to netCashProvidedByInvestingActivities
netCashUsedProvidedByFinancingActivities renamed to netCashProvidedByFinancingActivities

Key metrics

enterpriseValueOverEbitda renamed to evToEbitda
daysSalesOutstanding renamed to daysOfSalesOutstanding
daysPayablesOutstanding renamed to daysOfPayablesOutstanding
daysOfInventoryOnHand renamed to daysOfInventoryOutstanding
roe renamed to returnOnEquity
roic renamed to returnOnInvestedCapital

Ratios

peRatio renamed to priceToEarningsRatio
pbRatio renamed to priceToBookRatio
priceBookValueRatio renamed to priceToBookRatio
debtToEquity renamed to debtToEquityRatio
debtToAssets renamed to debtToAssetsRatio
interestCoverage renamed to interestCoverageRatio
payoutRatio renamed to dividendPayoutRatio
priceCashFlowRatio renamed to priceToOperatingCashFlowRatio
priceToOperatingCashFlowsRatio renamed to priceToOperatingCashFlowRatio
priceToFreeCashFlowsRatio renamed to priceToFreeCashFlowRatio
priceEarningsToGrowthRatio renamed to priceToEarningsGrowthRatio
cashFlowCoverageRatios renamed to operatingCashFlowCoverageRatio
cashFlowToDebtRatio renamed to operatingCashFlowCoverageRatio

Income-statement margins

grossProfitRatio renamed to grossProfitMargin
operatingIncomeRatio renamed to operatingProfitMargin
incomeBeforeTaxRatio renamed to pretaxProfitMargin
netIncomeRatio renamed to netProfitMargin
ebitdaRatio renamed to ebitdaMargin

Statements & general

totalLiabilitiesAndStockholdersEquity renamed to totalLiabilitiesAndTotalEquity
calendarYear renamed to fiscalYear
fillingDate renamed to filingDate

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

volAvg renamed to averageVolume (also `avgVolume`)
dividend renamed to lastDividend
changes renamed to change
changesPercentage renamed to changePercentage
exchangeShortName renamed to exchangeFullName — values changed, see Step 2

Dividend yield units

`dividendYield` returns a decimal (e.g. `0.0065` = 0.65%). The API also exposes `dividendYieldPercentage`, the same metric multiplied by 100. Don't mix the two in one model.

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

Five growth attributes that were documented but never returned data now work: `ebitGrowth`, `epsGrowth`, `epsDilutedGrowth`, `rdExpenseGrowth`, and `sgaExpenseGrowth`.