Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down/List w/Code and Definition, only code entered when selec Spiritdancer Excel Worksheet Functions 2 November 2nd 07 03:57 AM
Convert a Number Code to a Text Code Traye Excel Discussion (Misc queries) 3 April 6th 07 09:54 PM
Converting EasyLanguage to Excel Titanus Excel Worksheet Functions 2 December 13th 06 04:01 PM
UDF problem in converting data into code 128 B Safi Excel Worksheet Functions 0 July 30th 06 08:57 AM
copying vba code to a standard code module 1vagrowr Excel Discussion (Misc queries) 2 November 23rd 05 04:00 PM


All times are GMT +1. The time now is 08:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"