How do I use today's open to calculate an indicator value

Author: jedediah

Creation Date: 2/14/2012 7:01 PM

Wealth Lab » WealthScript (.NET) » How do I use today's open to calculate an indicator value

jedediah

2/14/2012 7:01 PM

I know this has probably been asked and answered somewhere. I have used the search function and the help files and tried numerous code variations and I have gotten nowhere. I am not a programmer, so I hacked the following code together from help files and other indicators:

CODE:
Please log in to see this code.

I bolded the code I need to fix. I would like TLow to plot as a fixed line on the price pane. TLow should be calculated using today's open minus the FailStat.

Any help would be greatly appreciated. Thanks in advance.

Size:

Color:

[CODE]using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using WealthLab;
using WealthLab.Indicators;

namespace WealthLab.Strategies
{
	public class MyStrategy : WealthScript
	{
		// Create an "Average Price" DataSeries

protected override void Execute()

{

// Find the StartBar of the 2nd day
			int StartBar = 0;
			int cnt = 0;
			for(int bar = 0; bar < Bars.Count; bar++) 
			{
				if( Bars.IntradayBarNumber(bar) == 0 ) cnt++;
				if( cnt == 2 )
				{
					StartBar = bar;
					break;
				}
			}
			
			SetScaleDaily();
			
			DataSeries DailyRange = (High - Low);
			DataSeries RangeSD = StdDev.Series( DailyRange, 30, StdDevCalculation.Sample );
			DataSeries AvgRange = SMA.Series((High - Low),30);
			DataSeries FQN= AvgRange/RangeSD;
			DataSeries FailStat = SMA.Series((Open - Low),30);
			
			
			DailyRange.Description = "Daily Range";			
			RangeSD.Description = "StDev";			
			AvgRange.Description="Average Range";			
			FQN.Description="FQN";			
			FailStat.Description="Fail Stat";
			
			RestoreScale();
			
			DailyRange= Synchronize(DailyRange)>>1;
			RangeSD= Synchronize(RangeSD)>>1;
			AvgRange= Synchronize(AvgRange)>>1;
			FQN= Synchronize(FQN)>>1;
			FailStat= Synchronize(FailStat)>>1;
			
			[b]DataSeries TLow	= (Open - FailStat);
			TLow.Description="Theoretical Low";[/b]
			
			HideVolume();
			
			ChartPane FQNPane = CreatePane( 10, true, true );
			PlotSeries(FQNPane, FQN, Color.Red, LineStyle.Solid, 1 );			
			ChartPane AvgRangePane = CreatePane( 10, true, true );
			PlotSeries(AvgRangePane, AvgRange, Color.Green, LineStyle.Solid, 1 );			
			ChartPane DevPane = CreatePane( 10, true, true );
			PlotSeries(DevPane, RangeSD, Color.Blue, LineStyle.Solid, 1 );		
			ChartPane FailStatPane = CreatePane( 10, true, true );
			PlotSeries(FailStatPane, FailStat, Color.Orange, LineStyle.Solid, 1 );
			PlotSeries(PricePane, TLow , Color.Aquamarine, LineStyle.Solid, 1 );

}
	}
}
[/CODE]

I bolded the code I need to fix. I would like [i]TLow[/i] to plot as a fixed line on the price pane. TLow should be calculated using today's open minus the FailStat.

Any help would be greatly appreciated. Thanks in advance.

Cone

2/15/2012 12:40 AM

In your calculation of TLow, Open is the open of each intraday bar. Assuming that you want to use the Daily Open, you'd have to SetScaleDaily again for that operation. However, when I tried that an error resulted for that DataSeries math operation. Anyway, here a straightforward way to get the result you're looking for:

CODE:
Please log in to see this code.

When plotting TLow, Color.Aquamarine doesn't show up very well if you're using a white background, so you may want to make that color something darker.

jedediah

2/15/2012 1:17 AM

Cone,

Thank you, it works perfectly. I had tried to reset the scale to daily and could not get it to work either...but I don't even live on the same planet as a programmer. Later, when I get a chance to really look at your code, I may have a question or two about it if I can't figure it out...if that's o.k.. Thanks again, big help. Take care.

a.j.