Numbers in xlsx do not work

[morrnel]

Hello,
I occassionally export and xlsx using Trade Performance -> Trades -> Export

When I open the xlsx, lnon of the numbers can be used for calculations. For example, if I =sum() a column, I get an error. What is the issue? Summing a column is a very standard XLSX calculation.

[jeronymite]

morrnel Although it would be (much) better if the workbook were created with awareness of the data types being included (they are all formatted as General), this is easily fixed using simple Replace in various columns to remove specific characters; i.e. replace "<some char>" with "" (e.g. replace "," with "").

Simply select the relevant column and Replace All:

• For Qty, remove "," (comma)
• For Entry price and Exit price, remove "'" (single quote for tenth pips if Forex)
• For all money columns, remove "$" (currency symbol, could be $ or € or £ or ¥ or any other, including Fr for CHF)

The columns should then change to be numbers that you can use as desired.

Hope that makes things better for you.

Thanks.

[morrnel]

Thanks for the message jeronymite. However, it is easilhy solved by saving as a CSV file rather than XLSX..

[jeronymite]

Yes, morrnel that would be one way to go ... but it still has two issues that may be problematic:

• Account names that are all digits will probably be treated as numbers; this may or may not present an issue, depending on your configuration and what you want
• Prices that are Forex will be text, not numbers; and that may or may not be inconvenient depending on your trading and how you want to treat the price data

Thanks.