Results 1 to 7 of 7

Thread: stocks (2000)

  1. #1
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    stocks (2000)

    Hi, may name is Lauren Knobbe. I

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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?

  3. #3
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: stocks (2000)

    Hans, thank for your reply. I guess what I

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    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. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    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>
    -John ... I float in liquid gardens
    UTC -7ąDS

  7. #7
    New Lounger
    Join Date
    May 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •