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

[amibroker] Re: Amibroker --> Excel?



PureBytes Links

Trading Reference Links

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@xxx> 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/