The Stock Latest function does exactly what it says – pulls the latest available information for a company. To use this equation, all that is required is a stock ticker and an attribute.

The generic stock equation requires the most information because this data will never change. Utilize this formula when you don’t want data to be updated or changed as it will require a ticker, attribute, year and quarter.

The Stock Relative function utilizes an optional quarter reference to pull the data relative to today. For instance, the quarter listed for today’s period would be “0.” Any variation for this would make the formula look back in time to determine the correct quarter. A good example of this would be a value of “4” would result in data from a year old filing.