Importing and Exporting with Excel CQG offers users the ability to import lists of stocks and commodities into a QSS. Your Excel spreadsheet must be one column only. When you enter symbols in lower case, the inverse value, 1/the value, will be displayed. In Excel, select the column you wish to import. On your keyboard, select Ctrl-C. In CQG, open a Quote SpreadSheet. Maximize the window, as only the visible fields will be populated. Click in the first field on QSS. On your keyboard, select Ctrl-V. QSS is populated with the symbols from your Excel spreadsheet. Your QSS will look similar to this window (which has been condensed): To facilitate additional evaluation of SpreadSheet data, you may wish to copy the information into an Excel spreadsheet. In QSS, select the data you want to export. Right-click the selected data and click Copy to Excel. In Excel, right-click a cell. Click Paste.
Importing and Exporting with Excel CQG offers users the ability to import lists of stocks and commodities into a QSS. Your Excel spreadsheet must be one column only. When you enter symbols in lower case, the inverse value, 1/the value, will be displayed. In Excel, select the column you wish to import. On your keyboard, select Ctrl-C. In CQG, open a Quote SpreadSheet. Maximize the window, as only the visible fields will be populated. Click in the first field on QSS. On your keyboard, select Ctrl-V. QSS is populated with the symbols from your Excel spreadsheet. Your QSS will look similar to this window (which has been condensed): To facilitate additional evaluation of SpreadSheet data, you may wish to copy the information into an Excel spreadsheet. In QSS, select the data you want to export. Right-click the selected data and click Copy to Excel. In Excel, right-click a cell. Click Paste.
cqg_basics.docx