Swissquote and finpension as brokers about export-to-ghostfolio HOT 29 CLOSED

from export-to-ghostfolio.

from export-to-ghostfolio.

oops sorry here you go.
failed_transactions-swissquote.csv

from export-to-ghostfolio.

from export-to-ghostfolio.

If you can provide me with example exports I can take a look at it!

from export-to-ghostfolio.

from export-to-ghostfolio.

Are these CSVs ok or do you need more examples?

from export-to-ghostfolio.

Sorry, haven't had time to look at it yet. After a quick glance just now I think the finpension export will work, but I need more transactions for Swissquote (different kinds, for example buy/sell are missing).

from export-to-ghostfolio.

Ok, I’ll upload a more elaborate csv later today. No worries. Appreciate you taking the time to check it out! :)

from export-to-ghostfolio.

Heya, heres a more elaborate swissquote example.
swissquote_transaction-2.csv

from export-to-ghostfolio.

This could work. When I have some time I will try and work this out!

from export-to-ghostfolio.

I have added a Finpension converter here. Can you try and verify if it works for you? The file you provided is converted succesfully and as far as I can see all looks good.

Please let me know if you have any findings. If all is good, can you provide me with step-by-step instructions how to make a Finpension export (like here), so I can add it to the readme?

When I find some time later this week I will work on the Swissquote converter!

from export-to-ghostfolio.

@mikaelheidrich I also added the Swissquote converter to the same branch.

Can you take a look at them and verify if they process your exports? Both CSV's you provided seem to be converted OK and are importable to Ghostfolio.

Can you also provide export instructions for Swissquote (as well as for Finpension), so I can add those to the manual? Thanks!

from export-to-ghostfolio.

from export-to-ghostfolio.

I had this same error on Yahoo Finance this morning, I believe this is because Yahoo Finance is rate limiting you because their api was requested too many times within the hour.

As for the discontinued ETF, it isn’t placed in the JSON which you import in Ghostfolio?

from export-to-ghostfolio.

Okay, I will try and look into the Swissquote error later this week and get back to you when I find something!

from export-to-ghostfolio.

from export-to-ghostfolio.

Thanks for the instructions! I have added them to the readme file.

As to the issue you describe with Swissquote. I have run the export you provided in this thread (swissquote_transaction-2.csv) without any issue just now. Can you please check wether you still have issues at this time? If so, can you provide me with a (partial) export of the record(s) that give you an error? That way I can analyse the issue and get to a fix.

from export-to-ghostfolio.

from export-to-ghostfolio.

I don't see an attachment. Don't think that works when replying via email. Can you add them in this issue on GitHub?

from export-to-ghostfolio.

They were records without an ISIN, so no wonder they break 😁

I have added them to the skip list. Can you verify one last time before I merge these changes?

from export-to-ghostfolio.

Hi Dick, exporter runs now with no crashing. So I have gone through three years of transactions and I have merged all the remainng troublesome exports from my broker into one csv.

sample-swissquote-export.csv

The following is noteworthy.

-VEUD Dividend is mis identified as veurl.as where as the VEUD buy or sell is correctly identified as VEUD.L
-Custody Fees should be identified as Fees
-ORFN is the discontinued ETF, I can enter those manually i think

• in 2022 the sell transaction IAAA, CORP and IGIL throw a no result found as it seems to be looking for CHF instead of USD, other transactions exactly the same in other years of these same ETFs worked no problem.
• WENS gets identified as WENS.AS in EUR instead of WENS in USD
• VWRL dividend gets identified as WWRD.AS, Eur instead of USD.
• ETH should be identified as Ethereum Crypto Currency

I could also be noted that, after deselecting wrong imports in Ghostfolio and subsequently deleting succesful transactions from the cvs and then re-runing the export tool, some of the faulty exports where then exported correctly. That is to say, trimming down the csv and reruning it sometimes fixed some of the faulty exports.

hope this helps,

Mikael

from export-to-ghostfolio.

Thanks for your detailed analysis. I will try to take a look this weekend and come back to you.

from export-to-ghostfolio.

@mikaelheidrich The file you attached seems to be empty

from export-to-ghostfolio.

strange, lets try this one:

sample-swissquote-export-merged.csv

from export-to-ghostfolio.

I added custody fee support. Will now look at the file you sent and check your analysis.

from export-to-ghostfolio.

@mikaelheidrich Did you manaually merge the files? The tool does not process is because the column count does not match. The header has 15 columns, but there are many rows with only 13 columns.

For now I have removed the 13 colums rows and then I can process the file. Will try again with 13 columns with changed header.

from export-to-ghostfolio.

Pushed some more changes.

Regarding your analysis, my thoughts below:

• VEUD is matched to VEUR.AS as that is the only match found while searching by ISIN (when you enter IE00B945VV12 in Yahoo Finance you only get VEUR.AS. The tool does not continue to look for another symbol because the currency matches (your dividend is paid in EUR and VEUR.AS is EUR.
• Custody fees are added. Please check if the values are mapped correctly.
• I see the records for IAAA, CORP, etc. have another currency attached in the row. This value wasn't used (it used currency from the last column). I have now added a control to use netAmountCurrency if present, otherwise currency. The tool now finds matches.
• WENS now matches in USD
• VRWL now matches in USD
• There is no way for the tool to determine ETH is the cryptocurrency. Trying something with combining names (like ETH-USD) is probably going to break something somewhere else, though.

from export-to-ghostfolio.

Merged changes into main branch. If any issues persist, please open a new issue.

from export-to-ghostfolio.