By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.

Tegus Functions


Tegus Functions help you leverage Tegus data to build workflows and templates outside the context of a typical Tegus model. Access the most recent data points from models to build bespoke workflows like benchmarking workbooks or simplified looks at individual companies with an
Excel Function. Contact us to get started today. 

Company Data

The most recent company reported data from any row in any model.
Syntax: =TEGUS.CD(“<Ticker>“, “<Model Row Name>“, “<Period>“)

Last Price

The last reported close price on the company’s primary exchange.
Syntax: =TEGUS.P(“<Ticker>“)

Foreign Exchange

The most recent daily average FX rate.
Syntax: =TEGUS.FX(“<Base Currency>“, “<Quote Currency>”)


Supplementary company data to supplement your data.
Syntax: =TEGUS.MD(“<Ticker>“, “<Metadata Code>”, “[Period]”, “[Model Row Name]”,)

Company Intelligence on Demand