Import stock codes

Is there a way to import a list of stock codes simultaneously from a Excel spreadsheet into Optuma to create a workbook without entering them one at time. I have attached excel spreadsheet of the stocks codes.

weeklysmf.xls (128 KB)

Hi Darren,

There are two ways to do this, both require you to save the file as a CSV (which you can do with Excel).

Once the CSV file has been created you can import it as a Symbol List, and open the Workbook from there, or you can create a workbook directly from the CSV.