[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Interact with OPENED Excel worksheet, Possible?



PureBytes Links

Trading Reference Links


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 amibroker@xxxxxxxxxxxxxxx, "amiespresso" <w2jchen@xxx> 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
>




------------------------------------

**** IMPORTANT PLEASE READ ****
This group is for the discussion between users only.
This is *NOT* technical support channel.

TO GET TECHNICAL SUPPORT send an e-mail directly to 
SUPPORT {at} amibroker.com

TO SUBMIT SUGGESTIONS please use FEEDBACK CENTER at
http://www.amibroker.com/feedback/
(submissions sent via other channels won't be considered)

For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
http://www.amibroker.com/devlog/

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/amibroker/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/amibroker/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:amibroker-digest@xxxxxxxxxxxxxxx 
    mailto:amibroker-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    amibroker-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/