Returns the requested detail type for the specified average earnings definition.

GETAVGDETAIL("DefName", Date, Index, Type)

"DefName": the name of the item for which you need additional detail. This name must be enclosed in quotes.

Date: the date as of which the detail should be returned. Enter 0 here if as of the calculation date.

Index: the index of the detail to be extracted (enter 0 for types 0, 1, or 2) where 1 is the latest detail.

Type: refer to the following to determine the type to use:

• 0: Averaging Period
• 1: Lookback Period
• 2: Earnings Sum
• 3: Earnings Unit Amount
• 4: Earnings Unit Effective Date
• 5: Earnings Unit Stop Date
• 6: Earnings Unit Maximum
• 7: Earnings Unit Period
• 8: Earnings Unit Used Indicator
• 9: Earnings Unit Amount (used)
• 10: Earnings Unit Effective Date (used)
• 11: Earnings Unit Stop Date (used)
• 12: Earnings Unit Maximum (used)
• 13: Earnings Unit Period (used)
• 14: Unadjusted Earnings Unit Amount
• 15: Unadjusted Earnings Unit Amount (used)