Matlab中获取荷兰（欧洲）前一个工作日的方法咨询

Great question—regional holiday differences are such a tricky detail when calculating business days! The key issue with your current busdate call is that it's using the U.S. NYSE holiday calendar by default. To get the correct previous business day for the Netherlands, you need to swap in a Dutch holiday calendar instead.

Here's how to do this in common tools:

MATLAB Implementation #

MATLAB's busdate function lets you pass a custom list of holidays to override the default U.S. set. Here's the step-by-step:

• First, generate the official Dutch holiday list using the holidays function with the regional parameter:

  % Get all Dutch holidays for the relevant date range
  nl_holidays = holidays('Netherlands');
  

• Then, use this holiday list in your busdate call. The third parameter controls weekend days (default is Saturday/Sunday, which matches Dutch norms, so we can leave it empty):

  dy = busdate(floor(now), -1, [], nl_holidays);
  

  For your example date (2018-01-15): if you run this on 2018-01-16, it will return 2018-01-15 (since that's a normal workday in the Netherlands), whereas the default U.S. busdate would return 2018-01-12 (skipping the U.S. Martin Luther King Jr. holiday).

Python (Pandas) Implementation #

If you're using Pandas for financial date handling, you can leverage its built-in regional holiday calendars:

• First, import the necessary modules and create a custom business day offset tied to the Netherlands calendar:

  from pandas.tseries.holiday import get_calendar
  from pandas.tseries.offsets import CustomBusinessDay
  import datetime as dt
  
  # Load the pre-defined Netherlands holiday calendar
  nl_calendar = get_calendar('Netherlands')
  # Create a custom business day rule using Dutch holidays and standard weekends
  nl_business_day = CustomBusinessDay(calendar=nl_calendar)
  

• Calculate the previous business day:

  today = dt.datetime.now().date()
  previous_dutch_business_day = today - nl_business_day
  

General Tips #

• If your tool doesn't have a built-in Dutch holiday list, you'll need to manually define the official Dutch public holidays (New Year's Day, Good Friday, Easter Monday, King's Day, Liberation Day, Ascension Day, Pentecost Monday, Christmas Day, Boxing Day) and add them to your exclusion set.
• Always verify edge cases (like holidays falling on weekends, which are usually observed on the next/previous workday in the Netherlands) to ensure your calendar accounts for these adjustments.

内容的提问来源于stack exchange，提问作者WJA