|
Title: Re[2]: [amibroker] Re: Amibroker --> Excel?
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@xxxxxxxxxxxxxxx <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@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/
__._,_.___
**** 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/
![]()
__,_._,___
|