1. ## stocks (2000)

Hi, may name is Lauren Knobbe. I

2. ## Re: stocks (2000)

Hello Lauren,

Welcome to the Lounge.

We will be happy to help you, but you will have to tell us a bit more about what you want to do. "The date formulas" is rather vague - what what would you like to calculate?

4. ## Re: stocks (2000)

Lauren,

Thank you for the clarification and the attachment. I am not a financial expert, so I am afraid that I would firmly put my foot in my mouth if I were to give you advice about this. But there are several Loungers who know a lot about this subject; I am sure they will be able to help you. You may have to wait a bit, for Saturday and sunday are always quiet days in the Lounge.

5. ## Re: stocks (2000)

No financial whiz either, but I believe the formula for the annual return on your investment would be:

(1+gain/purchase_price)^(365/days_held) - 1

So, if you purchased a stock for \$10000 (of your \$30K) and gained 10% (gain of 1000) after 30 days, your annualized rate would be: (1+1000/10000)^(365/30) - 1 = 218.8%. Hans and I and most (all) of the others in here would want you to give us financial advice then! I THINK this is the right formula...maybe some financial whiz will confirm or correct it.

6. ## Re: stocks (2000)

Lauren, in its data handling, Excel uses digits starting from 1/1/1900 (day 1) to count days; so a formula for day differences is simple: one date minus another date, result formatted as number rather than date. For example, today is May 3, 2000 (where I am), which Excel keeps as 37,744. So long as all your transactions fall within the same year, and you do not need any kind of compounding factor, your simple annualized rate of return formula in cell J3 should be:

=(H3/E3-1)/(F3-B3)*365

Copy that formula down in column J.

(H3/E3-1) is sales cost divided by purchase cost minus one (a shortcut way of saying [sales cost minus purchase cost] divided by purchase cost, where [sales cost minus purchase cost] = profit).

/(F3-B3) is the number of days between purchase and sales, and is used to get the daily rate of return

*365 annualizes the result

Hope this helps. Post back here if you have more questions.

In the real world, you will not always sell the entire stock purchase at once, you might just sell part of your original purchase, and you will keep stocks for a period that crosses into subsequent years, so it gets a bit complex, I hope you don't have to get into that stuff. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

7. ## Re: stocks (2000)

Thanks to all of you who tried to help me on my project you all where very kind to take your time to help. Thanks again for all the time and effort you gave me. John thanks for your formula it worked perfect and your explanation was great it helped a bunch. SOOOOOOOOOOO thanks again
Lauren <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•