How do I add a new column to a table which is a binary or intiger depending upon if the Date is a holiday or not?

I want to create a new variable called Holiday which is equal to an integer of my choosing depending upon if the Date in the same row of the table is a holiday or not. Some holidays mean more than others for this model so I want to return an integer of differing values for different holidays if possible. 4th of july would be a 3 (for example) and Veteran's Day would be a 1.

[Guillaume]

You already know how to add a column to a table. So just go ahead and do it. I'm not sure what it is you're asking. If it is how to identify a holiday, as far as I know there is no such function in matlab so you'll have to write one yourself. If you need help with that, you need to give a lot more details on what dates you consider a holiday.

[per isakson]

• The financial toolbox has a function, holidays, (Holidays and nontrading days).
• google "bank holiday" and notice it's different for nearly every country.

[T4H14]

Thank you. Yes I'm looking to assign a 1 to a variable if a date is a US Bank holiday and then if it is also a NERC holiday I want to add 1 to that variable so the results are either 0, 1 or 2.

[T4H14]

yes I was looking at the holidays function but that only seems to return the number of holidays between two dates rather than identify if a date is a holiday or not. Maybe i'm missing something though.

[per isakson]

• AFAIK: info on holidays is not available in Matlab, except for the financial toolbox where the number of trading days is important.
• I once made a function for Sweden. I found the data I needed on a governmental web-page.
• See the thread NERC holiday calendar

[Peter Perkins]

T4H14, you probably want to use a categorial variable with categories named something like Non-Holiday, US-Holiday, and NERC-Holiday.

Answer 1

[Walter Roberson]

https://www.mathworks.com/help/finance/isbusday.html

In a table data structure, the only way to have a column which could be either logical or integer is to use a cell array so that each entry in the column can contain a different data type.

However, your description of using either 0, 1, or 2, would be integers, and you do not need anything special for integers. Adding two logicals gives an integer (a double).

Question: is it possible for something to be a NERC holiday but not a US Bank Holiday?

[T4H14]

No. it's not possible for something to be a US Bank Holiday and not a NERC holiday. NERC holidays is a subset of US Bank Holidays.

[T4H14]

NERC Holidays are just:

• New Years
• Memorial Day
• Independence Day
• Labor Day
• Thanksgiving
• Christmas