OHLC, Studies, and Auto Price Format

This post offers a downloadable sample Excel spreadsheet for pulling in historical data and study values from CQG IC or QTrader using RTD formulas.

The Data consists of:

  • Open, High, Low, and Close.
  • Volume
  • Moving Average
  • Bollinger Bands
  • MACD
  • RSI
  • Stochastics
  • Imoku

The Dashboard offers input cells for the study parameters.

f1 

In addition, if the symbol is changed the spreadsheet determines the number of decimals of the tick size and then formats all prices using that number.

f2 

Excel's IFS function is used:

=IFS(A46=0,"#",A46=1,"#.00",A46=2,"#.00",A46=3,"#.000",A46=4,"#.0000",A46=5,"#.00000",A46=6,"#.000000",A46=7,"#.0000000")

The Excel TEXT function is employed for formatting the price using cell $A$47.

=TEXT(RTD("cqg.rtd",,"StudyData", $A$2, "BAR", "", "Open", $A$4, -$B2, $A$6,$A$10,,$A$8,$A$12),$A$47)

Requirements: CQG Integrated Client or QTrader, and Excel 2019 (locally installed, not in the Cloud) or more recent.

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.