Technical Analysis of ETFs

  ( Sample of Technical Analysis done for ETFs   )



ETFs/ETNs Analsis:
I use End-Of-Day data to generate Technical Analysis files. The data-vendor I use for getting the EOD data is TC200 (aka Worden Brothers), and the charting package I use is Amibroker. I've coded the analysis using AFL (Amibroker Formula Language) and C# (Free language by Microsoft). The final actionable result is generated using the analysis data generated using AFL/C# in Excel with some coding in VBA. I'm giving below a screen-grab of final analysis I generate daily to place the trades.

Actually, the technology details I gave in earlier paragraph are of secondary nature, and are just describing the decision support system I've built. The primary focus, of course, is the intelligence that's generated to help me with the decision making.

Decision being buy / hold / sell or no-action. Most of the times, for most of the ETFs, the decision is 'no action' *smile* - means just keep watching the movement of ETFs for the next day, and the next, and the next ... However for some of the times the indicators help me arrive at the 'action' desicion. This is when I act to Buy/Sell/Hold.

The Technical Analysis done here spans acrosss the ETFs I track - which is almost every ETF traded on the US Exchanges (around 1500+). I tend to exclude the ETFs that are not traded frequently - typically the ETFs with average daily volume of less than 50k. Also I tend to exclude trading ETFs that have low assets-under-management (AUM). After the exclusions I get the 'target' ETFs. For these ETFs, the analysis given below is to let me visualize indicator details for various Technical Indicators. The ones I tend to use frequently are:

(a) Commodity Channel Index   (b) Billinger Bands   (c) Momentum   (d) Price Zone Oscillator   (e) Chande Momentum Oscillator   (f) Rate of Change 5/10/15.


Screen-grab of the ETFs/ETNs Analysis showing worksheet 'TA':



Screen-grab of the ETFs/ETNs Analysis showing worksheet 'TA_Flat':




Copyright © 2019 Salil V Gangal, All Rights Reserved.