|
PureBytes Links
Trading Reference Links
|
Nice!
--- In amibroker@xxxxxxxxxxxxxxx, "Yofa" <jtoth100@xxx> 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" <bbmat@xxx>
> Sent: Friday, March 27, 2009 9:35 PM
> To: <amibroker@xxxxxxxxxxxxxxx>
> 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 amibroker@xxxxxxxxxxxxxxx, "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 amibroker@xxxxxxxxxxxxxxx, "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 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
> >
> >
> >
> >
>
------------------------------------
**** 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/
|