Accessing captial gain distributions as a fundamental item

Author: Panache

Creation Date: 1/5/2011 10:17 AM

Wealth Lab » WealthScript (.NET) » Accessing captial gain distributions as a fundamental item

Panache

1/5/2011 10:17 AM

Mutual funds often declare multiple dividends on the same date, ie. ordinary income dividends, short term capital gain distributions and long term capital gain distributions. If I annotate the chart for dividends, both ordinary income and capital gain dividends are shown. However, when I access the Fundamental Item dividends, only the ordinary income dividends are shown. How can I access the fundamental item where the capital gain distributions are stored?

CODE:
Please log in to see this code.

Size:

Color:

Mutual funds often declare multiple dividends on the same date, ie. ordinary income dividends, short term capital gain distributions and long term capital gain distributions.  If I annotate the chart for dividends, both ordinary income and capital gain dividends are shown.  However, when I access the Fundamental Item dividends, only the ordinary income dividends are shown.  How can I access the fundamental item where the capital gain distributions are stored?

[CODE]// Script to print the date and amount of each dividend

/* PROBLEM
  If I annotate the chart for Dividends, the symbol PRNEX shows two dividends on 12/15/2008 -- one for $0.49 and one for $0.39
  However, the Fundamental Item dividend only shows the $0.49 ordinary income dividend
  How can I access the other $0.39 capital gain distribution?
*/

using System;
using System.Collections.Generic;
using System.Text;
using System.Drawing;
using WealthLab;
using WealthLab.Indicators;

namespace WealthLab.Strategies
{
	public class MyStrategy : WealthScript
	{
		protected override void Execute()
		{
			double priorDividend = 0;
			
			//Set priorDividend = to most recent dividend amount
			FundamentalItem fiFirst = GetFundamentalItem(Bars.Count - 1, Bars.Symbol, "dividend");
			priorDividend = fiFirst.Value;
			
			for (int bar = Bars.Count - 1; bar >= Bars.FirstActualBar; bar--)
			{
				try{
					FundamentalItem fi = GetFundamentalItem(bar, Bars.Symbol, "dividend");
					
					// Print the dividend amount for each bar
					//PrintDebug(Date[bar] + "  " + fi.Value.ToString("$#,0.00"));
					
					// If the dividend amount is different, print the last date and dividend amount
					if(fi.Value != priorDividend)
					{
						PrintDebug(Date[bar + 1] + "  " + priorDividend.ToString("$#,0.00"));
						priorDividend = fi.Value;
					}
				}
				catch{}
			}		
		}
	}
}[/CODE]