QS.SCHEDULE.ADJUSTED¶
Spills a schedule adjusted with a market or joint calendar
Category: QuantSupport - Time.
- QS.SCHEDULE.ADJUSTED(start_date: text, end_date: text, frequency: text, calendar: text, convention: text, transpose: logical or blank) spilled range¶
- Parameters:
start_date (text) – ISO date text in YYYY-MM-DD format
end_date (text) – ISO date text in YYYY-MM-DD format
frequency (text) – Required frequency such as Annual, Semiannual, Quarterly, Monthly, or NoFrequency; no blank-input default
calendar (text) – Canonical calendar, e.g. Canada(Settlement), Switzerland, China(IB), or JointCalendar(JoinHolidays,TARGET,Japan)
convention (text) – Business-day convention: Following, ModifiedFollowing, Preceding, ModifiedPreceding, or Unadjusted
transpose (logical or blank) – Optional TRUE transposes the entire spill; omitted or blank defaults to FALSE; table headers move with their fields
- Returns:
One-column spill of business-day-adjusted schedule dates as ISO text (YYYY-MM-DD), without a header row. transpose=TRUE exchanges rows and columns; omitted transpose defaults to FALSE. Empty output returns a blank cell.
- Return Type:
spilled range
- Errors:
#VALUE! for invalid dates, frequency, calendar, business-day convention, or a schedule-builder failure. Invalid transpose/headers flags return #VALUE!; use TRUE/FALSE or leave optional flags blank.
Formula¶
=QS.SCHEDULE.ADJUSTED(start_date, end_date, frequency, calendar, convention, transpose)
Calculation¶
Thread-safe worksheet function.
Native Declaration¶
fn qs_schedule_adjusted (start_date : & str , end_date : & str , frequency : & str , calendar : & str , convention : & str , transpose : * const xll_rs :: types :: XLOPER12 ,) -> Result < * mut xll_rs :: types :: XLOPER12 , XllError >