lululee Posted January 10, 2017 Report Share Posted January 10, 2017 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 Quote Link to comment Share on other sites More sharing options...
Gretta Posted January 10, 2017 Report Share Posted January 10, 2017 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" Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 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 Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 10, 2017 Report Share Posted January 10, 2017 Hi @Kendal, I am not familiar with Excel formulas (Excel idoit) at all. Can you please do this for me ???? Thanks Lulu Will give it a shot when I have some time soon Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 10, 2017 Report Share Posted January 10, 2017 @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 Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 (edited) @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 January 10, 2017 by lululee Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 Will give it a shot when I have some time soon Thanks @zoheb ....look forward to it. Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 @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 Quote Link to comment Share on other sites More sharing options...
mafiaonmove Posted January 10, 2017 Report Share Posted January 10, 2017 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. Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 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... Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 10, 2017 Report Share Posted January 10, 2017 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: 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 lululee, ⭐ nadjib and marketrulez 3 Quote Link to comment Share on other sites More sharing options...
lululee Posted January 10, 2017 Author Report Share Posted January 10, 2017 @lululee: since you want to trade market profile, you may want to use concepts aligned to it. Think about it. eg: 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.... zoheb 1 Quote Link to comment Share on other sites More sharing options...
lululee Posted January 11, 2017 Author Report Share Posted January 11, 2017 Anyone finised doing this ??? Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 11, 2017 Report Share Posted January 11, 2017 (edited) 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 January 11, 2017 by zoheb Quote Link to comment Share on other sites More sharing options...
lululee Posted January 12, 2017 Author Report Share Posted January 12, 2017 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 ? thanks Zoheb....Yes thats right. zoheb 1 Quote Link to comment Share on other sites More sharing options...
Gretta Posted January 12, 2017 Report Share Posted January 12, 2017 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 lululee and ⭐ ESVepara 2 Quote Link to comment Share on other sites More sharing options...
mafiaonmove Posted January 12, 2017 Report Share Posted January 12, 2017 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. Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 13, 2017 Report Share Posted January 13, 2017 (edited) thanks Zoheb....Yes thats right. @lululee: am trying to PM you wrt this sheet, can you kindly clear some space in your inbox please ? Let know once done, thank you Edited January 13, 2017 by zoheb Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 13, 2017 Report Share Posted January 13, 2017 (edited) 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 January 13, 2017 by zoheb Quote Link to comment Share on other sites More sharing options...
lululee Posted January 13, 2017 Author Report Share Posted January 13, 2017 @lululee: am trying to PM you wrt this sheet, can you kindly clear some space in your inbox please ? Let know once done, thank you Cleared the space. you can PM me now. Quote Link to comment Share on other sites More sharing options...
⭐ klhk Posted January 13, 2017 Report Share Posted January 13, 2017 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. lululee 1 Quote Link to comment Share on other sites More sharing options...
lululee Posted January 13, 2017 Author Report Share Posted January 13, 2017 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 Quote Link to comment Share on other sites More sharing options...
lululee Posted January 13, 2017 Author Report Share Posted January 13, 2017 (edited) 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 January 13, 2017 by lululee iksak, zoheb, ⭐ flipper26 and 2 others 5 Quote Link to comment Share on other sites More sharing options...
zoheb Posted January 13, 2017 Report Share Posted January 13, 2017 (edited) 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 January 13, 2017 by zoheb lululee 1 Quote Link to comment Share on other sites More sharing options...
marketrulez Posted January 14, 2017 Report Share Posted January 14, 2017 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.