Dates Quiz
Relative Dates with Frequencies
-FQL or =FDS syntax only -examples 0M, -1AY
Relative Dates
-changed based on where you are in time (0,-5)
Calendar Frequencies
-end of last calendar quarter -end of last calendar year
Relative Calendar Dates
-includes weekends and market holidays when counting (-3/0/0) (12/31/-1)
Natural Frequencies
-latest completed period -end of last month -end of last fiscal quarter -end of last fiscal year
Actual Frequencies
-one month ago -three months ago -six months ago -one year ago -two years ago -three years ago -four years ago -five years ago -ten years ago -twenty years ago
Absolute Dates
represents a fixed point in time (ex. December 31, 2015)
Relative dates
represents a point in time that may change depending on your point of reference -examples of relative dates include yesterday, five years ago, six months ago, and the end of last year -starting point for a relative date is always 0
Daily (absolute)
MM/DD/YYYY (12/31/2015)
Monthly (absolute)
MM/YYYY (12/2015)
FQL: -1D
Screening: -1
FQL:-3M
Screening: -4/31/0
FQL: 0D
Screening: 0
FQL: -1AW
Screening: 0/-7/0
FQL: -2AY
Screening: 0/0/-2
FQL: -1CY
Screening: 12/31/-2
FQL: now
Screening: now
FQL: -3AM
Screening:-3/0/0
FQL: 0CY
Screening:12/31/-1
Annual- Fiscal Year (absolute)
YYYY (2015)
Quarterly-Fiscal Year (absolute)
YYYY/QF (2015/4F)
FQL Dates
both relative & absolute dates are used with FQL -when 0 is before an "actual frequency" is will ALWAYS default to yesterday's close date (0AY, 0AQ, 0AW)
Absolute dates allow the clients to retrieve what?
data from a specific date no matter when they are running their model
Absolute dates
fixed point in time -example (6/30/2018) (12/31/2018)
Relative trading days
trading days consist of any day in which a company's local stock exchange is open for business -weekends and market holidays are not included as trading days -FactSet automatically skips over any day that is not a trading day for historical relative dates
