addisonlynch / iexfinance

Python SDK for IEX Cloud
https://addisonlynch.github.io/iexfinance
Apache License 2.0
649 stars 136 forks source link

Some stocks inexplicably have no closing price #235

Open kyrofa opened 3 years ago

kyrofa commented 3 years ago

Summary (include Python version)

Using Python 3.6.9 and iexfinance v0.4.3, I'm trying to fetch the closing price of a number of stocks. Some of them are oddly None:

$ python3
>>> import iexfinance.stocks
>>> stock = iexfinance.stocks.Stock('ANH-A')
>>> stock.get_close() == None
True

Date/time of issue

Wednesday, December 9th, 21:00 Pacific.

Expected behavior

I expected this to be around $25 or so given this.

Actual behavior

The close price is None. This happens with several symbols, not just this one. I'm not sure if this is an issue with this library or with IEX, but I thought I'd start here and see if we can get to the bottom of it.

addisonlynch commented 3 years ago

Thanks. Looks like it's an IEX issue.

This method pulls from close field in the quote endpoint, which for this security is null. Do you have any other examples? I'll put in an issue with their team.

Query: https://sandbox.iexapis.com/stable/stock/anh-a/quote?token=

Response:

{
    "symbol": "ANH-A",
    "companyName": "Anworth Mortgage Asset Corp. - 8.625% PRF PERPETUAL USD 25 - Ser A",
    "primaryExchange": "NECRIENXKOESGO  AC,TNY .K WHC",
    "calculationPrice": "close",
    "open": null,
    "openTime": null,
    "openSource": "ioaffilc",
    "close": null,
    "closeTime": null,
    "closeSource": "lfacoiif",
    "high": 25.43,
    "highTime": 1682901734788,
    "highSource": "esloC",
    "low": 25.99,
    "lowTime": 1623175723736,
    "lowSource": "Eteepa ei  IirXmrlc",
    "latestPrice": 25.82,
    "latestSource": "Close",
    "latestTime": "December 9, 2020",
    "latestUpdate": 1644973312334,
    "latestVolume": 0,
    "iexRealtimePrice": 0,
    "iexRealtimeSize": 0,
    "iexLastUpdated": 0,
    "delayedPrice": null,
    "delayedPriceTime": null,
    "oddLotDelayedPrice": 26.186,
    "oddLotDelayedPriceTime": 1615299755862,
    "extendedPrice": 26.2,
    "extendedChange": -0.18,
    "extendedChangePercent": -0.0073,
    "extendedPriceTime": 1672162360049,
    "previousClose": 26,
    "previousVolume": 13407,
    "change": 0.19,
    "changePercent": 0.00747,
    "volume": 0,
    "iexMarketPercent": null,
    "iexVolume": 0,
    "avgTotalVolume": 11508,
    "iexBidPrice": 0,
    "iexBidSize": 0,
    "iexAskPrice": 0,
    "iexAskSize": 0,
    "iexOpen": 25.7,
    "iexOpenTime": 1631695093582,
    "iexClose": 25.76,
    "iexCloseTime": 1627450770126,
    "marketCap": 261438384,
    "peRatio": null,
    "week52High": 25.61,
    "week52Low": 6.68,
    "ytdChange": 0.07830634361610343,
    "lastTradeTime": 1615225463942,
    "isUSMarketOpen": false
}
kyrofa commented 3 years ago

Thank you @addisonlynch. Yes, here is a list of others:

List of securities with a close price of None

