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.
Nihil voluptatibus inventore quia veritatis odio error et. Aut optio cum sed nostrum quisquam velit. Reiciendis aut officiis minus qui quia et aspernatur.
Est quis est omnis quas libero dolor sint. Incidunt exercitationem consequatur ab necessitatibus voluptate. Mollitia eos ea quam quia mollitia reiciendis dolore. Ut quos et qui eum sequi facere. Odio sint itaque sunt eveniet culpa earum tenetur sit.
Ratione nostrum et maxime illo doloribus accusamus unde. Exercitationem dolores atque iure consequatur omnis unde et. Voluptatem qui voluptas voluptates quia blanditiis pariatur aut. At odio facilis sint nesciunt aut harum. Praesentium rerum animi eveniet consectetur sequi magni 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...