Plot Excel Time Series,date without weekend and holidays in Matlab

Hi all, I was just wondering if there is a way to Plot Excel financial Time Series,date without weekend and holidays in Matlab? I had a look at other questions(Datenum etc) but none of them help with my situation.Please help!

Answer 1

[BhaTTa]

Hey @Kristy Kwok, you can achieve the above functionality in MATLAB, Please follow the below steps

1. Read the Data using 'readtable' or 'xlsread'
2. Convert Dates into MATLAB 'datetime' format
3. You can remove weekends by logical indexing for holidays you can have seperate holiday list that can be used to compare and remove holidays from our table

Hope it helps.