Why am I unable to read live data from excel using XLSREAD?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
MathWorks Support Team
am 27 Jun. 2009
Bearbeitet: MathWorks Support Team
am 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.
Akzeptierte Antwort
MathWorks Support Team
am 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!