You can use MSN Money Central Investor Stock Quotes, the built-in connection of excel and pull the stock quotes. I will take you through the steps to be followed to achieve this. Then, click on “Connections” which opens “Workbook Connections” and click on “Add” button. See the following formula samples: Screenshots German Edition of Excel 2016: German Edition of Excel 2013: This add-in is based on a previous version I wrote for Excel 2007 and Excel 2010. You can insert the live market price, EPS, PE, 52-week high, book value, or any other of over 80 quotes into a cell with this VBA function. So now instead of the 2 other option you have a third and an automated one. Go to Yahoo Finance to look up the symbol of your stock. There are many built-in formulas and you can even create your own custom functions to extend the functionality.
|