Latest InsightsQ3-2026 Quarterly Economic Update

Excel

Updated Nov 21, 2026

The 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.

=TAGNIFI(1"tagnifi.fundamentals.data_type",2"company",3"tag",4"period_type",5"fiscal_year",6"fiscal_quarter",7"vintage_date",8"industry_template",9"relative_period",10"reference_date")
Required. Always a real value.Optional. To skip one, leave its own name in quotes as a placeholder.

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.

data_type
Required
What do you want back?

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.

value

The reported figure

company_name

Name of the company

fiscal_year

Fiscal year of the period

filing_date

Date the source filing was made

fiscal_quarter

Fiscal quarter of the period

filing_type

Kind of filing, such as 10-K

end_period

Date the period ended

filing_link

URL of the source filing

company
Required
Which company?

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.

tag
Required
Which line item?

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.

period_type
Required
Over what span of time?

How much time one figure covers. It also defines what "one period" means for the arguments that follow.

annual

One full fiscal year

quarter

One fiscal quarter on its own

year_to_date

From the start of the fiscal year through the quarter

trailing_twelve_month

The twelve months ending at the quarter. TTM also works

fiscal_year
Optional
Which fiscal year?

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.

fiscal_quarter
Optional
Which quarter of that year?

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.

vintage_date
Optional
As known on what date?

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.

industry_template
Optional
Which statement layout?

Fundamentals standardizes companies into three statement layouts, each with its own list of tags. Every company is mapped to one of them.

commercial

Most service and manufacturing companies: revenue, gross profit, operating expenses, operating income

banking

Banks and deposit-based companies: interest income and expense, non-interest income and expense

insurance

Insurers: premiums earned, investment income, policy acquisition costs, claims

If skipped: the company's own template is used.

relative_period
Optional
How many periods back?

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.

reference_date
Optional
Calendarized to what date?

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.

data_type
company
tag
period_type
fiscal_year, fiscal_quarter
Pins the formula to one fixed period.
vintage_date
industry_template
relative_period
reference_date
Your Formula
=TAGNIFI("tagnifi.fundamentals.value","AAPL","Revenue","quarter","2014","3","vintage_date","industry_template","relative_period","reference_date")
Highlighted slots carry real values. The rest are placeholders holding their position.
In Plain English
Returns
The reported value
Data Point
Revenue for AAPL
Period
A single fiscal quarter: Q3 2014
As Known
Today, including any restatements
Which Period You Get
-5Q2 2013
-4Q3 2013
-3Q4 2013
-2Q1 2014
-1Q2 2014
0Q3 2014
Each cell is one fiscal quarter. The outlined cell is the anchor. The filled cell is what the formula returns.
What's Interacting
The relative period stays as its placeholder. The year and quarter already name the exact period.
Rule 1

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")
Rule 2

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.

StatementAnnualQuarterYTDTTM
Balance SheetYesYesNoNo
Income StatementYesYesYesYes
Cash FlowYesYesYesYes
Rule 3

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.

Rule 4

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.

Rule 5

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.

Rule 6

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.

1

Never drop a slot. Skipped arguments keep their placeholder.

Wrong…,"annual","0")
Right…,"annual","fiscal_year","fiscal_quarter","vintage_date","industry_template","0","reference_date")
2

Balance sheet tags are annual or quarter only. A snapshot has no year-to-date or trailing total.

Wrong"TotalAssets","year_to_date"
Right"TotalAssets","quarter"
3

Date cells go in as they are. Don't convert them to text.

WrongTEXT(B1,"yyyy-mm-dd")
RightB1
4

EBITDA is built, not pulled. Sum its components instead.

Wrong"EBITDA"
RightFour component tags, summed
Next articleExcel: Installing The TagniFi Excel Add-In