Copied optimization report data cannot be pasted into Google Sheets (extra commas in numbers)
Posted: Jan 25 2021
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.
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.