well put G.

Just to add to the discussion. If you wanted to be able to SUM() across the date dimension you would need to record stock MOVEMENT not stock POSITION

but this would mean that if you want to know the POSITION you would have to SUM() the MOVEMENTs for all time (or at least from the last known POSITION)