Sync Issue with External Symbol

Author: gpetrie

Creation Date: 1/8/2011 9:59 PM

Wealth Lab » WealthScript (.NET) » Sync Issue with External Symbol

gpetrie

1/8/2011 9:59 PM

Hi,

I created an external data series with the following code. I copied all the PrintDebug results to excel and used the Excel Provider to create a new DataSet. I can display the resulting Chart in Wealth Lab 6.0 fine. However when I use the second set of code (below) to access and plot the data as an external symbol and sync it with the primary symbol I get an error that the "plotted DataSeries has fewer bars than the symbol being plotted." Seems my dates are not matching up.

Any thoughts/help would be appreciated.

Thanks,

Gene

C R E A T I O N C O D E

CODE:
Please log in to see this code.

A C C E S S C O D E

CODE:
Please log in to see this code.

Size:

Color:

Hi,

I created an external data series with the following code.  I copied all the PrintDebug results to excel and used the Excel Provider to create a new DataSet.  I can display the resulting Chart in Wealth Lab 6.0 fine.  However when I use the second set of code (below) to access and plot the data as an external symbol and sync it with the primary symbol I get an error that the "plotted DataSeries has fewer bars than the symbol being plotted."  Seems my dates are not matching up.

Any thoughts/help would be appreciated.

Thanks,

Gene

C R E A T I O N   C O D E

[CODE]StrategyParameter pSPPercent;
		StrategyParameter pSPMALen;
	
		public MyStrategy()
		{
			
			pSPPercent = CreateParameter("pSPPercent", 0.70, 0.70, 0.90, 0.01);
			pSPMALen = CreateParameter("pSPMALen", 20, 18, 24, 2);
		}
		
		protected override void Execute()
                
		{
			ClearDebug();
		
			double SPPercent = pSPPercent.Value;
			int SPMALen = pSPMALen.ValueInt;
			
			const char tab = '\u0009';
			
			DataSeries OverMA = new DataSeries( Bars, String.Concat("Number above MA (",SPMALen,")") );						
			for(int ds = 0; ds < DataSetSymbols.Count; ds++)			
			{				
				SetContext( DataSetSymbols[ds], true );				
				for(int bar = SPMALen; bar < Bars.Count; bar++)
				{	
					if( Bars.Close[bar] > SMA.Series( Bars.Close,SPMALen )[bar] && DataSetSymbols[ds] != "SPY" )						
						OverMA[bar]++;
				}	
				RestoreContext();	
				
			}
			ChartPane omaPane = CreatePane(20,true,true);			
			ChartPane omapctPane = CreatePane(60,true,true);			
			
			DataSeries PctOverMA = OverMA/DataSetSymbols.Count*100;	
			PctOverMA.Description = String.Concat( "Pct above MA (",SPMALen," )" );	
			
			PrintDebug("Symbol" + tab + "Date" + tab + "Close");
			
			for(int bar = SPMALen; bar < Bars.Count; bar++)
			{	
				PrintDebug("PctOver" + tab + Bars.Date[bar].ToString() + tab + PctOverMA[bar].ToString() );
			}
			
			PlotSeries( omaPane, OverMA, Color.Blue, LineStyle.Histogram,2 );			
			PlotSeries( omapctPane, PctOverMA, Color.DarkGreen, LineStyle.Solid,2 );			
			//EMA SigEma = EMA.Series( PctOverMA, SigLen, EMACalculation.Modern );			
			//PlotSeries( omapctPane, SigEma, Color.Red, LineStyle.Solid, 2 );
			DrawHorzLine( omapctPane, SPPercent, Color.Blue, WealthLab.LineStyle.Solid, 1 );
			//DrawHorzLine( omapctPane, SPPercentLo, Color.Blue, WealthLab.LineStyle.Solid, 1 );
			
			
		}	[/CODE]

A C C E S S   C O D E

[CODE]Bars PercentOverSym = GetExternalSymbol("PctOvr", "PCTOVR", true);
			
			DataSeries PercentOver = PercentOverSym.Close;
			
			ChartPane omapctPane = CreatePane(60,true,true);			
			PlotSeries( omapctPane, PercentOver, Color.DarkGreen, LineStyle.Solid,2 );[/CODE]

Eugene

1/9/2011 1:13 AM

QUOTE:
Bars PercentOverSym = GetExternalSymbol("PctOvr", "PCTOVR", true);

What's that symbol? I mean, what kind of symbol are you trying to access by the "access code"? Is it something created by the "creation code"? Or is it an ASCII-exported something? The connection between the code snippets is not clear.

By the way, have you tried dropping the DataSet name parameter (i.e. "PCTOVR") from that call, was that successful?

CODE:
Please log in to see this code.

gpetrie

1/9/2011 10:43 AM

Thanks Eugene,

Problem was me. Created the symbol, "PctOver" and tried to access it as "PctOvr". All good now.

For what its worth, I am (mostly) using code you suggested from a post on 12/24 to build a dataset of the percentage of stocks over the moving average of an index. I added the PrintDebugs (1 for the header and 1 for each bar) to copy them into excel. With the data in a spreadsheet I can to avoid the long calculation every time I access it. I used the Excel Provider to create a new DataSet avoiding a CSV conversion.

Appreciate your guys patience with us rookies.

Gene