Note that grabbing the stock price is the default function of GOOGLEFINANCE. However, you can specify many more attributes using the function to populate a full dashboard for your portfolio.
A recent tutorial from SpreadsheetPoint.com demonstrated how Excel can be used to create a powerful, automated stock portfolio tracker ... an easy way to create dashboards in Excel.