Navigation: Importing Bar Data >

The Event List File





Event List files can be included in a data import to add point-in-time event information to specific dates for specific symbols. The most likely use of this feature would be to include historical earnings dates and values if you have access to such information.

As with the symbol information file, the event list is a CSV file (or group of files).

The first row of the file must contain column names from the following list:

Symbol – the symbol for which the event occurred

Date – the date of the event

Time – the time of the event (optional)

Type – any numeric code > 0

Value – any numeric value (e.g. dividend amount, or EPS, or index constituency flags)

These columns can be in any order. The names are used to identify them.

Rows after the header row can also be in any order. Each row defines one event for one symbol on one date.

When first importing with an event list, it is suggested to use the LogFile option in your import definition. Events for which the symbol+date is not found in the imported bar data will be listed in the log.

Imported event data is accessed in script formulas by using the Event(type) function, which returns the value field if an event exists for the current symbol on the current date, or 0 if no event was found (with an option to return the most recent event -- see the function link for details).

The Time field stored with each event record determines which bar the Event function will align the event with. If Time <= 16:00:00 (160000) then the event will be aligned with the bar which has the specified date. If Time > 160000 then the event will be aligned with the next bar after the bar with the specified date.

The intention with this distinction is to differentiate "before the open" vs. "after the close" earnings report times. If you have point-in-time earnings data and are using EventListFile to import it and Event(n) to reference it, you will want Event(n) to return a value only for the dates on which the market first reacted to earnings news.

See also djia_earnings.rts and djia_earnings.csv in the Examples folder (note that this example does not use the Time field).




Copyright © 2020-2022 Systematic Solutions, LLC