!fTddlZddlmZddlmZmZdZedkr edSdS)N) MongoClient)datetime timedeltac ptd}|d}|d}tjd}ddddd d d d d ddd }d}|D]\}}|d}t d||d|i} | r| d} t j} || | } | D]u\} }| t|z }|| |}||j || f<| dkr?| r=|r;| dd}| |z |z dz}t|d|j ||f<vt d||gd}|d| dd !t d"| d#|dS)$Nzmongodb://192.168.31.175:27017/office zerodha_nsezzerodha_nse.csvZimiiGii!) YESTERDAY'S CLOSING7 DAYS BEFORE PRICE14 DAYS BEFORE PRICE1 MONTH BEFORE PRICE3 MONTH BEFORE PRICE6 MONTH BEFORE PRICE1 YEAR BEFORE PRICE2 YEAR BEFORE PRICE3 YEAR BEFORE PRICE4 YEAR BEFORE PRICE5 YEAR BEFORE PRICEc|d|vr|Sfd|D}|rt|}||SdS)Nz%Y-%m-%dc g|] }|k| Sr).0datetarget_date_strs 0e:\HARSH\Automation\J_Work\zerodha\getNSEdata.py z:getNSEdata..get_price_for_date..'s#SSS$4?;R;R;R;R;R)strftimekeysmax)prices target_date earlier_dates closest_daters @r get_price_for_datez&getNSEdata..get_price_for_datesy%..z:: f $ $/* *TSSS&++--SSS  (}--L,' 'tr"Symbol.1z Processing symbolr&)daysrPRICEzCHANGE %dzNo data found for )!exchange_tokeninstrument_tokenr+name last_priceexpirystrike tick_sizelot_sizeinstrument_typesegmentexchangerrrrrrrrrrrz7 DAYS BEFORE CHANGE %z14 DAYS BEFORE CHANGE %z1 MONTH BEFORE CHANGE %z3 MONTH BEFORE CHANGE %z6 MONTH BEFORE CHANGE %z1 YEAR BEFORE CHANGE %z2 YEAR BEFORE CHANGE %z3 YEAR BEFORE CHANGE %z4 YEAR BEFORE CHANGE %z5 YEAR BEFORE CHANGE %zcsvFiles\NSE_UPDATED_z.csvF)indexz=Processing completed. Results saved to 'csvFiles\NSE_UPDATED_z.csv')rpdread_csviterrowsprintfind_onernowritemsratreplaceroundto_csvclose) mongo_clientdb collectiondf date_rangesr*r<rowr,documentr&today today_pricecolumnr-r'pricepercent_change_columnpercent_changes r getNSEdatarVsU@AAL h BM"J & ' 'B ! " " " #""###  K$kkmm11 sZ $F$$%%%&&&'9::  1h'FLNN''))E-,VU;;K + 1 1 3 3 S S #iT&:&:&:: **6;??',eVm$222{2u2,2NN7J,O,O)'2U':e&Cs%JN:?PQ:R:RBE%!667 S /v// 0 0 0 0 ` ` ` a BII2u222%I@@@ W5 W W WXXXr"__main__)pandasr=pymongorrrrV__name__rr"r r[sr((((((((LLL\ zJLLLLLr"