Why am I unable to read live data from excel using XLSREAD?

I have an excel sheet that gets live data feed from Bloomberg. When I use XLSREAD to read the data, I get only 'NaN's in the output. However, I am able to read historical data without any problems.

Answer 1

[MathWorks Support Team]

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:

https://www.mathworks.com/products/datafeed.html