I have a model in one sheet that uses external data fetched from web ( e.g. yahoo finance ) based on ticker symbol of a company that I input. Problem starts when I use VBA to loop through a column full of company tickers and output the results into another sheet. Example : input ticker -> get data from web, based on that ticker -> analyse -> put result into sheet2, next ticker and so on. After couple of tickers data retrieval stops and I get errors results. I assume that's because cash memory is full of web data and needs to be cleared.

My question is how to clean memory after few looped iterations, so that whole process could be automated?