Excel Multi-Market Dashboard

This Excel 365 Dashboard tracks the daily individual performance of multi-market groups: Equity Indexes, Fixed Income, Metals and Energy, and Forex.

The groups are dynamically ranked from top to bottom based on the net percentage change using the Excel SORT function.

The dashboard displays the following data:

  • Symbol
  • Description
  • Best bid volume
  • Best bid
  • Best ask
  • Best ask volume
  • Open
  • High
  • Low
  • Last
  • Net Change
  • Percentage net change
  • Today's volume
  • The ratio of today's volume compared to the 21-day MA of the volume.

In addition, a candlestick chart for each group is displayed.

Here is the full dashboard.

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

Downloads

File
market_performance_dashboard_v3.xlsx
Tags
Excel/RTD
How To
Thom Hartle

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.