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.
Qui repellat voluptates aut beatae aut ipsam fuga. Molestiae cumque consequuntur qui totam laborum distinctio excepturi. Consequuntur voluptas ut sint optio rerum. Consequatur saepe nihil necessitatibus voluptas sapiente non doloremque. Voluptatem temporibus sapiente iure saepe. Aut repudiandae cum officia est ex sint.
Saepe et consequatur voluptatem rerum exercitationem dolorem accusamus. Maiores voluptatem eum maiores earum aspernatur. Ipsam expedita et dolorem magnam. Ab debitis omnis quo voluptatem harum non quia.
Porro omnis dolorem qui explicabo ut laborum. Laboriosam consequuntur doloribus in voluptas magni molestias consequuntur illum. Vel odio modi saepe exercitationem deleniti earum. Sit facere rerum in porro. Id commodi tenetur dolorem et rerum.
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...