Verizon VZ Manual Split Correction required

Author: Cone

Creation Date: 10/24/2013 5:59 AM

Wealth Lab » Data » Verizon VZ Manual Split Correction required

Cone

10/24/2013 5:59 AM

Everyone using data from the Yahoo! Finance Provider needs to be aware that three manual split corrections for VZ are required - especially if you use VZ in testing. It's in the Dow 30 and S&P 100.

The issue is that Yahoo!'s [what should be] unadjusted data for VZ includes the split adjustments, and therefore the data will be incorrect when WL's Y! Provider applies the splits a second time. The different treatment for VZ's data in Yahoo! database appears to be due to company spin-offs (more below).

The only solution for the moment is to apply the reverse split adjustments by right clicking the chart and selecting "Process a Stock Split". The dates (d.m.yyyy) and splits to apply are as follows:

CODE:
Please log in to see this code.

The volume data will still not be correct following this operation - again due to the inconsistent treatment in Y!'s unadjusted data. If your script uses volume for indicators/trading rules, you could add the following AdjustVZVolume() operation to correct the Volume at the start of the Execute() method.

CODE:
Please log in to see this code.

From the Verizon Wiki:

2010/07/01 64:5
On May 13, 2009, Verizon announced it was selling all of Verizon's wireline assets in Arizona, Idaho, Illinois, Indiana, Michigan, Nevada, North Carolina, Ohio, Oregon, South Carolina, Washington, West Virginia and Wisconsin as well as some assets in California to Frontier Communications. These assets include Contel of the South, Verizon North, Verizon Northwest, Verizon West Coast, Verizon West Virginia, and two new companies created for spinoff, New Communications of the Carolinas and New Communications of the Southwest.[15] On July 1, 2010, the transfer of these assets to Frontier took place.[16]

2008/03/31 21:32
On January 16, 2007, Verizon New England operations in Maine, New Hampshire, and Vermont were spun off, and merged with FairPoint Communications, a deal which was finalized on April 1, 2008.

2006/11/17 3:16
On April 3, 2006 Verizon agreed to sell its stakes in Verizon Dominicana (operating in the Dominican Republic), CANTV of Venezuela, and Puerto Rico Telephone Company, Inc. (PRT) in Puerto Rico to Telmexand América Móvil for $3.7 billion.[14]

Size:

Color:

Everyone using data from the [b]Yahoo! Finance Provider[/b] needs to be aware that three manual split corrections for VZ are required - especially if you use VZ in testing.  It's in the Dow 30 and S&P 100.

The issue is that Yahoo!'s  [what should be] [i]unadjusted data for VZ[/i] includes the split adjustments, and therefore the data will be incorrect when WL's Y! Provider applies the splits a second time.  The different treatment for VZ's data in Yahoo! database appears to be due to company spin-offs (more below).

The only solution for the moment is to apply the reverse split adjustments by right clicking the chart and selecting "Process a Stock Split".   The dates (d.m.yyyy) and splits to apply are as follows:

[code]Date	Apply Split
1.7.2010	5:64
31.3.2008	21:32
17.11.2006	3:16[/code]

The volume data will still not be correct following this operation - again due to the inconsistent treatment in Y!'s unadjusted data.  If your script uses volume for indicators/trading rules, you could add the following AdjustVZVolume() operation to correct the Volume at the start of the Execute() method.

[code]using System;
using System.Collections.Generic;
using WealthLab;

namespace WealthLab.Strategies
{
	public class MyStrategy : WealthScript
	{
		public void AdjustVZVolume()
		{
			double[] s = {64/5d * 64/5d, 32/21d * 32/21d, 16/3d * 16/3d};
			DateTime[] dt = {new DateTime(2010,7,1), new DateTime(2008,3,31), new DateTime(2006,11,17) };
			
			for (int n = 0; n < s.Length; n++)
			{
				int bar = DateTimeToBar(dt[n], true);
				if (bar > 0)
					do
					{
						Volume[bar] *= s[n];
						bar--;
					} while (bar > 0);	
			}			
		}
		
		protected override void Execute()
		{
			AdjustVZVolume();
		}
	}
}[/code]

[link=http://en.wikipedia.org/wiki/Verizon_Communications] From the Verizon Wiki:[/link]

2010/07/01	64:5
On May 13, 2009, Verizon announced it was selling all of Verizon's wireline assets in Arizona, Idaho, Illinois, Indiana, Michigan, Nevada, North Carolina, Ohio, Oregon, South Carolina, Washington, West Virginia and Wisconsin as well as some assets in California to Frontier Communications. These assets include Contel of the South, Verizon North, Verizon Northwest, Verizon West Coast, Verizon West Virginia, and two new companies created for spinoff, New Communications of the Carolinas and New Communications of the Southwest.[15] On July 1, 2010, the transfer of these assets to Frontier took place.[16]

2008/03/31	21:32
On January 16, 2007, Verizon New England operations in Maine, New Hampshire, and Vermont were spun off, and merged with FairPoint Communications, a deal which was finalized on April 1, 2008.

2006/11/17	3:16
On April 3, 2006 Verizon agreed to sell its stakes in Verizon Dominicana (operating in the Dominican Republic), CANTV of Venezuela, and Puerto Rico Telephone Company, Inc. (PRT) in Puerto Rico to Telmexand América Móvil for $3.7 billion.[14]

Wealth Lab » Data » Verizon VZ Manual Split Correction required