Feed aggregator

PowerShares DB Commodity Index Dashboard

Latest Articles - Aug 10, 2017
This Microsoft Excel® spreadsheet tracks the front month contracts of the PowerShares® DB Commodity Index (symbol: DBC) holdings. The actual ETF holds deferred contracts. More information about ETF can be found here. The PowerShares DB Commodity Tracking ETF tracks an index that includes 14 of the most heavily traded and liquid physical commodities: WTI Crude Brent Crude Gasoline NY Harbor ULSD Natural Gas Gold Silver Copper Zinc Aluminum Wheat Corn Soybeans Sugar Three of the markets (copper, aluminum, and zinc) require the LME... more

What's New in CQG M Version 2.15

Latest Articles - Aug 09, 2017
Charts Added crosshair mode New studies available: ADX and Fast Stochastics Quotes New data visualization histogram columns for net change and percent net change columns in QSS General When opening new HOT or chart widgets, they will default to the last used symbol instead of opening the Edit symbols dialog Linking has been added to the symbol entry field in HOT and charts to make linking even easier Default column sizing for orders and positions Trading Highlight box added around best bid/ask in HOT Options High and low columns now... more

Hang Seng Indices Dashboard

Latest Articles - Aug 07, 2017
This Microsoft Excel® dashboard displays the cash indices available from the Hang Seng Indexes Company. The quote displays are divided into four sections. The first section is the cash Hang Seng Indices. Net percent change is heat mapped. The second section has the Hang Seng short and leverage indices. The third section is the HIS Volatility Index. The fourth section is the futures markets. This last section allows you to enter your own symbols. This dashboard offers a high/low color alert. If the last prices is within two ticks of the high, then the high price and description... more

CQG Care Orders: A Flexible Way to Manage Customer Trades

Latest Articles - Aug 07, 2017
Join our live webinar to see how care orders can simplify your hedge management. CQG Trade Routing Director Troy Wood will show you how to use care orders to hedge your customers' orders in CQG. You will learn how to: Manage orders for a central order desk Cross fill orders internally With centralized hedge management for brokers managing multiple customer accounts, care orders are a flexible way to manage customer trades within CQG. Care orders can also provide European investment firms with additional controls helpful for managing client access to trading venues. Join us to... more

H-Shares Index Options by Volume

Latest Articles - Aug 01, 2017
This Microsoft Excel® dashboard scans the options on futures for the H-shares Index (HHI) and ranks the traded volume for each expiry out to nine expirations. The scan covers options traded ten strikes above and below the at-the-money option. The top ten strikes by traded volume are then presented on the main display. The options are sorted by volume, not strikes. The volume data is heat-mapped, with the highest volume levels highlighted bright green. The markets data display in the bottom right-hand corner allows you to enter in your own symbols. The dashboard includes a bar... more

Crude Oil Returns to Its Sweet Spot

Latest Articles - Aug 01, 2017
In the world of commodities futures, crude oil is the most closely watched and heavily traded market. We are all oil consumers in some form as we drive cars, heat our homes during the cold season, buy products that travel in trucks powered by diesel fuel, fly on airplanes, and directly or indirectly utilize oil to power our daily lives. On July 31, 2017, the price of nearby NYMEX crude oil futures settled at $50.17 per barrel, which is a sweet spot for the energy commodity. The $50 Pivot Point In June 2014, the price of active month NYMEX futures peaked at over $107 per barrel. In mid-... more

Dow Jones Industrial Average® Performance Dashboard

Latest Articles - Jul 27, 2017
This Microsoft Excel® spreadsheet tracks the constituents of the DJIA Index (symbol: DJIA). Throughout the trading session, the thirty individual stocks are dynamically ranked and displayed in the histogram bar chart with their respective net percent change for today’s trading session. In addition, this dashboard offers a high/low color alert. If the last prices is within two cents of the high, then the high price is highlighted with a green background. If the last prices is within two cents of the low, then the low price is highlighted with a red background. The percent net... more

Hang Seng Index Options by Volume

Latest Articles - Jul 25, 2017
This Microsoft Excel® dashboard scans the Hang Seng Index market options on futures and ranks the traded volume for each expiry out to eleven expirations. The scan covers options traded ten strikes above and below the at-the-money option. The top ten strikes by traded volume are then presented on the main display. The options are sorted by volume, not strikes. The volume data is heat-mapped, with the highest volume levels highlighted bright green. The markets data display in the bottom right-hand corner allows you to enter your own symbols. In addition, you can adjust the clock in the top... more

Pulling Market Data without Holidays

Latest Articles - 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

Latest Articles - 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

Latest Articles - Jul 06, 2017
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 View Now Presenter: David Williams For the past 27 years, Mr. Williams has pioneered a number of breakthrough market forecasting techniques, including Reflected Wave and the Square Principal, that put him into a league of his own. Today's market technicians are amazed by the... more

Q2 2017 Winners and Losers and a Look Ahead to Q3

Latest Articles - 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

Latest Articles - 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

Latest Articles - 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