Analyzing Securities

image with no caption

The Financial button on the Formulas tab includes a group of functions designed for specific tasks related to computing and analyzing various types of securities.

Note

In older versions of Excel, these functions were part of the Analysis Toolpak add-in, but Microsoft fully integrated these functions back in Excel 2007. As a result, the functions might produce slightly different results, but Microsoft says they’re so insignificantly different that the results are nonetheless “equally correct” (their words). Although its worksheet functions have been integrated into Excel, the Analysis Toolpak is still available as an add-in with ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.