excellent, this looks VERY promising. I will have a try thanks a thousand!!!
--- In [email protected], "Yofa" <jtoth...@...> wrote: > > Old, but it looks like just what you want: > > http://www.amibroker.com/newsletter/01-2000.html > > Google this: "Broker.Application" amibroker Quotations Retrieve > You might find more examples > > As far as I remember if you access automation, you generally take over the > control from the UI... > So I'm not sure how it works on real time databases. > > Y > > > -------------------------------------------------- > From: "BBMAT" <bb...@...> > Sent: Friday, March 27, 2009 9:35 PM > To: <[email protected]> > Subject: [amibroker] Re: Amibroker --> Excel? > > > thanks, but any pointer to get started? I am not too familiar with the > > interface and structure though I can code a bit. You would not know of any > > sample code that accomplishes something similar to what I try to achieve? > > Again, I dont try to control Amibroker out of VBA/VB scriot, but I try to > > attain access to the Amibroker database from VBA/VB script alone. > > > > Thanks > > Brian > > > > > > --- In [email protected], "Mike" <sfclimbers@> wrote: > >> > >> If you are comfortable writing VB script for your macro, you can very > >> likely do what you want by coding against the AmiBroker automation > >> object. > >> > >> http://www.amibroker.com/guide/objects.html > >> > >> Mike > >> > >> --- In [email protected], "BBMAT" <bbmat@> wrote: > >> > > >> > I took the time to screen old messages for posts about ODBC and Excel > >> > but I could not find what I was looking for. Basically all proposed > >> > solutions deal with how to extract data from other databases into AmiB. > >> > However, I look for the opposite. Having Amibroker running, I basically > >> > want to extract a time series for a specified ticker and start time - > >> > end time from the Amibroker Database into Excel or VBA (as array). I > >> > dont want to have to run an AFL or so. I simply want to run a macro in > >> > VBA which then communicates with Amibroker to extract the data and > >> > loads them directly into a specified array. > >> > > >> > Is this at all doable or am I asking for something that has not been > >> > done yet? > >> > > >> > Thanks a lot for all your help and ideas!!! > >> > > >> > > >> > --- In [email protected], "ozzyapeman" <zoopfree@> wrote: > >> > > > >> > > 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" <droskill@> 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 > >> > > > > > >> > > > > >> > > > >> > > >> > > > > > > > > > > ------------------------------------ > > > > **** 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 > > > > > > > > >
