SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : DATEK Web Pages -- Ignore unavailable to you. Want to Upgrade?


To: Wolfgang Schoenle who wrote (115)8/20/1998 10:11:00 PM
From: Jon Tara  Read Replies (1) | Respond to of 205
 
Orders from Excel would be doable, but it sure sounds dangerous!

The "order" part would not be too difficult. I'm not very familiar with Excel, but I know you can use it to send DDE commands, and probably OLE automation.

You could write a server to receive these commands, and generate the order. Microsoft provides some pretty good tools now for talking to web sites. Though I avoid Visual Basic (I'm a C++ programmer) VB might be a good choice for writing this, as you can use it to write OLE controls.

Actually confirming orders, though, is a bit tougher. You'd have to poll Datek the check messages, and then parse the messages to see when/if your order was executed.

Not something that I want to do, but it could be done.