Turn this recipe on to track a stock's rise (and hopefully not fall!) in Google Drive
If
Price at close
This Trigger retrieves the closing price of a stock you specify every time the market closes.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Finance and Google Sheets