PDA

View Full Version : Live Data over network



mark.miller9
04-25-2008, 08:35 AM
I have built some vba macro code that constantly updates from vols, prices and depth pulled from my trading software that I want to broadcast over the netowrk to make my theos available to other users in my office. I could let them have my spreadsheet and would work fine as they run the same trading software, but would rather not give up my pricing models. I am still new at VB coding and wanted to find out if this was possible and if there are any good resources on how to do this.

Thanks

Bob Phillips
04-25-2008, 08:36 AM
Why not just drop it into a database, and give them an Excel addin to pull the data from the db into Excel?

mark.miller9
04-25-2008, 08:42 AM
Is it possible to update real-time (or very near to real time) doing this as this is what will be essential, if so, am assuming this will be ODBC and linking to excel?

Thanks

Bob Phillips
04-25-2008, 09:11 AM
You can make it as real-time as you desire if you put enough effort in. I wasn't thinking ODBC, more ADO with OLEDB, but that is on a very cursory piece of information.