Nothing can beat Excel as a multi-purpose user interface medium. It is then only natural to want to analyze the performance of your stock portfolio in Excel, as that would enable you to devise and apply your own custom metrics.
But in order to monitor your portfolio metrics in real time, you would need to get the required market data in real time as well. You may think that getting true real time prices is only available to expensive broker applications. This is generally not true! Several exchan