MATLAB: Cell array output format

cell array output formatMATLAB

>> sim_ret_table.L1Op

ans =

    'BUY'
    'SELL'
    'BUY'

That is the output when I try to view the contents of column L1Op in table sim_ret_table; the original vector I used to make the table was a cell array. Would it be possibile to "hide" the apostrophes?

Best Answer

v={'BUY'
  'SELL'
  'BUY'}
char(v)

Related Solutions

MATLAB: Is there any way to change an array output to display a word or phrase

jStr = repmat( { 'Buy' }, numel( j ), 1 );
jStr( j == -1 ) = { 'Sell' };

I'm sure there are neater ways, but that should work.

MATLAB: Time series plot from structure array

but for the original data set tickers will have different number of dates so it will not be possible to put them in a table (I think?)

Not a problem, as long as there's good overlap between the date. If they're completely distinct then it may be a waste of time.

Using your demo test file:

%assuming that you have a structure stocks in the workspace
numdateperticker = arrayfun(@(s) numel(s.Date), stocks);
tickers = table(datetime(vertcat(stocks.Date)), vertcat(stocks.AdjClose), repelem({stocks.Ticker}', numdateperticker), ...
                'VariableNames', {'Date', 'AdjClose', 'Ticker'});
tickers = table2timetable(unstack(tickers, 'AdjClose', 'Ticker'))

Tickers for which there's no value for a date will get a NaN for that particular date.

Now to plot this for a given time range:

range = timerange('01-Jan-2016', '10-Apr-2018');  %whatever you want it to be
selectedtickers = {'AAPL', 'FB'};
tickersrange = tickers(range, :);
plot(tickersrange.Properties.RowTimes, tickersrange{:, selectedtickers});
legend(selectedtickers);

Or using stacked plots, even simpler:

range = timerange('01-Jan-2016', '10-Apr-2018');
selectedtickers = {'AAPL', 'FB'};
stackedplot(tickers(range, selectedtickers));

Best Answer

Related Solutions

MATLAB: Is there any way to change an array output to display a word or phrase

MATLAB: Time series plot from structure array

Related Question