Is Fidelity not adjusting for stock splits?
Author: wycan
Creation Date: 1/12/2009 7:16 AM
profile picture

wycan

#1
I have a script that I'm backtesting which eliminates any stocks under $15. It looks like there are a number of stocks that have not been adjusted for stock splits. For example, when I run the script it eliminates FTO prior to 6/1/2005 because the price is $11.72. This stock had a 2:1 split on 6/20/2005 and again 2:1 split on 6/27/2006. Technically, when the stock traded back on 6/1/2005 the price should have been much higher, around $47. It happens on HANS as well. I'm sure there are many others.

Am I misunderstanding this, or is Fidelity not adjusting for stock splits ? Is there a solution ?

thx

profile picture

Cone

#2
QUOTE:
Is there a solution ?
If a split is not automatically processed:
1. right click and process the split manually, or,
2. right click and Reload the chart history.

QUOTE:
I have a script that I'm backtesting which eliminates any stocks under $15.
Are you properly backtesting this method by UNadjusting for splits?
profile picture

wycan

#3
QUOTE:
Are you properly backtesting this method by UNadjusting for splits?


No, I guess I'm not UNadjusting for splits. Fidelity appears to properly adjust for splits going forward, but not going back in time. It poses a problem, in particluar, when using scripts to eliminate stocks not meeting a minimum price (my example: $15).

I was hoping that Fidelity would be more accurate that if I went back in time and looked at a stock price (from a script) it would be the price "at that time", not after it's been split a number of times.

How does one go about UNadjusting for stock splits (from a script perspective) ?

thx.



profile picture

Eugene

#4
QUOTE:
How does one go about UNadjusting for stock splits (from a script perspective) ?

The easiest way would be to see how the Rule Wizard handles it. Open up a new rule-based strategy, throw in an entry order, then go to the Conditions tab, expand the "Price (or Volume) Action" group and add the following item:

Price is above (or below) a value (backtest)

Then you just have to open the code in a new window. Note that you'll need to add a reference to WealthLab.Rules to your strategy for that method to work.
profile picture

wycan

#5
thx. I think that will work.
profile picture

kfmfe04

#6
QUOTE:

The easiest way would be to see how the Rule Wizard handles it. Open up a new rule-based strategy, throw in an entry order, then go to the Conditions tab, expand the "Price (or Volume) Action" group and add the following item:

Price is above (or below) a value (backtest)

Then you just have to open the code in a new window. Note that you'll need to add a reference to WealthLab.Rules to your strategy for that method to work.


This is very useful advice.

I was just struggling this morning trying to figure out how to throw out <$10 stocks without throwing out stocks that have split-adjusted in the distant past to below $10.

This fix is much appreciated - thanks!


profile picture

gbullr

#7
I am having the following issue with ABX in 1993. Stock Split 2/1 in 3/2/1993 and I right click and adjust. It seems that the adjustment does not get "stored." Is there a way to make it permanent? I checked data on Bloomberg. Thanks.

profile picture

Eugene

#8
What data provider is it (ABX)?
How exactly is the adjustment not "stored"?
This website uses cookies to improve your experience. We'll assume you're ok with that, but you can opt-out if you wish (Read more).