X-Received: by 2002:a37:b4c6:: with SMTP id d189mr59806570qkf.173.1558371617869; Mon, 20 May 2019 10:00:17 -0700 (PDT)
X-Received: by 2002:a81:4bcc:: with SMTP id y195mr36425493ywa.407.1558371616735; Mon, 20 May 2019 10:00:16 -0700 (PDT)
Path: csiph.com!xmission!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!c48no2205906qtc.0!news-out.google.com!b26ni579qtp.1!nntp.google.com!c48no2205898qtc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: cz.comp.lang.python
Date: Mon, 20 May 2019 10:00:16 -0700 (PDT)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=78.108.109.155; posting-account=ODeXMAoAAAB_031yjTzGl4Ds5WoPvADV
NNTP-Posting-Host: 78.108.109.155
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <020253fc-34aa-47c1-b2fa-cf9bed268b59@googlegroups.com>
Subject: =?UTF-8?B?cGFuZGFzIHRvIGV4Y2VsIGJleiBwxZllcHPDoW7DrSBwxa92b2Ruw61jaCBob2Rub3Q=?=
From: radekmesner@gmail.com
Injection-Date: Mon, 20 May 2019 17:00:17 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 44
Xref: csiph.com cz.comp.lang.python:3360

Dobr=C3=BD den,
m=C3=A1m tady dal=C5=A1=C3=AD velice (ur=C4=8Dit=C4=9B pro v=C3=A1s) jednod=
uch=C3=BD probl=C3=A9m, s kter=C3=BDm se nedok=C3=A1=C5=BEu poprat.

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).

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 po=
ka=C5=BEd=C3=A9 p=C5=99ep=C3=AD=C5=A1e.

***************************************************************************=
*
# z=C3=ADsk=C3=A1n=C3=AD informace o vypln=C4=9Bn=C3=BDch p=C5=99=C3=ADkaze=
ch

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.shares,=
e.execution.avgPrice,e.execution.orderRef)=20
           for e in exekuce]
exe=3Dpd.DataFrame(exekuce, columns=3D['symbol', 'cas','smer','akcii','cena=
','ref'])
#exe['cas'] =3D pd.to_datetime(exe['cas'], format=3D"%m/%d/%Y")
exe.set_index("symbol",inplace=3DTrue)
print(exe)

# DataFrame si pro kontrolu vyp=C3=AD=C5=A1eme
exe

# 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']

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')

***************************************************************************=
*

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 sroz=
umiteln=C3=A9.