X-Received: by 2002:a6b:c411:: with SMTP id y17mr5635343ioa.265.1558773307792; Sat, 25 May 2019 01:35:07 -0700 (PDT) X-Received: by 2002:a25:106:: with SMTP id 6mr15417063ybb.320.1558773307349; Sat, 25 May 2019 01:35:07 -0700 (PDT) Path: csiph.com!xmission!news.snarked.org!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!i64no674048iti.0!news-out.google.com!p73ni215itp.0!nntp.google.com!c92no672006itd.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: cz.comp.lang.python Date: Sat, 25 May 2019 01:35:06 -0700 (PDT) In-Reply-To: <020253fc-34aa-47c1-b2fa-cf9bed268b59@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=2001:470:6f:1b5:785b:b1e0:fa73:27a9; posting-account=frgO0goAAACFAIMiBRfX5f4-oMQqbHvX NNTP-Posting-Host: 2001:470:6f:1b5:785b:b1e0:fa73:27a9 References: <020253fc-34aa-47c1-b2fa-cf9bed268b59@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: Subject: =?UTF-8?B?UmU6IHBhbmRhcyB0byBleGNlbCBiZXogcMWZZXBzw6Fuw60gcMWvdm9kbsOtY2ggaG9kbg==?= =?UTF-8?B?b3Q=?= From: =?UTF-8?Q?Lum=C3=ADr_Balhar?= Injection-Date: Sat, 25 May 2019 08:35:07 +0000 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Lines: 80 Xref: csiph.com cz.comp.lang.python:3361 Dne pond=C4=9Bl=C3=AD 20. kv=C4=9Btna 2019 19:00:18 UTC+2 radek...@gmail.co= m napsal(a): > Dobr=C3=BD den, > m=C3=A1m tady dal=C5=A1=C3=AD velice (ur=C4=8Dit=C4=9B pro v=C3=A1s) jedn= oduch=C3=BD probl=C3=A9m, s kter=C3=BDm se nedok=C3=A1=C5=BEu poprat. >=20 > M=C3=A1m napsan=C3=BD skript, kter=C3=BD mi ka=C5=BEd=C3=BD den vyp=C3=AD= =C5=A1e data a exportuje do .xlsx souboru, kde filtruji do dvou sheets (BOT= , SLD). >=20 > Pot=C5=99eboval bych, aby se dal=C5=A1=C3=AD den hodnoty doplnily na nov= =C3=BD =C5=99=C3=A1dek op=C4=9Bt podle filtru (BOT, SLD). Takhle se tabulka= poka=C5=BEd=C3=A9 p=C5=99ep=C3=AD=C5=A1e. >=20 > *************************************************************************= *** > # z=C3=ADsk=C3=A1n=C3=AD informace o vypln=C4=9Bn=C3=BDch p=C5=99=C3=ADka= zech >=20 > exekuce =3D (e for e in ib.fills() if e.contract.secType =3D=3D "STK") > exekuce =3D [(e.contract.symbol,e.time,e.execution.side,e.execution.share= s,e.execution.avgPrice,e.execution.orderRef)=20 > for e in exekuce] > exe=3Dpd.DataFrame(exekuce, columns=3D['symbol', 'cas','smer','akcii','ce= na','ref']) > #exe['cas'] =3D pd.to_datetime(exe['cas'], format=3D"%m/%d/%Y") > exe.set_index("symbol",inplace=3DTrue) > print(exe) >=20 > # DataFrame si pro kontrolu vyp=C3=AD=C5=A1eme > exe >=20 > # Ulo=C5=BE=C3=ADme do excelu, zvl=C3=A1=C5=A1=C5=A5 n=C3=A1kup a zvl=C3= =A1=C5=A1=C5=A5 prodej > exe_bot =3D exe[exe['smer']=3D=3D'BOT'] > exe_sld =3D exe[exe['smer']=3D=3D'SLD'] >=20 > with pd.ExcelWriter('exekuce.xlsx') as writer: > exe_bot.to_excel(writer, sheet_name=3D'N=C3=A1kup') > exe_sld.to_excel(writer, sheet_name=3D'Prodej') >=20 > *************************************************************************= *** >=20 > D=C4=9Bkuji za p=C5=99=C3=ADpadnou pomoc. P=C5=99edem upozor=C5=88uji, = =C5=BEe jsem naprost=C3=BD za=C4=8D=C3=A1te=C4=8Dn=C3=ADk, tak snad je to s= rozumiteln=C3=A9. Ahoj. Nem=C3=A1m te=C4=8F moc =C4=8Dasu, tak zkus=C3=ADm jen nast=C5=99elit mo=C5= =BEn=C3=A9 =C5=99e=C5=A1en=C3=AD. Kdyby bylopot=C5=99eba v=C3=ADce detailu,= napi=C5=A1 a j=C3=A1 dopln=C3=ADm i s p=C5=99=C3=ADklady. =C5=98e=C5=A1en=C3=ADm probl=C3=A9mu je to, =C5=BEe m=C3=ADsto vytv=C3=A1= =C5=99en=C3=AD nov=C3=A9ho pd.DataFrame si na=C4=8Dte=C5=A1 ten p=C5=AFvodn= =C3=AD z .xlsx souboru, dopln=C3=AD=C5=A1 jej o nov=C3=A9 =C5=99=C3=A1dky a= pak jej stejn=C4=9B jako doposud ulo=C5=BE=C3=AD=C5=A1 zp=C4=9Bt do .xlsx = souboru. 1. Na=C4=8Dte=C5=A1 existuj=C3=ADc=C3=AD .xlsx soubor do dvou DataFram=C5= =AF (pro ka=C5=BEd=C3=BD list jeden) - na to je funkce read_excel https://p= andas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html#pa= ndas-read-excel 2. Ve sv=C3=A9m programu si klidn=C4=9B stejn=C4=9B jako doposud vytvo=C5= =99=C3=AD=C5=A1 dva nov=C3=A9 DataFrame exe_bot, exe_std 3. Tyto nov=C3=A9 hodnoty p=C5=99id=C3=A1=C5=A1 pomoc=C3=AD metody .append = do DataFram=C5=AF, kter=C3=A9 sis na=C4=8Detl v bod=C4=9B 1 ze souboru htt= ps://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.ap= pend.html 4. Ulo=C5=BE=C3=AD=C5=A1 DataFrame obsahuj=C3=ADc=C3=AD spojen=C3=A9 nov=C3= =A9 a star=C3=A9 hodnoty zp=C4=9Bt do .xlsx souboru jako doposud. Jin=C3=A9 je v tom pro jednoduchost jen to, =C5=BEe si na=C4=8Dt=C4=9B=C5= =A1 ze souboru star=C3=A9 hodnoty a p=C5=99ed ulo=C5=BEen=C3=ADm je spoj=C3= =AD=C5=A1 s nov=C3=BDmi hodnotami. Snad to alespo=C5=88 tro=C5=A1ku pom=C5=AF=C5=BEe. Kdyby ne, dod=C3=A1m v= =C3=ADce detail=C5=AF i s p=C5=99=C3=ADklady. Lum=C3=ADr