0

I have try to combined stock chart and line graph using excel. But it cannot do. I can draw Stock chart and line graph separately. Is anyone know a way to darw stock chart and line chart in same plot. X axis is same. If you can do this using Matlab, it also okay.

brettdj
  • 54,857
  • 16
  • 114
  • 177
Vajira Karunathilake
  • 55
  • 2
  • 6

2 Answers2

2

Yes you can plot in MATLAB.

To have a candlestick plot and a line plot of closing prices in the same chart,

candle(HighPrices, LowPrices, ClosePrices, OpenPrices)
hold on
plot(ClosePrices)

HighPrices, LowPrices, ClosePrices, OpenPrices are all columns. The hold on command is to let you plot multiple graphs in the same figure.

candle is for making stock-charts and plot by default makes line charts.

Refer to the MATLAB documentation on the MathWorks website for more clarity.

Adarsh Chavakula
  • 1,509
  • 19
  • 28
0

Combining a stock chart and line graph using Excel without VBA is not possible:

SO24585292 example

pnuts
  • 58,317
  • 11
  • 87
  • 139