Currency Holiday Output

Question

Hi,

Situation 1

How to create an output such that if its a DKK ccy holiday today (assume today is 27th June) then the start date and end date comes as below - ie No

Settle cycleCcyStart DateEnd DateT1DKKNoNo

Situation 2

If theres say a MXN and DKK holiday tomorrow (assume tomorrow is 28th Jun) then the start and end Date outputs as below : since MXN has a T0 cycle its today to day after tomorrow (next normal day (non-public holiday) - if theres a holiday the next day as well then it shd skip that day as well)

since DKK has a T1 cycle then its day after tomorrow (not a DKK public holiday) to the next day (not a DKK public holiday).

Settle cycleCcyStart DateEnd DateT0MXN27-Jun-202229-Jun-2022T1DKK29-Jun-202230-Jun-2022

Start and End Dates shd skip Saturdays and Sundays

Is this possible on Alteryx? Attached the holiday calendar.

Holiday Calendar.xlsx

clarrock · Answer

@MatthewO Thanks for sharing the worflow
I looking for an output like below :

Today is 30th Juneand as per the file tomorrow it is a CAD holiday which has a T0 settlement and HKD which has a T1 settlement

(to explain T0 and T1 in a situation with no holidays, T0 means today start to tomorrow end and T1 means tomorrow start to day after tomorrow end)

Alteryx output shd be below for 30th June run :

CcySettle CycleStart DateEnd DateCADT02022-06-302022-07-04HKDT12022-07-042022-07-05

Tomorrow when i run i,e on 1st July the output would be below :

CcySettle CycleStart DateEnd DateCADT0NoNo*HKDT1NoNoUSDT02022-07-012022-07-05**CZKT12022-07-042022-07-06***

*No as its a holiday (cycle doesnt matter)

**04th is a USD holiday

***05th is a CZK holiday as in the file

Is this possible on Alteryx?

MatthewO · Answer

@clarrock attached is an example of how you can approach this using Alteryx. I hope this is helpful!

CurrencyHolidays.yxzp

DanM · Answer

@clarrock

I'm making the assumptions that you're using DateTime fields and not String fields for this suggestion. You could join your calendar data with the data you are working with (again assuming) and write conditional statements to create the time frames by using the date time add function. Something like, if column 1 equals column 2 then datetimeaddfunction depending on the situation. You may also have to write a conditional statement for each situation you mentioned and any other that may cause your dates to change.

I'm not familiar with the acronyms you are using and I would suggest not using acronyms when posting your questions as users may not understand them without effort and may shy away from assisting.

Suggested help - https://community.alteryx.com/t5/Interactive-Lessons/Writing-Conditional-Statements/ta-p/98910

and https://community.alteryx.com/t5/Interactive-Lessons/DateTime-Functions/ta-p/98952