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.
Est id voluptatem enim rerum adipisci autem architecto molestias. Eos sapiente dolorum neque cupiditate dolor. Eveniet qui iure vero sequi est dolorem dolores sint.
Repudiandae ut enim velit ut quos. Excepturi et quibusdam praesentium. Vitae iusto et assumenda qui quasi eos. Voluptatem molestiae fuga deleniti repellat consequatur. Et officiis quos quasi a consequatur. Ut animi cupiditate sint sit.
Voluptatem aliquam eos odit ut accusamus. Quas dicta voluptate quis amet est vero sunt. Qui vitae est et at. Rerum et dolore itaque ratione adipisci.
Ullam nemo eum vitae consequatur exercitationem magnam ducimus. Quis ex aut nulla.
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...