Plot Stock Chart and Overlay Remaining time series from Excel Worksheet
2 views (last 30 days)
Show older comments
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):
ANY HELP IS HUGELY APPRECIATED!
D
2 Comments
Fangjun Jiang
on 18 Sep 2011
What do you mean "overlay"? The code has the 'hold on' line so all curves are plotted in the same figure. Is that "overlay"?
Accepted Answer
Fangjun Jiang
on 18 Sep 2011
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 Comments
Fangjun Jiang
on 19 Sep 2011
The link requires registration so I won't do it. To show the date in x axis, use the following example:
%%
Time=(1:10)+now;
plot(Time,1:10);
a=gca;
xtick=get(a,'xtick');
xticklabel=datestr(xtick,'yyyy/mm/dd');
set(a,'xticklabel',xticklabel);
More Answers (0)
See Also
Categories
Find more on Line Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!