StockFetcher Forums · Filter Exchange · Didn't someone create an ETF filter?<< >>Post Follow-up
karennma
6,831 posts
msg #58314
Ignore karennma
12/20/2007 8:09:31 AM

symlist(ETF)??
The filter included a list of all the ETFs.
Anyone know how to find it?
THANKS.




chetron
2,817 posts
msg #58359
Ignore chetron
12/20/2007 7:04:44 PM

I DID A SEARCH ON "ETF" AND IT CAME UP

Fetcher[
/* ETF Filter */

/* APPLY TO ETF SYMLIST*/
apply to Symlist (QQQQ,SPY,IWM,GLD,MDY,EEM,FXI,DIA,FXY,XLB,XLV,XLP,XLY,XLE,XLF,XLI,XLK,XLU,IVV,IVW,IVE,IJH,IJK,IJJ)
apply to Symlist (IJR,IJT,IJS,IEV,IYY,IYM,IYC,IYK,IYE,IYF,IYH,IYJ,IYW,IYZ,IDU,IYG,IYR,IWV,IWZ,IWW,IWO,IWN,IWB,IWF,IWD)
apply to Symlist (HHH,RKH,UTH,PPH,BHH,IIH,IAH,BBH,BDH,SMH,TTH,EWU,EWT,EWL,EWD,EWP,EWY,EWS,EWN,EWW,EWJ)
apply to Symlist (EWI,EWH,EWG,EWQ,EWC,EWZ,EWK,EWO,EWA,EWM,EZU,ELV,ELG,DSV,DSG,DGT,MTK,TMW,OEF,IOO)
apply to Symlist (ICF,IBB,IGM,RWR,VTI,IGN,IGW,IGV,IWP,IWR,IWS,EFA,IGE,EPP,ILF,ITF,IXC,IXG,IXJ,IXN,IXP,VXF,SHY,IEF,TLT)
apply to Symlist (LQD,RSP,FEZ,FEU,PWC,PWO,AGG,IYT,ONEQ,DVY,TIP,EZA,VV,VO,VB,VTV,VUG,VBK,VCR,VDC,VDE,VFH)
apply to Symlist (VHT,VIS,VGT,VAW,VOX,VPU,VBR,ADRE,ADRD,ADRU,ADRA,ISI,JKD,JKE,JKF,JKG,JKH,JKI,JKJ,JKK,JKL,NYC)
apply to Symlist (NY,VNQ,PEY,PGJ,IAU,KLD,PBW,PWT,PWJ,PWB,PWY,PWP,PWV,VGK,VPL,VWO,XLG,PJP,PBE,PBJ,PEJ,PBS)
apply to Symlist (PXQ,PSI,PSJ,EFV,EFG,IWC,PZI,PID,PFM,PHJ,PPA,PXN,PKB,PXE,PIC,PXJ,PMR,PUI,FDM,ELR,EMM,EMV,EMG)
apply to Symlist (DSC,KBE,KIE,KCE,SDY,RTH,SWH,OIH,MKH,EKH,WMH,PIV,PHO,PHW,PTE,PRF,XBI,XHB,XSD,PZJ,RPV,RPG)
apply to Symlist (RFV,RFG,RZV,RZG,FXE,DBC,FDL,USO,FPX,QTEC,VIG,QQEW,SLV,IEO,IEZ,IHE,IHF,IHI,GDX,IAI,IAK,IAT,ITA)
apply to Symlist (ITB,DWM,DTH,DTN,DEW,DFE,DEB,DTD,DHS,DES,DOO,DOL,DND,DNH,DIM,DON,DLS,DNL,DFJ,DXJ,DLN)
apply to Symlist (SSO,XES,XOP,XPH,XRT,KRE,QLD,GSP,XME,DJP,MZZ,FBT,DDM,MVV,SH,PSQ,DOG,SDS,QID,FDN,DXD,FDV)
apply to Symlist (MYY,FXB,FXC,FXA,FXF,FXS,FXM,GSG,VOE,VOT,OIL,SLX,EVX,PGF,PSP,PDP,PYH,EEB,NFO,XRO,CVY,DBN)
apply to Symlist (DPC,DPN,DKA,DRF,DBR,DDI,DBT,DBU,DGG,VYM,DBV,PRFM,PRFG,PRFS,PRFE,PRFF,PRFH,PRFN,PRFQ)
apply to Symlist (PRFU,PRFZ,EEN,EEW,RXI,KXI,EXI,MXI,JXI,STH,PYZ,PEZ,PSL,PTH,PRN,PTF,PJB,PTJ,PKW,PZD,PXI,PFI,PIQ)
apply to Symlist (PJF,PJG,PJM,PVM,PGZ,NXT,FVI,FVD,PUW,RCD,RHS,RYE,RYF,RYH,RGI,RTM,RYT,RYU,DSI,JPP,JSC,UCR,DCR)
apply to Symlist (INP,CSD,OTP,GRN,DEF,RWX,GMF,GXC,GMM,GUR,GML,GAF,GWL,UWM,SAA,UYM,UGE,UCC,UYG)
apply to Symlist (RXL,UXI,DIG,URE,USD,ROM,UPW,RWM,SBB,TWM,SDD,SMN,SZK,SCC,SKF,RXD,SIJ,DUG,SRS,SSG,REW)
apply to Symlist (SDP,DGL,DBO,DBP,DBB,DBS,DBA,DBE,SHV,IEI,CSJ,TLH,CIU,CFT,GVI,GBF,MBB,CWI,HHA,HHK,HHE,HRD)
apply to Symlist (HHQ,HRW,HHD,HHJ,HHV,HRJ,HHT,HHU,HHG,HHM,HHN,HHZ,HHP,HHB,HHR,GII,FVL,UVG,UKF,UVU)
apply to Symlist (UKW,UVT,UKK,SJF,SDK,SKK,SJH,QQXT,UUP,UDN,QCLN,SFK,SJL,EXT,EEZ,EZY,EPS,EZM,EES,DEM,DRW)
apply to Symlist (BIL,ITE,TLO,IPE,LAG,VEU,TDD,TDH,TDN,TDV,TDX,CZG,CZA,XGC,OTR,PFF,GEX,RSX,BST,BMV,BES,HYG)
apply to Symlist (BSV,BIV,BLV,BND,LVL,KSF,MCG,SCV,UNG,GWX,FXD,FXG,FXN,FXO,FXH,FXR,FXZ,FXL,FXU,FEX,FNX,FYX)
apply to Symlist (FTA,FTC,FAB,FAD,FRI,REZ,FIO,RTL,REM,FTY,CGW,JYN,GBB,ERO,FNI,FCG,FIW,BWV,PBD,PEH,PUA,PIO)
apply to Symlist (PFA,PAF,PXF,PEF,PJO,IDV,CLV,BIK,JNR,ENY,EXB,CRO,HGI,VEA,PDN,PWD,PXH,PFP,ROB,MOO,NLR)
apply to Symlist (WPS,EEH,MZN,MZO,MZG,AGV,ACK,ATY,AQS,ACB,AKB,FDD,FFR,MUB,TFI,BWX,PDQ,CMF,NYF,PZA)
apply to Symlist (PZT,PWZ,PLW,PCY,CXA,INY,SHM,SFV,SIH,SNB,SSK,SVD,SZG,WMW,JJA,JJE,JJG,JJM,COW,GAZ,JJN)
apply to Symlist (JJC,IRO,EFZ,EUM,EFU,DGS,RJI,RJA,RJN,RJZ,EEV)



/* profit checker - long only */

set{ LongProfit, high - open}
set{Long10, count(longprofit above .10, 100) }
set{Long50, count(longprofit above .50, 100) }
set{LoseLg, Long10 - Long50}

add column LoseLg
add column LongProfit
add column Long10
add column Long50

and add column cma(longprofit, 100)

/* profit checker - short only */

set{ ShortProfit, open - low }
set{Short10, count(Shortprofit above .10, 100) }
set{Short50, count(Shortprofit above .50, 100) }
set{LoseSh, Short10 - Short50}

add column LoseSh
add column ShortProfit
add column Short10
add column Short50

and add column cma(Shortprofit, 100)



/* VOLUME CALCULATIONS */
set{v, volume 1 day ago}
set{volinc, volume - v}
set{volpc, volinc / v}
set{volpct, volpc * 100}

set{VolZ, days(volume < 1,100)}
set{VolUp, days(volume is below volume 1 day ago,100)}
set{VolDn, days(volume is above volume 1 day ago,100)}
set{VlXvl, VolUp - VolDn}

set{vck1, volume 1 day ago }
set{vck, volume / vck1 }
set{vdbl, days(vck < 2, 100)}

and add column VlXvl
and add column Vdbl
and add column volpct

/* END VOLUME CALCULATIONS */

add column industry

sort column 4 descending


]



karennma
6,831 posts
msg #58360
Ignore karennma
12/20/2007 7:10:22 PM

thanks.
i couldn't find it.
:>)


nikoschopen
2,824 posts
msg #58404
Ignore nikoschopen
12/21/2007 6:35:54 PM

The filter included a list of all the ETFs.

Fetcher[stock is ETF]



dbyrt
70 posts
msg #58405
Ignore dbyrt
12/21/2007 6:41:15 PM

"The filter included a list of all the ETFs"

Using "stock is ETF" will only find you a small proportion (152) of the ETFs. There are over 600.

The symlist that was created was up-to-date a couple of weeks ago and contains most of those 600.
New ETFs are coming almost weekly.

StockFetcher Forums · Filter Exchange · Didn't someone create an ETF filter?<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus