Results 1 to 8 of 8

Thread: Generating stock price change (daily and weekly)

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker jaadu's Avatar
    Join Date
    Nov 2011
    Posts
    13
    Articles
    0
    Excel Version
    Excel 2010

    Generating stock price change (daily and weekly)

    Hi - I am stuck in a little problem with excel and am hoping someone can help guide me in the right direction to generate the correct stock price change (daily and weekly).

    In the attached spreadsheet, I am experiencing problems in generating the correct stock price change (daily and weekly) by changing the date in cell A1 in the "AAA overview" worksheet.

    Listed below are some things to help you understand the attached spreadsheet.

    1. There are only 2 worksheets in the excel file:
    a. AAA overview -- this is where all the calculations occur
    b. AAA historical data -- this is where I am storing all the historical stock information


    2. If I change the date in cell A1 in the "AAA overview" spreadsheet, the daily and weekly information should generate accordingly, cell C9 and cell C10 respectively.

    3. Formula in C9 (indicates daily stock price change) works when the date in cell A1 is between Tues - Fri, and fails between Sat - Mon. This formula has an insane IF statement, and is needed, as I have to meet 2 criteria before calculating the correct daily price change (Ex - Monday the stock market is open, but Friday and Thursday it was closed due to holiday. So the daily change should be from Wednesday to Monday)

    4. Formula in C10 (indicates weekly stock price change) works when the date in cell A1 is between Mon - Fri, and fails between Sat-Sun. Also, I do not have an IF statement in cell C10, but now that I am thinking about it, I guess it should, considering if the markets were closed the prior weeks Thursday and Friday, then the current weeks change should be based from the prior weeks Wednesday to this weeks Friday.

    I believe I said that correctly.

    Well, if someone could shed some light, I would appreciate it.

    Thanks and if you have any questions, or think I should use another excel function/formula, please feel free to mention it. Also, if you can make the change in my spreadsheet and repost, I will see what you are referring to.

    Attached Files Attached Files

Posting Permissions

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