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?
Thanks,
Mike
Environment:
Windows 7 64-bit
CSI Unfair Advantage v2.10.7.119
MultiCharts v8.0.5622.401, 64-bit
CSI Data - historical adjustments [SOLVED]
Re: CSI Data - historical adjustments
I asked CSI technical support for help, and Rudi at CSI told me:Have I correctly inferred the behavior of the Multicharts-CSI built-in connection? Is there any way to control the historical adjustment settings?
He suggested using ASCII Mapping as an alternative, or asking Multicharts if there was any way to control the adjustments used in the API.Unfortunately, the Back Adjusted parameters for Multicharts are preset to the criteria that is widely used by traders.
I haven't yet found a way to control the adjustments. It seems like they are hard-coded in the Multicharts software.
Mike
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: CSI Data - historical adjustments
Hello Mike,
That is correct, the built-in connection from MultCharts to CSI has default hard-coded settings.
That is correct, the built-in connection from MultCharts to CSI has default hard-coded settings.
- Henry MultiСharts
- Posts: 9165
- Joined: 25 Aug 2011
- Has thanked: 1264 times
- Been thanked: 2957 times
Re: CSI Data - historical adjustments [SOLVED]
Hello Mike,
We will add ability to change the default settings in the next version of MultiCharts.
We will add ability to change the default settings in the next version of MultiCharts.