Stock Split Adjustment Wizard

The Stock Split Adjustment Wizard allows you to adjust historical price and volume data when a stock split occurs. Following a stock split, previous price and volume data values are adjusted to match the new valuation. This allows the price and volume information to maintain a consistent scale with new data.

:    For example, when a 2-for-1 stock split occurs, all of the previous price data is divided by two and all of the previous volume data is multiplied by two.

Historical data from data providers is typically back-adjusted to take into account any new stock splits. Because of this, data previously imported into your portfolio also needs to be adjusted after a split to match the new data.

Ä    Note: The date listed here is the date where the data jumps in price due to the split-adjustment and may not be the date where the split actually occurred.

When new data is imported into an existing data series, TradingSolutions automatically checks to determine if split adjusted data may be being placed next to non-adjusted data. If a change in price of over 25% occurs at the edge of the new data, a warning is given indicating that the data may need to split adjusted and a suggested action is recommended.

Ä    Note: If non-split adjusted data is imported into the middle of previously split-adjusted data, two adjustments will be detected. The first adjustment will be from the end of the newly imported data to adjust it to match the data that comes after it. The second adjustment will be from the start of the newly imported data to de-adjust the data that comes before it. This second adjustment should be the reverse of the first ratio. In other words, an adjustment for a 2-for-1 split should be followed by an adjustment for a 1-for-2 split.

Specifying Split Adjustment Information

There are two ways to adjust the data in your portfolio for a split.

·      Re-import entire date range from current data source.

This option attempts to re-import the entire data range from the data source currently being used for this data series. If it was imported from an Internet data source, TradingSolutions will re-request the entire date range. If it was imported from a file, TradingSolutions will re-import all of the data from the most recently imported file for that data series.

Ä    Note: If the entire date range is not available, a message may indicate further adjustment is required for older data in your portfolio. If this occurs, use the manual adjustment option for the remaining data.

·      Manually adjust current values.

This option modifies the data in your portfolio by manually adjusting the values by the amount of the split. On the next page of the wizard, you can select which fields will be adjusted.

¨    Split Adjustment

These values specify the ratio of the stock splits that have occurred. For example, if a 2-for-1 split has occurred, enter the numbers 2 and 1.

¨    Date of Adjustment

This value indicates the last date of the adjustment. The data for this data and all dates prior to this date is adjusted to reflect the new value.

Ä    Note: When adjusting old data for split-adjusted data, this is almost never the actual date of the stock split. Instead, this is the last date of the old data that now needs to be adjusted.

&  For help using the date controls, see the help for Date Selection Controls.

Recovering from an Incorrect Split Adjustment

If you accidentally enter a split adjustment for the wrong amount or for the wrong date, you can reverse the process by entering a split of the opposite amount for the same date.

:    For example, if you enter an adjustment for a 2-for-1 split for a date and then want to undo it, enter an adjustment for a 1-for-2 split for the same date. This will reverse the price and volume changes and restore the original values.

What Do I Do Next?

If you have selected to re-import the entire date range, press the Finish button to start the import.

If you have selected to manually adjust the current values, press the Next button to continue on to the Specify Fields page. If you would like to exit the wizard without performing any split adjustment at this time, press the Cancel button.

How Did I Get Here?

The Stock Split Adjustment Wizard is typically accessed by double-clicking or selecting to perform the action for a message indicating that TradingSolutions has detected a split. It also appears when you select Split Adjust Data… from the context menu for a data series from the Portfolio View or Split Adjust from this Date… from the context menu for a date in the Spreadsheet View.