Registered User Joined: 3/10/2012 Posts: 465
|
Bruce any luck with turning point query ?/ my top first question in this post
I was thinking what if you improvise on clear bar theory using this below formula that you had computed in past and if we can put percentages to match peaks and troughs in them
IIF(L > H1, H1, IIF(H < L1, L1, IIF(L > MINH2.1, H2, IIF(H < MAXL2.1, L2, IIF(L > MINH3.1, H3, IIF(H < MAXL3.1, L3, IIF(L > MINH4.1, H4, IIF(H < MAXL4.1, L4, IIF(L > MINH5.1, H5, IIF(H < MAXL5.1, L5, IIF(L > MINH6.1, H6, IIF(H < MAXL6.1, L6, IIF(L > MINH7.1, H7, IIF(H < MAXL7.1, L7, IIF(L > MINH8.1, H8, IIF(H < MAXL8.1, L8, IIF(L > MINH9.1, H9, IIF(H < MAXL9.1, L9, IIF(L > MINH10.1, H10, IIF(H < MAXL10.1, L10, IIF(L > MINH11.1, H11, IIF(H < MAXL11.1, L11, IIF(L > MINH12.1, H12, IIF(H < MAXL12.1, L12, IIF(L > MINH13.1, H13, IIF(H < MAXL13.1, L13, IIF(L > MINH14.1, H14, IIF(H < MAXL14.1, L14, IIF(L > MINH15.1, H15, IIF(H < MAXL15.1, L15, IIF(L > MINH16.1, H16, IIF(H < MAXL16.1, L16, IIF(L > MINH17.1, H17, IIF(H < MAXL17.1, L17, IIF(L > MINH18.1, H18, IIF(H < MAXL18.1, L18, IIF(L > MINH19.1, H19, IIF(H < MAXL19.1, L19, IIF(L > MINH20.1, H20, IIF(H < MAXL20.1, L20, IIF(L > MINH21.1, H21, IIF(H < MAXL21.1, L21, IIF(L > MINH22.1, H22, IIF(H < MAXL22.1, L22, IIF(L > MINH23.1, H23, IIF(H < MAXL23.1, L23, IIF(L > MINH24.1, H24, IIF(H < MAXL24.1, L24, IIF(L > MINH25.1, H25, IIF(H < MAXL25.1, L25, IIF(L > MINH26.1, H26, IIF(H < MAXL26.1, L26, IIF(L > MINH27.1, H27, IIF(H < MAXL27.1, L27, IIF(L > MINH28.1, H28, IIF(H < MAXL28.1, L28, IIF(L > MINH29.1, H29, IIF(H < MAXL29.1, L29, IIF(L > MINH30.1, H30, IIF(H < MAXL30.1, L30, IIF(L > MINH31.1, H31, IIF(H < MAXL31.1, L31, IIF(L > MINH32.1, H32, IIF(H < MAXL32.1, L32, IIF(L > MINH33.1, H33, IIF(H < MAXL33.1, L33, IIF(L > MINH34.1, H34, IIF(H < MAXL34.1, L34, IIF(L > MINH35.1, H35, IIF(H < MAXL35.1, L35, IIF(L > MINH36.1, H36, IIF(H < MAXL36.1, L36, IIF(L > MINH37.1, H37, IIF(H < MAXL37.1, L37, IIF(L > MINH38.1, H38, IIF(H < MAXL38.1, L38, IIF(L > MINH39.1, H39, IIF(H < MAXL39.1, L39, IIF(L > MINH40.1, H40, IIF(H < MAXL40.1, L40, IIF(L > MINH41.1, H41, IIF(H < MAXL41.1, L41, IIF(L > MINH42.1, H42, IIF(H < MAXL42.1, L42, IIF(L > MINH43.1, H43, IIF(H < MAXL43.1, L43, IIF(L > MINH44.1, H44, IIF(H < MAXL44.1, L44, IIF(L > MINH45.1, H45, IIF(H < MAXL45.1, L45, IIF(L > MINH46.1, H46, IIF(H < MAXL46.1, L46, IIF(L > MINH47.1, H47, IIF(H < MAXL47.1, L47, IIF(L > MINH48.1, H48, IIF(H < MAXL48.1, L48, IIF(L > MINH49.1, H49, IIF(H < MAXL49.1, L49, IIF(L > MINH50.1, H50, IIF(H < MAXL50.1, L50, 1 / 0))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))
|