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

Overview

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>”)

Metadata

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

Company Intelligence on Demand

Request a free trial
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.