Consensus Custom Functions

Help and syntax for the InSync Consensus Excel custom functions. Every function is called under the INSYNC. namespace and requires an active signed-in add-in session.

Functions on This Page

INSYNC.IAD_OFJ – financial data and estimates
INSYNC.IGD_OFJ – guidance data
INSYNC.ISD_OFJ – stock data
INSYNC.IBD_OFJ – broker data
INSYNC.ILD_OFJ – line-item codes

INSYNC.IAD_OFJ Streaming

InSync Analytics Data retrieves financial data and estimates for a ticker and fiscal period.

=INSYNC.IAD_OFJ(ticker, [period], [ltCode], [ltType], [dp])

Parameter	Required	Description
`ticker`	Required	Ticker symbol, for example `"AAPL"`.
`period`	Optional	Fiscal period or metadata selector.
`ltCode`	Optional	Line item code.
`ltType`	Optional	Line item type or broker.
`dp`	Optional	Datapoint selector.

Example

=INSYNC.IAD_OFJ("AAPL", "2026", "IS_P_101", "CD")

This is a streaming function. The cell updates automatically as data is delivered. Back to top

INSYNC.IGD_OFJ Streaming

InSync Guidance Data returns a company’s guidance figure for a fiscal period.

=INSYNC.IGD_OFJ(ticker, [fiscalPeriod], [ltCode], [category], [sourcePeriod])

Parameter	Required	Description
`ticker`	Required	Ticker symbol.
`fiscalPeriod`	Optional	Guidance fiscal period, for example `2027`.
`ltCode`	Optional	Line item / LT code, or UIC for `i_` codes.
`category`	Optional	Guidance datapoint: `G`, `GH`, `GM`, or `GL`.
`sourcePeriod`	Optional	Optional source fiscal period.

Example

=INSYNC.IGD_OFJ("AAPL", "2027", "IS_P_101", "GM")

Guidance values may return as a range depending on the category selector. Back to top

INSYNC.ISD_OFJ Streaming

InSync Stock Data is a COM-compatible alias that keeps the legacy Insert Formula stock output shape while reusing the broker-data engine.

=INSYNC.ISD_OFJ(ticker, datacategory, [datedon], [ltType])

Parameter	Required	Description
`ticker`	Required	Ticker symbol.
`datacategory`	Required	Stock data category.
`datedon`	Optional	Optional date selector.
`ltType`	Optional	Optional subtype.

Example

=INSYNC.ISD_OFJ("AAPL", "Close", "2025-12-31")

Streaming function provided for backward compatibility with legacy Insert Formula sheets. Back to top

INSYNC.ILD_OFJ

InSync Line Data returns the available line-item codes for a ticker and category as a spilled range.

=INSYNC.ILD_OFJ(ticker, [selector])

Parameter	Required	Description
`ticker`	Required	Ticker symbol.
`selector`	Optional	Line-item selector, such as `AllLineItem`, `AllLineItem.IS`, `AllLineItem.BS`, `AllLineItem.CF`, `AllLineItem.SD.OM`, or `AllLineItem.KPI`.

Example

=INSYNC.ILD_OFJ("AAPL", "AllLineItem.IS")

Returns a matrix, or spilled range, of line-item codes. Back to top

INSYNC.IBD_OFJ Volatile

InSync Broker Data retrieves broker-specific market data for a ticker.

=INSYNC.IBD_OFJ(ticker, datacategory, [datedon], [ltType])

Parameter	Required	Description
`ticker`	Required	Ticker symbol.
`datacategory`	Required	Data category or broker selector.
`datedon`	Optional	Date or datapoint selector.
`ltType`	Optional	Optional broker subtype.

Example

=INSYNC.IBD_OFJ("AAPL", "TargetPrice")

Volatile function. Recalculates whenever the workbook recalculates. Back to top

Need More Help?

Visit the Support page or reach the InSync team through the contact page.