Path: news.mathworks.com!not-for-mail
From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: What is the best way to import Excel files, with stock data, into Matlab? I’m using Matlab R2010b (64-bit)
Date: Fri, 27 Apr 2012 03:19:08 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 20
Message-ID: <jnd37c$a85$1@newscl01ah.mathworks.com>
References: <jnc9v7$1ot$1@newscl01ah.mathworks.com> <jncmr3$o02$1@newscl01ah.mathworks.com>
Reply-To: <HIDDEN>
NNTP-Posting-Host: www-01-blr.mathworks.com
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: newscl01ah.mathworks.com 1335496748 10501 172.30.248.46 (27 Apr 2012 03:19:08 GMT)
X-Complaints-To: news@mathworks.com
NNTP-Posting-Date: Fri, 27 Apr 2012 03:19:08 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 2921053
Xref: news.mathworks.com comp.soft-sys.matlab:766086

Thanks, TideMan.  I tried this:
[a,b] = xlsread('XLSFile','stock_data.xls');

I got this error message:
??? Error using ==> xlsread at 219
XLSREAD unable to open file XLSFile.
File C:\Program Files\MATLAB\XLSFile.xls not found.

I need to look into this a bit more.

Basically, I think my question boils down to this. I can import the data, with no indication of which stock is which, and no dates, but the plots work perfect. I can import the data with dates and headers and values, but I can't PLOT anything.

There must be a simple thing that I'm missing. There must be a simple work-around, right.

I'd really like see the prices on the Y-Axis and see the dates on the X-Axis. How can I do that? it must be simple, right.

Thanks, everyone!!

"per isakson" wrote in message <jncmr3$o02$1@newscl01ah.mathworks.com>...
> Do you have the Statistical Toolbox?