STREAMING REAL TIME DATA FROM EXCEL TO MATLAB
12 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Dear all,
I have an excell spreadsheet feeded in real time trought a DDE from a trading platform, my aim is to stream the real time data from excel to Matlab. Matlab DDE functions are not available in my version which is R2018a, so I can't stream the data directly in Matlab without pass through excel.
The data in excel is available in a table in which the value of all cells vary over time without a defined frequency; my aim is to acquire in Matlab the value "as it comes" from market. The acquisition of the data each "x seconds" (at a fixed sample frequency) is useless for my scope.
Attached there is a zip file which containes a short screen recorded video of 10 seconds which shows the excel table which I want to aquire; the video shows the dynamics with which the value in cell vary.
Is there a way to do what I intend to do?
0 comentarios
Respuestas (1)
Jacob Wood
el 14 de Feb. de 2020
Editada: Jacob Wood
el 14 de Feb. de 2020
One possibility - you can constantly read the Excel document with xlsread(); this will read in new values every time the Excel document is saved.
while 1
d = xlsread('test.xls');
disp(d)
end
Additionally, and likely a faster solution, would involve having Excel stream the data to a socket which Matlab is listening to.
2 comentarios
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!