Pulling Historical CVB Data into Excel

Pull historical CVB data into Microsoft Excel® using RTD formulas with this sample spreadsheet. It not only pulls open, high, low, and close values into Excel, but also a study, the Relative Strength Index.

To pull in the data, we used a constant volume bar symbol:


This symbol calls for a constant volume bar using 1,000 actual volume contracts (tick volume is the other option) building the open, high, low, and close values. 

You can change the symbol, the volume level for building a new bar, including using a continuation setting, and the look-back period for the RSI.

Read more about constant volume bars ‌‍‍‍‍

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



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.