Ranking stocks in a watch-list according to % performance during a given period

Author: tradeoholic

Creation Date: 1/23/2014 3:19 AM

Wealth Lab » WealthScript Translator » Ranking stocks in a watch-list according to % performance during a given period

tradeoholic

1/23/2014 3:19 AM

Hi,

could somebody help me ? I would like to write a script that scans through a watchlist on every stock and counts the % performance betwenn two given time on a one minute chart. At first I enter the start and end time minute based (mm.dd.yyyy / hh:mm) then the script counts and ranks the stocks according to their % performance in this period and writes it to an exel file ranked with the performance value. Is it possible to give different background colour to minus and plus performance in the exel cells ?
I wrote something simlilar script, but it doesn't work for me.

CODE:
Please log in to see this code.

Size:

Color:

Hi,

could somebody help me ? I would like to write a script that scans through a watchlist on every stock and counts the % performance betwenn two given time on a one minute chart. At first I enter the start and end time minute based (mm.dd.yyyy / hh:mm) then the script counts and ranks the stocks according to their % performance in this period and writes it to an exel file ranked with the performance value. Is it possible to give different background colour to minus and plus performance in the exel cells ?
I wrote something simlilar script, but it doesn't work for me.

[code]using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using System.Threading; // Sleep()
using System.Windows.Forms;
using WealthLab;
using WealthLab.Indicators;
using finantic.TL; // WealthScriptTL

namespace WealthLabCompile2
{
	class Strategy : WealthScriptTL
	{
		#region file ChartScript

// start of prolog: This is a comment at the top of each file
		public new void Init()
		{
			base.Init();
			//optional settings
			UseUpdatedEMA(true);
			SetStdDevCalculation(StdDevCalculation.Population);
		}
		// end of prolog: This is a comment at the top of each file

public int w, Bar, StartBar, Period, Interval, ValuePane = 0;
		public double currentChange, XFirstCurrent = 0.0;
		public string b, c = null;
		public int chSeriesAAPL = 0;

/** This method contains the meat of your script,
    i.e, any statements that are not inside a user defined class or function/procedure. */
		protected override void Execute(){
			Init();
			// [declaration for class ChartScript used to be here] 
    
			chSeriesAAPL = (int)CreateSeries();
			b = (string)Input("Enter start date and time:");
			if ((b == "")) return ;
			Period = (int)int.Parse(b);
			c = (string)Input("Enter enddate and time:");
			if ((c == "")) return ;
			Interval = (int)int.Parse(c);
			StartBar = (int)(Bars.Count - Period);
			if ((StartBar < 0)) StartBar = (int)0;
			ValuePane = (int)CreatePane(1000, true, false);
			for (w = 0; w <= (DataSetSymbols.Count - 1); w++) 
			{
				SetPrimarySeries(WatchListSymbol(w));
				for (Bar = (StartBar + 1); Bar <= (StartBar + Interval); Bar++) 
				{
					PrintStatusBar((FormatFloat("#0.00%", ((((Bar - StartBar)) * 100) / ((Bars.Count - StartBar)))) + " complete ..."));
					XFirstCurrent = (double)PriceClose(StartBar);
					currentChange = (double)(((((PriceClose(Bar) - XFirstCurrent)) / XFirstCurrent)) * 100.0);
					SetSeriesValue(Bar, chSeriesAAPL, currentChange);
            
				}
        
			}
			PrintStatusBar((FormatFloat("#0.00%", ((((Bar - StartBar)) * 100) / ((Bars.Count - StartBar)))) + " complete ..."));
			PlotSeriesLabel(chSeriesAAPL, ValuePane, WL_MAROON, WL_THICK, "AAPL");
    
		}

// start of epilog: This is a comment at the end of each file
	} // class Strategy
} // namespace
	// end of epilog

#endregion file ChartScript
[/code]

Eugene

1/23/2014 5:02 AM

It's not necessarily a good idea to start learning Wealth-Lab 6 scripting with the help of WealthScript Translator. It's unsupported, and it's a pain to extend its output code because "pure" WealthScript doesn't mix up good with WSTL-interprted code.

Next, why use Excel if almost anything can be achieved right in Wealth-Lab (just ask)? For example, what you've been doing is essentially plotting the rate of change, isn't it? Then you could start with a tried design pattern and fine tune it to your needs (again, just ask):

Indicators | How to Plot ROC of multiple symbols on same chart