Comments (13)
hi @dickwolff to be honest i am using my powershell scripts to process my activities, with these scripts i can import them directly to ghostfolio using the api
from export-to-ghostfolio.
I will close this issue.
Thank you very much to you and all who helped for all the time spent creating and helping me and others with this tool.
from export-to-ghostfolio.
I found out that the export was incorrect. So i exported it again and it is running now but it doesn't do much it seems. This is the output:
> [email protected] start
> nodemon "degiro"
[nodemon] 2.0.22
[nodemon] to restart at any time, enter `rs`
[nodemon] watching path(s): src/**/*
[nodemon] watching extensions: ts,js
[nodemon] starting `ts-node ./src/index.ts degiro`
Processing file using DeGiro converter
Read CSV file Account.csv. Start processing..
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ 0% | ETA 1020s | Duration: 10s | 8/891(node:3030357) UnhandledPromiseRejecti.
at DeGiroConverter.<anonymous> (/home/ingz/docker/compose/apps/Ghostfolio/Export-To-Ghostfolio/src/converters/deg)
at Generator.next (<anonymous>)
at fulfilled (/home/ingz/docker/compose/apps/Ghostfolio/Export-To-Ghostfolio/src/converters/degiroConverter.ts:28)
at runMicrotasks (<anonymous>)
at processTicksAndRejections (internal/process/task_queues.js:97:5)
(node:3030357) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwin)
(node:3030357) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise reje.
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ 0% | ETA 1020s | Duration: 68178s | 8/891
from export-to-ghostfolio.
Hi there!
Could you try and run the tool with debug logging on? If you set ‘DEBUG_LOGGING’ to true in the environment variables you will get more logging.
Also, I know there are some issues currently with the exporter, see #4
I have a work in progress branch that should work better than the current main branch. It’s not done yet.
from export-to-ghostfolio.
Hi @dickwolff
Thank you for your reply, I'm doing a run now with the debug on true. The export had about 800+ rows, so i removed the majority to check if that would help. When i ran it with about 5 it did create a json file, but that contained no activities. I am running it now with 170 rows and its showing the below for the last 20 min (not sure its doing anything). where would I see the log files?:
getSecurity(): Found 1 matches by ISIN US00206R1023
getSecurity(): Found 1 matches by ISIN US00206R1023
getSecurity(): Found 1 matches by ISIN US00206R1023
getSymbol(): Match found for US00206R1023
getSecurity(): Found 1 matches by ISIN US92343V1044
getSecurity(): Found 1 matches by ISIN US92343V1044
getSecurity(): Found 1 matches by ISIN US92343V1044
getSymbol(): Match found for US92343V1044
getSecurity(): Found 1 matches by ISIN NL0011540547
getSymbol(): Match found for NL0011540547
getSecurity(): Found 1 matches by ISIN NL0011540547
getSymbol(): Match found for NL0011540547
getSecurity(): Found 1 matches by ISIN NL0011540547
getSymbol(): Match found for NL0011540547
getSecurity(): Found 1 matches by ISIN NL0011540547
getSymbol(): Match found for NL0011540547
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ 1% | ETA 489s | Duration: 10s | 10/891(node:3793770) UnhandledPromiseRejecti.
at DeGiroConverter.<anonymous> (/home/ingz/docker/compose/apps/Ghostfolio/Export-To-Ghostfolio/src/converters/deg)
at Generator.next (<anonymous>)
at fulfilled (/home/ingz/docker/compose/apps/Ghostfolio/Export-To-Ghostfolio/src/converters/degiroConverter.ts:28)
at runMicrotasks (<anonymous>)
at processTicksAndRejections (internal/process/task_queues.js:97:5)
(node:3793770) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwin)
(node:3793770) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise reje.
getSecurity(): Found 1 matches by ISIN LU1959429272
░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░ 1% | ETA 489s | Duration: 1438s | 10/891
from export-to-ghostfolio.
I haven't seen this error before. No clear notion of what went wrong. I don't think it will complete the run.
Could you send a part of the export so I can take a look at it?
from export-to-ghostfolio.
I've been going through it and one of the line it is failing on is
03-04-2023,09:04,03-04-2023,VANGUARD FTSE AW,IE00B3RBWM25,"Koop 1 @ 97,93 EUR",,EUR,-97.93,EUR,43.62,07d17d6b-cb47-4949-b9d7-2c506537783e
Not sure why but when I remove this it continues, until the next failure which is:
23-02-2023,04:21,23-02-2023,FBR LTD,AU000000FBR4,"PRODUCTWIJZIGING : Koop 500 @ 0,039 EUR",,EUR,0,EUR,18.3, 23-02-2023,02:30,23-02-2023,FBR LTD.,AU000000FBR4,"PRODUCTWIJZIGING : Verkoop 500 @ 0,039 EUR",,EUR,0,EUR,18.3,
I had to remove both lines here to continue.
Next error line is 16-02-2021,14:42,16-02-2021,FBR LTD.,AU000000FBR4,"Koop 500 @ 0,039 EUR",,EUR,-19.5,EUR,51.92,1bb91f96-6356-4b37-be74-bb6d6b8996fb
Maybe you can debug with this, i do not see a clear correlation between them that could be the error. I suspected "
, but that is also part of other lines which it does proces and removing it caused the following error TypeError: Cannot read property 'length' of undefined
Hope this helps somewhat. Either way thank you very much for everything you've done for this project so far.
PS1: I have exported data al they back from 2020, not sure if that breaks anything. It really shouldn't.
PS2: The above lines are from the Rekeningoverzicht i downloaded from deGiro.
PS3: The (somewhat strange) headers: Datum,Tijd,Valutadatum,Product,ISIN,Omschrijving,FX,Mutatie,,Saldo,,Order Id
from export-to-ghostfolio.
Weirdly enough, the lines you sent in your post are processed on my machine. The last line are two orders, a buy and sell order, but the tool interpreted them both as sell-orders because the amount is positive with both orders. (No money was "withdrawn" for the buy order). The order above is an actual buy order (and I presume there also is a sell order somewhere in your order book) which is why I am inclined to say that the PRODUCTWIJZIGING is a line that needs to be skipped in the processing.
@ PS1: It shoudn't
@ PS3: These are the same headers as I have in my example export.
I'm pushing my changes to the main branch and I would like you to try again with that code and see if the issue persists. If so, please let me know and I will look into it further.
from export-to-ghostfolio.
Hi @dickwolff ,
It is running through the list without error now, but on import into ghostfolio im getting import errors:
I have created my own PowerShell script based on yours that works for me, so if this works for others no need to put more effort in it and you can close this issue.
Here's my code:
https://github.com/JahFyahh/Scripts/blob/master/Ghostfolio/deGiro2Ghostfolio.ps1
from export-to-ghostfolio.
Seems like something went wrong with the processing of the previous line. I’ll take a look at your PowerShell script and see if I can take some inspiration from it.
from export-to-ghostfolio.
Hi @JahFyahh, can you provide me with a (partial) export of transactions that aren't processed by my converter? That way I can look into why this issue occurs. Thanks!
from export-to-ghostfolio.
This is on my roadmap. The thing that is keeping me from doing this right now is because you wont ever be 100% right with converting using the Yahoo Finance api. I want users to have control over what they are importing. Using the manual import option you can verify for yourself if the conversion was successful and make corrections if needed.
from export-to-ghostfolio.
If you no longer have issues with this tool I propose to close the issue.
from export-to-ghostfolio.
Related Issues (20)
- Fix workflow runs on PR from other contributors HOT 6
- Create Yahoo Finance mock for testing purposes HOT 1
- Add test coverage to `SecurityService.ts` HOT 1
- Add functionality to automatically validate JSON and upload to Ghostfolio
- new install fails on dayjs import HOT 2
- Degiro conversion error - module not found HOT 16
- Make DEGIRO V2 GA
- Swchab conversion error HOT 15
- Include BUX csv template HOT 13
- DeGiro conversion failing HOT 2
- Got a parsing error HOT 6
- Error when processing DEGIRO file due to Currency Exchange operation HOT 3
- Import Activities Error HOT 14
- Symbol mapping HOT 3
- Swissquote cash balance HOT 10
- Degiro import fails with "[e] An error ocurred while trying to retrieve an empty symbol (line 38)!" HOT 1
- XTB import fails with `TypeError: Cannot read properties of null (reading '1')` HOT 10
- all stocks give an error only the fee's gets ready to upload HOT 7
- GBX items are not imported correctly HOT 6
- Bitvavo csv header changed HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from export-to-ghostfolio.