Guest User | Sign In

Knowledge Base

External Data Fields - Importing from Excel or .csv Files

Overview


Professional and Enterprise Services clients can import data as External Data Fields (EDFs) from Excel or .csv files. These can display text, date, or numerical data, such as internal ratings, price targets or transaction prices/dates. Note that the column headings will be the names of the data fields:

image

Adding an External Data Field


To add an EDF to Optuma:

1. Click on the Data menu

2. Left click External Data Fields

image

3. In the window that opens click New and select Excel or CSV file

4. Navigate to the file on your computer that contains the data.

Note: The file has to contain a column containing the code or ticker of the company that the data refers to.

5. Left-click on the file you wish to add, and then click the Import button to load the file.

The EDFs will be added to the list of available items which can be used in scripting in a number of areas throughout Optuma.

image

EDFs in Watchlists


Click here more information on Watchlists.

Custom columns can be added to Watchlists allowing you to create a "radar screen" of technical and fundamental data. Click on the + icon to add a column, and your imported fields will be listed under the External Data Field section:

image

EDFs in Scripting


For more information on scripting, click  here.

EDFs can be used in a number of different scripts, which are available in scans, alerts, and scripting tools (such as Show View, Show Bar, Show Plot, etc) by using the DATAFIELD() function. This script can be used in a Scan to find all equities that have a Rating of 3 and above.

DATAFIELD(FEED=XL, FIELD=Rating) >= 3

Note: Click on the DATAFIELD() text to select the required field from the list

image

EDFs in Chart Headers


Chart Headers can be set up to display EDF fields while in Edit mode by right-clicking in the header and selecting Add Field:

image

 Last updated Thu, Oct 18 2018 12:08am

Please Wait!

Please wait... it will take a second!