Auto-save fetched data
Use this formula in the rest of column C, and values will automatically fill in for other accounts you're tracking. However, those values won't be saved; they'll change each time you open the sheet.
To keep historical data as the sheet's currently designed, you'd need to copy and paste values manually into another column or spreadsheet. What fun is that? Instead, let's create a new function to 1) Find the first empty column, 2) label the column with the date of data extraction, and 3) copy the value from column C into that first empty cell.