• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

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
0
Naresh Patel
Asked:
Naresh Patel
  • 10
  • 5
1 Solution
 
gowflowCommented:
your file is passwd protected
gowflow
0
 
Naresh PatelTraderAuthor Commented:
0
 
Naresh PatelTraderAuthor Commented:
if any clarification needed regarding process pls reply.

Thanks
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
gowflowCommented:
yes step 1 we add 1 to existing ?
step 2,3,4,5 where we add 1 what column
gowflow
0
 
Naresh PatelTraderAuthor Commented:
ok
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
0
 
Naresh PatelTraderAuthor Commented:
This is Stage 1 of this question. there 2 more. second one  for LOWS & last for applying to all data point Math G

Thanks
0
 
gowflowCommented:
would you simply wait till one finishes part 1 so you post part 2 ?? why this rush ??
gowflow
0
 
Naresh PatelTraderAuthor Commented:
I am just saying Sir I am not gona post before Part one is over.

Thanks
0
 
gowflowCommented:
Is this what you want ?
pls test it
gowflow
Scoring-G-V01.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Yes Sir    :) only confirmation from your side leverage factor is + or - 4 point. m I right?

Thanks You
0
 
Naresh PatelTraderAuthor Commented:
May post part 2?

Thanks
0
 
Naresh PatelTraderAuthor Commented:
Excellent
0
 
gowflowCommented:
yes go ahead although it is 11:30 now will try my best
gowflow
0
 
Naresh PatelTraderAuthor Commented:
here it is Scoring.


Thanks
0
 
Naresh PatelTraderAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

  • 10
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now