I did not expect such situation. Usually people have 1 account for each currency. Then dividends are imported correctly.
Or do you have account with one currency but the dividend is paid in a different currency? I think it does not have to be difficult to update the script.
The problem with error can be fixed. I have figured that out recently - choose “Type of data” as “Portfolio Transactions”. Then it can work with exchange reates. But I don’t know if this breaks something else 
I have retirement account (in Poland called IKE) which have currency in PLN and dividends from US stocks are converted to PLN. Currency is converted by XTB from USD to PLN.
Ok, I will update it when I have some free time 
1 Like
the ImportExcel in powershell download went good, but i am not sure it has installed
After running (with admin) .bat file is a problem - for a sec comes a black window and nothing after happens. I am not able to choose the xlsx file
Edit the .bat file and leave just “@pause” at the last line. Then the window does not close automatically and you can see the error if there is any.
@hubga i get some errors after i ran the script like: Import-Excel : The term ‘Import-Excel’ is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
And yes i ran Install-Module -Name ImportExcel in powerShell
Any suggestions?
@Edg I found this topic. You probably did not install it with admin rights. Just run the 2 lines mentioned there and I hope it will work
https://stackoverflow.com/questions/41192536/cannot-install-importexcel-powershell-module
Thank you, it didn’t worked for me. I asked chatGpt to help and i added at top of the script a few line of code which force-loaded ImportExcel from known path. Now it works.