Range of Formulae to VBA

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
Wolf1877
Posts: 367
Joined: Fri Sep 08, 2017 10:59 am

sa7med wrote:
Mon Oct 08, 2018 8:42 am
Hey, correct me if I'm wrong but isn't it more efficient to write formulas directly into excel rather than vba? my understanding is that vba is single threaded while Excel can use more cores.
I cant comment on the multithreading capabilities of excel formula calculations but the problem with excel formulas is they are continuously recalculated unconditionally whenever worksheets are refreshed. There are 6 worksheet refreshes per bet angel worksheet per guardian cycle. 7 refreshes per cycle if you have opted for optional values like VWAP.

VBA code can be developed so that calculations are performed conditionally so that numbers are only crunched when actually needed. So my code would typically be something like if the market volume has changed then crunch numbers selectively via VBA else dont bother. Excel formula would be blindly recalculated needlessly on every refresh. In my experience multi sheet workbooks with lots of formula are slow while well optimised VBA calculations are much faster.
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”