How to copy full data of a dseries

dseries/data/reporting
1

Hello,

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.

Thank you.

Argyn

2

The .data operator can be used to print out the data. To write to Excel, use

xlswrite('Excel_filename',dseries_name.data)
3

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.

4

Try

xlswrite('Excel_filename',double(dseries_name.dates),1,'A2')
xlswrite('Excel_filename',dseries_name.name,1,'B1')
xlswrite('Excel_filename',dseries_name.data,1,'B2')
5

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
delete(‘data.xlsx’);
end

load(‘ss.mat’);
xlswrite(‘data.xlsx’,double(sss.dates),‘ss’,‘A2’)
tmp=sss.name’;
xlswrite(‘data.xlsx’,tmp,‘ss’,‘B1’);
xlswrite(‘data.xlsx’,sss.data,‘ss’,‘B2’);