Notebook

rudimentary stock screener - step through a list of symbols, analyze each one, and store the result

In [48]:
symbols = 'XOM,IBM,CVX,GE,PG,T,JNJ,PFE,HBC,WFC,NVS,BP,PM,JPM,KO,RDS/A,TM,TOT,BHP,MRK,GSK,VZ,SLB,WMT,MCD,RDS/B,PEP,COP,C,ABT,SI,SNY,OXY,RIO,BAC,RY,BRK/B,MTU,BRK/A,HD,TD,DIS,STD,BBL,TSM,HMC,TEF,CAT,WBK,UTX,SAP,MO,E,KFT,V,AZN,UNH,CVS,DEO,SU,BNS,NVO,MMM,UPS,EMC,BMY,USB,AXP,CHL,UNP,HPQ,UN,UBS,CAJ,BA,PBR,GS,BUD,ABX,ABB,SMFG,BCS,DD,AMX,F,MA,DB,APC,UL,APA,MON,BBVA,HON,CL,FCX,CNQ,MDT,NKE,SPG,POT,DOW,MFG,GG,LLY,ACN,SO,NGG,EMR,TWX,BMO,NOV,HAL,DE,ING,LOW,CNI,CEO,TGT,VALE,PX,BAX,PTR,EOG,SYT,PNC,MET,YUM,CM,CS,DHR,FTE,NEM,STO,WAG,DVN,PRU,CVE,PUK,TRP,D,KMB,BT,DUK,DCM,TJX,AGN,BK,ENB,FDX,COV,SSL,EXC,HIT,NEE,AMT,TWC,PKX,MRO,ACE,MHS,MS,CTL,PCP,TRV,TYC,NSC,ITW,LFC,GIS,LMT,WLP,CSX,BHI,JCI,COF,LYG,MFC,AFL,COH,NOK,TMO,SNE,GD,GLW,PHG,PC,CMI,LVS,EP,SE,HES,BBT,MCK,STT,BLK,MT,HDB,ADM,NTT,TCK,PSA,CB,SNP,CBS,NBL,FE,APD,AEP,MOS,BEN,BAM,RTN,CRM,LO,SHG,ETN,NMR,SYY,MMC,HNZ,WMB,ED,EQR,AET,ECL,PCG,CHK,PPL,AU,DFS,RIG,AV,VTR,NLY,SYK,PSO,IBN,MJN,BDX,HCP,KYO,M,CRH,PGN,GR,VNO,TEL,PLD,AON,PEG,MPC,GM,FMS,LYB,BXP,ALL,A,RCI,TLM,ECA,NOC,HUM,CAH,WM,KB,PXD,MSI,PPG,STJ,RAI,SCHW,VLO,CAM,BRFS,SLW,PH,L,MHP,EL,ESV,OMC,IP,AGU,AUY,KR,CF,SDRL,K,SRE,CI,PGR,VRX,XEL,CCI,AMP,CP,VFC,KGC,IR,EIX,KSS,FTI,JNPR,MUR,SWK,AVB,NUE,SLF,WFT,AIG,GWW,DOV,SWN,CMG,TI,CCL,ZMH,STI,ETR,SLE,ROK,NJ,LTD,CXO,EC,MMI,KUB,TV,XRX,ADI,GFI,CHT,HST,WY,IVZ,CAG,HOG,NXY,AA,WU,TDC,FLR,AZO,RUK,HOT,RL,RRC,AES,TRI,IX,MGA,BCE,HCN,MTB,MAR,NE,ABC,ICE,BG,CBE,CCJ,BTU,CLF,GPC,RHT,PWE,JOY,MBT,HSY,TS,TTM,APH,COL,BSX,DTE,WDC,HIG,ENL,ROP,RSG,CLX,LH,BWA,DGX,CCE,AEG,SHW,SNN,JWN,CHU,SJM,BEAM,EW,TU,VMW,DNR,THI,DPS,TIF,FRX,EGO,PFG,CHA,CNX,AVP,BCR,SID,OKE,DVA,FIS,WAT,NYX,CIT,EQT,DAL,RBS,WEC,SJR,ABV/C,VAR,AME,AEE,HLF,LNC,KEY,TXT,CE,KIM,KSU,TLK,CX,LLL,DLR,CNP,COG,MCO,S,WPI,XEC,BBY,PLL,WLL,RF,BF/B,MAC,SWY,EMN,FMC,CHD,TAP,KMX,UMC,UNM,WYN,LUV,BTE,UAL,CPB,BVN,FLS,NI,CEG,HFC,PXP,BLL,DRI,BAP,SLG,GGP,XL,NBR,IHG,PCL,AEM,NU,AAP,JCP,ADS,HP,ALV,OII,QEP,WSH,FRT,ELN,FDO,JEC,MKC,CPN,ALU,FNV,HSP,CLB,DOX,IAG,KEP,AWK,CMA,ALB,TSN,CFN,GPS,MTD,RAX,SCCO,EOC,NYB,PHI,UDR,AMG,DEG,LUK,CCK,CMS,CLR,CBG,KBR,RYN,WHR,NWL,AVT,VMC,ENR,IPG,ARG,IRM,TDG,SQM,SM,SCG,ASX,LPL,MWV,OGE,WIT,PNW,CUK,EFX,TMK,LUX,SUG,DG,TPX,AGCO,DCI,PVH,ENI,XYL,HRB,HRS,JBL,O,CSC,RDC,NFX,LSI,PAY,NST,YZC,RKT,CVH,STM,IVN,LEA,ESS,GIB,LNT,HMY,TRW,VE,ATI,BCH,GAS,TAC,CIE,SPN,IFF,ANR,IGT,ARW,BPO,MGM,CPT,ASH,CBI,GNW,IHS,POM,HCA,CGV,LFL,FL,DO,ARE,OIS,SKM,PRE,PWR,PII,RMD,CPO,DKS,NRG,SAI,AMD,TSS,ANF,RGA,TEG,AUO,SUN,RHI,ERJ,RDY,SIG,TKR,HRL,MAS,MSCI,WLT,AXS,RAH,WRB,GPN,AIZ,DRC,RS,DNB,STZ,OI,X,VAL,HUB/B,TCO,WBC,EGN,MKL,MLM,OCR,RE,TSO,SBS,SNI,UHS,NFG,VIP,RCL,TKC,DHI,LRY,AJG,REG,FNF,ITC,SPW,PCS,MDU,PNR,KEX,SEE,TNB,RNR,TUP,ROC,NVE,COO,LVLT,TRH,BRE,MAN,URS,LM,MSM,MD,KMI,WF,FDS,WPX,WSM,CCH,GCI,TE,GDI,KMT,SLT,UPL,CVC,PT,SFD,IT,RJF,WCN,SNH,IEX,JLL,SNA,WAB,DRE,STR,HAR,OC,LEN,GRA,SLH,UFS,KT,HTZ,MHK,HNT,LAZ,NCR,NZT,SOA,TW,EV,NVR,TOL,SD,UA,EDU,PBI,AGP,PDS,HCC,AFG,ATR,AVY,CFR,SBH,MDR,RPM,JAH,PVX,SON,CLH,AWC,WR,BMS,LEG,SAN,DDR,GT,UGI,GME,NAV,NBG,NUS,TDW,CIM,HPT,WTR,WTM,GGG,INT,PKI,PDM,AIV,BR,BWC,ACI,CSL,GIL,TER,WCG,EBR,WRI,AGO,IM,FBHS,KRC,LXK,PKG,CVD,CYT,BMR,ACC,ATO,BIG,PHM,HME,GXP,SPR,TEX,TRN,BRO,WCC,AEO,TDS,SMS,CAE,DRQ,VC,BRY,IRE,KNM,KOF,ARCO,HBI,BID,DEI,AUQ,WDR,AYI,KEG,FLO,R,URI,KOG,RBC,HUN,ATW,MFA,ELS,PRA,ORI,BIN,AWH,CLC,Y,NNN,CVI,CHS,SCI,CDE,SIX,WRC,TGI,CBL,CR,EXR,HXL,THC,SKT,CLI,FRC,VMI,MR,ACM,CBT,FHN,TFX,WXS,ALK,CNC,OAS,CNL,HE,UNT,CMP,DBD,GWR,VVC,WTW,PL,PNY,DAN,JW/A,CXW,TEN,MAA,HIW,NSR,CYN,RBA,VLY,CYH,LHO,CPA,CRS,JEF,PPS,DF,HRC,ALR,TDY,SWI,CRI,DTG,OSK,BOH,DFG,GES,OHI,SHAW,VR,DV,ITT,AG,ACH,ATE,BC,CKH,EAT,MRX,HTS,WGL,HBM,AXE,MTW,CPL,EPR,FII,LTM,THS,CNK,YPF,DDS,DLB,CZZ,IDA,SF,ESL,SMG,MW,ATK,ESI,GMT,HLS,TTC,NLSN,ATU,DST,NJR,XLS,WRE,BIO,FCE/A,SWX,IVR,AHL,HLX,HNP,OMI,RBN,AAN,WPO,DAR,PB,BYI,BKD,BDC,CVA,FCS,GEN,LPS,LII,CLS,CRL,MOG/A,STWD,SXT,CRR,HMA,POR,THG,EME,DPZ,GNC,WSO,WWW,ALEX,CLP,HSC,SFG,UIL,VSH,AOS,CSE,PIR,RDK,TWO,AL,AOL,CAB,CW,HAE,MLI,PLT,OFC,KORS,JE,DRH,NEU,MIM,SGY,STE,FCN,MBI,SWC,ENS,G,EXPR,FBR,BCA,CNO,BRS,H,GTI,FNB,TCB,HII,WBS,JNS,ABVT,MCP,LNKD,HR,SJI,FAF,BRC,CNW,ENH,CWH,IRF,PPO,CACI,CMC,GCO,LYV,ROL,CFX,AIT,FICO,BGC,MMR,TEO,CCU,MTN,OCN,OLN,THO,FST,FUL,HL,YOKU,KOS,TRGP,JOE,SNV,AVA,BDN,BF/A,CLGX,GLF,MMS,N,HI,CYS,SPP,EXP,EXBD,IMAX,PNM,RRR,WST,ARO,DSW,SVU,DFT,DCT,HHC,CHMT,CVG,EE,CSH,SFY,STN,UNS,ASR,ALE,TC,IPI,AT,B,BKH,BKI,HOS,PRX,PTP,SSS,CHE,EGP,GHL,KCG,SKS,SVM,CUBE,DLX,MPW,TX,GFA,POL,NWN,KMPR,WMS,ANN,NWE,PAC,RLI,TIE,GEF,GET,MDP,SSD,CHH,KDN,PRI,AER,BBG,LXP,MSA,PSB,AN,TK,VSI,FLT,BKE,EQY,VCI,WTS,GPI,ICA,MTX,ONB,BCO,RLJ,CNH,MCY,MTZ,TYL,CMO,LCC,SWM,ABH,WLK,MRH,NHI,CLD,PEB,UVV,GEO,XCO,GGC,BGS,RATE,MUX,ALX,GRT,RGC,SHO,PAG,AWI,PSS,TWI,HWD,ABM,HPY,LPX,MOH,RGS,CBU,CHG,GVA,DDD,PVG,BHE,SXC,WNR,SNX,AH,SEMG,CTB,KNX,LGF,BZ,WTI,ESE,FDP,FR,HNI,LIZ,OMG,SMI,WFR,ARB,HEI/A,OEH,MHR,BEE,SSW,SUI,SWFT,WOR,AKO/B,BXS,EDR,LTC,RAD,CIG/C,EXK,VCO,AIR,AKR,KAMN,NYT,WX,KRA,BKU,EXH,UNF,ELX,IO,SHI,TAL,USG,ZNH,AKS,BGG,EDE,LG,MDC,MTG,MWW,GOV,ANH,CCC,RWT,KS,POST,BLT,CNA,DEL,DIN,SAM,ARR,FSM,ABG,JNY,PBH,RGR,TXI,DLPH,AF,AXL,GEF/B,ODP,ORB,RES,CLW,LRN,ACO,CUB,HT,LNN,PFS,RYL,SCS,TTI,P,CEA,CWT,KFY,KOP,NPO,PBY,PHH,SYA,CATO,DY,KBH,NAT,PKD,PVD,CXS,BMA,CBB,EVR,KNL,LZB,OPK,PCX,GNRC,UIS,WNC,AEL,MTOR,VGR,CEC,CRK,HEI,KWK,NCI,NR,OXM,PEI,SPB,TNC,FSL,VAC,NSP,CEL,GLT,NNI,RTI,RSH,RENN,AWR,BLC,CNS,FPO,GPK,PNK,AGRO,ABD,AVX,AYR,EIG,HGR,HMN,HXM,IRC,KNXA,TBI,MTH,SCL,USM,AAV,ETH,IIT,MTL,TR,NX,AAT,AIN,MTRN,IBI,LXU,NFP,GDOT,LPR,WAL,AEC,AZZ,CUZ,QTM,FCF,ROG,TISI,TGH,FIO,CIR,REN,TMH,CODE,ZQK,AHT,BAS,DSX,FOE,NCT,SAH,SHS,FOR,GZT,AKO/A,GB,GBX,NC,SFL,ESC,FTK,GFF,GSH,PKE,TSL,DGI,CLNY,CHSP,AM,BLX,COT,DW,HF,IVC,KND,KWR,NDZ,TG,JAG,AEA,SFI,LAD,LDR,TPC,SMP,VIT,BKS,EPL,MIG,NRF,OFG,SXI,JBT,ONE,BMI,CASC,BH,DX,FCH,KBW,MFB,RT,LL,PMT,KAR,RLD,ELT,OMX,CCO,GTY,ITG,KKD,NPK,PZE,PGI,RDN,SKX,GTS,BPI,PAM,LPI,EGY,WMK,WPP,BWS,BYD,CQB,FIX,MWA,PJC,SPF,SSI,TNS,LDK,DHX,GA,SEM,KW,PRIS/B,UHT,CIA,CKP,CMN,END,FFG,GDP,KRO,MOD,MYE,RA,INXN,UAM,CGX,EBF,ELY,KEM,MKC/V,PTI,RPT,RSO,SRZ,SUP,COR,AVD,CPK,CV,VVI,HHS,NP,TPL,TRC,FSR,DUF,ISS,YGE,VHS,UBA,IN,MOV,PQ,STP,EXAM,ACW,BPZ,CTS,EBS,MEI,ORA,TREX,MIL,PRO,PMC,EJ,ES,DOLE,MG,CALX,EXL,HPP,KH,VG,HTH,BTH,CGI,GMK,LF,MDF,MNR,OB,PBNY,FLY,ZEP,FN,WNS,ALC,BRP,CYD,SFE,STRI,CCG,DANG,VHI,TCL,DVR,GY,KRG,SJW,ARI,PPC,WAIR,BFS,CBZ,CPE,AOI,DRD,FSS,FUR,HVB,NM,SSP,SVN,QUAD,PRIS,USNA,UTI,UTL,VQ,CBR,FRO,FRM,XOXO,LSE,SMA,STL,KAI,DM,BTM/C,PLOW,NOR,ENV,IPHI,BAH,THR,WGO,CDR,GCA,GFIG,MCS,OSG,CAP,HGG,INN,CBS/A,WHG,ADC,BZH,CSU,GPX,HUB/A,MED,CVO,OMN,SRI,STC,TNK,GGS,AMRC,CJES,WWE,ALG,ANW,BFR,HNR,HVT,MHO,NCS,PHX,PNX,REX,SYX,IL,DMD,QIHU,SN,CPAC,WG,AHS,ARC,CAS,CBM,STZ/B,CDI,CSA,GNK,IRS,OLP,PKY,PVA,RAS,TLB,TRK,MX,SFUN,MITT,FENG,RSE,SLCA,DK,ETM,GBL,HZO,IMN,JRN,LEN/B,LVB,MGI,MLR,SWS,TGS,STV,ORN,TRNO,STNG,RRTS,BOX,CMRE,ARX,BCEI,ASI,AGM,AP,CSS,HW,DRL,FVE,OPY,HOV,IBA,NOA,OME,REV,SBX,SEH,TNP,SCR,SOL,SB,MUSA,ACTV,AMTG,TEA,INVN,IMPV,GWRE,RNDY,USU,VPG,AI,HDY,KCP,LDL,MTE,NGS,NTE,PIKE,TUC,ART,CLDT,MY,FXCM,FF,TMS,PPP,GNE,MN,MTDR,WNI,CRY,DCO,FBC,HIL,DYN,MILL,MPR,TVL,XRS,NOAH,WD,PTGI,UFI,ALJ,FC,GMXR,IDT,ISH,MDS,MNI,MSO,SGK,PULS,TRR,JMP,SKH,AMBO,CCSC,PRLB,RLH,EQU,ENZ,GKK,GTN,MPG,NL,EDN,RST,XRM,ABR,BBW,CFI,CSV,DAC,EXM,LUB,MPX,NTZ,ODC,AHC,CO,JKS,MXL,XUE,TEU,STAG,AVG,GWAY,EPAM,CBK,NLS,DHT,EVC,FBN,FBP,FMD,IHC,RC,SPA,OWW,XIN,CGA,CCM,DEXO,BALT,CSFS,CIS,TOWR,BITA,GCAP,NPTN,TAOM,GSE,ZLC,ZZ,BIO/B,BRT,BXC,CRD/A,JW/B,KV/A,MEG,NWY,SCX,NPD,SQNS,PACD,FX,UBP,ADY,AIQ,AOB,BSI,BXG,CRD/B,CT,PAR,KID,SKY,TGX,PRGN,PZN,UTA,CHC,DQ,SHP,LAS,FRF,IFT,NQ,ZX,HRG,SAB,BBX,DDE,FCE/B,KFS,FAC,MLP,MOG/B,SR,ATV,MXT,GRO,GSL,GSI,DL,XNY,ZA,DDMG,AXR,CPF,DVD,HVT/A,KV/B,SRT,TAP/A,TMM,QXM,NED,WH,GU,VRS,CTC,BORN,SYSW,ARL,GTN/A,TCI,CMM'
In [49]:
symbols = symbols.split(',')
In [50]:
symbols
Out[50]:
['XOM',
 'IBM',
 'CVX',
 'GE',
 'PG',
 'T',
 'JNJ',
 'PFE',
 'HBC',
 'WFC',
 'NVS',
 'BP',
 'PM',
 'JPM',
 'KO',
 'RDS/A',
 'TM',
 'TOT',
 'BHP',
 'MRK',
 'GSK',
 'VZ',
 'SLB',
 'WMT',
 'MCD',
 'RDS/B',
 'PEP',
 'COP',
 'C',
 'ABT',
 'SI',
 'SNY',
 'OXY',
 'RIO',
 'BAC',
 'RY',
 'BRK/B',
 'MTU',
 'BRK/A',
 'HD',
 'TD',
 'DIS',
 'STD',
 'BBL',
 'TSM',
 'HMC',
 'TEF',
 'CAT',
 'WBK',
 'UTX',
 'SAP',
 'MO',
 'E',
 'KFT',
 'V',
 'AZN',
 'UNH',
 'CVS',
 'DEO',
 'SU',
 'BNS',
 'NVO',
 'MMM',
 'UPS',
 'EMC',
 'BMY',
 'USB',
 'AXP',
 'CHL',
 'UNP',
 'HPQ',
 'UN',
 'UBS',
 'CAJ',
 'BA',
 'PBR',
 'GS',
 'BUD',
 'ABX',
 'ABB',
 'SMFG',
 'BCS',
 'DD',
 'AMX',
 'F',
 'MA',
 'DB',
 'APC',
 'UL',
 'APA',
 'MON',
 'BBVA',
 'HON',
 'CL',
 'FCX',
 'CNQ',
 'MDT',
 'NKE',
 'SPG',
 'POT',
 'DOW',
 'MFG',
 'GG',
 'LLY',
 'ACN',
 'SO',
 'NGG',
 'EMR',
 'TWX',
 'BMO',
 'NOV',
 'HAL',
 'DE',
 'ING',
 'LOW',
 'CNI',
 'CEO',
 'TGT',
 'VALE',
 'PX',
 'BAX',
 'PTR',
 'EOG',
 'SYT',
 'PNC',
 'MET',
 'YUM',
 'CM',
 'CS',
 'DHR',
 'FTE',
 'NEM',
 'STO',
 'WAG',
 'DVN',
 'PRU',
 'CVE',
 'PUK',
 'TRP',
 'D',
 'KMB',
 'BT',
 'DUK',
 'DCM',
 'TJX',
 'AGN',
 'BK',
 'ENB',
 'FDX',
 'COV',
 'SSL',
 'EXC',
 'HIT',
 'NEE',
 'AMT',
 'TWC',
 'PKX',
 'MRO',
 'ACE',
 'MHS',
 'MS',
 'CTL',
 'PCP',
 'TRV',
 'TYC',
 'NSC',
 'ITW',
 'LFC',
 'GIS',
 'LMT',
 'WLP',
 'CSX',
 'BHI',
 'JCI',
 'COF',
 'LYG',
 'MFC',
 'AFL',
 'COH',
 'NOK',
 'TMO',
 'SNE',
 'GD',
 'GLW',
 'PHG',
 'PC',
 'CMI',
 'LVS',
 'EP',
 'SE',
 'HES',
 'BBT',
 'MCK',
 'STT',
 'BLK',
 'MT',
 'HDB',
 'ADM',
 'NTT',
 'TCK',
 'PSA',
 'CB',
 'SNP',
 'CBS',
 'NBL',
 'FE',
 'APD',
 'AEP',
 'MOS',
 'BEN',
 'BAM',
 'RTN',
 'CRM',
 'LO',
 'SHG',
 'ETN',
 'NMR',
 'SYY',
 'MMC',
 'HNZ',
 'WMB',
 'ED',
 'EQR',
 'AET',
 'ECL',
 'PCG',
 'CHK',
 'PPL',
 'AU',
 'DFS',
 'RIG',
 'AV',
 'VTR',
 'NLY',
 'SYK',
 'PSO',
 'IBN',
 'MJN',
 'BDX',
 'HCP',
 'KYO',
 'M',
 'CRH',
 'PGN',
 'GR',
 'VNO',
 'TEL',
 'PLD',
 'AON',
 'PEG',
 'MPC',
 'GM',
 'FMS',
 'LYB',
 'BXP',
 'ALL',
 'A',
 'RCI',
 'TLM',
 'ECA',
 'NOC',
 'HUM',
 'CAH',
 'WM',
 'KB',
 'PXD',
 'MSI',
 'PPG',
 'STJ',
 'RAI',
 'SCHW',
 'VLO',
 'CAM',
 'BRFS',
 'SLW',
 'PH',
 'L',
 'MHP',
 'EL',
 'ESV',
 'OMC',
 'IP',
 'AGU',
 'AUY',
 'KR',
 'CF',
 'SDRL',
 'K',
 'SRE',
 'CI',
 'PGR',
 'VRX',
 'XEL',
 'CCI',
 'AMP',
 'CP',
 'VFC',
 'KGC',
 'IR',
 'EIX',
 'KSS',
 'FTI',
 'JNPR',
 'MUR',
 'SWK',
 'AVB',
 'NUE',
 'SLF',
 'WFT',
 'AIG',
 'GWW',
 'DOV',
 'SWN',
 'CMG',
 'TI',
 'CCL',
 'ZMH',
 'STI',
 'ETR',
 'SLE',
 'ROK',
 'NJ',
 'LTD',
 'CXO',
 'EC',
 'MMI',
 'KUB',
 'TV',
 'XRX',
 'ADI',
 'GFI',
 'CHT',
 'HST',
 'WY',
 'IVZ',
 'CAG',
 'HOG',
 'NXY',
 'AA',
 'WU',
 'TDC',
 'FLR',
 'AZO',
 'RUK',
 'HOT',
 'RL',
 'RRC',
 'AES',
 'TRI',
 'IX',
 'MGA',
 'BCE',
 'HCN',
 'MTB',
 'MAR',
 'NE',
 'ABC',
 'ICE',
 'BG',
 'CBE',
 'CCJ',
 'BTU',
 'CLF',
 'GPC',
 'RHT',
 'PWE',
 'JOY',
 'MBT',
 'HSY',
 'TS',
 'TTM',
 'APH',
 'COL',
 'BSX',
 'DTE',
 'WDC',
 'HIG',
 'ENL',
 'ROP',
 'RSG',
 'CLX',
 'LH',
 'BWA',
 'DGX',
 'CCE',
 'AEG',
 'SHW',
 'SNN',
 'JWN',
 'CHU',
 'SJM',
 'BEAM',
 'EW',
 'TU',
 'VMW',
 'DNR',
 'THI',
 'DPS',
 'TIF',
 'FRX',
 'EGO',
 'PFG',
 'CHA',
 'CNX',
 'AVP',
 'BCR',
 'SID',
 'OKE',
 'DVA',
 'FIS',
 'WAT',
 'NYX',
 'CIT',
 'EQT',
 'DAL',
 'RBS',
 'WEC',
 'SJR',
 'ABV/C',
 'VAR',
 'AME',
 'AEE',
 'HLF',
 'LNC',
 'KEY',
 'TXT',
 'CE',
 'KIM',
 'KSU',
 'TLK',
 'CX',
 'LLL',
 'DLR',
 'CNP',
 'COG',
 'MCO',
 'S',
 'WPI',
 'XEC',
 'BBY',
 'PLL',
 'WLL',
 'RF',
 'BF/B',
 'MAC',
 'SWY',
 'EMN',
 'FMC',
 'CHD',
 'TAP',
 'KMX',
 'UMC',
 'UNM',
 'WYN',
 'LUV',
 'BTE',
 'UAL',
 'CPB',
 'BVN',
 'FLS',
 'NI',
 'CEG',
 'HFC',
 'PXP',
 'BLL',
 'DRI',
 'BAP',
 'SLG',
 'GGP',
 'XL',
 'NBR',
 'IHG',
 'PCL',
 'AEM',
 'NU',
 'AAP',
 'JCP',
 'ADS',
 'HP',
 'ALV',
 'OII',
 'QEP',
 'WSH',
 'FRT',
 'ELN',
 'FDO',
 'JEC',
 'MKC',
 'CPN',
 'ALU',
 'FNV',
 'HSP',
 'CLB',
 'DOX',
 'IAG',
 'KEP',
 'AWK',
 'CMA',
 'ALB',
 'TSN',
 'CFN',
 'GPS',
 'MTD',
 'RAX',
 'SCCO',
 'EOC',
 'NYB',
 'PHI',
 'UDR',
 'AMG',
 'DEG',
 'LUK',
 'CCK',
 'CMS',
 'CLR',
 'CBG',
 'KBR',
 'RYN',
 'WHR',
 'NWL',
 'AVT',
 'VMC',
 'ENR',
 'IPG',
 'ARG',
 'IRM',
 'TDG',
 'SQM',
 'SM',
 'SCG',
 'ASX',
 'LPL',
 'MWV',
 'OGE',
 'WIT',
 'PNW',
 'CUK',
 'EFX',
 'TMK',
 'LUX',
 'SUG',
 'DG',
 'TPX',
 'AGCO',
 'DCI',
 'PVH',
 'ENI',
 'XYL',
 'HRB',
 'HRS',
 'JBL',
 'O',
 'CSC',
 'RDC',
 'NFX',
 'LSI',
 'PAY',
 'NST',
 'YZC',
 'RKT',
 'CVH',
 'STM',
 'IVN',
 'LEA',
 'ESS',
 'GIB',
 'LNT',
 'HMY',
 'TRW',
 'VE',
 'ATI',
 'BCH',
 'GAS',
 'TAC',
 'CIE',
 'SPN',
 'IFF',
 'ANR',
 'IGT',
 'ARW',
 'BPO',
 'MGM',
 'CPT',
 'ASH',
 'CBI',
 'GNW',
 'IHS',
 'POM',
 'HCA',
 'CGV',
 'LFL',
 'FL',
 'DO',
 'ARE',
 'OIS',
 'SKM',
 'PRE',
 'PWR',
 'PII',
 'RMD',
 'CPO',
 'DKS',
 'NRG',
 'SAI',
 'AMD',
 'TSS',
 'ANF',
 'RGA',
 'TEG',
 'AUO',
 'SUN',
 'RHI',
 'ERJ',
 'RDY',
 'SIG',
 'TKR',
 'HRL',
 'MAS',
 'MSCI',
 'WLT',
 'AXS',
 'RAH',
 'WRB',
 'GPN',
 'AIZ',
 'DRC',
 'RS',
 'DNB',
 'STZ',
 'OI',
 'X',
 'VAL',
 'HUB/B',
 'TCO',
 'WBC',
 'EGN',
 'MKL',
 'MLM',
 'OCR',
 'RE',
 'TSO',
 'SBS',
 'SNI',
 'UHS',
 'NFG',
 'VIP',
 'RCL',
 'TKC',
 'DHI',
 'LRY',
 'AJG',
 'REG',
 'FNF',
 'ITC',
 'SPW',
 'PCS',
 'MDU',
 'PNR',
 'KEX',
 'SEE',
 'TNB',
 'RNR',
 'TUP',
 'ROC',
 'NVE',
 'COO',
 'LVLT',
 'TRH',
 'BRE',
 'MAN',
 'URS',
 'LM',
 'MSM',
 'MD',
 'KMI',
 'WF',
 'FDS',
 'WPX',
 'WSM',
 'CCH',
 'GCI',
 'TE',
 'GDI',
 'KMT',
 'SLT',
 'UPL',
 'CVC',
 'PT',
 'SFD',
 'IT',
 'RJF',
 'WCN',
 'SNH',
 'IEX',
 'JLL',
 'SNA',
 'WAB',
 'DRE',
 'STR',
 'HAR',
 'OC',
 'LEN',
 'GRA',
 'SLH',
 'UFS',
 'KT',
 'HTZ',
 'MHK',
 'HNT',
 'LAZ',
 'NCR',
 'NZT',
 'SOA',
 'TW',
 'EV',
 'NVR',
 'TOL',
 'SD',
 'UA',
 'EDU',
 'PBI',
 'AGP',
 'PDS',
 'HCC',
 'AFG',
 'ATR',
 'AVY',
 'CFR',
 'SBH',
 'MDR',
 'RPM',
 'JAH',
 'PVX',
 'SON',
 'CLH',
 'AWC',
 'WR',
 'BMS',
 'LEG',
 'SAN',
 'DDR',
 'GT',
 'UGI',
 'GME',
 'NAV',
 'NBG',
 'NUS',
 'TDW',
 'CIM',
 'HPT',
 'WTR',
 'WTM',
 'GGG',
 'INT',
 'PKI',
 'PDM',
 'AIV',
 'BR',
 'BWC',
 'ACI',
 'CSL',
 'GIL',
 'TER',
 'WCG',
 'EBR',
 'WRI',
 'AGO',
 'IM',
 'FBHS',
 'KRC',
 'LXK',
 'PKG',
 'CVD',
 'CYT',
 'BMR',
 'ACC',
 'ATO',
 'BIG',
 'PHM',
 'HME',
 'GXP',
 'SPR',
 'TEX',
 'TRN',
 'BRO',
 'WCC',
 'AEO',
 'TDS',
 'SMS',
 'CAE',
 'DRQ',
 'VC',
 'BRY',
 'IRE',
 'KNM',
 'KOF',
 'ARCO',
 'HBI',
 'BID',
 'DEI',
 'AUQ',
 'WDR',
 'AYI',
 'KEG',
 'FLO',
 'R',
 'URI',
 'KOG',
 'RBC',
 'HUN',
 'ATW',
 'MFA',
 'ELS',
 'PRA',
 'ORI',
 'BIN',
 'AWH',
 'CLC',
 'Y',
 'NNN',
 'CVI',
 'CHS',
 'SCI',
 'CDE',
 'SIX',
 'WRC',
 'TGI',
 'CBL',
 'CR',
 'EXR',
 'HXL',
 'THC',
 'SKT',
 'CLI',
 'FRC',
 'VMI',
 'MR',
 'ACM',
 'CBT',
 'FHN',
 'TFX',
 'WXS',
 'ALK',
 'CNC',
 'OAS',
 'CNL',
 'HE',
 'UNT',
 'CMP',
 'DBD',
 'GWR',
 'VVC',
 'WTW',
 'PL',
 'PNY',
 'DAN',
 'JW/A',
 'CXW',
 'TEN',
 'MAA',
 'HIW',
 'NSR',
 'CYN',
 'RBA',
 'VLY',
 'CYH',
 'LHO',
 'CPA',
 'CRS',
 'JEF',
 'PPS',
 'DF',
 'HRC',
 'ALR',
 'TDY',
 'SWI',
 'CRI',
 'DTG',
 'OSK',
 'BOH',
 'DFG',
 'GES',
 'OHI',
 'SHAW',
 'VR',
 'DV',
 'ITT',
 'AG',
 'ACH',
 'ATE',
 'BC',
 'CKH',
 'EAT',
 'MRX',
 'HTS',
 'WGL',
 'HBM',
 'AXE',
 'MTW',
 'CPL',
 'EPR',
 'FII',
 'LTM',
 'THS',
 'CNK',
 'YPF',
 'DDS',
 'DLB',
 'CZZ',
 'IDA',
 'SF',
 'ESL',
 'SMG',
 'MW',
 'ATK',
 'ESI',
 'GMT',
 'HLS',
 'TTC',
 'NLSN',
 'ATU',
 'DST',
 'NJR',
 'XLS',
 'WRE',
 'BIO',
 'FCE/A',
 'SWX',
 'IVR',
 'AHL',
 'HLX',
 'HNP',
 'OMI',
 'RBN',
 'AAN',
 'WPO',
 'DAR',
 'PB',
 'BYI',
 'BKD',
 'BDC',
 'CVA',
 'FCS',
 'GEN',
 'LPS',
 'LII',
 'CLS',
 'CRL',
 'MOG/A',
 'STWD',
 'SXT',
 'CRR',
 'HMA',
 'POR',
 'THG',
 'EME',
 'DPZ',
 'GNC',
 'WSO',
 'WWW',
 'ALEX',
 'CLP',
 'HSC',
 'SFG',
 'UIL',
 'VSH',
 'AOS',
 'CSE',
 'PIR',
 'RDK',
 'TWO',
 'AL',
 'AOL',
 'CAB',
 'CW',
 'HAE',
 'MLI',
 'PLT',
 'OFC',
 'KORS',
 'JE',
 'DRH',
 'NEU',
 'MIM',
 'SGY',
 'STE',
 'FCN',
 'MBI',
 'SWC',
 'ENS',
 'G',
 'EXPR',
 'FBR',
 'BCA',
 'CNO',
 'BRS',
 'H',
 'GTI',
 'FNB',
 'TCB',
 ...]
