Latest Articles

Subscribe to Latest Articles feed
Content updates from news.cqg.com
Updated: 7 hours 27 min ago

Pulling Market Data without Holidays

Jul 20, 2017
In this article, we outline how to pull historical market data into Excel while excluding data from days when the market was in a holiday session. Holiday sessions are trading dates, but not clearing dates. Holiday session data is merged with the next session. For example, July 4 is a US holiday and is a trade date, but the clearing date is July 5.There are RTD formulas for calling open, high, low, and close by date and time. We will use that RTD format here to ignore trading on July 4. First, pulling daily bar data will always give you clearing dates. Here is the... more

What's New in CQG M Version 2.14

Jul 12, 2017
Trading View more than one account, or view all accounts for orders, positions, and account views.  Easily access recently used park and activate custom settings. Quotes Identify which symbols have delayed data subscriptions via icons. Continuously view the symbol column when horizontally scrolling to see other columns.  Find lists faster with search. Chart: New Studies Added Momentum MACD with Histogram Average True Range More Details and How to Access the New Features Horizontal Scrolling in QSS ​In your desktop version of... more

Explore the Outer Limits of Technical Analysis with David Williams

Jul 06, 2017
Join our live webinar to watch David Williams reveal visual methods that test the accuracy of trades before they're placed. You will learn: How to examine the market differently and make informed trading decisions When to trade the forecast and when to scalp the market What is next for technical analysis   Date & Time: July 20, 2017 3:00 p.m. CT Register Now Presenter: David Williams For the past 27 years, Mr. Williams has pioneered a number of breakthrough market forecasting techniques, including... more

Explore the Outer Limits of Technical Analysis with PageTrader

Jul 06, 2017
Join our live webinar, hosted by David Williams, as he reveals visual methods to test the accuracy of your trade BEFORE placing it. During this webinar you will learn:  How to examine the market differently and make informed trading decisions When to trade the forecast and when to scalp the market  What is next for technical analysis   Date & Time: July 20, 2017 3:00 p.m. CT Register Now Bio: For the past 27 years, Mr. Williams has pioneered a number of breakthrough market foreca

Q2 2017 Winners and Losers and a Look Ahead to Q3

Jul 03, 2017
The dollar index moved lower by 4.79% in the second quarter of 2017. Out of the 29 commodities that I follow, 22 posted losses during the three-month period that ended last Friday, June 30. Commodities are watching the dollar move lower while interest rates are heading up. A weak dollar tends to be bullish for raw material prices, but higher real interest rates increase the cost of carrying inventories of commodities. Therefore, the results from raw materials sector reflected individual fundamentals as the macroeconomic picture remains confusing. A Marginal Winning Quarter During the... more

SPDR S&P Bank ETF Dashboard

Jun 30, 2017
This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Bank ETF (symbol: KBE). Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom fifteen performers as histogram bar charts, along with their respective net percent change for today’s trading session. The quotes display portion is divided into three sections: The first section allows you to enter your own symbols. The second section displays the top fifteen performers. The third section displays the bottom fifteen performers.... more

Using Chart Continuation Settings in RTD Formulas

Jun 28, 2017
RTD formulas for chart types and studies can include the same parameter settings used in your CQG continuation charts. In the RTD formula the continuation parameters are entered in the “time interval" field and the choice to equalize the closes is entered in the “equalize closes" field. In the RTD formula below the symbol is "EP" and the formula calls for the closing price for today’s daily bar (indicated by "D"). No continuation setting is applied. The choice to equalize closes is set to “False”, however, this setting in this example does not matter as there is no continuation... more

RTD OTE and P&L Using Yesterday’s Settlement

Jun 14, 2017
Some traders want to see their current open trade equity (OTE) and closed out trades (P&L) based on yesterday’s settlement, not the original price when the trade was opened. In DOMTrader's Trading Preferences, under Trading Display, you can set the OTE and P&L calculation to use the previous settlement (here highlighted with a red box). The RTD calls in Excel pull OTE and P&L using yesterday’s settlement: =RTD("cqg.rtd", ,"OrderData","Symbol", "", "OpenTradeEquity","AccountNumber") =RTD("cqg.rtd", ,"OrderData","Symbol", "", "ProfitLoss","AccountNumber")... more

