BT results (positions) copied and dragged to excel is showing very strange data…
Rename
For example?
now in excel the coloums are displaced. MAybe the change is between closed positions and open positions..
It's your decimal separator. Likely due to country's default value (comma). Not sure about Excel but LibreOffice allows to configure the decimal separator when pasting delimited data from clipboard.
the profit is split in two columns, instead of 147,67$ it shows 147$ and in the next column the cent 67.
Same is the profit in percent, split in two columns, too.
Is it an issue of the import/copying to excel?
An issue of US version Europe (separation in US is point . 1.5 , in Europe it is a , 1,5 )?
Same is the profit in percent, split in two columns, too.
Is it an issue of the import/copying to excel?
An issue of US version Europe (separation in US is point . 1.5 , in Europe it is a , 1,5 )?
I just set the decimal separator to comma in Windows and verified that copy/paste from Positions to 2 office packages works correctly. Like I said, you should see if Excel allows to configure it - perhaps with Edit > Paste special... or something like that?
We should be able to change the copy paste to use the localized decimal separator, will take a look!
Your Response
Post
Edit Post
Login is required