businessYearEnd

businessYearEnd(X, [endingMonth=12], [offset], [n=1])

Return the last business day (Monday to Friday) of the year that X belongs to and that ends in the month of endingMonth.

By default, each period corresponds to one year, and the function returns the last business day of the year containing X. The ending month of the year is determined by the endingMonth parameter. Here, business days are determined solely by the day of the week: Monday through Friday are considered business days, while Saturday and Sunday are considered non-business days.

When both offset and n are specified and n > 1, the function calculates period end dates based on n-year periods. In this case, offset determines how multi-year periods are aligned. Specifically, the system first calculates the last business day of the year containing offset according to endingMonth, and uses that date as the reference point. A new period end boundary is then generated every n years, and the function returns the last business day corresponding to the period to which X belongs.

DolphinDB and pandas both provide similar date offset functionality at the conceptual level. For a comparison of calculation rules, see Functions Related to Date Offset.

X is a scalar/vector of data type DATE, DATEHOUR, DATETIME, TIMESTAMP or NANOTIMESTAMP.

endingMonth is an integer between 1 and 12 indicating a month. The default value is 12.

offset (optional) is a scalar of the same data type as X, It must be no greater than the minimum value of X. The default value is the minimum value of X.

n (optional) is a positive integer. The default value is 1.

A scalar/vector of type DATE.

businessYearEnd(2012.06.12, 3);
// output: 2013.03.29

businessYearEnd(2012.06.12, 9);
// output: 2012.09.28

businessYearEnd(2012.06.12);
// output: 2012.12.31

businessYearEnd(2012.06.12, 12, 2009.04.03, 2);
// output: 2013.12.31

date=2011.04.25+(1..10)*365
time = take(09:30:00, 10)
sym = take(`MSFT,10)
price= 49.6 29.46 29.52 30.02 174.97 175.23 50.76 50.32 51.29 52.38
qty = 2200 1900 2100 3200 6800 5400 1300 2500 8800 4500
t1 = table(date, time, sym, qty, price);

t1;

select avg(price),sum(qty) from t1 group by businessYearEnd(date, 4, 2010.04.01, 2);

Related functions: businessYearBegin, yearBegin, yearEnd