Why am I unable to read live data from excel using XLSREAD?
2 views (last 30 days)
Show older comments
MathWorks Support Team
on 27 Jun 2009
Edited: MathWorks Support Team
on 2 Feb 2017
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.
Accepted Answer
MathWorks Support Team
on 2 Feb 2017
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:
0 Comments
More Answers (0)
See Also
Categories
Find more on Data Import from MATLAB 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!