Plot Stock Chart and Overlay Remaining time series from Excel Worksheet

Question

Dima 2011-9-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16076-plot-stock-chart-and-overlay-remaining-time-series-from-excel-worksheet

Hello!

I am trying to plot data from Excel in Matlab...

I wonder if it is possible to plot a stock chart, from the stock data and then add more time series over it??? I have the following code to plot different time series from excel file (from http://www.mathworks.com/matlabcentral/answers/15871-plot-multiple-time-series-based-on-individual-condition):

%% [Num,Txt,Raw]=xlsread('test.xls'); colors = {'r', 'k', 'g'}; %red, black, green linetypes = {'--', '-'}; %dashed, solid figure(1);hold on; for k=2:23 plot(Num(4:end,1),Num(4:end,k),[colors{Num(1,k)},linetypes{Num(2,k)}],'linewidth',Num(3,k)); end

I wonder if the the stock-chart plot from financial toolbox can be used to plot 4 first time series from the following worksheet( and then the remaining time series to be overlaid over it):

http://ifile.it/b51vhul

ANY HELP IS HUGELY APPRECIATED!

D

2 个评论
显示无隐藏无

Fangjun Jiang 2011-9-18

What do you mean "overlay"? The code has the 'hold on' line so all curves are plotted in the same figure. Is that "overlay"?

Dima 2011-9-18

glad to hear again form you...I mean that the first four series are actually the open high low close prices of a stock chart....and I see that they can be plotted as a candlestick chart by a special function in Matlab...I think it is as follows:

candle(HighPrices, LowPrices, ClosePrices, OpenPrices)

I need to plot those former time series over a candlestick chart based on the first four columns of this dataset (test.xls). I hope this is win in the boundaries of Matlab capabilities)

Hope to hear from you soon!)

D

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Fangjun Jiang 2011-9-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/16076-plot-stock-chart-and-overlay-remaining-time-series-from-excel-worksheet#answer_21804

在 MATLAB Online 中打开

Make your program flow like this:

f=figure;hold on;
candle(....)

Then run the previous code with the 'figure(1);hold on;' line.

Type help figure or doc figure to lean how to create new figure or use existing figure for plotting.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Dima 2011-9-18

BTW as you can see on this chart (http://ifile.it/1zwk43i) each line start is accompanied by an upward vertical line - I wonder if there is a way to remove that? thanks!)