You shouldn't try to keep a closing total of items in an inventory, as this
can be simply calculated using a dsum or similar function.
The closing price of a stock product should probably be kept in a table
with a datestamp, so you know what date the closing price is applicable for.
You could also graph the rise/fall in price of a stock item over the days.