Excel Trading right from Spreadsheet?
- Thread starter scooke
- Start date
Interestingly, there were improvements made in 2007 and then again in 2010 towards parallel calculations in worksheets. However, once again, I think no improvement in that regard occured with VBA-based functions.
Yes, you are right. With a 6x processor, you could assign a separate Excel instance to each core.
how do you assign an instance of something to specific core?
http://www.addictivetips.com/window...cessor-affinity-to-an-application-in-windows/
And they are correct about it being highly NOT recommended.
Setting processor affinity screws with hyperthread algos as well as other things such as dynamic memory allocation and page file use.
Yes VBA is somewhat limited but if you are reaching the limits of VBA why not make the jump to C#? They are very similar and for someone running that many spreadsheets the C# switch should be easy and much better.
No, a 6-core or an 8-core probably won't help unless you keep the clock speed up and crank the memory up in the machine. Most of those 8-core CPUs (that are reasonably priced) are very low clock speed and will be somewhat disappointing.
A couple of tools that may help:
http://orlando.mvps.org/XLtoEXEMore.asp
Converts XLS to EXE
thecommon.net
VB tool set for using SQLite DB in excel without ms stack overhead.
Requires much work up front but the results are worth while.
http://orlando.mvps.org/XLtoEXEMore.asp
Converts XLS to EXE
thecommon.net
VB tool set for using SQLite DB in excel without ms stack overhead.
Requires much work up front but the results are worth while.
I see. I have a quad core i7-2600. It probably doesn't make sense for me to do this.
Interesting with the Excel to EXE. Not sure if my IB still works if its "EXEed" Just so afraid that it contains virus too haha!
Anyway, I haven't met with a processing CPU issue as of running 30 workbook in Single Excel. Likely, instead of doing additional programming (which makes coding harder though increase compatibility,) I will be instead opening additional accounts, and run it off 2 machines, or VMware them.
I don't believe I could run 50 stocks, 5 fx, and 2 futures off 1 account, due to reporting and strategies, not just the technical limitation, so separating computers would be a better choice, hence I can "do" away (lazily) with the technical stuff. Aadditional computer for Asia trading I hope.