What can't be done in Excel ?
What can't be done in Excel ?
When I ask customers why they're not using Excel for more things, they often say to me: "Well, we'd like to do XXXX, but you can't do that in Excel can you ?"
Often, the answer is: "YES YOU CAN !"
So my question to all of you, is this: What do you think can't be done in Excel ?
Nick
»
- Nick's blog
- Add new comment
- 263 reads
Very limited at analysising stock prices
Excel is good at somethings, but quickly runs out of steam. E.g. backtesting. Great for a single stock but not great if you want to write lots of indicators etc or run through lots of symbols. There are several solutions out there that download stock data into excel but they are so unscalable that it really sucks for anything more sophisticated.
Mark
Limitations of Excel
Hi Mark
I feel your pain, but there are utilities out there that solve this problem by storing the data in memory and allowing you to access it through Excel.
Multi-threading
Hello
I dont know f anyone who's used Excel or VBA for multi-threading programming.
I work on valuation and Excel modeling and any complex (and sometimes not so complex to be fair) calculation has to be taken out of Excel to C++, C#, etc.
I think professional level multithreading is something out of the scope of both Excel and VBa.
Thanks
JA
Windows API
Just to add that calling the Windows API from VBA is not a solution. It actually brings a new host of additional problems.
We probably need to accept that Excel/VBA simply cannot do it.
multi threading
yes, agreed.. although it has to get pretty complex before you need multi-threading.
I hear Excel 2010 improves on this aspect, although I have not played with it yet.