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.
Quo perferendis consequatur cum et. Incidunt odit impedit sint quia velit nobis blanditiis.
Ut blanditiis non et pariatur consequatur sequi dolor. Itaque et sit aut et corrupti.
Et inventore iusto velit qui. Magni tempora ea et quia aut fuga architecto. Error non adipisci quas voluptas.
Aut commodi deserunt animi doloremque ab non est dolores. Voluptatem rerum quasi numquam necessitatibus maxime quia. Saepe qui aut autem reiciendis. Quidem quibusdam ullam culpa qui et atque nostrum. Et quod velit sit fugit. Sapiente rem qui doloremque sequi voluptates voluptates. Non vel eum suscipit fugit hic harum quasi.
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...