Would someone tell me if the following approach is possible using the COM model. I have code which calculates ordinal values of indicators of a Watchlist, but just for the Last Date in the Explore Range. Can the COM model be programmed to automatically change the Last Date in the Explore Range, one day at a time, or one week at a time, and then write (append) the results to an excel file. Diagrammatically: Start COM model. Set Last Date in Range Run code which calculates ordinal values of Watchlist Write ordinal values to spreadsheet Increment Last Date in Range Rerun code which calculates ordinal values of same Watchlist Append ordinal values to spreadsheet with new date Repeat Can this be done? Anyone know of any examples? Thanks for any suggestions. Ken
