News for hackers. Stuff that matters.
Re:How Linux mastered Wall Street by gruseom on Tuesday August 16, 2011 @12:17AM (#2889874)
if Excel's performance could be improved, it would become the best tool for some scenarios

Where have you found Excel's performance to be inadequate?

Re:How Linux mastered Wall Street by chollida1 on Wednesday August 17, 2011 @09:48AM (#2895330)
Oh gosh, where to start:)

- on any calculations that are iterative, - the recacluation rate is limited to something like once per second, - sheets containing over 2000 market positions getting real time quotes grind to a halt. - any time you have more than about 20,000 calls out to a COM component per sheet - large vba functions, it seems vba is about an order of magnitude slower than the corresponding Excel built in methods.

TL/DR large sheets, dde, COM, heavy use of iterative solvers, large amounts of vba, all make excel really slow down.

Having said all that Excel is really awesome, it's just not for big data:)

Re:How Linux mastered Wall Street by gruseom on Wednesday August 17, 2011 @06:01PM (#2897134)
Suppose somebody made a spreadsheet for big data. What might you do with it?
Re:How Linux mastered Wall Street by paperwork on Tuesday August 16, 2011 @09:36AM (#2891072)
I believe excel only updates once a second (or whatever the refresh rate is, I remember it being too slow for high frequency trading).