Jump to content

Excel expert needed to look at this


lululee

Recommended Posts

@lululee:

below is with Reza's coded for your reference.

https://www.sendspace.com/file/607ldk

Note:

1. no change to the non-reza setups

2. gap up is coded as open>close, gap down as open<close (I used these to keep the required conditions in effect)

3. since value is always within range (pls correct me if i am wrong), if both conditions <range AND <value is required, only the min (ie <range) is coded.

4. overnight (ON) high and low rows are added to your data set

 

sorry that i did not have time to work out if there's any contradiction in the author's proposal. the formula is purely a straight forward translation of the verbal descriptions provided. other memebers are welcome to provide corrections and modification to make it better and more reliable.

 

@marketrulez, no worries. i removed the file because I named a tab inappropriately. now i named it as "combined". btw, you may use your vba skill to make a better version for lululee.

Link to comment
Share on other sites

@lululee:

below is with Reza's coded for your reference.

https://www.sendspace.com/file/607ldk

Note:

1. no change to the non-reza setups

2. gap up is coded as open>close, gap down as open<close (I used these to keep the required conditions in effect)

3. since value is always within range (pls correct me if i am wrong), if both conditions <range AND <value is required, only the min (ie <range) is coded.

4. overnight (ON) high and low rows are added to your data set

 

sorry that i did not have time to work out if there's any contradiction in the author's proposal. the formula is purely a straight forward translation of the verbal descriptions provided. other memebers are welcome to provide corrections and modification to make it better and more reliable.

 

@marketrulez, no worries. i removed the file because I named a tab inappropriately. now i named it as "combined". btw, you may use your vba skill to make a better version for lululee.

 

Thanks @khlk

 

#3 yes you are right. <range is good enough.

 

As you said..... everyone's input is welcome... lets keep making it better.. :)

 

Regards

Link to comment
Share on other sites

@lululee:

below is with Reza's coded for your reference.

https://www.sendspace.com/file/607ldk

Note:

1. no change to the non-reza setups

2. gap up is coded as open>close, gap down as open<close (I used these to keep the required conditions in effect)

3. since value is always within range (pls correct me if i am wrong), if both conditions <range AND <value is required, only the min (ie <range) is coded.

4. overnight (ON) high and low rows are added to your data set

 

sorry that i did not have time to work out if there's any contradiction in the author's proposal. the formula is purely a straight forward translation of the verbal descriptions provided. other memebers are welcome to provide corrections and modification to make it better and more reliable.

 

@marketrulez, no worries. i removed the file because I named a tab inappropriately. now i named it as "combined". btw, you may use your vba skill to make a better version for lululee.

 

Hi @klhl

Reza's setups are totally different then the first ones ??

The purpose if this (https://www.sendspace.com/file/d1e999) file was to see the click on the main links to see the picture and setup. it is possible to do the fomulas in this file.

Edited by lululee
Link to comment
Share on other sites

The file is deleted. Would you please upload the excel file once again.

 

Thanks.

 

@lululee:

below is with Reza's coded for your reference.

https://www.sendspace.com/file/607ldk

Note:

1. no change to the non-reza setups

2. gap up is coded as open>close, gap down as open<close (I used these to keep the required conditions in effect)

3. since value is always within range (pls correct me if i am wrong), if both conditions <range AND <value is required, only the min (ie <range) is coded.

4. overnight (ON) high and low rows are added to your data set

 

sorry that i did not have time to work out if there's any contradiction in the author's proposal. the formula is purely a straight forward translation of the verbal descriptions provided. other memebers are welcome to provide corrections and modification to make it better and more reliable.

 

@marketrulez, no worries. i removed the file because I named a tab inappropriately. now i named it as "combined". btw, you may use your vba skill to make a better version for lululee.

Link to comment
Share on other sites

Hi @mafiaonmove @klhk @zoheb ..

 

I have another request for you guys. I have got Reza's setups http://profiletraders.com . I have put it in Excel with picture so it will be easier for us to pin point the setup very quickly. I also included setup pdf. In Excel just put X in front of that cell whatever setup is applicable. I really appreciate it if you guys can get this one done also. This way we can compare both on which one is better. Thanking you in advance.

 

https://www.sendspace.com/file/d1e999

 

Regards

Lulu

 

I also have his courses if anyone needs please let me know.

 

Hi

 

Could you please share Reza's courses if possible?

 

Thanks

Link to comment
Share on other sites

  • 3 years later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...