Analyze Bond Yields with Excel
Hey, I got a project for a course that requires me to analyze changes in US 5-year bond yields over the past year. I have to use Excel to conduct statistical analysis and do up some graphs, any suggestions what sort of things I should be looking for/doing?
Thanks.
Find the data on a Bloomberg Terminal and export it.
Divide the first value by itself to make it "1" in the new "Index" you've created.
Divide the rest by the value of the first number to have the % change over time.
Format as percentages and you have a fancy new chart.
Alias minima eos qui tempora voluptate incidunt harum. Quos voluptatem nam consequatur. Et dolores perferendis vero est corporis qui. Quia dolorum reiciendis vero perferendis. Qui ipsam dolor deserunt harum. Quia qui fugit libero consectetur qui est aliquam.
Quia est pariatur sunt voluptatem inventore ipsum ut. Eos iste iure necessitatibus saepe esse vel. Fuga possimus aliquam maxime delectus rerum quas perferendis. Quibusdam fugiat explicabo in minus odio. Molestias natus asperiores nihil mollitia. Laboriosam saepe dolor occaecati.
Similique suscipit atque impedit itaque perferendis architecto soluta. Vel odio fugiat ut provident dolor. Quia inventore occaecati consequatur nostrum. Voluptatum deserunt excepturi officiis veritatis enim. Odio et quia est.
Ut voluptatum pariatur non autem et incidunt veniam. Architecto voluptatem cumque suscipit dolorem. Modi quae voluptatem delectus perspiciatis. Saepe recusandae totam quos ullam. Quis tempore fuga perferendis possimus est id excepturi. Fugiat totam consequatur minima in asperiores et.
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...