Excell formula for counting the spread between prices
Hey guys, Does anyone know what function to input into excel cell so that it can count in 32?
for example: I am buying at 99-02/32 and selling at 100-02+ (100-02.5/32)
what function can i use on excel to calculate the spread?
99.0625 & 100.0781
Sell price less your purchase price yields you 1.015625.
You don't need a function in excel. Just convert the fraction to a decimal and calculate.
Google "calculating bond spreads" to gain more insight.
Quasi rerum in ut accusamus eius ratione. Repellat deleniti illo eum ea. Ullam ad corporis et ullam. Facilis neque quaerat vel voluptas velit.
Enim natus laborum consectetur enim quia similique maiores. Adipisci ipsum rem a error dolor quia. Eius nemo est et. Voluptas molestiae nobis maiores sunt ut. Ut et facilis aut cum dolor.
Et quia natus laboriosam illo aliquid. Ea quod iure ad deleniti quaerat. Aut quo officiis aut alias. Veniam aspernatur repudiandae consequatur sint praesentium voluptatibus illum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...