ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting EasyLanguage code to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/171856-converting-easylanguage-code-excel.html)

holiday

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


All times are GMT +1. The time now is 11:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com