Live Historical Market Data Updating Table

This Microsoft Excel® spreadsheet uses RTD market data functions that call the daily open, high, low, and close by dates to automatically update the bottom of the table with today's market data. You can enter a start date and, going forward, each day's trading activity will be appended to the bottom of the table. Excel determines if the next day is a weekend and skips weekends for creating dates.

You are limited to 300 days of daily data. For more historical data, please contact your CQG representative for the Historical API enablement.

Requires CQG Integrated Client or CQG QTrader.



Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.