Pulling Historical Data into Excel

This spreadsheet allows you to pull historical data into Microsoft Excel® using RTD formulas. The sample spreadsheet pulls open, high, low, close, contract volume, contract open interest and one study, the RSI. The spreadsheet pulls up to 1,000 bars of data, which is the default setting for RTD. For more data, you need the CQG Historical Data API. Please contact your CQG sales representative for more information. The spreadsheet is unlocked and uses cell references for the RTD parameters.

You can change the symbol, the time frame including using continuation setting, and the lookback period for the RSI.

Requires CQG Integrated Client or CQG QTrader, data enablements for all symbols used in the spreadsheet, and Excel 2010 or higher.

Downloads

Disclaimer

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.