Results 1 to 5 of 5

Look up dates in event study, +/- 10 days surrounding announcement

Threaded View

  1. #1
    Registered User
    Join Date
    03-03-2014
    Location
    Oslo
    MS-Off Ver
    Excel 2003
    Posts
    2

    Look up dates in event study, +/- 10 days surrounding announcement

    Hi,

    I have a dataset with stock prices from 2007-2010 and several event dates that occurs are random times within this dataset. Does anyone know how to make excel display the stock returns on e.g. 120 days prior to and 10 days after the event? (given the event date)
    I'm gonna do this for 100 events, so it would save me a lot of time to fix this with a formula!

    Attached are the doucment
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Event study
    By arjantrinks in forum Excel General
    Replies: 4
    Last Post: 05-22-2014, 02:22 AM
  2. VBA and Event Study
    By hassan88 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 12:45 PM
  3. Event study!!
    By roooreee in forum Excel General
    Replies: 3
    Last Post: 03-13-2013, 09:44 AM
  4. M&A Event Study
    By rthomson91 in forum Excel General
    Replies: 0
    Last Post: 03-11-2013, 05:13 PM
  5. Event study
    By Niek in forum Excel General
    Replies: 9
    Last Post: 12-26-2010, 05:22 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1