I am using MultiCharts QuoteManager to import instruments from the CSI data source. For example, I say:
Instrument / Add Symbol / From Data Source / CSI
(In a previous post I describe how my CSI account needed to have the API setting enabled for this to work.)
In the CSI Unfair Advantage interface, there is a process for creating a portfolio of symbols and setting properties to control adjustments for corporate actions such as splits and dividends. I've attached a screenshot of what that looks like. However, as best as I can tell, when you use Multicharts QuoteManager to extract historical data from CSI, the settings you may apply in the CSI application do not apply. It seems that the built-in connection from QuoteManager to CSI has its own hard-coded settings. I've simulated what I think these settings are in the second screenshot.
The built-in hard-coded settings seem to use the "additive" adjustment (subtracting the amount of the dividend from prices before the dividend) rather than a "multiplicative" or proportional adjustment (scaling the earlier prices by the ratio of the pre- and post-dividend price). The additive technique has certain advantages, such as preserving cashflow for P+L analysis, but is generally not appropriate for backtesting.
For example, if a stock's unadjusted price was $10.00 on one day and $10.50 on the next, this represents a price change of 5%. If this price were adjusted using the additive technique and $5 of dividends have been paid since this date, then the adjusted prices will be $5.00 and $5.50. The daily change now appears to be 10%. The multiplicative approach preserves the relative daily change as 5%.
This can get even worse if the total dividends paid since a given date exceeds the stock's unadjusted price on that date. In that case the additively adjusted price will go negative. Obviously this is a disaster for backtesting. You can see an example of this for CCE (Coca Cola) in the third screenshot upper chart, and a comparison to the Yahoo data for CCE (which itself uses CSI as its data vendor) in the lower chart. Notice the different y-axis scales.
Have I correctly inferred the behavior of the Multicharts-CSI built-in connection? Is there any way to control the historical adjustment settings?
Windows 7 64-bit
CSI Unfair Advantage v220.127.116.11
MultiCharts v8.0.5622.401, 64-bit
CSI Data - historical adjustments [SOLVED]
Questions about MultiCharts and user contributed studies.
5 posts • Page 1 of 1
mjm wrote:Have I correctly inferred the behavior of the Multicharts-CSI built-in connection? Is there any way to control the historical adjustment settings?
I asked CSI technical support for help, and Rudi at CSI told me:
Unfortunately, the Back Adjusted parameters for Multicharts are preset to the criteria that is widely used by traders.
He suggested using ASCII Mapping as an alternative, or asking Multicharts if there was any way to control the adjustments used in the API.
I haven't yet found a way to control the adjustments. It seems like they are hard-coded in the Multicharts software.
Henry MultiСharts wrote:That is correct, the built-in connection from MultCharts to CSI has default hard-coded settings.
Thanks for the follow-up. I am trying to use ASCII Mapping as an alternative.