Hello, You *can* send data from AmiBroker to excel. Just write a macro in Excel that uses Broker.Application object - this not only allows to access data, but also allows you to run backtest/exploration, export charts and lots of other things. You can also use AmIBroker's built in OLE support to write values to Excel cells directly. http://www.amibroker.com/library/detail.php?id=218 (the sample has VBScript part for historical reasons, but the same can be written in native AFL as well now)
Also with AFL you can create for example XML files using fopen/fputs/fclose. Then XML files are native in Excel and they can be read using VBA/macros as well. DDE is outdated technology. Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "scourt2000" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, January 09, 2007 2:03 PM Subject: [amibroker] Re: DDE Excel > >> Frankly I see NO reason connecting via excel > > The reverse is not true though. I see GREAT VALUE in being able to > setup a DDE communication between Excel and Amibroker so that > Amibroker can send script variable information easily to Excel for > further display/calculation/analysis. Notice that I didn't > say "streaming real-time data from a data provider." > > eSignal does this easily: > > var val = new DDEOutput("dataForExcel"); > > val.set(1245); > > In Excel, this exposes the current value from the eSignal chart > script: > > =eSignal|EFS!dataForExcel > > Excel is a more powerful application from which to display and > organize complex data that is not in the form of a stock/futures > chart. > > Steve > > [yes, I know. There is a request for this already in the Amibroker > suggestion database...from me] > > > > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > > Yahoo! Groups Links > > > > >
