[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] OT: Compile Excel VBA code ?



PureBytes Links

Trading Reference Links

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@xxxxxxxxxxxx>
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@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/ 
> 
> 
> 

------------------------ 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/