Actual dates

Actual dates are used to define the actual start and end dates for a function. Dates can be entered in either DD/MM/YY, DD.MM.YY or MM-DD-YY format.

For example, to obtain the average share price of Marks and Spencer between 31/12/98 and 31/12/99, type:

AVG#(MKS,31/12/98, 31/12/99)

Or equivalently:

AVG#(MKS,12-31-98, 12-31-99)

Note: If the actual date falls on a Saturday or Sunday, the previous Friday is used.