Is it possible to create rows that automatically expand?

Hello everyone,

I’m in the process of making a spreadsheet to track the value of stocks I’m involved in. I want to be able to type in the current value into the top (where I have a spot for input) along with a date and then be able to save the data below them automatically? Also wouldn’t mind being able to have the last value entered displayed beside it so I can compare the past 2 changes automatically. Is this even possible or should I start typing in data manually?