customstats.xlsx

So I have two columns. One with dates, the other with either "Bid" or "Offer". I'm trying to create a time series on a daily / weekly basis whereby I calculate bid / ( bid+offer) or other random stats. I need the stats column to automatically follow new data entries. The user won't touch the custom stats column.

Any suggestions?