|
PureBytes Links
Trading Reference Links
|
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" <sonyfanaticsss@xxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
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 amibroker@xxxxxxxxxxxxxxx, "sidhartha70" <sidhartha70@xxx> 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 amibroker@xxxxxxxxxxxxxxx, "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 amibroker@xxxxxxxxxxxxxxx, "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: <amibroker@xxxxxxxxxxxxxxx>
>> > > 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 amibroker@xxxxxxxxxxxxxxx, "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
>
>
>
------------------------------------
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
<*> 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/
|