Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)

Copied data from the Optimization Report contains comma separators in large number, e.g. 1,500 or 2,000,000. This causes issues when trying to paste the data into Google Sheets because Sheets uses commas to delimit columns. I have not tested with Excel.

To reproduce:

1) From the Optimization Report window, right click and select "Copy All" (the report must contain numbers over 999)
2) Open a new Google Sheets document and paste the data
3) A small drop down window appears at the bottom of the sheet. Click it and select "Split text to columns"
4) Note how columns that contained numbers with commas are split up. For example, 1,500 will create two columns: 1 and 500.

Data exported as a CSV file does not contain these extra commas, so a workaround is to export the data to a file then import or copy/paste that data into Sheets. This gets the job done, but it would be great if copy/pasting worked without extra steps.

The two other pieces of trading software I use (DAS and Trade Ideas) export tables to the clipboard as tab-delimited data, which can be pasted directly into Sheets with no issues.

Hello,

We reproduced the issue on our end and it looks like it is necessary to select separator = semicolon in Google spreadsheet for the correct display of the Optimization Report. You can select it after you click on "Split text to columns".


Please try this and let us know if it resolved the issue on your end.

Thanks for the response. The problem is actually that the data exported by Multicharts is not separated by semicolons, but commas. This means the commas in large numbers are indistinguishable from commas used to separate columns.

Here's some example data I just pulled from an optimization report:

2,859.13,5,820.10,-2,960.97,67,37.31 %,25,41,42.67,-669.02,0,232.80,5.0,-72.22,3.22,4,6,17,9,1.97,529.89
4,841.63,7,953.44,-3,111.81,65,33.85 %,22,42,74.49,-804.83,0,361.52,7.5,-74.09,4.88,4,8,30,13,2.56,748.13
6,375.60,9,580.28,-3,204.68,65,30.77 %,20,44,98.09,-720.58,0,479.01,10.0,-72.83,6.58,4,8,37,15,2.99,1,016.50
7,867.60,11,110.18,-3,242.58,65,27.69 %,18,46,121.04,-1,359.56,0,617.23,12.5,-70.49,8.76,4,16,41,23,3.43,771.51
7,816.15,11,113.57,-3,297.42,65,23.08 %,15,49,120.25,-2,037.86,0,740.90,15.0,-67.29,11.01,4,23,50,35,3.37,552.82
7,468.50,10,781.22,-3,312.72,65,21.54 %,14,50,114.90,-2,037.86,0,770.09,17.5,-66.25,11.62,4,23,69,36,3.25,528.23
7,108.47,10,457.89,-3,349.42,65,18.46 %,12,52,109.36,-2,037.86,0,871.49,20.0,-64.41,13.53,2,23,109,41,3.12,502.76
7,165.12,10,535.71,-3,370.59,65,16.92 %,11,53,110.23,-2,037.86,0,957.79,22.5,-63.60,15.06,2,23,118,41,3.13,506.77
6,690.42,10,079.35,-3,388.93,65,15.38 %,10,54,102.93,-2,037.86,0,1,007.94,25.0,-62.76,16.06,2,23,128,43,2.97,473.20

The first two numbers in the first row should be 2859.13 and 5820.10, but as you can see, Multicharts exports this data using commas as separators so it's impossible to tell where one column ends and the next begins.

Is there a setting within Multicharts to change the commas to semicolons?