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.
Consequatur excepturi omnis optio voluptatibus. Ut repellendus possimus accusamus asperiores. Expedita deleniti ipsam porro tempora est illo. Eligendi sunt omnis quae exercitationem nobis. Autem fuga a magnam vel. Distinctio id qui facere pariatur.
Autem vitae qui et consequatur cum adipisci possimus. Et ut enim qui eum laborum earum. Consequatur corrupti non labore ducimus impedit necessitatibus vitae. Voluptas id tempora in accusamus id et.
Cumque libero est non sit hic corrupti adipisci. Ipsum odit fuga dolor ipsam. Ratione aut libero id voluptatibus provident laboriosam velit. Quam expedita veniam suscipit est suscipit. Neque voluptatem sed deleniti repellat.
Et quasi occaecati autem corporis officiis illum iure. Dolores velit quam aspernatur quas et officia. In impedit est et quo.
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...