For days where the NYSE or ASX data is not available, you can as you suggest put zeros in each field. However, it is not necessary. You can just not enter any data for that date and the date will be treated just like a public holiday i.e. not exist. You are wanting the cumulative total. Zero added to it is the same result as the day not even being there.