Is VBA more CPU efficient than using excel formulas?

[Captain Sensible]

BA and excel regularly take my CPU up to 100% at the moment for some reason , probably due to my poor coding somewhere along the line

Looking to rejig things and wanted to know if I'd be more efficient coding in VBA rather than mainly using the formulas on some of my older sheets that were written before I gained some VBA knowledge.

[alrodopial]

Does your code backs up odds,amounts,bets etc at every refresh or just calculates if a bet must be fired?

[Captain Sensible]

Not sure what you mean by backs up? It doesn't store any info just uses current odds to do it's calcualtions

[alrodopial]

Then it's not a case of write/read that usually is the case of high cpu usage.
We'll have to wait for os to answer but it's weird that so much cpu is needed for just calculations.
Are there any calls (at every refresh) using the com?

[Captain Sensible]

Not using the COM just three sheets via the normal excel link and a little VBA. I'll have to sit down and look through it all to see where the problem is at some time.

Was mainly questioning if I'd be better off using VBA or formulas when I get round to re-writing them , whatever is likely to be more efficient

[mak]

I have also noticed lately high cpu demands and have report it to Gary.
Without any changes at all one day my bots started "consume" all my cpu and slow down my vps.

[wizardofmann]

This may not relevant in this case and I know sweet FA about VBA or Excel but since the 16th of January this year, the odds movements have become more erratic than usual. Also getting too many unmatched and partial matches, where as before that date it they were infrequent. Has anyone else noticed these changes

[osknows]

It depends..... and actually it would make a really good thread to ask the best way of performing certain functions in both Excel and VBA.

Generally, Excel formulae are normally quicker than VBA.

Excel array formulae are almost always bad and can be improved using alternative methods.

If placing more than a single trade on a runner then VBA will always be faster than Excel as a bet can be placed at the same time as clearing existing bet references so will always be one refresh ahead if no other performance issues impact the trade.

Personally, most of my systems are Excel formulae based to highlight a trade and then VBA is used to place the trade.

Also, you have a 200ms window between refreshes to calculate so assuming this is actually nearer 150ms in real terms then it doesn't really matter if your PC calculates in 1ms or 150ms, you won't place a trade any quicker. However, if trading multiple markets then the quicker the better.

Os

[Captain Sensible]

Thanks Osknows, I was more concerned with the efficiency of the various methods rather than speeds. Luckily my methods never rely on speed for an edge, I realised a long time ago people would always be putting more effort/money into obtaining those type of edges. Just wondering if one method would require or use more CPU resources than the other.