How To Get Updated Stock Prices In Excel. One way to do this is to use the data > refresh all command. Each column has a standard heading with the googlefinance() attribute in the 2 nd row.

The formula essential goes like this: This link simply provides information related to all shares who gained at that point of time i.e. One way to do this is to use the data > refresh all command.