Calculate how many stocks in a DataSet closed up

Author: kelvinyip

Creation Date: 12/12/2020 12:15 AM

Wealth Lab » WealthScript (.NET) » Calculate how many stocks in a DataSet closed up

kelvinyip

12/12/2020 12:15 AM

I want to have a sample to calculate across my Dow30 DataSet and if today's close is greater than yesterday, I want to add one to my global variable so eventually I want to see how many Dow stocks closed up. I think index lab has that but I think I may want something non standard but index lab requires complex C++ code that I don't think I know how to develop. Code below is my sample and I am trying to print out my FTC global variable. I thought this will print once at the end of my loop after all 30 stocks have been iterated through for 1 day. However, my debug statement got triggered 30 times. The global variable also increases if I run it over and over again.. 30 symbols for DOW but if I run it twice, my global variable goes to 60 and beyond.

Where should I put my debug so it prints only once each day after all 30 stocks have been iterated through and where /what should I use to reset the global variable each day after all 30 stocks have been iterated through

CODE:
Please log in to see this code.

Size:

Color:

I want to have a sample to calculate across my Dow30 DataSet and if today's close is greater than yesterday, I want to add one to my global variable so eventually I want to see how many Dow stocks closed up. I think index lab has that but I think I may want something non standard but index lab requires complex C++ code that I don't think I know how to develop. Code below is my sample and I am trying to print out my FTC global variable. I thought this will print once at the end of my loop after all 30 stocks have been iterated through for 1 day. However, my debug statement got triggered 30 times. The global variable also increases if I run it over and over again.. 30 symbols for DOW but if  I run it twice, my global variable goes to 60 and beyond.

Where should I put my debug so it prints only once each day after all 30 stocks have been iterated through and where /what should I use to reset the global variable each day after all 30 stocks have been iterated through

[code]using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using WealthLab;
using WealthLab.Indicators;
using WealthLab.Rules;
using System.Collections;
using WealthLab.Strategies;
using Community.Components;
using System.IO;

namespace WealthLab.Strategies
{
	 
	public class MyStrategy7 : WealthScript
	{

Hashtable FTCHASH=new Hashtable();
		int FTC = 0;
				DateTime ldate = new DateTime();
			bool NO_AUTO_EXECUTE = true;
		
		public MyStrategy7()
		{

}

protected override void Execute()
		{
		
			 FTCHASH.Clear();

ClearExternalSymbols();
		
			for (int bar = Bars.Count - 1; bar < Bars.Count; bar++)
			{
					PrintDebug(" current ftc value" + FTC);
				string currentSymbol = Bars.Symbol;
	
				if (Close[bar] > Close[bar-1])
				FTC = FTC + 1;
				
			
				// for loop
			}
		
				PrintDebug("FTC" + FTC);

}// end function
	
	
	}// end  class
		
}// end namespace[/code]

Eugene

12/12/2020 5:56 AM

QUOTE:
I want to see how many Dow stocks closed up

Don't code (especially in C++ when IndexDefinitions can be coded in a few lines of easy C#) what you can beg, borrow or steal - or simply use the built-in tool. Open the Index-Lab tool, and from the "Index Builder" choose "Advancing Issues" and select your Dow DataSet. Voila. Then refer to the newly created index symbol as you would with GetExternalSymbol. It's that simple.

Further reading: Wealth-Lab User Guide > Index-Lab®

P.S. Topic is renamed.