|
The following is not necessary to read or understand unless you have your own custom dividend and/or index constituency data series that you need to add to a non-Norgate import.
As well as for user-defined events as described in Event List Files, RealTest also uses the event list within each RTD file to store Dividends and Constituency Change events.
Dividends are stored as event type -1. Event(-1) is therefore equivalent to Dividend in any formula. Event(-1, 1) can be used if desired to find the most recent dividend amount. Event(-1, 1) is equivalent to WhenTrue(Dividend > 0, Dividend).
To add your own dividend event, set Date to the ex-dividend date, Type to -1, and Value to the dollars-per-share amount of that dividend on that date.
Constituency Changes are stored as event type -2 through -n. The specific event number for an index is -1 minus the number from the first column of the constituency.csv file. So by default $MEL is -2, $XAO is -3, etc.
RealTest automatically generates a constituency change event on the first available date of each symbol in the RTD file for each imported constituency series (index) that it belonged to on that date.
Though constituency change events are only present for the dates (after the first date) on which the symbol entered or left the index, RealTest automatically maps the corresponding InXXX variable to Event(n, 1), i.e., it looks up the most recent change event to determine whether the stock was in the index on the date being evaluated.
To add your own index constituency series, do the following:
1. Edit your copy of the constituency.csv file and add your indices at the end. Perhaps start with 100 is the first index number, to leave plenty of space after the Norgate numbers. Make up your own values for the remaining columns, e.g. 100, $DAX, InDAX, Member of Dax. The only required items here are the number and the InXXX name to use -- the other two are provided only for your own information since you would not be directly importing these series from Norgate.
2. Create an EventListFile containing your constituency change events. Symbol is the stock to which the change applies. Date is the date of change. Type is -1 minus your index number as specified in step 1 above, e.g. -101 for index 100. Value is 1 if the stock joined the index or 0 if the stock left the index on that date.
3. Close and re-open RealTest so it can read your new constituency.csv file
4. Run your import
You should now be able to reference your custom index constituency series using your custom InXXX variable!
|