US Treasury and Europe Sovereign Yield Dashboard

Jun 12, 2017
This Microsoft Excel® spreadsheet tracks the BrokerTec US Treasury Yield Curve data and the ICAP Euro Bonds and Gilts markets. The top-left quote display allows you to enter your own symbols. To the right is a portfolio view of the daily percent net change as histogram bars using the symbols entered at the top of the chart. Below the top quote display is another quote display detailing the BrokerTec treasury yields and the futures prices for the fixed income products traded on CME Globex. The bottom-left chart is the US Treasury yield curve compared to Germany's and the United... more

What's New in CQG M Version 2.13

Jun 08, 2017
Here is a summary of the new features in CQG Version 2.13. Chart Tooltips show bar and study values on the chart (coming soon: crosshairs). Countdown timer is now available for intraday charts. Trading Park all and activate all are now available in the trading widgets. Quotes & Orders Grids Multi-column sort. General Faster searching in preferences and widget dialogs. Trading buttons in the Options widget removed. Turkish translation now available. More Details and How to Access the New Features Tooltips on Chart In... more

SPDR S&P Biotech ETF Dashboard

Jun 08, 2017
This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the SPDR® S&P® Biotech ETF (symbol: XBI). Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom fifteen performers as histogram bar charts, along with their respective net percent change for today’s trading session. The quotes portion of the display is divided into three sections: The first section allows you to enter your own symbols. The second section displays the top fifteen performers. The third section displays the bottom fifteen performers... more

Custom Sessions and RTD

Jun 05, 2017
CQG Integrated Client customers can set up custom sessions for their charts. For example, NYSE’s trading hours are from 8:30 to 15:00. The primary session for the E-mini S&P opens at 8:30, but closes 15-minutes later, at 15:15. If you want to see E-mini S&P market data and studies based on a close of 15:00, you can create a custom session to open at 8:30 and close at 15:00 and apply that to the E-mini S&P chart. The maximum number of minutes you can use is the range of the custom session. In this case, that would be 390 minutes. You cannot apply a custom session to a daily bar... more

The Dollar and Commodities Prices

Jun 02, 2017
The US dollar is the reserve currency of the world, and it is also the benchmark pricing mechanism for most raw material prices. Typically, a weak dollar results in strong commodities prices and vice versa. However, the dollar has been moving lower since January 2017 when the dollar index futures contract traded to the highest level since 2002 at 103.815. Since then, it has been nothing but lower highs and lower lows for the US currency. The Dollar is Sitting Near Lows The dollar index has declined by over 6.5% since the January highs, which is a significant move for a... more

Learn How to Trade with Oscillators

May 31, 2017
In this webinar, hosted by industry veteran Bill Glenn, you will learn how to trade various types of Oscillators. Gain insight into different trading methodologies while using Oscillators such as RSI, MACD, Stochastics, CCI, ADX, and more. Mr. Glenn explained: Oscillators and when to use them What each Oscillator tells us How to execute them in CQG  View Now This example shows the ADX Signals Oscillator in CQG Integrated Client.   Presenter: Bill Glenn began his career in 1997 as a member of the analyst... more

Financial Select Sector SPDR ETF Dashboard

May 31, 2017
This macro-enabled Microsoft Excel® spreadsheet tracks the holdings of the Financial Select Sector SPDR® ETF (symbol: XLF). Throughout the trading session, the individual stocks are dynamically ranked. The main display shows the top and bottom fifteen performers as histogram bar charts, along with their respective net percent change for today’s trading session. The quotes display portion is divided into three sections: The first section allows you to enter your own symbols. The second section displays the top fifteen performers. The third section displays the bottom fifteen performers... more