Could you have both excels connect directly to the datafeed (or perhaps it only lets one computer connect to the feed at a time)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to stream Excel data from one comp to another
- Thread starter rolando87
- Start date
you wont get around this without programming. What you need to do is to have a centralized place (via API preferably) that captures data. You then stream the data to an RTD server (yes, google it please if you dont know what it is). You can then access the rtd server from within Excel from any machine on the internet that you like. You can actually have the data streamed to as many machines as you like (well there are some constraints but it certainly handles 2 machines ;-)
I do not see another around it.
Well, a quick and dirty solution (yes dirty!!!) is to capture the incoming data on one machine's Excel spread sheet via VBA events, then write the data to a file (spreadsheet format/text/csv/whatever, but file must be shared by other machine), and on the other machine you periodically read the file to update the data. But again, that is very dirty and I do not recommend it.
I do not see another around it.
Well, a quick and dirty solution (yes dirty!!!) is to capture the incoming data on one machine's Excel spread sheet via VBA events, then write the data to a file (spreadsheet format/text/csv/whatever, but file must be shared by other machine), and on the other machine you periodically read the file to update the data. But again, that is very dirty and I do not recommend it.
Hey folks, maybe you guys can help me with this.
I need to transfer streaming excel data from one computer to another via the internet. The data is a live quote stream from CQG's excel feed and need that same data to appear on another Excel workbook in a different computer without too much lag maybe a few seconds or a min at most is reasonable. Basically whatever updates in one excel cell should update quickly in another excel cell on another computer.
Anyone know software that will help me accomplish this, free or paid? Thanks
You can do that, or even simpler, stream it to a messaging bus or in-memory database, something that can be accessed from the outside as well. I highly recommend Redis for that (http://redis.io/). But not sure whether anyone has done work with it in VBA space. Good luck.
Cool thanks for that suggestion. I was leaning towards some mysql type of solution, where i get a mysql server and upload to the server and then have the data stream to the other computer