Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Nearly everybody I know uses Excel for tracking the returns in the stock market. Not many however know that Excel can be used for online stock tracking and getting live price information from stock exchanges like NYSE and Nasdaq as well. Here's how. Establishing a connection to the MSN server for Stock Quotes Click on the data tab in the Excel ribbon (in Excel 2007 and later). ...

Continue Reading

Stock Tracking Dashboard and Live Stock Price Quotes Using Excel

Excel Dashboard using Pivot Table

Posted on 13 August 2009

Excel Dashboard using Pivot Table
Excel Dashboards created using a pivot table have the advantage of being low maintenance. The excel dashboard created using this method will typically have three layers - the raw data, the pivot table and the final dashboard presentation. This loosely follows the Model–View–Controller pattern found in software programming with the pivot table acting as the controller. Creating an Excel Dashboard using pivot tables As we mentioned earlier, to create a complete dashboard, the following three pieces need to be put together. ...
Continue Reading

Comments (3)



Translate

Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel