Howdy, Stranger!
Categories
- All Categories
- 2.2K StockCharts
- 392 SharpCharts
- 149 Other Charting Tools
- 58 Saved Charts and ChartLists
- 1.4K Scanning
- 67 Data Issues
- 162 Other StockCharts Questions
- 214 Technical Analysis
- 154 Using Technical Analysis
- 2 InterMarket and International
- 19 Market and Breadth Indicators
- 39 Market Analysis
- 100 Trading
- 100 Trading Strategies
- 161 S.C.A.N the StockCharts Answer Network forum
- 66 Using this StockCharts Answer Network forum
- 95 s.c.a.n. archives
- 17 Off-Topic
- 10 The Cogitation & Rumination Emporium
- 7 Forum Test Area
New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
Options
In Advanced Scan Builder
in Scanning
Does anyone know what makes up the 'All ETF' list? Is it truly all available ETF's?
If so how often is it updated? Is there a web link to the list?
Thank you in advance!
If so how often is it updated? Is there a web link to the list?
Thank you in advance!
0
Comments
[group is ETF]
you get the first 999 ETFs in alphabetical order by symbol. The list stops at INTF, so that suggests there are many more. So, because of the 999 limit, you can't get a single list of all ETFs available. I'm not aware of any other method to get such a list. Maybe the data vendor has something. However, as far as I know, if an ETF trades on an exchange, there is no reason there wouldn't be a chart for it (unless it has stopped trading).
The alternative would be to think about the characteristics of an ETF that interest you - volume traded, price, country (or exchange), sponsor, etc. and scan for those characteristics. If you need help with writing a scan, post your "plain english" requirements and whatever you can put together for a scan, and we'll help tweak it.
Another approach might be to note the various sponsors of the ETFs and go to their websites for a list of what they offer.
// begin
[group is etf]
and [symbol starts with "a"]
// end
You would run the scan 26 times to cover every letter of the alphabet (the letter can be upper case or lower case - doesn't matter, same results).
For each letter, on the results page you would choose "Download in CSV format" from the Available Actions drop down at the top of the page. In Excel, you could merge all the files.
Its doubtful there are more than 999 results for any one letter, so you should get everything.
If you want ETFs by sponsor, you could run this scan:
// begin
[group is ETF]
and [name contains "iShares"]
// end scan
Substitute any unique portion of a a fund sponsor name for "iShares", like "Hancock" or "WisdomTree". Again, the letters in the quote marks are not case sensitive.
[group is etf]
and [
[symbol starts with "a"] or
[symbol starts with "b"]
]
// end
Now you only have to do 13 scans
I haven't used the scan workbench for a few months now... getting pretty rusty.
Better get back on the wagon.