Dividend Adjusted Price Series
Author: ss161
Creation Date: 3/27/2009 12:31 PM
profile picture

ss161

#1
i find this a useful function to adjust the Open High Low Close for dividends as they are paid. please note i've tested over a handful of names,but am still in the process of more completely testing the function.

CODE:
Please log in to see this code.
profile picture

Cone

#2
Good show ss161, but a couple notes -

1) Use the Yahoo! Provider to load dividend-adjusted data directly. You can turn on/off the adjustment (and other options) in the Yahoo! tab in the DataSource Manager.

2) If you use dividend-adjusted data, make sure that you uncheck "Apply dividends" in the Backtest Settings Preferences (F12), otherwise you'll essentially be counting them twice.
profile picture

ss161

#3
i agree on point 2 completely

with respect to 1) i'm using 1 minute bar data, i can't get that from Yahoo, although maybe if you pay for data you can get it? (i havn't looked into it too much). either way, being able to turn it on or off on the fly in a script seems useful. of course, it requires access to fundamental data from fidelity to get the dividends.
profile picture

Eugene

#4
QUOTE:
although maybe if you pay for data you can get it?

No, even having a Premium account won't help get intraday historical data from Yahoo -- they just don't offer intraday backfills.
profile picture

crk31174

#5
Hi,

I tried using the Dividend adjusted data using the method that ss161 created on Fidelity data and compared it with Yahoo's dividend adjusted data. But they don't appear to match.

ss161, can you confirm if that is the case? Have you been able to do a comparison of the two?

Thanks,