Welcome to the Traders Laboratory Forums.
Coding Forum Collaborate, receive help, or discuss coding related issues.

Reply
Old 09-22-2009, 08:38 PM   #1

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

MP Indicator in EL Using Arrays

I am trying to understand arrays in programming and would like to learn through practice. I saw the arrays thread but thought I would start a fresh one for this indicator as it may be useful to many. I will try to outline the mechanics of how to do this very specifically. I know how to this in Excel easily so I think I can outline this pretty well -- but I don't know the syntax necessary in Easylanguage. If someone who understands arrays well in EL can help, then I can learn how to do arrays and I would be greatly appreciative.

I would like to do an indicator that creates an array for each 30-min bar that places in the array all the prices that were traded during that bar. This can be done by taking the low price of the bar and adding 0.25 (1 tick) for each tick of range in that bar (H - L) / 0.25

obviously, this requires a dynamic array as there will be different amounts of items within each bar.

then I would like to cross references those arrays in a new cumulative array (all bars since day started) and take that cumulative array and solve for the 'mode' (an easy keyword function in EL) -- mode is the most repeated price. In excel, it defaults such that if there is more than 1 price that occurs the most amount of times, Excel takes the lowest of these prices --- which is fine..... because I would then like to just count the number of times the mode price occured and put that in a histogram.

any willing to help out --- if this isn't clear, I can surely make it more clear.

thanks

Frank
Frank is offline  
Reply With Quote
Old 09-22-2009, 09:04 PM   #2

Tams's Avatar

Join Date: Sep 2008
Location: Geelong
Posts: 3,779
Ignore this user

Thanks: 2,084
Thanked 1,474 Times in 912 Posts

Re: MP Indicator in EL Using Arrays

have you studied Ant's version?
what do you think?

http://www.traderslaboratory.com/for...ation-516.html
__________________



Only an idiot would reply to a stupid post
Tams is offline  
Reply With Quote
Old 09-22-2009, 09:13 PM   #3

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: MP Indicator in EL Using Arrays

I've seen his screenshots and while that is good, its not what I am looking for -- not to mention that it is too complex a script for my level.
Frank is offline  
Reply With Quote
Old 09-22-2009, 11:03 PM   #4

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: MP Indicator in EL Using Arrays

my first sad attempt -- already lost





Here it is in Excel if it helps visualize it:



thanks for any help
Attached Thumbnails
MP Indicator in EL Using Arrays-overlap-count-indicator.png   MP Indicator in EL Using Arrays-overlap-count-indicator-excel.png  

Last edited by Frank; 09-22-2009 at 11:19 PM.
Frank is offline  
Reply With Quote
Old 09-23-2009, 01:27 AM   #5
ant

ant's Avatar

Join Date: Sep 2006
Location: USA
Posts: 421
Ignore this user

Thanks: 22
Thanked 314 Times in 81 Posts

Re: MP Indicator in EL Using Arrays

Frank,

Your use of static arrays is correct. Nice job so far.

Here are some suggestions...
  • Instead of using a different array for each bar, use a 2-dimensional array. For example, use Array[BarNumber, Index], where BarNumber is the number of the bar on each day and Index is each price level per bar.
  • You probably have use for the array in your indicator, but so far, an array is not required. All of the information in your Excel spreadsheet can be derived from the high and low of each bar.
  • Keep in mind that the EL code is executed as each historical bar is processed, so you don't have to process all bars at one time. That is, you don't have to explicitly loop through all bars.

Below is the EL code with the suggestions made above. Hope it helps.

MP Indicator in EL Using Arrays-array.jpg
ant is offline  
Reply With Quote
The Following 3 Users Say Thank You to ant For This Useful Post:
Blu-Ray (09-23-2009), Frank (09-23-2009), Tams (09-23-2009)
Old 09-23-2009, 10:30 PM   #6

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: MP Indicator in EL Using Arrays

ok ant and/or anyone else that may be interested in helping -- I looked at this code more closely and now there is a framework I understand.

that is cool, you have created an 2-dimensional array with all the 30-min prices indexed within an assigned bar number.

so next step would then be to reference the cumulative bars up to that point in the day --- would you use an if/then statement such as:

if currentbar = 4 then loop through all the elements within BarNums 1-3 and create a cumulative array from which we loop through that and use a counter such as y=y+1 to count when an element is = to the mode price of the cumulative array?? is that doable?

open ecry is slightly different but it did compile with one adjustment (changing 'bars' to 'bars1')

one other thing, with current structure, the array can run out of space unless we set a huge number up front. how do you deal with this elegantly?

thanks for any help

frank

Attached Thumbnails
MP Indicator in EL Using Arrays-overlap-count-indicator.png  
Frank is offline  
Reply With Quote
Old 09-23-2009, 11:28 PM   #7
ant

ant's Avatar

Join Date: Sep 2006
Location: USA
Posts: 421
Ignore this user

Thanks: 22
Thanked 314 Times in 81 Posts

Re: MP Indicator in EL Using Arrays

Quote:
Originally Posted by Frank »
so next step would then be to reference the cumulative bars up to that point in the day --- would you use an if/then statement such as:

if currentbar = 4 then loop through all the elements within BarNums 1-3 and create a cumulative array from which we loop through that and use a counter such as y=y+1 to count when an element is = to the mode price of the cumulative array?? is that doable?
I would do any calculations you need as you process each bar. You shouldn't have to go back to reference previous bars.

Quote:
Originally Posted by Frank »
one other thing, with current structure, the array can run out of space unless we set a huge number up front. how do you deal with this elegantly?
Since you're processing bars as you go, you really don't know how many ticks you have in future bars. You could probably figure out the first array subscript (i.e., BarNum), but to keep it simple, just specify the array subscripts as inputs and then define a dynamic array. If you get a run-time error about an array overflow, simply increase the inputs corresponding to the array subscripts to resolve it. Usually, you don't want to make arrays too big because you can take a performance hit, especially for real-time indicators on high volume days, but it doesn't sound like this is a real-time indicator so it probably isn't a big deal. Also, 2-dimensional arrays can get quite large. For example, your array currently holds 14 x 5000 = 70000 elements.
ant is offline  
Reply With Quote
Old 09-24-2009, 12:31 AM   #8

Join Date: Jan 2008
Location: San Francisco
Posts: 394
Ignore this user

Thanks: 17
Thanked 338 Times in 156 Posts

Re: MP Indicator in EL Using Arrays

Quote:
You shouldn't have to go back to reference previous bars.
having trouble processing this. this calculation doesn't store a resulting number to use in the next bar, don't you have to repeatedly look back at all the cumulative array elements and re-count the mode as it may have changed?

funny, maybe I am just a visual person -- but this was really easy for me when I originally did it in Excel but now seems quite compute intensive when thinking about the array coding steps.
Frank is offline  
Reply With Quote

Reply

Thread Tools
Display Modes Help Others By Rating This Thread
Help Others By Rating This Thread:


Similar Threads
Thread Thread Starter Forum Replies Last Post
Arrays Question andypap Coding Forum 8 04-11-2009 11:34 AM
Looking for Someone Good with Coding Arrays waveslider Coding Forum 3 10-28-2008 02:26 PM
Indicator with Data of Another Indicator Tresor Coding Forum 13 08-06-2008 10:48 AM
Arrays ImXotep Coding Forum 1 05-07-2007 06:09 AM

All times are GMT -4. The time now is 01:52 PM.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
CS to VB integration by DeskLancer
©2006-2011 Traders Laboratory, All Rights Reserved.