Importing Data from Other Programs

Users of financial analysis programs other than MetaStock can share financial data with TradingSolutions by saving the data as text (CSV or ASCII) files. Once you have saved the data in this format, you can import it using the Import Data Wizard by selecting Import data from files on your computer.

&  For help importing text files, see Importing Data from Text Files.

Exporting Data from Microsoft Excel

To export data from Microsoft Excel into a comma-delimited text file, select Save As… from the File menu of Excel. Then, set Save as type: as "CSV (Comma delimited) (*.csv)" and save the file, taking note of where it is located on your computer.

Ä    Note: It will be necessary to close the Excel spreadsheet prior to importing the data into TradingSolutions.

Ä    Note: TradingSolutions does not handle dollar signs ($), thousand-separating commas (,), percent signs (%), or parentheses "( )" while it is importing numeric fields. If the fields in the spreadsheet are formatted to contain these symbols, TradingSolutions may not be able to import the data.

Exporting Data from NeuroShell Trader

To export data from NeuroShell Trader into a comma-delimited text file, select Export Chart/Data from the Tools menu of the program. Select to export Data Values to a File and press Next. Press Add Data Item(s)… and select the data items (fields) you would like to export. Note that you can export the results of indicators and predictions if desired. After pressing OK to select the data items, press Next. Select either a Comma separated ASCII file or a Tab separated ASCII file and indicate a file name for the export data.

Ä    Note: Since NeuroShell Trader does not export a ticker symbol column, TradingSolutions will default to use the file name as the ticker symbol associated with the imported data. Therefore, it is a good idea to use the ticker symbol as the file name.