How do you combine multiple commands into a single code for one execution?
4 views (last 30 days)
Show older comments
I have been working on a side project for the past few weeks. I am analyzing a stock ticker (CHK) and I have plotted it into a figure using created 5 commands that import the data, convert the Excel serial dates into matlab serial dates, and plot. I want to automate this whole process using one command, i.e. importspreadsheet so I can do this for multiple stocks. How do I go about doing that?
Here are my commands:
importfile('chk.xls');
cDate = Date;
cDate = x2mdate(cDate, 0);
str = datestr(cDate, 1);
cDt = cellstr( str );
plot(cDate,DeltaP,'DisplayName','cDate vs. DeltaP','XDataSource','cDate','YDataSource','DeltaP');figure(gcf)
plot(cDate,DeltaV,'DisplayName','cDate vs. DeltaV','XDataSource','cDate','YDataSource','DeltaV');figure(gcf)
plot(cDate,Volume,'DisplayName','cDate vs. Volume','XDataSource','cDate','YDataSource','Volume');figure(gcf)
Thanks!
0 Comments
Accepted Answer
Matt Fig
on 2 Sep 2012
Follow these steps.
1) At the command line, type: edit
2) Paste your code into the blank document you opened in step 1
3) Save As --> importspreadsheet
Now at the command line, type: importspreadsheet
More Answers (0)
See Also
Categories
Find more on Interactive Control and Callbacks 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!