Learn how to use and build a Price Formula
How to Use Price Formula
You can access close price data for any company in Tegus coverage with the Price formula. Available price data includes the most recent close price, the last close price as of a historical date, and the average close price of a historical date range.
=TEGUS.P(Ticker, [Date], [End Date])
Ticker (Company)
Identify the company in a Tegus Formula using a ticker assigned to the company. The ticker is the only required argument for the Price formula. If you only define the ticker argument, the formula will always point to the most recent close price for that company and automatically update when there is a new price available.
Please use the Tegus Ticker Format when adding a ticker to a Tegus Formula. If you are unsure of the format, the company look-up in the Formula Builder provides a search feature that can be a helpful resource to find the ticker and confirm the company is in coverage.
- Tegus Ticker Format: {Ticker Symbol}_{2-Letter Country Code}
Optional Arguments
The following arguments are not required to build a Price formula but may be included to refine the output. If you do not define these arguments, the formula can still be created and will point to the most recent close price.
Date (Historical Close Price)
When this argument is used in a Price formula it will return the most recent close price as of that date. It can also be used in conjunction with the 3rd argument to pull an average price.
This argument accepts most date formats. We do not recommend using time based Excel functions like TODAY() or NOW() for this argument because these will cause Tegus Formulas to constantly recalculate. This will clear undo history for all workbooks you’re working on and can make Excel run slower.
End Date (Average Close Price)
The 3rd argument can be used in conjunction with the 2nd argument to define an average close price from a historical date range. You must define the 2nd (Date) and 3rd argument to pull an average price.
This argument accepts most date formats. We do not recommend using time based Excel functions like TODAY() or NOW() for this argument because these will cause Tegus Formulas to constantly recalculate. This will clear undo history for all workbooks you’re working on and can make Excel run slower.