search

masbug / etoro-edavki

MIT License
49 stars 14 forks source link

težava pri pogonu prevedene skripte #36

Closed Mihajlo1250 closed 6 months ago

Mihajlo1250 commented 6 months ago

Pozdravljeni.

V cmd sem po zagonu etoro_konverzija prejel tole obvestilo: ... Traceback (most recent call last): File "etoro_edavki.py", line 1169, in File "etoro_edavki.py", line 322, in main File "openpyxl_templates\table_sheet\table_sheet.py", line 379, in read openpyxl_templates.table_sheet.table_sheet.HeadersNotFound: Header column not found on sheet 'Closed Positions' either make sure that the following headers are present 'Position ID, Action, Amount, Units, Open Date, Close Date, Leverage, Spread Fees (USD), Market Spread (USD), Profit(USD), Profit(EUR), Open Rate, Close Rate, Take profit rate, Stop lose rate, Rollover Fees and Dividends, Copied From, Type, ISIN, Notes'. [13624] Failed to execute script 'etoro_edavki' due to unhandled exception! Press any key to continue . . .

Kaj bi lahko bilo narobe? (predhodno sem v mapo skopiral etoro.xlsx, v cmd sem vpisal DŠ in kratico FO)

masbug commented 6 months ago

Vzrok je stara verzija programa ali pa star statement export.

Mihajlo1250 commented 6 months ago

Ko sem javil napako, sem: -uporabil najnovejšo verzijo programa (1.6.4). -uporabil account statement za "last year", torej 01/01/2023 - 31/12/2023.

Tokrat sem: -kot izvozil account statement 01/01/2023 - 01/01/2024

Hvala za odzivnost. Zanima me, ali lahko prispevam s svojimi podatki v skupno bazo Company_info? LP

masbug commented 6 months ago

Precej čudno. Bi lahko videl header tabele "Closed positions"?

Company info lahko kar dodate tukaj v komentar, pa bom združil v skupnega.

Mihajlo1250 commented 6 months ago

Header of Closed positions.xlsx

To je xlsx prejšnje datoteke etoro.xlsx (Last year) z zgornjo vrstico zavihka 'Closed positions'; v originalu je v vseh stolpcih na tej vrstici vklopljen tudi 'sort filter' gumb.

Ko končam z dopolnjevanjem Company info, pošljem.

masbug commented 6 months ago

Star etoro export je... manjkajo stolpci. Samo v januarju so ~3x spremenili kako izgleda export. image

Mihajlo1250 commented 6 months ago

Če so res spreminjali, potem je res to razlog. Moj "nedelujoči" export je s 3. januarja. Hvala za diagnozo.

Mihajlo1250 commented 6 months ago

Pošiljam podatke za Company info, ki sem jih dodal k manjkajočim.

company_info-additional.xlsx

Ponovno hvala za vaš trud in čas.

masbug commented 6 months ago

Dodano, hvala!