STREAMING REAL TIME DATA FROM EXCEL TO MATLAB

Question

Ciro 2020-2-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505475-streaming-real-time-data-from-excel-to-matlab

评论： Abbas HAMADE 2021-3-18

RT_DATA_IN_EXCEL.zip

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jacob Wood 2020-2-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/505475-streaming-real-time-data-from-excel-to-matlab#answer_415615

编辑：Jacob Wood 2020-2-14

在 MATLAB Online 中打开

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.

https://www.myonlinetraininghub.com/real-time-data-excel-using-sockets

https://www.mathworks.com/help/matlab/ref/tcpclient.read.html

2 个评论
显示无隐藏无

Ciro 2020-2-17

Dear Jacob,

thanks for your prompt reply; the table generated with xlsread is static and does not update in real time. Moreover the loop you have suggested keep the Matlab busy indefinitely showing (disp(d)) always the same values aquired in the beginning. In addition I get 'NaN' values for all the cells whose values are dinamically updated in the excel.

For the second solution you have proposed, which foresees the excel to stream the data in a socket, I'm still evaluating it; It could be a solution. I'll keep you updated.

Thanks!

Ciro

Abbas HAMADE 2021-3-18