SmartQuant Discussion

Automated Quantitative Strategy Development, SmartQuant Product Discussion and Technical Support Forums
It is currently Sat Aug 15, 2020 1:34 pm

All times are UTC + 3 hours

Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: Mon Dec 17, 2012 11:34 pm 

Joined: Tue Jul 24, 2012 7:38 am
Posts: 5
In the CSI Data "Properties" panel, I find the following settings:
* Adjust_Dividends
* Adjust_Splits
The CSI UA application also allows you to choose whether to use "additive" or "proportional" (multiplicative) adjustments. I've attached a screenshot of the CSI dialog to illustrate. The additive style preserves the dollar amount of the dividend (say $0.25) while the multiplicative style preserves the relative change (say 1%). The additive style may cause historical prices to be adjusted to negative values and does not preserve relative changes; this makes it unsuitable for most backtesting studies.

So far as I can tell, OpenQuant uses the additive style. I selected menu Data / Import / Instruments / CSI Data and requested historical data for symbol CCE (Coca Cola). In October 2008 the adjusted prices go negative, as shown in the second screenshot. Is there a way to choose the multiplicative style?


File comment: Screenshot of CSI UA settings window for historical adjustments
CSI-dialog-window.png [ 28.46 KiB | Viewed 6506 times ]
File comment: Screenshot of OpenQuant Data window for CCE
CCE.png [ 44.29 KiB | Viewed 6506 times ]
PostPosted: Thu Jun 05, 2014 3:36 pm 

Joined: Fri May 06, 2005 1:40 am
Posts: 521
Hi Mike,
I am the author of the CSI Data plugin. From memory I do not think multiplicative adjustments are in the older release included with OpenQuant. I am in the processing of updating the code for OQ so will include it if possible - perhaps in a week (or two, time permitting).


PostPosted: Tue Jun 10, 2014 12:34 pm 

Joined: Fri May 06, 2005 1:40 am
Posts: 521
New version should be included in one of the next few OpenQuant releases adds this option for you. Let us know how it goes, thanks.

PostPosted: Wed Jun 11, 2014 11:21 pm 

Joined: Tue Aug 05, 2003 3:43 pm
Posts: 6817

thanks to Keith, here are links to custom releases containing the latest version of the CSI provider: ... nt.x86.exe ... se.x86.exe ... er.x86.exe

Please take a look and let us know if it works as expected.


Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC + 3 hours

Who is online

Users browsing this forum: No registered users and 3 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group