|
PureBytes Links
Trading Reference Links
|
Tomasz,
The kind of things I'm doing in Excel are not possible to be done in
AB.
This includes running things like Monte Carlo simulations, creating
composite equity curves, calculating the various MCS statistics, etc.
I have written the code in VBA but would like to compile it for
performance reasons. I'm trying to determine if this VBA code can be
compiled into a dll that would be a COM add-in for Excel.
Thanks for the response.
HB
--- In amibroker@xxxxxxxxxxxxxxx, "Tomasz Janeczko" <amibroker@xxxx>
wrote:
> Hello,
>
> VBA is only a little bit faster than VBScript as neither one
> or another are compiled to native x86 code.
>
> My tests show that native AFL looping is 4-8 faster than
VBA/VBScript/JScript.
>
> So my advice is just to use AFL to write your functions
> if you don't want to learn C.
>
> Best regards,
> Tomasz Janeczko
> amibroker.com
> ----- Original Message -----
> From: "hmab1" <hossamb@xxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Monday, June 02, 2003 6:39 PM
> Subject: [amibroker] OT: Compile Excel VBA code ?
>
>
> > Hello all,
> >
> > Can VBA code (e.g. subroutines in an Excel module) be compiled
into a
> > dll or exe ? If so, how ?
> >
> > I'm asking because I created some trading-related functions using
VBA
> > in Excel but they are really slow to run. I'm assuming a dll or
exe
> > file would have higher performance.
> >
> > Thanks,
> > HB
> >
> >
> >
> > Send BUG REPORTS to bugs@xxxx
> > Send SUGGESTIONS to suggest@xxxx
> > -----------------------------------------
> > Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> > (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> > --------------------------------------------
> > Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get A Free Psychic Reading! Your Online Answer To Life's Important Questions.
http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|