``` AAA AAIC-B AAIC-C ABR-A ABR-B ABR-C ACIC= ACND+ ACND= AEL-A AEL-B AFLG AGBAR AGM-C AGM-D AGM-E AGM-F AGM.A AGO-B AGO-E AGO-F AHH-A AHL-C AHL-D AHL-E AHT-D AHT-F AHT-G AHT-H AHT-I AIG+ AIG-A AIRTP AIV# AIW AJAX= AKO.A AKO.B AL-A ALIN-A ALIN-B ALIN-E ALL-B ALL-G ALL-H ALL-I ALP-Q ALTG+ ALUS+ ALUS= AMCA AMH-D AMH-E AMH-F AMH-G AMH-H AMNA AMRHW ANH-A ANH-B ANH-C AONE+ AONE= AP+ APO-A APO-B APSG+ APSG= APTV-A ARES-A ARGO-A ARR-C ASAQ+ ASAQ= ASB-C ASB-D ASB-E ASB-F ASPL+ ASPL= ASRVP ATAC= ATCO-D ATCO-E ATCO-G ATCO-H ATCO-I ATH-A ATH-B ATH-C AUUD AUUDW AVAN+ AVAN= AVSF AVTR-A AXS-E AZAL AZBL AZBO BAC-A BAC-B BAC-C BAC-E BAC-K BAC-L BAC-M BAC-N BAC-O BANC-D BANC-E BANFP BBSC BCV-A BEP-A BF.A BF.B BFS-D BFS-E BFT+ BFT= BH.A BHR-B BHR-D BILS BIO.B BIP-A BK-C BLHY BML-G BML-H BML-J BML-L BNE BNKO BNKZ BOAC= BRG-A BRG-C BRG-D BRK.A BRK.B BRMK+ BROGW BSMS BSMU BSN+ BSN= BSX-A BTE BTYS BWL.A BXP-B BXS-A C-J C-K C-S CAI-A CAI-B CAP= CAS= CBAH= CBB-B CCAC+ CCAC= CCIV+ CCIV= CCRV CCX+ CCX= CCZ CDR-B CDR-C CEFA CERT CETXP CFG-D CFG-E CFR-B CHAQ+ CHAQ= CHEKZ CHEP CHFW= CHIU CHMI-A CHMI-B CIG.C CIM-A CIM-B CIM-C CIM-D CIO-A CIT-B CLA+ CLA= CLDB CLII+ CLII= CLNY-G CLNY-H CLNY-I CLNY-J CLRG CMO-E CMRE-B CMRE-C CMRE-D CMRE-E CMS-B CND= CNO-A CNP-B CODI-A CODI-B CODI-C COF-G COF-H COF-I COF-J COF-K CORR-A CPSR+ CPSR= CRD.A CRD.B CREXW CRHC+ CRHC= CTA-A CTA-B CTAC= CUBI-C CUBI-D CUBI-E CUBI-F CVR CWEN.A CYTH CYTHW DBEH DCP-B DCP-C DEED DEH+ DEH= DEMZ DFHTW DFNS+ DFNS= DGNR+ DGNR= DHR-A DHR-B DIT DIVA DJCB DLNG-A DLNG-B DLR-C DLR-J DLR-K DLR-L DMDV DMRE DMRI DMS+ DMYD+ DMYD= DMYI= DMYT+ DMYT= DRH-A DS-B DS-C DS-D DSX-B DTLA- DUAL DUK-A DWAT DWCR DWPP DX-B DX-C DYHG EBR.B ECF-A EEH EFC-A EFO EMCF EMPW+ EMPW= ENPC+ ENPC= ENR-A EPR-C EPR-E EPR-G EQC-D EQD+ EQD= EQH-A ESGN ETI- ETP-C ETP-D ETP-E EUFX EVGBC EVLMC EVSTC FAII+ FAII= FATBW FCA FDUSG FEAC+ FEAC= FEUL FFEU FGNA+ FGNA= FHN-A FHN-B FHN-C FHN-D FHN-E FIEE FJNK FLEU FLFR FLIY FLMI FLQG FLRT FLSA FLSP FLUD FLZA FMAC+ FMAC= FNB-E FOTXY FOVL FPAC= FPI-B FRC-G FRC-H FRC-I FRC-J FRC-K FRT-C FRX= FSR+ FST+ FST= FTAG FTAI-A FTAI-B FTV-A FUE FUSE+ FUSE= GAB-G GAB-H GAB-J GAB-K GAM-B GB+ GBDV GBGR GBLO GBUG GDL-C GDV-G GDV-H GEF.B GFNCP GGN-B GGO-A GGT-E GGT-G GGZ-A GIK+ GIK= GIX+ GIX= GIX^ GJO GJP GJR GJT GLBZ GLEO+ GLEO= GLOG-A GLOP-A GLOP-B GLOP-C GLP-A GLU-A GLU-B GMRE-A GNE-A GNL-A GNL-B GNPK= GNT-A GOAC+ GOAC= GRN GRP= GRX-B GS-A GS-C GS-D GS-J GS-K GS-N GSAH+ GSAH= GSL-B GTN.A GUT-A GUT-C GYRO HCXY HEI.A HERD HEWC HFBL HFRO-A HIG-G HIGA= HL-B HMG HMLP-A HMNF HOLD HPX+ HPX= HT-C HT-D HT-E HTAB HTPA= HVT.A HYLN+ HZAC+ HZAC= HZON= IACA+ IACA= IBTA IBTB IIAC= IIPR-A IMPX+ IMPX= INN-D INN-E IOR IPB IPOB+ IPOB= IPOC+ IPOC= IPOD+ IPOD= IPOE+ IPOE= IPOF+ IPOF= IPV+ IPV= IRET-C ISZE IVR-A IVR-B IVR-C IXSE JHMA JHMU JIGB JIH+ JIH= JJE JJN JJT JJU JPM-C JPM-D JPM-G JPM-H JPM-J JW.A JW.B JWS+ JWS= KBUY KEMX KEY-I KEY-J KEY-K KIM-L KIM-M KKR-A KKR-B KKR-C KLR+ KMED KNAB KOKU KSU- KTH KWAC= LACQ LD LEAP+ LEAP= LEN.B LGF.A LGF.B LGL+ LGVW+ LGVW= LNFA= LOAK+ LOAK= LOKB= LSXMB LTL LXP-C MAA-I MACU MARB MCRO MER-K MET-A MET-E MET-F MFA-B MFA-C MFAC+ MFAC= MFUS MH-A MH-C MH-D MITT-A MITT-B MITT-C MJJ MKC.V MNR-C MOG.A MOG.B MP+ MPLN+ MS-A MS-E MS-F MS-I MS-K MS-L MVIN NAV-D NBA+ NBA= NBR-A NCV-A NCZ-A NEWTI NFH+ NGA+ NGA= NGHCP NGL-B NGL-C NGLS-A NI-B NIFE NJV NLSP NLSPW NLY-D NLY-F NLY-G NLY-I NMK-B NMK-C NNN-F NREF-A NRZ-A NRZ-B NRZ-C NS-A NS-B NS-C NSA-A NSCO+ NSH+ NSH= NSPR+ NSPR+B NYCB-A OAC+ OAC= OACB+ OACB= OAK-A OAK-B OBOR OCA= OCCIP OFED OFG-A OFG-B OFG-D OIBR.C OJSCY OPP-A OXY+ PACE+ PACE= PANA+ PANA= PBI-B PBR.A PCG-A PCG-B PCG-C PCG-D PCG-E PCG-G PCG-H PCG-I PCPC= PCPL+ PCPL= PDAC+ PDAC= PDEV PEB-C PEB-D PEB-E PEB-F PEI-B PEI-C PEI-D PEXL PHGE+ PHGE= PIAI+ PIAI= PIC+ PIC= PIPP= PLYM-A PMT-A PMT-B PMVC+ PMVC= PNC-P PQIN PQLC PQSV PRE-G PRE-H PRE-I PRIF-A PRIF-B PRIF-C PRIF-D PRIF-E PRIF-F PRPB+ PRPB= PSA-B PSA-C PSA-D PSA-E PSA-F PSA-G PSA-H PSA-I PSA-J PSA-K PSA-L PSA-M PSA-N PSA-O PSB-W PSB-X PSB-Y PSB-Z PSM PSTH+ PTK+ PTK= PUBM PW-A PXMD PXMDW QLVE QMJ QMN QS+ QTS-A QTS-B RBAC+ RBAC= RBIN RBND RBUS RDS.A RDS.B RECS REVS REXR-A REXR-B REXR-C RF-A RF-B RF-C RFEU RFUN RHE-A RICE= RJZ RLJ-A RMG+ RMG= RMPL- RNR-E RNR-F ROSC RPLA+ RPLA= RPT-D RTP+ RTP= RTPZ= RWVG RY-T SAN-B SB-C SB-D SBE+ SBE= SBG+ SBG= SBM SBUG SCCB SCE-H SCE-J SCE-K SCE-L SCHW-C SCHW-D SCPE+ SCPE= SCVX+ SCVX= SDCI SEAH+ SEAH= SENEB SF-A SF-B SF-C SFBC SFTW+ SFTW= SGAM SGAMW SHO-E SHO-F SIGIP SIM SITC-A SITC-K SIXA SIXH SIXL SLG-I SMDY SMEZ SNGXW SNPR+ SNPR= SNV-D SNV-E SNX# SOAC+ SOAC= SPE-B SPEL SPFR= SPG-J SPLP-A SPNV= SPQQ SPRQ= SPUC SPXN SPXV SR-A SRC-A SRE-A SRE-B SRG-A SSLY STAG-C STAR-D STAR-G STAR-I STIC= STL-A STPK+ STPK= STT-D STT-G STZ.B SV SVA SVSVW SYF-A T-A T-C TACA= TALO+ TAP.A TAPR TCO-J TCO-K TDW+ TDW+A TDW+B TFC-F TFC-G TFC-H TFC-I TFC-O TFC-R TGP-A TGP-B TINV= TKGZY TLEH TNP-D TNP-E TNP-F TPGY+ TPGY= TREB+ TREB= TRNE+ TRNE= TRTN-A TRTN-B TRTN-C TRTN-D TWND+ TWND= TWO-A TWO-B TWO-C TWO-D TWO-E TY- UBP-H UBP-K UMH-C UMH-D UN USB-A USB-H USB-M USB-O USB-P USB-Q USHG USLB UTZ+ UUUU+ VBFC VEGA VER-F VERT= VETS VGAC+ VGAC= VKTXW VNO-K VNO-L VNO-M VNO-N VNSE VOYA-B VRT+ VST+A VTRN VVNT+ VYGG+ VYGG= WBS-F WCC-A WFC-A WFC-L WFC-N WFC-O WFC-P WFC-Q WFC-R WFC-T WFC-V WFC-W WFC-X WFC-Y WFC-Z WPF+ WPF= WPG-H WPG-I WRB-C WRB-D WRB-E WRB-G WSO.B WVVIP XAN-C XPOA= YAC+ YAC= YCBD-A YCL YGRN ZJPN ```

addisonlynch commented 3 years ago

Thanks. Sent IEX an email.

kyrofa commented 3 years ago

Thanks for keeping tabs on this @addisonlynch. Have you heard anything?

kyrofa commented 3 years ago

Hey there @addisonlynch, just checking in on this.

addisonlynch commented 3 years ago

@kyrofa no word from IEX. I would recommend sending them a support request.