Excel
Updated Nov 21, 2026The TagniFi Function for Fundamentals
One Excel function pulls standardized balance sheet, income statement and cash flow data into a cell. It takes ten arguments. Four are required, six are optional, and their order never changes. This guide explains each one in plain English, then shows how they work together.
One Function, Ten Slots
TagniFi identifies each argument by its position, not its name. Every Fundamentals formula has the same ten slots in the same order.
Read It As A Sentence
Give me the data type (1) of this tag (3) for this company (2), measured over this period type (4), for this fiscal year (5) and quarter (6), as known on this vintage date (7), using this industry template (8), moved back this many periods (9) from the latest period ended on or before this reference date (10).
Example
=TAGNIFI( "tagnifi.fundamentals.value", "AAPL", "Revenue", "quarter", "2014", "3", "vintage_date", "industry_template", "relative_period", "reference_date")Give me the value of Revenue for AAPL, measured over a quarter, for fiscal 2014, quarter 3. The last four slots are skipped, so you get today's view of the data, the company's own template, no step back, and no reference date.
The Ten Arguments
Each argument answers one question. The first four say what you want. The last six say which period, and which version of it.
The first argument is a path. It always begins tagnifi.fundamentals. and ends with the data type. Use value for the number itself. Every other data type returns a fact about that same number: which period it belongs to, or which filing it came from.
The reported figure
Name of the company
Fiscal year of the period
Date the source filing was made
Fiscal quarter of the period
Kind of filing, such as 10-K
Date the period ended
URL of the source filing
A ticker, such as AAPL, or a TagniFi ID. Point this slot at a cell that holds the ticker and one set of formulas can serve any company.
The standardized name of one line on the balance sheet, income statement or cash flow statement, such as Revenue, OperatingIncome or TotalAssets. Tags are written without spaces and are not case-sensitive. The statement a tag belongs to matters, because it limits which period types are available. See the Fundamentals Data Reference for the full tag list.
How much time one figure covers. It also defines what "one period" means for the arguments that follow.
One full fiscal year
One fiscal quarter on its own
From the start of the fiscal year through the quarter
The twelve months ending at the quarter. TTM also works
The company's fiscal year, which may not match the calendar year. Together with the quarter, it pins the formula to one fixed period.
If skipped: the most recent period is used.
A number from 1 to 4. It applies when the period type is quarter, year to date or trailing twelve month.
If skipped: correct for an annual request, which needs no quarter. Otherwise the most recent quarter is used.
A point-in-time date. Only filings made on or before it are used, so you see the figures as they stood that day, without later restatements. Use it for valuation dates and back-testing. Type it as 2014-12-31 or point to a cell that holds an Excel date.
If skipped: today. You get the latest filed figures.
Fundamentals standardizes companies into three statement layouts, each with its own list of tags. Every company is mapped to one of them.
Most service and manufacturing companies: revenue, gross profit, operating expenses, operating income
Banks and deposit-based companies: interest income and expense, non-interest income and expense
Insurers: premiums earned, investment income, policy acquisition costs, claims
If skipped: the company's own template is used.
A count backward from the anchor period. 0 is the anchor itself, -1 is one period earlier, -4 is four earlier. The size of a step is whatever the period type says a period is.
If skipped: 0. No step back.
Calendarizes the financials. The formula returns the latest period that ended on or before this date, and the relative period counts back from there. Enter 2025-12-31 and each company returns its latest period ended on or before December 31, 2025, so companies with different fiscal year ends line up on the same calendar date. Type the date or point to a cell that holds an Excel date.
Note: a reference date must be used with a relative period. Set slot 9 to a number, such as 0, whenever slot 10 holds a date.
If skipped: the anchor comes from the fiscal year and quarter, or from the most recent period.
How They Interact
The arguments are not independent. Change the inputs below and watch what happens to the formula, the period it lands on, and the notes underneath.
=TAGNIFI("tagnifi.fundamentals.value","AAPL","Revenue","quarter","2014","3","vintage_date","industry_template","relative_period","reference_date")- Returns
- The reported value
- Data Point
- Revenue for AAPL
- Period
- A single fiscal quarter: Q3 2014
- As Known
- Today, including any restatements
Position Is Identity
The function reads arguments by where they sit. The fifth slot is always the fiscal year, whatever you put in it. You can't drop an argument you don't need, because everything after it would shift left. Leave its own name in quotes instead. The placeholder holds the slot.
…, "annual", "fiscal_year", "fiscal_quarter", "vintage_date", "industry_template", "0", "reference_date")The Tag Limits The Period Type
A balance sheet is a snapshot on one date, so it has no year-to-date or trailing total. Income and cash flow items accumulate over time, so they do.
| Statement | Annual | Quarter | YTD | TTM |
|---|---|---|---|---|
| Balance Sheet | Yes | Yes | No | No |
| Income Statement | Yes | Yes | Yes | Yes |
| Cash Flow | Yes | Yes | Yes | Yes |
Period Type Sets The Unit
The period type decides two things about the arguments after it. First, whether the fiscal quarter is needed: an annual request has no use for it. Second, how far one step of the relative period travels: a fiscal year for annual, a quarter for the rest.
Three Ways To Anchor. Relative Period Offsets.
Fiscal year and quarter fix an anchor period. The relative period counts back from that anchor. Skip the year and quarter and the anchor becomes the most recent period, so 0 is the latest and -4 is four periods earlier. A reference date is the third option. It calendarizes: the anchor becomes the latest period ended on or before that date. Choose one per formula: a fixed period, a rolling one that follows the latest filing, or a calendar date.
Vintage Date Rewinds The Data First
The vintage date removes every filing made after it, then the other arguments choose a period from what's left. With a fixed period, you get the figure as first known, before any restatement. With a rolling period, "most recent" means the most recent one filed by that date. Don't confuse it with the reference date: vintage asks when a filing was made, reference asks when a period ended.
Data Type Describes The Same Data Point
Arguments 2 through 10 pick one data point. The data type picks what to report about it. Keep the other nine identical and swap value for end_period to label a column, or for filing_link to cite the source.
Seven Formulas Worth Keeping
The arguments doing the work are highlighted. Any of them can be a cell reference instead of typed text.
Latest Fiscal Year
No year, no quarter, relative period 0. It returns the most recent fiscal year on file and moves forward once the next one is filed.
=TAGNIFI( "tagnifi.fundamentals.value", "AAPL", "Revenue", "annual", "fiscal_year", "fiscal_quarter", "vintage_date", "industry_template", "0", "reference_date")One Fixed Quarter
Year and quarter pin the period. It returns the same quarter no matter when the workbook is opened.
=TAGNIFI( "tagnifi.fundamentals.value", "AAPL", "Revenue", "quarter", "2014", "3", "vintage_date", "industry_template", "relative_period", "reference_date")A History Row From One Formula
Put the ticker in A1 and 0, -1, -2, -3, -4 across row 1 (B1 through F1). Write the formula once in B2 and fill right. Add a row that swaps value for fiscal_year to label each column.
=TAGNIFI( "tagnifi.fundamentals.value", $A$1, "Revenue", "annual", "fiscal_year", "fiscal_quarter", "vintage_date", "industry_template", B$1, "reference_date")As Of A Valuation Date
B1 holds the valuation date as a normal Excel date. The formula returns trailing twelve month revenue using only what had been filed by then.
=TAGNIFI( "tagnifi.fundamentals.value", "AAPL", "Revenue", "trailing_twelve_month", "fiscal_year", "fiscal_quarter", $B$1, "industry_template", "0", "reference_date")Cite The Source
Same data point, different data type. The formula returns the URL of the filing the figure came from.
=TAGNIFI( "tagnifi.fundamentals.filing_link", "MSFT", "TotalAssets", "annual", "2011", "fiscal_quarter", "vintage_date", "industry_template", "relative_period", "reference_date")EBITDA From Its Parts
EBITDA is not a Fundamentals tag. Pull its four components into separate cells with identical period arguments, then add them.
B2 …,"OperatingIncome",…
B3 …,"DepreciationDepletionAmortization",…
B4 …,"RestructuringImpairmentChargesIncomeOpEx",…
B5 …,"NonrecurringSpecialChargesExpense",…
B6 =SUM(B2:B5)Calendarize A Comp Set
Tickers run down column A and B1 holds one date, such as 12/31/25. Each company returns revenue for the trailing twelve months ended on or before that date, so different fiscal year ends still land on comparable periods.
=TAGNIFI( "tagnifi.fundamentals.value", $A2, "Revenue", "trailing_twelve_month", "fiscal_year", "fiscal_quarter", "vintage_date", "industry_template", "0", $B$1)Before You Press Enter
Four mistakes account for most errors and wrong numbers.
Never drop a slot. Skipped arguments keep their placeholder.
…,"annual","0")…, "annual", "fiscal_year", "fiscal_quarter", "vintage_date", "industry_template", "0", "reference_date")Balance sheet tags are annual or quarter only. A snapshot has no year-to-date or trailing total.
"TotalAssets","year_to_date""TotalAssets","quarter"Date cells go in as they are. Don't convert them to text.
TEXT(B1,"yyyy-mm-dd")B1EBITDA is built, not pulled. Sum its components instead.
"EBITDA"