Much better and faster solution is to use for example AA "scan every" and use AddToComposite / Foreign to store / retrive data.
Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "sonyfanaticsss" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 26, 2008 12:51 PM Subject: [amibroker] Re: Hitting the AFL execution limit? > Hi Sidhartha70, > > The afl script took 0.6561 sec to execute. And that's with less symbols. > > I just found a way to deal with the problem: > > The Excel.Application.Run method blocks, but WshShell.Run doesn't. So > I simply do this in AFL: > > WshShell = CreateObject("WScript.Shell"); > WshShell.Run( "D:\afl\system2a\invoke.vbs"); > > invoke.vbs then call Excel.Application.Run("some macro"). > > Data between Amibroker and Excel are exchanged via text files. > > Thanks a lot to everyone! > > > > --- In [email protected], "sidhartha70" <[EMAIL PROTECTED]> wrote: >> >> If you goto preferences>miscellaneous and select 'show chart >> timings'... how long does the chart is question take to redraw?? It >> should tell you once you have selected this option. >> >> What type of database are you using...? What data provider? What >> resoltuion of bars (i.e. tick or 1 min etc)...? >> >> >> --- In [email protected], "sonyfanaticsss" >> <sonyfanaticsss@> wrote: >> > >> > Hi Tomasz, >> > >> > I'm aware that afl is faster than excel macro. But I've already done >> > an afl implementation of this code and it slows down the other chart >> > significantly. >> > >> > The idea is that porting this code would allow Amibroker to do its >> > stuff and Excel to do some other stuff, simultaneously. >> > >> > The Excel.Application.Run method obviously is not the right choice... >> > I wonder if there's any other way round? >> > >> > Thank you. >> > >> > >> > --- In [email protected], "Tomasz Janeczko" <groups@> wrote: >> > > >> > > I don't think it is good idea. >> > > Excel will be many times SLOWER than AFL. >> > > And of course any script .RUN waits until completion. >> > > >> > > Best regards, >> > > Tomasz Janeczko >> > > amibroker.com >> > > ----- Original Message ----- >> > > From: "sonyfanaticsss" <sonyfanaticsss@> >> > > To: <[email protected]> >> > > Sent: Tuesday, August 26, 2008 5:48 AM >> > > Subject: [amibroker] Re: Hitting the AFL execution limit? >> > > >> > > >> > > > Hello, >> > > > >> > > > To solve the problem mentioned in the post below, I've ported >> the code >> > > > to Excel. A AFL formula is used to open Excel and run the macro >> (with >> > > > vbscript). >> > > > >> > > > But now I have a new problem. Amibroker seems to halt until the >> macro >> > > > finished its calculation. And if the macro takes too long to > finish, >> > > > Amibroker will popup a dialog box asking me to either "switch >> to" that >> > > > application, or "Retry". >> > > > >> > > > I think the problem is in the OLE vbscript, because the >> > > > Excel.Application.Run("some macro") method do not return until the >> > > > macro is finished. >> > > > >> > > > I wonder if anyone can help? >> > > > >> > > > Thank you. >> > > > >> > > > >> > > > >> > > > --- In [email protected], "sonyfanaticsss" >> > > > <sonyfanaticsss@> wrote: >> > > >> >> > > >> Hi, >> > > >> >> > > >> I've 6 formulas running in my active window now, and when I >> > scroll the >> > > >> chart with my mouse button there is a very noticeable lag in the >> > > >> redraw speed. The top chart draws first and the bottom chart >> last. I >> > > >> think it takes almost one second for the bottom chart to update >> with >> > > >> new plots and values. >> > > >> >> > > >> I wonder if I have hit the AFL execution limit, or is this just >> > normal >> > > >> phenomenon? >> > > >> >> > > >> Thank you very much for your help. >> > > >> >> > > > >> > > > >> > > > >> > > > ------------------------------------ >> > > > >> > > > Please note that this group is for discussion between users only. >> > > > >> > > > To get support from AmiBroker please send an e-mail directly to >> > > > SUPPORT {at} amibroker.com >> > > > >> > > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: >> > > > http://www.amibroker.com/devlog/ >> > > > >> > > > For other support material please check also: >> > > > http://www.amibroker.com/support.html >> > > > Yahoo! Groups Links >> > > > >> > > > >> > > > >> > > >> > >> > > > > ------------------------------------ > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > Yahoo! Groups Links > > >
