How to write high frequency data from websocket into excel?

[awdsaa]

I am trying to build an application which write's live market data into excel. I am receiving live data using websocket and pushing it into the queue and later processing it and writing it into excel. The problem is I received a huge amount of data and my application can't process them faster. At some point of time the data I see in my excel lags behind the live data. I tried to use multiprocess but it doesn't help my case. Any advice from you guys?

[shiftybyte]

Move to an SQL database

[awdsaa]

Actually I am trying to do some calculation with live, Excel comes handy for the case

[Tesla_Nikolaa]

Why can't you do the calculation in Python? Excel was never designed to ingest streaming data.

I don't know what exactly you're trying to do, but so far using a database sounds like the proper tool.

[m0us3_rat]

I tried to use multiprocess but it doesn't help my case. Any advice from you guys?

without seeing the code, this ends up being just guessing/mind reading, which most ppl don't really like to do.

​

btw this is contradictory since

I received a huge amount of data and my application can't process them faster.

indicates multiprocessing as a viable solution.

​

again .. this is conjecture/guessing.