asked on

Scoring

Hi Experts,

I need to following steps in my WB via VBA.

01.

On Button click analyze
if C29=”High” then
+1 @ Cell B48 & D48 & F48 & H48

02.

Find C22 Value from Range C2:C10 (+ or – 3 point leverage)
if True then find respective factor in range B39:B47 & Add +1 else nothing next step

03.

Find C23 Value in Range C2:C10(+ or – 3 point leverage)
if true then find respective factor in range D39:D47 & Add +1else nothing next step

04.

Find C22 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range F39:F47 & Add +1 else nothing next step

05.

Find C23 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range H39:H47 & Add +1 else nothing. End
Find attached file

Thanks
Scoring-G.xlsm

Jacques Geday

your file is passwd protected
gowflow

Naresh Patel

ASKER

Scoring-G.xlsm

Naresh Patel

ASKER

if any clarification needed regarding process pls reply.

Thanks

Jacques Geday

yes step 1 we add 1 to existing ?
step 2,3,4,5 where we add 1 what column
gowflow

Naresh Patel

ASKER

yes step 1 we add 1 to existing ?

Yes if there is "" then 1 if there is 3 then add +1 = 4

step 2,3,4,5 where we add 1 what column

ok
first change leverage (+ or – 3 point to 4 points) just for understanding
In Step 4 we found in TRUE value in cell G6 which is 288 & Cell C22 is 284 so assuming 4 point leverage comes to 284+4= 288. Factor for G6 is -180. So we have to put +1 in Cell F43. I guess you understand what am I up to.

Thanks

Naresh Patel

ASKER

This is Stage 1 of this question. there 2 more. second one for LOWS & last for applying to all data point Math G

Thanks

Jacques Geday

would you simply wait till one finishes part 1 so you post part 2 ?? why this rush ??
gowflow

Naresh Patel

ASKER

I am just saying Sir I am not gona post before Part one is over.

Thanks

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naresh Patel

ASKER

Yes Sir :) only confirmation from your side leverage factor is + or - 4 point. m I right?

Thanks You

Naresh Patel

ASKER

May post part 2?

Thanks

Naresh Patel

ASKER

Excellent

Jacques Geday

yes go ahead although it is 11:30 now will try my best
gowflow

Naresh Patel

ASKER

here it is Scoring.

Thanks

Naresh Patel

ASKER

My Bad Sir Need little modification.

01.

On Button click analyze
if C29=”High” then
+1 @ Cell B49 & D49 & F49 & H49

02.

Find C22 Value from Range C2:C11 (+ or – 3 point leverage)
if True then find respective factor in range B39:B48 & Add +1 (if it is at Close Hits then put +1 @ Unity)else nothing next step

03.

Find C23 Value in Range C2:C11(+ or – 3 point leverage)
if true then find respective factor in range D39:D48 & Add +1(if it is at Close Hits then put +1 @ Unity )else nothing next step

04.

Find C22 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range F39:F48 & Add +1 (if it is at Point Hits then put +1 @ Unity )else nothing next step

05.

Find C23 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range H39:H48 & Add +1 (if it is at Point Hits then put +1 @ Unity )else nothing. End
same way for LOW if you need detailed Step pls let me know I will post on that question.

Thanks
Scoring-G-V04.xlsm