Amibroker supports ODBC so you can apparently write directly to Excel. I'm not familiar with ODBC myself, but others on this forum, and the automated trading forum, have done exactly what you want to do.
Try a search for ODBC and excel on this forum (if Yahoo decides to cooperate this morning!). --- In [email protected], "droskill" <drosk...@...> wrote: > > Haven't looked at this myself but might be worth looking at: > > http://www.icc-az.com/ > > Under links - goto Amibroker - there is an Excel program for getting data > from AB. > > Don't know if it will do what you want but I thought I'd mention it. > > > --- In [email protected], "BBMAT" <bbmat@> wrote: > > > > Hello, > > > > I am wondering whether anybody has got experience with sending data out of > > Amibroker directly to Excel? Here is what I try to achieve: I like to > > specify a ticker and barsize as well as number bars and dump those from > > Amibroker directly into Excel, no manual saving of data into text files and > > then re-opening those files in Excel. Why Excel? I use those timeseries to > > perform computations, calculations of custom indexes and I like to the > > flexibility in Excel to display the results and numbers in a > > speadsheet-like way for my trading. So, I basically look for a way to get > > historical intra-day data directly into Excel. I use IB as broker but dont > > like the ActiveX and DDE solutions they provide. I figured because > > AMIBROKER already has got the data in an efficient database that it should > > not be a problem to simply specify a subset and dump it into Excel (can > > Amibroker use OLE, meanin control Excel, such as opening a sheet, and then > > writing some data from the database into the sheet?). > > > > Any help would be greatly appreciated. > > > > Thanks > > Thomas > > >
