1. Home
  2. Your Data in Sentieo
  3. Sentieo Connect
  4. How to Create and Manage a Sentieo Connect Field

How to Create and Manage a Sentieo Connect Field

Create a field from Connect Portal

Head to the Overview section of the Sentieo Connect portal. You can find it in the “Add Tab” menu of the Sentieo tab bar.

To create a new field, press the “Create Field” button.

 

When creating a field, some fields are required and others are optional.

Required fields

  • Field Name: The name you want to give the field.
  • Excel Code: Pick an Excel code for your field. As you start typing the Field Name, Sentieo will suggest a field code automatically but you can change that to anything you like.
  • Content Type: A field needs a content type. It will determine what kind of data can go in it and what can be done with it.

For example, a field defined as “Numeric” will accept only numbers; on Screener, this will allow you to be able to filter for values equal or greater to a certain value, and so forth.

On the other hand, a field that is a periodic text will only accept values that are text,  but also requires you to provide a period (eg: FY2020) along with the field.

Sentieo offers a handful of generic content types (Numeric, Boolean, Text, List, Dates), as well as many pre-built content types (Eg: Revenue estimate, Price Target, or Analyst Name).

Why use pre-built content types? We recommend using pre-built content types because, besides the nature of data, they also pre-set other important parameters for you, such as the periodicity, the currency, or the lookback period. At a later date, we will be delivering new features leveraging user and Sentieo data that will take advantage of user fields being tagged to concepts like these.

For example, soon we will introduce the ability to generate a LTM series out of quarterly data. If this data is from the income statement, it will not be treated the same way it would be from a balance sheet (sum of periods vs average of periods).

We are working on many more full-scale features which benefit from the proper usage of content type, so we highly encourage you to try and use them as much as possible.

The full list of pre-built content types is available here .

  • Periodicity (Default = No): A periodic field lets you store data which is periodic by nature and follow the financial statement reporting schedule of a company (eg: Revenue or EPS estimates). Typically, you shouldn’t create separate fields for Revenue FY2020 and Revenue FY2021; create only one field and set Periodicity to “Yes”. Most key financial model metrics are already covered with pre-built content types and are all marked as periodic.

Optional items

You can also customize the following items, they are either optional or come pre-populated with default values:

  • Units (Default = Unit): Chose the unit in which you will be uploading the data. For example, if you select “Trillions”, and you upload 4.32, Sentieo Connect will understand that you meant 4.32 trillion and not 4.32 units. This is useful later on when displaying data on Screener or Price monitor, or when applying formulas with custom expressions or hybrid series in Plotter.
  • Description: Provide a quick summary of what the field is intended to display. This will be shown in various menus across Sentieo, including the field picker on Price Monitor or Screener. It also provides context for your team to understand what the field is meant for.
  • Advanced options: Some items are either optional or pre-configured and hidden in the Advanced Options section.

Click “Show Advanced Options” to display them and make changes.

    • Header Label (Default = same as Field name): This is the name shown when the field is displayed in tables in Sentieo or Excel. If left empty, the Field Name will be used in table headers
    • Default Data Source: Each datapoint is tagged with a source. When you create a field, you can define a default source for the datapoints you are going to load in the field. Whenever a datapoint is created without specifying the source, the default data source is applied to it. Data source is added informatively in subscript to tables on Notebook Notes that contain Sentieo Connect data.
    • Lookback (Default = infinite): We define lookback as the maximum period of time a datapoint is still considered “fresh” and valid. It is by default set to “infinite”, but it is probably good practice for you to reduce it to a reasonable cut-off time, for example 30 days.

To illustrate this, if you set Lookback to 30 days, and you ask Screener or Excel to fetch the field “MyRevenueEstimate” as of today, but the latest value is older than 30 days, it will not return anything. Lookbacks help you make sure you do not rely on stale or outdated data.

    • Currency (Default = No Currency): Defines what the data’s currency type the is. At the moment, you can pick between “No Currency”, “Trading Currency” and “Reporting Currency”. Setting the correct currency helps provide better automatic results across the various tools in Sentieo.
    • Adjustments (Default = disabled; only some pre-built fields): We offer you the ability to automatically reflect corporate and capital actions for the data you will have uploaded historically. This feature is offered for content types that are on a per-share basis (ex., EPS).

Create a Field from Price Monitor

You can also create a field from the field picker in Price Monitor. Type a field name; if it doesn’t exist, the menu will offer you the option to create a new field.

Once created, it is automatically added to the current view on Price Monitor.

Amend a field (Admins only)

To amend an existing field, press the pencil button in the main Overview page, or press the “Edit Field” button in the Single Field View.

Limitations

After you have created a field, not everything can be amended. The elements that cannot be changed are greyed out in the Edit field menu.

In particular:

  • the content type can only be changed to other content types of the same nature (Eg: if the field was originally created as a non-periodic number, only non-periodic content types will be available in the Edit field menus). This limitation was introduced to protect the integrity of the data.
  • Also, the Excel field code cannot be changed. This is to avoid disrupting models and mapping files created using the Excel field codes.
  • Only users defined as Admins have the ability to amend a field.

Delete a Field (Admins only)

To delete a field, press the Delete button from the Field Overview page or the “Delete Field” button in Single Field View.

Important note: When deleting a field, every datapoint created for this field will also be permanently deleted.

Note that only users with Admin privilege can delete fields. The buttons to delete fields are not available in the UI for non-Admin (“normal”) users.

Updated on April 13, 2022

Was this article helpful?

Related Articles