J
Jan Jansens
Hi, i've got a spreadsheet with a function i would like to duplicate:
There are 2 cells, one with the Yield of a security (in this case
bond) and another cell with the price of the security (the same bond)
Lets say A1 holds the price and cell A2 holds the yield. Now Exce
functions Price() and Yield() use more or less the same arguments an
let you calculate the Price of a bond, based on a certain yield OR le
you calculate the yield of a bond, based on a certain price. So it's
bit like the chicken and the egg...you need a price to calculate yiel
or you need a yield to calculate a price.
In this spreadsheet i'm having they allow you to type in the Price of
security in cell A1, which will give you a yield in cell a2. The nic
thing however is the following: if you type a yield in cell a2 it wil
give you the price in cell a1. So based upon your input Excel looks a
the cell where you have input the value and puts a function in th
other cell....it calculates the result and puts the original functio
back into the cell where you have just typed a value, allowing you t
do further calculations with that function....So even when you type
value in a cell, somehow excel still knows what functions should behin
it once it has done it's calculations......Maybe i'm not explaining thi
very well but if someone has any idea how you can do this i would lov
to hear from you ! Thanks in advance!!!
There are 2 cells, one with the Yield of a security (in this case
bond) and another cell with the price of the security (the same bond)
Lets say A1 holds the price and cell A2 holds the yield. Now Exce
functions Price() and Yield() use more or less the same arguments an
let you calculate the Price of a bond, based on a certain yield OR le
you calculate the yield of a bond, based on a certain price. So it's
bit like the chicken and the egg...you need a price to calculate yiel
or you need a yield to calculate a price.
In this spreadsheet i'm having they allow you to type in the Price of
security in cell A1, which will give you a yield in cell a2. The nic
thing however is the following: if you type a yield in cell a2 it wil
give you the price in cell a1. So based upon your input Excel looks a
the cell where you have input the value and puts a function in th
other cell....it calculates the result and puts the original functio
back into the cell where you have just typed a value, allowing you t
do further calculations with that function....So even when you type
value in a cell, somehow excel still knows what functions should behin
it once it has done it's calculations......Maybe i'm not explaining thi
very well but if someone has any idea how you can do this i would lov
to hear from you ! Thanks in advance!!!