TradersEdgeSystems.com

Consulting | Custom Trading Systems
Built-In Indicators | Custom Indicators

How To Handle Stock Splits in AIQ's Portfolio Manager

ALTERNATE METHOD (IN LIEU OF USING THE “SPLIT” FUNCTION IN PORTFOLIO MANAGER(PM)) USING A RAW OR UNSPLIT DATA FILE TO FIX STOCK SPLITS IN PM.

By Richard Denning,

Data downloaded for free from Yahoo finance is in the raw format but must be resorted to get ascending date order before importing as explained below:

Warnings: if you have already used the split function within Portfolio Manager (PM), then using the following will cause older splits for that ticker to be messed up. If you have never used the split ticker feature in PM then the following is a way to correct for all splits to date on a ticker even the older ones:

Steps-using CLF as an example, my CLF has a start date of 11/5/1997 which matches Yahoo’s start date.

1) In the AIQ DataManager (DM) module, create a new ticker with start date = to your start date for CLF or the start date shown on the Yahoo history (11/5/1997). Name the ticker CLF_RAW and paste in or type in the name and change the start date to 11/5/1997 and uncheck the "active" box then click OK button.

2) Go to yahoo finance http://finance.yahoo.com/ then type in CLF then click on “historical prices” and scroll to the bottom when it says "download to spreadsheet"; open with Excel; once open, sort on the date column, ascending, then save the file to C:\wintes32\dtu\CLF.csv (if you have another data source like QuotesPlus, you can just export the file to CLF.csv and choose the "raw" format).

3) Import the CLF.CSV file using AIQ DTU utility with the following settings for the import:


4) Go to PM and rename CLF to CLF_RAW - see the following:



Be sure to use "all positions" option. Click OK and this might take a while to complete.

Now you should have the equity curve fixed.

 

 

 

 

 

 

 

Disclaimer | Privacy Policy | Contact Us | Spam Blocker | ©2009 Traders Edge Systems