One of the more exciting features of the latest Microsoft Excel version was the ability to add apps that would make it much easier to gather data in order to manage it more easily in Excel. You’d think that finance would be one area where Microsoft could deliver. The data required is fairly simple (most investors need metrics such as price, dividend info, P/E ratio, etc), the company has most of that data through Bing Finance and has a lot of experience dealing with financial spreadsheets.
If you look at the app offering:
You will quickly see that the response has not been good so far. The rating currently stands at 1.5 stars (out of 5). There seem to be a lot of bugs, crashes, it does not work well for international stocks.
You Need To Take Action
There are other ways to get this done. One easier option is to build cloud-based spreadsheets using Google docs which does provide a decent infrastructure based off of Google Finance data.
The main alternative is building your own excel spreadsheet, getting your data to web queries or API’s and managing the entire process either manually or by building a macro based spreadsheet. It will certainly take a bit longer to build but will be much more flexible than whatever you’d find.
I’ve written several posts about doing this and would be more than happy to help out more if that would help.