another date challenge

[Moneo]

......
A function for a project of mine needs to get the next trading day (e.g.: Monday through Friday).....

I think you're going to have to identify holidays, falling on Monday to Friday, which are not trading days for the location where the program is to be run.

This a pain because you need to create a table or file of these holidays, and update the table every year.

You could also try to program these holidays. Examples in the USA: Martin Luther King's birthday is celebrated on the third Monday in January. Thanksgiving is the fourth Thursday in November. If Good Friday is a holiday at your location, you will also need to compute the date of Easter. Banking laws in some countries inhibit banks from being closed for more than 4 days. So, if a Friday is a holiday, then Thursday and Monday cannot both be holidays. Trading days generally adhere to bank holidays.

Computing all these holidays can get tedious. The holiday table or file is less elegant and perhaps prone to user error, but much simpler.

EDIT: I think that The best solution would be to get the holiday table/file from the applicable stock exchange directly.


Regards..... Moneo