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
there's a few ways in which you could do this. maybe this can be done through a DDE, although Im not sure. I've used ddE to share data to/from excel to/from 3rd party programs but havent used it from excel to excel. if you need the "other workbook" to be exactly the same, then maybe you can use drop box to synchronize them. (install dropbox on both machines and then update on one and dropbox will update the other side -- im not sure if this would be fast enough) you could also do this trhoguh a cmd script by sharing the folder that has the original excel between both machines and having a script make a copy of the file at periodic intervals... or... you could go with a solution using MySQL as a middleman between the 2 documents
thanks for your suggestions. I don't think dropbox will work because once it's open on the other side it won't update unless you close it and reopen it again which won't work for me. I think using mySQL as a middleman is probably the way to go. Need to investigate that further. AS for using VBA, not really sure how you could accomplish this but if you've seen it please do tell.
it's easy with vba. 1. implement on cell changed event. http://www.excel-easy.com/vba/events.html updates from feed will trigger this event. 2. simply copy the cell values over. workbookB.cell.value = workbookA.cell.value 3. profit
have a look at QuoteLink. Its main feature is handling data feeds such as IB or IQFeed, but it also lets you publish your own data using RTD. So communication between Excel instances is just one use case (as long as they are both on machines within your private network)
Yeah I get what you're saying however it wouldn't be possible because i need the data streamed from one computer to another so how do I link up the computers is the big question.