My company name from file? - Wealth Lab Forum

My company name from file?

Author: jeffisw

Creation Date: 3/30/2013 6:49 PM

Wealth Lab » WealthScript (.NET) » My company name from file?

jeffisw

3/30/2013 6:49 PM

I use a strategy as a stock screener to generate a list of stocks in the debug log window. I would like to list the company name. I want to use my company name instead of the long company name from Fidelity. In the past I use excel VLOOKUP function to search from an excel file. Is there a better way to search the company name by creating an external text file? How can I create the external text file?

Eugene

3/31/2013 2:09 AM

Assuming there's a custom crafted comma- or tab-separated text file at "c:\Users\jeffisw\Documents\MyCompanyName.txt" that looks like this:

QUOTE:
AAPL Apple
BA Boeing

1. We can create the following extension method:

CODE:
Please log in to see this code.

As can be seen, the method can be applied to any string (here: to Bars.Symbol).

P.S. The ugly ExtensionAttribute class goes away only when Fidelity upgrades the built-in Editor.

But should it happen that you don't like the uber-convenient extension method syntax as much as I do, you can extract the MyCompanyName routine (removing the "this" keyword prefacing "string ticker", of course), place it in your strategy and treat it like any other method:

2. Traditional way:

CODE:
Please log in to see this code.

Size:

Color:

Assuming there's a custom crafted comma- or tab-separated text file at [i]"c:\Users\jeffisw\Documents\MyCompanyName.txt"[/i] that looks like this:

[quote]AAPL	Apple
BA	Boeing
[/quote]

1. We can create the following [b]extension method[/b]:

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

namespace System.Runtime.CompilerServices
{
	public class ExtensionAttribute : Attribute { }
}

namespace WealthLab.Strategies
{	
	public static class Util
	{
		public static string MyCompanyName( this string ticker, string pathToFile )
		{
			Dictionary<string, string> lstNames = new Dictionary<string, string>();
			
			using (System.IO.StreamReader reader = new System.IO.StreamReader(pathToFile))
			{
				string line;
				while ((line = reader.ReadLine()) != null)
				{
					string symbol = line.Split(new char[]{',','\t'})[0];
					string name = line.Split(new char[]{',','\t'})[1];
					lstNames.Add( symbol, name);
				}
			}
			
			if (lstNames.ContainsKey(ticker))
				return lstNames[ticker];
			
			return string.Empty;
		}
	}
	
	public class MyStrategy : WealthScript
	{
		protected override void Execute()
		{
			string pathToFile = @"c:\Users\jeffisw\Documents\MyCompanyName.txt";
			PrintDebug( Bars.Symbol.MyCompanyName( pathToFile ) );
		}
	}
}[/code]

As can be seen, the method can be applied to [i]any[/i] string (here: to Bars.Symbol).

P.S. The ugly [i]ExtensionAttribute[/i] class goes away only when Fidelity upgrades the built-in Editor.

But should it happen that you don't like the uber-convenient extension method syntax as much as I do, you can extract the MyCompanyName routine (removing the "this" keyword prefacing "string ticker", of course), place it in your strategy and treat it like any other method:

2. [b]Traditional way[/b]:

[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
	{
		public static string MyCompanyName( string ticker, string pathToFile )
		{
			string companyName = "Company name isn't found";
			Dictionary<string, string> lstNames = new Dictionary<string, string>();
			
			using (System.IO.StreamReader reader = new System.IO.StreamReader(pathToFile))
			{
				string line;
				while ((line = reader.ReadLine()) != null)
				{
					string symbol = line.Split(new char[]{',','\t',';'})[0];
					string name = line.Split(new char[]{',','\t',';'})[1];
					lstNames.Add( symbol, name);
				}
			}
			
			if (lstNames.ContainsKey(ticker))
				companyName = lstNames[ticker];
			
			return companyName;
		}
		
		protected override void Execute()
		{
			string pathToFile = @"c:\Users\jeffisw\Documents\MyCompanyName.txt";
			PrintDebug( MyCompanyName( Bars.Symbol, pathToFile ) );
		}
	}
}
[/code]