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)
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.