View Single Post
  #1   Report Post  
holiday holiday is offline
Junior Member
 
Posts: 1
Default Converting EasyLanguage code to Excel

Hi all

I am a not good with VB and only slightly better with Excel formulas. I am using 2007.

Please please please could someone with any EasyLanguage knowledge convert this code to either Excel formula or VB code? Either will do - I suppose formulas would be easier for me but honestly VB is fine too - hey I would be grateful for absolutely ANY help!!!

I have tried myself but I keep getting it wrong and wrong and wrong - if I try to describe what I have done I will only confuse this post so I thought better of it!!!!!

Anyway, this is the EasyLanguage code:

--------------------------------------------------------------------------
Inputs:
Price((H+L)/2),
alpha(.07);

Vars:
Smooth(0),
ITrend(0);

ITrend = (alpha - alpha*alpha/4) * Price + .5*alpha*alpha*Price[1] - (alpha - .75*alpha*alpha) * Price[2] + 2*(1-alpha) * ITrend[1] - (1-alpha)*(1-alpha)*ITrend[2];

If currentbar < 7 then ITrend = (Price + 2*Price[1] + Price[2]) / 4;

Plot1(ITrend, "ITrend");
--------------------------------------------------------------------------

If anyone could help I would be forever thankful - honest I would!!!

Many thanks

Holiday