Hmmmm thx for answer :) I want to make backtest a system and I can't write in ASL formula for this sytuation what I wrote you in previous mail....
________________________________ From: Herman <[email protected]> To: reinsley <[email protected]> Sent: Thursday, March 26, 2009 9:38:56 PM Subject: 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 amibro...@yahoogrou ps.com <mailto:amibroker% 40yahoogroups. com>, >> "droskill" <drosk...@...> 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 amibro...@yahoogrou 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
