I am running a model that produces a shock database with dseries. The database indicates that all series have a length of 142 data points. However, when I open a series in MATLAB I see only the beginning and the end of the series (please see a screenshot, I was unable to attach it). In a debug mode I see that series do have all the data. How can I open I see the full data of a series? How can I load dseries into Excel.
.data operator can be used to print out the data. To write to Excel, use
jpfeifer thank you, it loaded the data into an excel file but dates and dseries names are missing, is there a way to fix it. thank you.
jpfeifer thank very much. It worked.
I just modified your answer so the name vector does not overwrite the data by transposing it before writing. My dseries are in ss.mat.
% copy ss data into data.xlsx, ss-sheet
if exist(‘data.xlsx’, ‘file’)==2