Tracking Markets by linking to Excel from CQG
CQG’s Digital Data Service enables users to establish real-time links between spreadsheets and CQG. DDS provides activity data, bar data and study values.
You can build spreadsheet portfolios of ETFs, stocks, fixed income product, futures, other markets, and do analysis, such as ranking by percentage performance.
Here, is an example of the top ten one-day performing ETFs for November 3, 2006.
January 3rd, 2007 at 10:36 am
[…] The first day of trading is being led by Emerging Market ETFs and Retails ETFs. Excel is linked to CQG for the data. […]
January 4th, 2007 at 10:24 am
[…] Today, Internet and Biotech ETFs are leading the top performers. However, of the 228 ETFs I track, only 35-percent of them are up on the day. Excel is linked to CQG for the data. […]
January 5th, 2007 at 10:56 am
[…] Only one of the 228 ETFs I track is showing a positive gain today. This obviously indicates widespread selling. Excel is linked to CQG for the data. […]
January 8th, 2007 at 10:08 am
[…] This morning only 27-percent of the 228 ETFs I track are showing a positive gain today. However, tech is in the top ten, along with energy, and emerging markets. I like seeing technology, and emerging markets have been market leaders. Excel is linked to CQG for the data. […]