A recent tutorial from SpreadsheetPoint.com demonstrated how Excel can be used to create a powerful, automated stock portfolio tracker that’s perfect for paper-trading competitions. Excel’s ...
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.