Ray, ODBC would be the most stable way if you need data to be managed outside AB, this seems to be a conclusion from people here. The reason I'm using Excel is that I have some code logic written in VBA format. Excel is not really used for keeping data in my case.
Regards, abxlab --- In [email protected], "raymondpconnolly" <raymondpconno...@...> wrote: > > > > Hi, > > I'm anticipating a similar situation to what you describe in the not to > distant future although I probably will not be using Excel as the database. > I was considering using ODBC and Acess as the DB. I have not done this yet > so I don't know the details of an ODBC implementation. There is an ODBC > plugin for AB [http://www.amibroker.com/odbc.html] and the VBA object model > supports OBDC. > > Other options I'm considering and which you may want to look into are: > Static variables, Osaka plugin, and Berkeley DB > [http://www.oracle.com/database/berkeley-db/db/index.html]. > > I have not yet implemented any of these methods they are just the options I > have considered based on searching this forum for possible solutions to the > issue of database functionality for data that is not OHLCVOI. > > Regards, > Ray > > --- In [email protected], "amiespresso" <w2jchen@> wrote: > > > > > > Hello folks, > > > > > > > > I've been searching for a solution for quite a while and explored all > > what I could get, now I feel it's time to ask for help after enough > > homework done with no luck... > > > > > > > > To put it simple, I'd like to have AB exchange data back and forth with > > an OPENED Excel file. Is it all possible? > > > > > > > > To illustrate it more, I need a bridge b/w AB and Excel so that AB could > > exchange data with Excel using Scan/Explore, or even during Backtesting > > execution. The tricky part here is - I have the Excel worksheet opened, > > for example, Sheet1 is for AB to dump something there, while Sheet2 has > > my VBA code. And hopefully I still should be able to interact with Excel > > while AB "talking" to THIS Excel instance. > > > > > > > > Here I tried the following: > > > > 1) XLPlugin - It looks like a right solution by moving data thru memory > > copy between AB/XL. However after spending many days on this direction, > > I was blocked by things I couldn't fix without its source code. > > Basically, its sample.xls couldn't execute properly if AA has > > Periodicity set as any non-Daily value. XLCase() doesn't work if for > > example I run Scan/Explore on Hourly bars, which seem so strange. My > > only guess is VB.net changed its RtlMemoryCopy() used by XLPlugin. This > > function now has different signature from VB6, which may break things > > somehow. > > > > > > > > 2) I tried some sample code that uses "Excel.Application" > > syntax. The problem here is that AB will initiate another copy of Excel, > > NOT the one I opened with something loaded already. It's OK to > > create a new sheet, load it with something, save it and close. But I > > need interaction with my current Excel. > > > > > > > > 3) Plain text or CSV file from AB to Excel is straightfoward, but > > it's not capable of doing quick data exchange between AB and Excel. > > > > > > > > Can anybody here to enlighten me with some idea or code if you ever > > faced similar problem and resolved it? > > > > > > > > Your input is much appreciated! > > > > > > > > > > > > P.S. my envrionments > > > > Windows XP and/or Windows 2003 Server Std Edition > > > > Amibroker v5.20 > > > > Office Professional Edition 2003 > > > > Visual C++ 2005 Redistributable > > >
