Excel for finance
The spreadsheet application in the Microsoft Office suite was designed for statistical, engineering, and financial data management. In finance, Microsoft Excel is used as a handy tool for bond traders and an integral part of banking operations to task automations using VBA. For example, built-in Excel functions, such as TBILLYIELD and DURATION, helps you calculate the yield of a T-bill and the Macaulay duration of a bond and displays these values onto a cell.
Excel supports the use of COM to extend the functionality for custom tasks. This is achieved with the use of COM add-ins as an in-process COM server. With VBA, a wrapper can be created for the COM add-in function so that the COM component can be used as a worksheet cell formula ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access