Having a historic function that would average data over a specified time period would be extremely useful. And eliminate excessive calls to the data servers and large user spreadsheets that can be problematic for both the user and marketXLS. Example. What is the 10 year average of the P/E, P/S, P/B, P/OCF, P/FCF, etc.? e.g. hf_Price_to_Earnings(stock symbol, start year-qtr, end year-qtr, option "TTM") P/E average (daily closing price/qrtly earnings averaged over quarter) for each quarter is stored with hf financials. Do not get overly concerned with negative ratios. A clear indication that folks are willing to pay for negative performance. And comparing over different duration averages, provides some insights.