In [51]:
len(symbols)
Out[51]:
1867
In [52]:
m = {}
for s in symbols:
    data = get_pricing(s,start_date='2013-03-20',end_date='2015-03-20',fields='price',frequency='minute')
    m[s] = data.mean()

---------------------------------------------------------------------------
NoSuchSymbols                             Traceback (most recent call last)
<ipython-input-52-481323337206> in <module>()
      1 m = {}
      2 for s in symbols:
----> 3     data = get_pricing(s,start_date='2013-03-20',end_date='2015-03-20',fields='price',frequency='minute')
      4     m[s] = data.mean()

/home/qexec/src/qexec_repo/qexec/research/api.py in get_pricing(symbols, start_date, end_date, symbol_reference_date, frequency, fields, handle_missing)
    153         frequency=frequency,
    154         fields=fields,
--> 155         handle_missing_mode=handle_missing,
    156     )
    157 

/home/qexec/src/qexec_repo/qexec/research/web/client.py in get_pricing(self, symbols, start_date, end_date, symbol_reference_date, frequency, fields, handle_missing_mode)
    228 
    229         missing = resp_json['missing']
--> 230         self.handle_missing(handle_missing_mode, missing)
    231 
    232         items = ensure_list(fields)

/home/qexec/src/qexec_repo/qexec/research/web/client.py in handle_missing(self, mode, missing)
    134                 'log': self.log_missing_securities,
    135                 'ignore': lambda m: None,
--> 136             }[mode](missing)
    137 
    138     def _make_symbols_request(self, symbols, symbol_reference_date):

/home/qexec/src/qexec_repo/qexec/research/web/client.py in raise_for_missing(missing_securities)
    122     @staticmethod
    123     def raise_for_missing(missing_securities):
--> 124         raise NoSuchSymbols(missing_securities)
    125 
    126     def handle_missing(self, mode, missing):

NoSuchSymbols: Failed to find securities matching [u'HBC']
In [53]:
m
Out[53]:
{'CVX': 119.42519906351585,
 'GE': 25.229568648547588,
 'IBM': 183.69617686914876,
 'JNJ': 96.047648482915875,
 'PFE': 30.303341805451183,
 'PG': 81.765175189702532,
 'T': 34.847873182837944,
 'XOM': 93.835498152856971}
In [ ]: