[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[amibroker] Re: Amibroker --> Excel?



PureBytes Links

Trading Reference Links

Thanks a lot guys for your response. I have not had the time to look into it as I just saw the responses but will do right away tomorrow. Will post feedback about my findings. Thanks



--- In amibroker@xxxxxxxxxxxxxxx, reinsley <reinsley@xxx> wrote:
>
> 
> XLPlugin.zip into Yahoo! AmiBroker User's List Files
> 
> BR
> 
> 
> ozzyapeman a écrit :
> > 
> > 
> > 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 <mailto:amibroker%40yahoogroups.com>, 
> > "droskill" <droskill@> wrote:
> >  >
> >  > Haven't looked at this myself but might be worth looking at:
> >  >
> >  > http://www.icc-az.com/ <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 
> > <mailto:amibroker%40yahoogroups.com>, "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/