This looks very nice...!
Please tell me if it be used to have Excel display and refresh a .csv file that is maintained from afl?
I already have all my data in csv files. I just want to display them, add some calculations, charts, etc.
many thanks,
herman
Thursday, March 26, 2009, 2:25:10 PM, you 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@xxxxxxxxx ps.com <mailto:amibroker% 40yahoogroups. com>,
>> "droskill" <droskill@xxx> 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@xxxxxxxxx ps.com
>> <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.amibroke r.com/feedback/
> (submissions sent via other channels won't be considered)
> For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG:
> http://www.amibroke r.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@xxxxxxxxx ps.com
> mailto:amibroker- fullfeatured@ yahoogroups. com
> <*> To unsubscribe from this group, send an email to:
> amibroker-unsubscri be@xxxxxxxxxxxx com
> <*> Your use of Yahoo! Groups is subject to:
> http://docs. yahoo.com/ info/terms/