LinkBack URL
About LinkBacks
Niek 
Niek,
I generally get the idea and I think it can be done, but please upload as Sample dummy with about 100 rows (both sheets)
We'll make it work for D(-5), D(+5), but this range is adjusted easily later on.
Niek,
I generally get the idea and I think it can be done, but please upload as Sample dummy with about 100 rows (both sheets)
We'll make it work for D(-5), D(+5), but this range is adjusted easily later on.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Hello rwgrietveld,
I had to make some minor adjustments. Since one firm can be involved in multiple deals, we can not work with the firm's names, so I created a unique code to work with. I also included the event date in the same sheet that holds the stock prices. So I've created a small sample file (see attachment) with one sheet that includes the info I have and a second sheet which gives an idea of what I'm trying to get.
Grtz,
Niek
FYI: the event dates in the sample are not the right ones, since I had to adjust them so they would fall in the range of dates included in the sample file.
Put this in Sheet2 B4 and drag right, down
maybe a little explination is requiredHTML Code:
The INT(column/2) is because you go from one columns spread into two columns
The 1+(COLUMN()-1)*0.5*SIN(0.5*PI()*COLUMN())^2) is just and alternating sequence 1,2,1,3,1,4,1,5,1,6, etc. as you need to keep looking in Column A for the date and the stock prices in 2,3,4,5, etc.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks