Skip to content

Proposed Frequency Conventions

jseabold edited this page Feb 20, 2012 · 6 revisions

Proposed frequency mapping table.

Frequency constants

Offset String aliases
Annual - Calendar
YearEnd(month=1) A@JAN
YearEnd(month=2) A@FEB
YearEnd(month=3) A@MAR
YearEnd(month=4) A@APR
YearEnd(month=5) A@MAY
YearEnd(month=6) A@JUN
YearEnd(month=7) A@JUL
YearEnd(month=8) A@AUG
YearEnd(month=9) A@SEP
YearEnd(month=10) A@OCT
YearEnd(month=11) A@NOV
YearEnd(month=12) A@DEC, A
Annual - Calendar (Start)
YearBegin(month=1) AS@JAN, AS
... ...
YearBegin(month=12) AS@DEC,
Annual - Business
BYearEnd(month=1) BA@JAN
BYearEnd(month=2) BA@FEB
BYearEnd(month=3) BA@MAR
BYearEnd(month=4) BA@APR
BYearEnd(month=5) BA@MAY
BYearEnd(month=6) BA@JUN
BYearEnd(month=7) BA@JUL
BYearEnd(month=8) BA@AUG
BYearEnd(month=9) BA@SEP
BYearEnd(month=10) BA@OCT
BYearEnd(month=11) BA@NOV
BYearEnd(month=12) BA@DEC, BA
Annual - Business (Start)
BYearBegin(month=1) BAS@JAN, BAS
... ...
BYearBegin(month=12) BAS@DEC,
Quarterly - Calendar
QuarterEnd(month=1) Q@JAN
QuarterEnd(month=2) Q@FEB
QuarterEnd(month=3) Q@MAR, Q
QuarterEnd(month=4) Q@APR
QuarterEnd(month=5) Q@MAY
QuarterEnd(month=6) Q@JUN
QuarterEnd(month=7) Q@JUL
QuarterEnd(month=8) Q@AUG
QuarterEnd(month=9) Q@SEP
QuarterEnd(month=10) Q@OCT
QuarterEnd(month=11) Q@NOV
QuarterEnd(month=12) Q@DEC
Quarterly - Calendar (Start)
QuarterBegin(month=1) QS@JAN, QS
... ...
QuarterBegin(month=12) QS@DEC
Quarterly - Business
BQuarterEnd(month=1) BQ@JAN
BQuarterEnd(month=2) BQ@FEB
BQuarterEnd(month=3) BQ@MAR, BQ
BQuarterEnd(month=4) BQ@APR
BQuarterEnd(month=5) BQ@MAY
BQuarterEnd(month=6) BQ@JUN
BQuarterEnd(month=7) BQ@JUL
BQuarterEnd(month=8) BQ@AUG
BQuarterEnd(month=9) BQ@SEP
BQuarterEnd(month=10) BQ@OCT
BQuarterEnd(month=11) BQ@NOV
BQuarterEnd(month=12) BQ@DEC
Quarterly - Business (Start)
BQuarterBegin(month=1) BQS@JAN, BQS
... ...
BQuarterBegin(month=12) BQS@DEC
Monthly - Calendar
MonthEnd() M
Monthly - Calendar (Start)
MonthBegin() MS
Monthly - Business
BMonthEnd() BM
Monthly - Business (Start)
BMonthBegin() BMS
Weekly - Calendar
Week(weekday=0) W@MON, WS, BWS
Week(weekday=1) W@TUE
Week(weekday=2) W@WED
Week(weekday=3) W@THU
Week(weekday=4) W@FRI, BW
Week(weekday=5) W@SAT
Week(weekday=6) W@SUN, W
Daily - Calendar
Day() D
Daily - Business
BDay() B
Hourly
Hour() H
Minute() Min
Second() S
Undefined U, None
Clone this wiki locally