|
PureBytes Links
Trading Reference Links
|
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@xxxxxxxxx>
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@xxx> 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/
|