thanks a lot for your hints and thoughts. I was already contemplating your second suggestion, to run an AFL and save data as .csv files. This would be feasable if I wanted to do this as a one-time thing. However, I intend to repeat the queries in regular intervals, such as every 5 minutes. In thus this would not be the best way to go. I am not sure whether mentioned API would do the job, I also read the user manual and as I am not as knowledgable in coding as some of you guys here I could not make much sense of how to access specific time series and in what format they would be retrieved. I will keep on trying but looks like nobody here has tried to attempt something similar before.
Let me work on the broker.application object, maybe I can get something useful out of it.... --- In [email protected], "Mike" <sfclimb...@...> wrote: > > I don't know that you'll be able to get to the AmiBroker database without > controlling AmiBroker itself. By "control" I just mean that you will likely > need to instantiate an instance of the AmiBroker automation object (of type > Application) as shown in the link that I sent you. > > I've used the API, but not to do what you are trying. There are examples in > the guide for how to instantiate an instance of the Application object. >From > there it's all trial and error until you get it to do what you want. > > The documentation is VERY sparse in this area. For example; The GetTickerList > function on the Stocks object takes an argument, but there is nothing telling > us what the argument is supposed to be (presumably the number of a > Watchlist). Assuming that you can figure that out, you'll get a string, but > what delimiter is used to separate the stocks within the string (presumably > comma separated). etc. > > Once you've got the Application object it looks like you could then use the > API to gain access to the Stocks object, from which you can get an individual > Stock object from which you can get all Quotations from which you can select > the desired individual Quotation objects and on and on. > > If this is a one time periodic update, you would likely have a far easier > time by just writing a simple AFL script that generates a .csv file, run the > .afl and then load the resulting .csv into Excel. > > If you are not 100% sure about whether your intent is going to work out, I > would suggest starting with the .csv approach first, as proof of concept. > Only then would I spend the time/frustration trying to get the automation to > do what I wanted. At a minimum, writing the .afl will solidify exactly what > you need the automation to mimic. So, it would not be wasted effort. > > Mike > > --- In [email protected], "BBMAT" <bbmat@> wrote: > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > >
