Stock History is an Excel function that provides access to historical data on stocks, funds, bonds and currency. The data can get refreshed, too.

Excel users have been requesting for a function that makes it easy to pull stock prices into Excel spreadsheets. Microsoft had previously enabled refreshable quotes for stocks, bonds, funds, and ...

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...