StockFetcher Forums · Filter Exchange · ETF Filter<< 1 2 >>Post Follow-up
TheRumpledOne
6,411 posts
msg #55959
Ignore TheRumpledOne
modified
10/23/2007 5:32:00 PM

Fetcher[
/* ETF Filter */

MARKET IS ETF

/* 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
]



Muddy/Wallman gave me the heads up on an ETF today. So I figured, I should look at the stats.

Thanks Mudd Man.



rharmelink
81 posts
msg #55974
Ignore rharmelink
10/23/2007 11:35:15 PM

Unfortunately, "Market is ETF" only identifies 151 ETFs and there are currently over 500...

glgene
616 posts
msg #55986
Ignore glgene
10/24/2007 11:32:46 AM

Doesn't SF include UltraETFs (ones that are 2x an index, such as SKF)?

dbyrt
70 posts
msg #56906
Ignore dbyrt
11/21/2007 12:57:06 PM

I did a search on Yahoo, which has a good ETF section, http://finance.yahoo.com/etf

and found that there are indeed over 600 ETFs.

After some cut and pasting, see below to run in any filters to select on all ETF's I could find. There may be a better way to list them all, but this seemed to work.

/* 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)

Have fun.

chetron
2,817 posts
msg #56908
Ignore chetron
11/21/2007 1:08:22 PM

THANX TRO AND dbyrt

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


]



lawfej
9 posts
msg #59128
Ignore lawfej
1/18/2008 4:31:08 PM

Many Thanks dbyrt

TheRumpledOne
6,411 posts
msg #60561
Ignore TheRumpledOne
3/17/2008 2:16:33 PM

In my inbox today:

http://www.etfprofitdriver.com/documents/UndergroundETFProfitBlueprint_369216.pdf

ProZachJ
8 posts
msg #60771
Ignore ProZachJ
3/26/2008 12:28:28 AM

OK now what is the significance of the data that this gives...i am a noob to trading have only managed to work my way through 4 books and about 2 months of paper trading. Where do i go from here?

rtucker
318 posts
msg #64153
Ignore rtucker
6/21/2008 4:08:10 PM

Here are a couple new commodity etfs.

DAG is double long . AGA is double short. New and thin for now.

They look like DBA (corn, wheat, soybean, sugar) but I may be wrong.

Fetcher[symlist(DAG,AGA)]




WALLSTREETGENIUS
983 posts
msg #64177
Ignore WALLSTREETGENIUS
6/22/2008 5:01:53 PM

Most of these are from the Swiss-based
financial giant...UBS.
________________

Agriculture.........(UAG)
Livestock...........(UBC)
Livestock...........(LSO) cattle & hogs 70/30
Metals................(UBM)
Food...................(FUD)
Energy................(UBN
Gold....................(UBZ)
Silver...................(USZ)
Heating Oil........ (UHN)



RIGGS

StockFetcher Forums · Filter Exchange · ETF Filter<< 1 2 >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.