XLSREAD returns 'NaN' for all the cells that are not numeric. In this case, the issue is the excel sheet accessed by XLSREAD is not getting saved after being updated with data from the live server.
To workaround this, please save the Excel sheet,everytime before data is read. In order to do this, you can use Excel's API.
To directly get live data into MATLAB bypassing Excel, use the Datafeed Toolbox. The toolbox enables you to:
-Retrieve and analyze a wide variety of security data from financial data servers in MATLAB.
-Access market, time-series, and historical market data in MATLAB.
-Monitor the status and history of each connection to a supported data service provider.
-Fetch data fields for multiple securities in a single call.
-Look up security ticker symbols from the toolbox GUI or the MATLAB command line.
Please visit here to read more about this toolbox:
