Excel

From the ARK website: "ARKF is an actively managed Exchange Traded Fund (ETF) that seeks long-term growth of capital. It seeks to achieve this investment objective by investing under normal… more

The Accumulation/Distribution Study and the Chaikin Oscillator were introduced in the post titled CQG Primer: The Chaikin Oscillator.

The Chaikin Oscillator is the difference between two… more

This post, DEMA Based MACD Oscillator, introduced using the Double Exponential Moving Average Study for smoothing the data to create an MACD study that would have less lag than the classic MACD… more

Stories are appearing in the media pointing out the possibility of an AI bubble. Alternative ETFs have been suggested that are not so "tech heavy." One suggestion is the Invesco S&P 500®… more

The Double Exponential Moving Average study is a moving average calculation that reduces the lag associated with other moving averages. The Double Exponential Moving average is calculated as the… more

At the bottom of this post is a downloadable CQG Pac that installs a page for CQG IC and QTrader customers interested in following a section of the technology ETFs. The group of ETFs are displayed… more

From the ARK website: "Companies within ARKQ are focused on and are expected to substantially benefit from the development of new products or services, technological improvements, and advancements… more

This post details steps using the Excel CQG RTD Toolkit Add-in to pull in open interest data for an options series based on the same expiration. These same steps can be used to pull in other… more

This post offers two Excel dashboards for tracking the holdings of the Vanguard Information Technology ETF. The fund tracks the performance of the CRSP US Large Cap Growth Index.

It uses a… more

This post offers a downloadable CQG PAC for IC and QTrader and Excel dashboard that includes two custom studies that track a market's performance by measuring the price difference between the… more