wilmott.com

I am trying to produce realistic schedule generation using holiday calendars. Are there good sources of obtaining holiday calendars ? Anything to watch out for while implementing in C# or Python ? I will be implementing the following natural method - getNthBday which given a date and a holiday calendar and a N, will return the Nth business day per that calendar.

My guess is that C++ is well-developed here (QL) or Boost Date even. If they are suitable then it is not too difficult to link them up to C# via the Managed C++ (aka C++/CLI).

Yes I agree quantlib is the best choice since it gets updated often enough when there is a change in holidays and covers most if not all countries with active trading being done there.Heck it even has Iceland which closed most foreign investments off in 2008.

Thanks Cuch & Hansi. Will check out QL.

QuoteOriginally posted by: HansiYes I agree quantlib is the best choice since it gets updated often enough when there is a change in holidays and covers most if not all countries with active trading being done there.Heck it even has Iceland which closed most foreign investments off in 2008.Good to see the influence of Irish (Vestmenn) monks on Icelandic holidays.

QuoteOriginally posted by: outrunforcing jan 1st to be on a monday?Iceland is brilliant!

Yeah I don't get that reference but January 1st is always a holiday.

QuoteOriginally posted by: HansiYeah I don't get that reference but January 1st is always a holiday.Maybe it means if Jan 1 falls on a Sunday you get Monday free?

It might do that in some countries but it doesn't apply in Iceland.

surya2cents, since you've mentioned you're also considering implementing in Python you may also be interested in PyQL (cleaner than SWIG-generated wrappers):http://dpinte.wordpress.com/2012/03/23/ ... k/Examples: https://github.com/enthought/pyql/tree/ ... lesThere's been a presentation about it at the New York Finance Python User's Group (NY FPUG):Slides: http://public.enthought.com/~kjordahl/F ... -2013Video:

IMO Python is OK for a prototype solution but lacks the robustness and efficiency of languages such as C# and C++. Correct me if I am wrong. How is the easiness of Python-Excel interop?One initial point is determining the provides-requires interfaces between your system and QL. This determines what you need to wrap in QL. See how R does itIn C#, you can do something similar 1. Wrapper C++/CLI class as in section 11.5 of our C# book. at the least I suppose you need isHoliday(Date) function?2. You will probably need to create a converter between QL Date and .NET DateTime. OK3. C# - Excel is an advantage (e.g. Excel-DNA)Of course, there are many other solutions and this is one of them. Choosing the one that best suits you is not diissimlar to a constrained optimisation problem in ISO 9126 space.

QuoteOriginally posted by: CuchulainnIMO Python is OK for a prototype solution but lacks the robustness and efficiency of languages such as C# and C++. Correct me if I am wrong. How is the easiness of Python-Excel interop?I'd say they are now a days pretty similar in terms of ease of use and robustness. Speed is still an issue for Python though, but development speed somewhat offsets that.For normal interop there are COM wrappers and for an Excel-DNA "equivilent" there is PyXLL