Calculate your Gains and Losses of your Stocks in Excel.

Posted on April 3, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

And today were continuing with another Excel Tip & Trick. And it’s another Cool Excel Trick. I showed you on Monday a Formula to Calculate the Price Reduction or Discount. On Tuesday I showed you a Formula for Converting the Currency Dollars to Euros. And I’m having fun with the currency formulas so I have another one for you today. Unfortunately this can be now a day’s a very useful one too. It’s kind of the same as yesterday where I talked about changing my advertising and review values into Euros instead of dollars. This is of course caused by “strong” dollar, hmmm. One other good way of losing money is investing in Stocks especially in financials (again hmmm).

Today I want to show you a formula how you can keep track of your stocks (or any other particular value) via percentages. This is a really cool excel trick.

Calculate your Gains and Losses of your Stocks in Excel via percentages.

Your stocks have fallen 9.5 % on Monday and you now want to see what percentage you need to get back to 100%.

Calculate-Gains-Losses-Stocks-Excel-pic1

· Select Cell B4

· Type in the percentage that you’ve lost.

· Select Cell C4

· Type in =C3-(C3*$B$4)

· And press enter

Calculate-Gains-Losses-Stocks-Excel-pic2

· Now select Cell B5

· And type in the formula =B4/(1-B4)

· And press Enter

Calculate-Gains-Losses-Stocks-Excel-pic3

· Now Select Cell C5

· And type in the formula =C4+(C4*$B$5)

· And press Enter

Calculate-Gains-Losses-Stocks-Excel-pic4

And you should now end on the value that you’ve entered in Cell C3. If you have losses all week you can drag the formula to the other Cells by clicking on the bottom right corner of each cell. But just play a bit with this and you’ll master it in no time. So, I hope you’ve enjoyed this Cool Excel Trick and I’ll talk to you all tomorrow with another Excel Tip & Trick. And it’s not a financial Excel tutorial;).

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.