risk to reward calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2312260%22%20slang%3D%22en-US%22%3Erisk%20to%20reward%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2312260%22%20slang%3D%22en-US%22%3E%3CP%3Ehello!%20i%20am%20trying%20to%20create%20an%20excel%20sheet%20or%20formula%20that%20allow%20me%20to%20enter%20data%20and%20have%20it%20quickly%20calculate%20it...%20basically%2C%20i%20want%20to%20find%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22DOLLAR%20risk%20%2F%20(ENTER%20amount%20-%20RISK%20amount)%20%3D%20SHARES%20%22%3C%2FP%3E%3CP%3E%245%20%2F%20(%240.25%20ENTER%20-%20%240.23%20RISK)%20%3D%20%245%20%2F%20%240.02%20%3D%20250%20SHARES%3C%2FP%3E%3CP%3Eso%20if%20I%20want%20to%20risk%20%245%2C%20ENTER%20at%20%240.25%20and%20RISK%20%240.23%2C%20I%20would%20get%20250%20SHARES%20x%20%240.25%20ENTER%20%3D%20%2462.50%3C%2FP%3E%3CP%3Eso%20I%20then%20want%20to%20be%20able%20to%20compute%20an%20EXIT%20price%20based%20off%20a%20percentage%20gain...%20like%20a%2020%25%20gain%20of%20%240.25%20ENTER%20would%20mean%20I%20would%20EXIT%20at%20%240.30%20...%26nbsp%3B%20is%20that%20possible%3F%3C%2FP%3E%3CP%3Eso%20it%20would%20cost%20me%20%2462.50%20with%20250%20shares%20at%20%240.25%20and%20i%20would%20make%20%2475%20with%20250%20shares%20at%20%240.30%2C%20which%20is%20a%20profit%20of%20%2412.50%20(20%25%20gain)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20info%20would%20help%20if%20there%20is%20a%20way%20to%20compute%20this!%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2312260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2313063%22%20slang%3D%22en-US%22%3ERe%3A%20risk%20to%20reward%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2313063%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042152%22%20target%3D%22_blank%22%3E%40volcomkiss7%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20file%20is%20helpful.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-01%20at%2006.47.23.png%22%20style%3D%22width%3A%20635px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277214i620B86BF75EF1A6E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-01%20at%2006.47.23.png%22%20alt%3D%22Screenshot%202021-05-01%20at%2006.47.23.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2318397%22%20slang%3D%22en-US%22%3ERe%3A%20risk%20to%20reward%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BTHIS%20IS%20AWESOME!%20Would%20you%20be%20able%20to%20create%20one%20that%20I%20can%20easily%20plug%20in%20numbers%20with%20this%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3EShares%20%3D%20Dollar%20Risk%20%2F%20(Enter%20%24%20-%20Risk%20%24)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

hello! i am trying to create an excel sheet or formula that allow me to enter data and have it quickly calculate it... basically, i want to find:

 

"DOLLAR risk / (ENTER amount - RISK amount) = SHARES "

$5 / ($0.25 ENTER - $0.23 RISK) = $5 / $0.02 = 250 SHARES

so if I want to risk $5, ENTER at $0.25 and RISK $0.23, I would get 250 SHARES x $0.25 ENTER = $62.50

so I then want to be able to compute an EXIT price based off a percentage gain... like a 20% gain of $0.25 ENTER would mean I would EXIT at $0.30 ...  is that possible?

so it would cost me $62.50 with 250 shares at $0.25 and i would make $75 with 250 shares at $0.30, which is a profit of $12.50 (20% gain)

 

Any info would help if there is a way to compute this!

Thank you!!!

 

 

 

4 Replies

@volcomkiss7 Perhaps the attached file is helpful.

Screenshot 2021-05-01 at 06.47.23.png

@Riny_van_Eekelen THIS IS AWESOME! Would you be able to create one that I can easily plug in numbers with this formula: 

Shares = Dollar Risk / (Enter $ - Risk $) 

 

Thanks so much!

@volcomkiss7 Isn't that what I did in column D?

got it! thank you for this!