The Query tab is a holding space for data downloaded for both historical prices and real time quotes. This sheet downloads the entire page for each URL required and then extracts the data required for the Data sheet. The reason that the entire page is downloaded is to make this solution compatible with all versions of Excel and HTML rendering including those on the Macintosh operating system.
Focus should be made on the Data sheet which is provides the downloaded data in a structured and continuous format.
