Jump to content

Excel expert needed to look at this


lululee

Recommended Posts

Hi All,

Looking for excel expert to look into this. I have 2 tabs, first tab is the one where you put input the values and second tab is the examples and 3rd tabs is the setups bases on the market/volume profile. If any excel expert can help put together. basically automat when you put the values in the first tab so excel sheet automatacally tells you what setup to takes based on 3rd sheet.

 

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

 

Thanks in advance

Lulu

Link to comment
Share on other sites

You will need a long logical statement starting like: =IF(B14="Up",IF(B6<B12,"a1",""),""), but given the number of setups, I think you will hit the maximum nested if statements that Excel will allow, not to mention it getting pretty complicated.

 

To keep each formula simple, you might instead list all the setups under each day and have the formula put an "X" next to the one that matches. That would give each cell a formula as small as the above, replacing "a1" with "X"

Link to comment
Share on other sites

You will need a long logical statement starting like: =IF(B14="Up",IF(B6<B12,"a1",""),""), but given the number of setups, I think you will hit the maximum nested if statements that Excel will allow, not to mention it getting pretty complicated.

 

To keep each formula simple, you might instead list all the setups under each day and have the formula put an "X" next to the one that matches. That would give each cell a formula as small as the above, replacing "a1" with "X"

 

Hi @Kendal,

I am not familiar with Excel formulas (Excel idoit) at all. Can you please do this for me ????

 

Thanks

Lulu

Link to comment
Share on other sites

@lululee: what is your criteria for determining trend is up/down ? i can automate that for you too so all you need to do is enter the values basis which the trend & setup will auto update

 

It can be anything.... HH HL or may be 50 bar CCI... 50 Bar EMA... depending on the what time frame you trade and you manually look at the chart and enter that value "up or down"...hope that helps

Edited by lululee
Link to comment
Share on other sites

@lululee: what is your criteria for determining trend is up/down ? i can automate that for you too so all you need to do is enter the values basis which the trend & setup will auto update

 

It can be anything.... HH HL or may be 50 bar CCI... 50 Bar EMA... depending on the what time frame you trade and you manually look at the chart and enter that value "up or down"...hope that helps

Link to comment
Share on other sites

I think I will look into it. Just at a glance, looking at ur setup criteria it doesnt seem too hard to code it ( looks simple if input values r good).

 

to calculate trend based on anything u mentioned above, requires a lot of data in input. But I will leave it upto u to decide if trend is up or down.

 

I will get onto it. Will need some spare time though. Hope I finish up this project.

Link to comment
Share on other sites

I think I will look into it. Just at a glance, looking at ur setup criteria it doesnt seem too hard to code it ( looks simple if input values r good).

 

to calculate trend based on anything u mentioned above, requires a lot of data in input. But I will leave it upto u to decide if trend is up or down.

 

I will get onto it. Will need some spare time though. Hope I finish up this project.

 

thank you...

Link to comment
Share on other sites

It can be anything.... HH HL or may be 50 bar CCI... 50 Bar EMA... depending on the what time frame you trade and you manually look at the chart and enter that value "up or down"...hope that helps

 

@lululee: since you want to trade market profile, you may want to use concepts aligned to it. Think about it.

 

eg:

  1. Trend Days
    • Bullish: if market opens above previous day's VAH and stays above it, (above previous day's high will be highly bullish)
    • Bearish: if market opens below previous day's VAL and stays below it, (below previous day's low will be highly bearish)

 

[*]Non-Trend Days

  • Balanced: Market Opens within previous day's Value Area

Link to comment
Share on other sites

@lululee: since you want to trade market profile, you may want to use concepts aligned to it. Think about it.

 

eg:

  1. Trend Days
    • Bullish: if market opens above previous day's VAH and stays above it, (above previous day's high will be highly bullish)
    • Bearish: if market opens below previous day's VAL and stays below it, (below previous day's low will be highly bearish)

 

[*]Non-Trend Days

  • Balanced: Market Opens within previous day's Value Area

 

agreed....

Link to comment
Share on other sites

Anyone finised doing this ???

 

hey lululee, started work on it but was unable to do much as I am currently travelling. will complete before eow. btw, kindly confirm the following:

'OS High' = overnight session high ?

'DBY' = day before yesterday ?

Edited by zoheb
Link to comment
Share on other sites

Hi @Kendal,

I am not familiar with Excel formulas (Excel idoit) at all. Can you please do this for me ????

 

Thanks

Lulu

 

I'd suggest getting up to speed with the basics if you are wanting to use Excel. This will get you started for the logical function you will need to use: https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2

Link to comment
Share on other sites

Excel is not tough, specially if u can do abit of VBA.

 

The only problem with excel is, it can't handle large amount of data so easily as R-Studio can. If I were to rely on statestics I would use R.

 

Anyways, I might start looking into it this weekend. If all goes right then its just a matter of couple of hours.

 

No need for VB for this, straight forward excel formulas only required. Why go in for a nose surgery to fix a common cold, no ;)

 

FYI: I have already started work on this.

Edited by zoheb
Link to comment
Share on other sites

Anyone finised doing this ???

 

Hi lululee, please test the following

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

 

Points to note:

1. within range is defined as VAL<OPEN<VAH, pls let me know if = should be included

2. it requires at least 2 day's data to work

3. when no condition fits, it displays "NO_SETUP"

 

Procedure:

1. in row "Today's_Trend", key in "1" for up-trend and "0" for down trend

2. key in Open value

3. copy the blue box D4 to right (E4) by dragging low right-hand handle to find out the setup #

 

hope it works.

Link to comment
Share on other sites

Hi lululee, please test the following

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

 

Points to note:

1. within range is defined as VAL<OPEN<VAH, pls let me know if = should be included

2. it requires at least 2 day's data to work

3. when no condition fits, it displays "NO_SETUP"

 

Procedure:

1. in row "Today's_Trend", key in "1" for up-trend and "0" for down trend

2. key in Open value

3. copy the blue box D4 to right (E4) by dragging low right-hand handle to find out the setup #

 

hope it works.

 

Thanks Klhk.... awesome...I will test next whole week

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.

Edited by lululee
Link to comment
Share on other sites

Hi lululee, please test the following

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

 

Points to note:

1. within range is defined as VAL<OPEN<VAH, pls let me know if = should be included

2. it requires at least 2 day's data to work

3. when no condition fits, it displays "NO_SETUP"

 

Procedure:

1. in row "Today's_Trend", key in "1" for up-trend and "0" for down trend

2. key in Open value

3. copy the blue box D4 to right (E4) by dragging low right-hand handle to find out the setup #

 

hope it works.

 

@klhk - within 'Range' = above low & below high, the region between the day's high & low. The region between VAL & VAH is called Value Area.

Edited by zoheb
Link to comment
Share on other sites

The share is gone already, can someone share the file please?

 

Hi lululee, please test the following

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

 

Points to note:

1. within range is defined as VAL<OPEN<VAH, pls let me know if = should be included

2. it requires at least 2 day's data to work

3. when no condition fits, it displays "NO_SETUP"

 

Procedure:

1. in row "Today's_Trend", key in "1" for up-trend and "0" for down trend

2. key in Open value

3. copy the blue box D4 to right (E4) by dragging low right-hand handle to find out the setup #

 

hope it works.

Link to comment
Share on other sites

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...