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 in the table below. The majority are the ARK funds.
This is the description of the ARK funds form their website: "ARK aims to deliver long-term capital appreciation with low correlation to traditional investment strategies by investing in the leaders, enablers, and beneficiaries of disruptive innovation."
| Symbol | Description |
|---|---|
| S.US.ARKK | ARK Innovation |
| S.US.ARKQ | ARK Autonomous Technology & Robotics ETF |
| S.US.ARKW | ARK Next Generation Internet ETF |
| S.US.ARKG | ARK Genomic Revolution ETF |
| S.US.ARKF | ARK Blockchain & Fintech Innovation ETF |
| S.US.ARKX | ARK Space & Defense Innovation ETF |
| S.US.PRNT | The 3D Printing ETF |
| S.US.IZRL | ARK Israel Innovative Technology ETF |
| S.US.NLR | Market Vectors Uranium + Nuclear Energy ETF |
| S.SMH | Vaneck Semiconductor ETF |
| S.QQQ | Invesco QQQ ETF |
The other two, Market Vectors Uranium + Nuclear Energy ETF and Vaneck Semiconductor ETF, are discussed in two posts on Workspaces.
The CQG page includes a Quote Spreadsheet V2 with the standard market data labels and is linked to three charts: 5-minute, daily, and weekly open, high, low, and close.
In addition, the QSS V2 has a column to the right that displays the current net percentage change for the year.
If you want to bring this data into Excel, simply right-click the symbol in the first column of the QSS V2 and select "Copy to Excel" and then in Excel right-click a cell and select "Paste." The annual percentage net change requires using the following formula:
=IFERROR(RTD("cqg.rtd",,"StudyData","S.ARKK", "PCB","BaseType=Index,Index=1", "Close", "A","0","all",,,,"T")/100,"")Requires CQG Integrated Client or CQG QTrader, and Excel 365 or more recent locally installed, not in the cloud.