Keep track of the stock's daily closing price in a spreadsheet saved in your 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