Questions about Importing and Exporting

Questions about Text Files

Why are some of the dates from my text file are missing?

If you imported a file using space as a field delimiter, it may be possible that different numbers of spaces were separating the fields in some records. If this is the case, the file import may have skipped over those records since they appeared invalid.

If this is the case, make sure that the file is not a fixed width column file rather than a space delimited file. Fixed width column files separate columns by allocating a certain number of characters to each column. This is different from a delimited file, which uses a specific character to denote the start of a new column.

Questions about Downloading from ProphetFinance.com

Why is some of my data not being updated when I select to update from the Internet?

Prophet associates a type with each data symbol. This type can be seen on the Modify Data Series Dialog: Name page. If Prophet indicates that it does not recognize a data symbol or that your account currently does not include that type of data, the type will be set to "Other (Not Updated)". This will cause TradingSolutions to not try to update this data.

If you would like to use update for data that currently has the type "Other (Not Updated)", simply change the type to any other value.

Questions about Processing after Import

Why was a stock split detected when one didn’t occur?

After you import new data into an existing data series, TradingSolutions checks to see if the newly imported data changes by a significant amount from the existing data on the previous day. Although TradingSolutions uses several rules to detect for splits, the basic rule is that if the data changes by more than 25%, a split may have occurred.

This analysis is only performed for data series that have both a Close field and a Volume field. The data that is examined is the Close field. This means that if you have a Close column with non-price data, it will still be checked. Or, if your price data does not contain a Close field, it will not be checked.

It is important to remember that this analysis is performed on the transition date between the existing data and the newly imported data. This is because most historical data is already split-adjusted. This check is performed so that you can adjust your existing data to match the split-adjusted data. Therefore, the date associated with this check is typically not the date of the actual stock split.

Stock split processing is always optional. TradingSolutions simply reports all of the potential times when a split adjustment may be necessary. If you do not perform a split adjustment when it is suggested after import, you can perform it manually from the Spreadsheet View by selecting Split Adjust From This Date… from the context menu for a particular date.

Why do some fields take longer to update than others following an imported update?

You may notice that following an import update that some calculated fields process very quickly, while others take several seconds. This is because the processing of some fields is dependent on any previous processing that may have occurred. For example, function definitions that depend on the previous value of the function and signal analysis fields are recalculated from the beginning. Predictions are also recalculated from the beginning since many neural network topologies are dependent on the current state of the model.