| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Caculate yield over a period of time
I have range A2:B7 bonus shares history of a company.I am looking for a
function in E3 to get Number of shares I hold On Sale date(E2).My data is Col A -------------Col B ---------Col C ------Col D ----------Col E 1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date 2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 --- 25-Aug-2006 3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ? 4. 19-Jan-2006 ----- 1:1 5. 25-jan-2007 ------ 1:2 6. 7. D2=shares buy date,D3= number of shares bought.I am looking for a function in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI bought+bonus shares yield).answer is 240. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Caculate yield over a period of time
how about
=(D3*(1+B3))*(1+B4) and for the next period =((D3*(1+B3))*(1+B4))*(1+B5) note the extra brackets but you do need to change the ratio's into decimals b3 = 0.2 b4 =1 b5=0.5 -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... I have range A2:B7 bonus shares history of a company.I am looking for a function in E3 to get Number of shares I hold On Sale date(E2).My data is Col A -------------Col B ---------Col C ------Col D ----------Col E 1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date 2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 --- 25-Aug-2006 3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ? 4. 19-Jan-2006 ----- 1:1 5. 25-jan-2007 ------ 1:2 6. 7. D2=shares buy date,D3= number of shares bought.I am looking for a function in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI bought+bonus shares yield).answer is 240. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Caculate yield over a period of time
Mr.Bill, your formula is not right.You have given a constant formula to my
question.When I am changing sale date(25-Aug_2006) with other dates it is giving wrong results.The formula should autumatically calculate time period from Bonus table range A2:B7. "Bill Kuunders" wrote: how about =(D3*(1+B3))*(1+B4) and for the next period =((D3*(1+B3))*(1+B4))*(1+B5) note the extra brackets but you do need to change the ratio's into decimals b3 = 0.2 b4 =1 b5=0.5 -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... I have range A2:B7 bonus shares history of a company.I am looking for a function in E3 to get Number of shares I hold On Sale date(E2).My data is Col A -------------Col B ---------Col C ------Col D ----------Col E 1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date 2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 --- 25-Aug-2006 3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ? 4. 19-Jan-2006 ----- 1:1 5. 25-jan-2007 ------ 1:2 6. 7. D2=shares buy date,D3= number of shares bought.I am looking for a function in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI bought+bonus shares yield).answer is 240. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Caculate yield over a period of time
Please post the question again, perhaps with a couple of examples and
results. -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... Mr.Bill, your formula is not right.You have given a constant formula to my question.When I am changing sale date(25-Aug_2006) with other dates it is giving wrong results.The formula should autumatically calculate time period from Bonus table range A2:B7. "Bill Kuunders" wrote: how about =(D3*(1+B3))*(1+B4) and for the next period =((D3*(1+B3))*(1+B4))*(1+B5) note the extra brackets but you do need to change the ratio's into decimals b3 = 0.2 b4 =1 b5=0.5 -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... I have range A2:B7 bonus shares history of a company.I am looking for a function in E3 to get Number of shares I hold On Sale date(E2).My data is Col A -------------Col B ---------Col C ------Col D ----------Col E 1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date 2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 --- 25-Aug-2006 3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ? 4. 19-Jan-2006 ----- 1:1 5. 25-jan-2007 ------ 1:2 6. 7. D2=shares buy date,D3= number of shares bought.I am looking for a function in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI bought+bonus shares yield).answer is 240. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Caculate yield over a period of time
Please refer to my new post named "Bonus Yield calculation".Thanks.
"Bill Kuunders" wrote: Please post the question again, perhaps with a couple of examples and results. -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... Mr.Bill, your formula is not right.You have given a constant formula to my question.When I am changing sale date(25-Aug_2006) with other dates it is giving wrong results.The formula should autumatically calculate time period from Bonus table range A2:B7. "Bill Kuunders" wrote: how about =(D3*(1+B3))*(1+B4) and for the next period =((D3*(1+B3))*(1+B4))*(1+B5) note the extra brackets but you do need to change the ratio's into decimals b3 = 0.2 b4 =1 b5=0.5 -- Greetings from New Zealand "TUNGANA KURMA RAJU" wrote in message ... I have range A2:B7 bonus shares history of a company.I am looking for a function in E3 to get Number of shares I hold On Sale date(E2).My data is Col A -------------Col B ---------Col C ------Col D ----------Col E 1. Date -------------BonusRatio--- ------ ------Buy Date ----- Sale Date 2. 07-Jul-2004 ------ 1:1 ---- ------- -----10-Feb-2005 --- 25-Aug-2006 3. 03-Mar-2005 ----- 1:5 ---- -------- ---- 100 --- ? 4. 19-Jan-2006 ----- 1:1 5. 25-jan-2007 ------ 1:2 6. 7. D2=shares buy date,D3= number of shares bought.I am looking for a function in E3,how many shares I hold on sale date i.e on 25-aug-2006(sharesI bought+bonus shares yield).answer is 240. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Count function applied to a time period | Excel Worksheet Functions | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Worksheet Functions | |||
| Time calculation for a givenn period | Excel Discussion (Misc queries) | |||
Hybrid Mode
