ó ùh\\c @s¡dZddlZddlmZddlZddlmZddlZddl m Z ej dddd d d d d ƒZ e j ƒZddd„ƒYZdS(s5 Created on Wed Feb 6 15:48:44 2019 @author: cpace iÿÿÿÿN(tstats(tstrptime(t relativedeltathosts 198.71.225.56tusert coreypacetpasswdtAud12reytdbt FarmBusinesstpnpcBsYeZd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z RS( cCs\tt|dƒjƒd}tj|t|dƒjdƒtddƒ|_tj|t|dƒjdƒ|_|j||||t|jƒƒ|_ |j |||j|ƒ|_ |j |j |j ƒ|_ |j|j |j ƒ|_|j |j|j ƒ|j |||j|ƒƒ|_|j|j|j ƒ|j |||j|ƒƒ|_dS(Ns%bs-1itmonthsiüÿÿÿ(tstrRttm_montdatetimetdateRt startDatetendDatetgetdatatdatat getstartpricet startPricet getmaxBestFitt maxBestFitt getminBestFitt minBestFitt getdownyearstdownBestFitHight getupyearst upBestFitLow(tselftcroptmonthtyeart expiration((sModules\pnp.pyt__init__s1$'6c Cs-tj||ƒ\}}}}}|||S(N(Rt linregress( Rtxtytcurpricetslopet intercepttr_valuetp_valuetstd_err((sModules\pnp.pytregress#s!cCsèdt|ƒdt|ƒdt|ƒd|d|d|dt|ƒdt|ƒd t|ƒdt|ƒd|d|d|d t|ƒd t|ƒd t|ƒd }tj|ƒtjttjƒƒƒS( Nsºselect minmax.year, minmax.minimum, minmax.maximum, startclose.start, stopclose.stop from (select year, min(close) as minimum, max(close) as maximum from MarketHistory where Contract = 's' and Crop = 's' and Date >= (concat(year-s+year('s'),'-',month('s '),'-',day('s%'))) and Date <= (concat(year,'-' , 'sx')) and year >= 1900 group by year) as minmax, (select year, close as start, close from MarketHistory where contract = 's' and crop = 'sŽ'))) and year >= 1900 group by year order by date asc) as startclose, (select year, close as stop, close from MarketHistory where contract = 's"' and Date >= (concat(year,'-' , 'sŠ')) group by year order by date desc) as stopclose where startclose.year = minmax.year and stopclose.year = minmax.year order by year asc;(R tpnpcurtexecutetnptasarraytlisttfetchall(Rt contractmonthRt contractyearR"t startdatetsql((sModules\pnp.pyR's cCs`d|dt|ƒd|dt|ƒd}tj|ƒtjttjƒƒƒddS(Ns8select min(date), open from MarketHistory where crop = 's' and year = 's' and contract = 's ' and date>='s';ii(R R.R/R0R1R2R3(RRR!R6R R7((sModules\pnp.pyR2s2 cCsE|j|dd…dfjtƒ|dd…dfjtƒ|ƒS(Nii(R-tastypetfloat(RRt startprice((sModules\pnp.pyR7scCsE|j|dd…dfjtƒ|dd…dfjtƒ|ƒS(Nii(R-R8R9(RRR:((sModules\pnp.pyR:scCsG|tj|dd…df|dd…dfkƒddd…fS(Niii(R0twhere(RR((sModules\pnp.pyR=scCsG|tj|dd…df|dd…dfkƒddd…fS(Niii(R0R;(RR((sModules\pnp.pyR@scCs tjƒS(N(tpnpdbtclose(R((sModules\pnp.pyt closeconnCs( t__name__t __module__R#R-RRRRRRR>(((sModules\pnp.pyR s      ((t__doc__tMySQLdbtscipyRtnumpyR0ttimeRRtdateutil.relativedeltaRtconnectR<tcursorR.R (((sModules\pnp.pyts