On your Mac, double-click on the cell, then click Edit as Formula.On your iPhone, iPad, or iPod touch, tap on the cell, tap Cell, then tap Edit Formula.Here's how to edit the STOCK as a formula: You can also use the STOCK formula to enter and edit stock information in a cell.

If you want to see updated information as of the previous day's close or change the attribute you're tracking, double-tap or double-click on the cell. The attribute you’re tracking has a to the left of it. If you want to search for a specific stock, enter the company name or stock symbol.