![]() ![]() This is where programming languages like R and Python come into play. You can always write advance macros using Excel VBA, but sometimes they may also not be enough. ![]() Third, since spreadsheets get passed around, it’s difficult to keep them updated and to maintain the sanctity of your solution. Second, it is difficult to build complex relations between different data sets. As the dataset becomes slightly large, your spreadsheets will start hanging or will take enormous time to refresh. The first problem is that you can’t load large data sets in Excel. ![]() You can easily load data, build a quick model, crunch numbers and get a solution. They can help you with crunching numbers quickly. The new tools of choice for traders are R and Python. This makes Excel a bit outdated or primitive tool of choice. The traders need to deal with much larger amounts of data and need to carry our complex analysis in order to gain a competitive edge in the financial markets. However, with time, the nature of financial data has become quite complex. Excel is one of the most important tools for traders and investors. If you work in the finance industry, especially as a trader, then I bet you can’t live a day without Excel spreadsheets. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |