|
PureBytes Links
Trading Reference Links
|
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 amibroker@xxxxxxxxxxxxxxx, "BBMAT" <bbmat@xxx> 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 amibroker@xxxxxxxxxxxxxxx, "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 amibroker@xxxxxxxxxxxxxxx, "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 amibroker@xxxxxxxxxxxxxxx, "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
<*> 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/
|