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.
Voluptas ut dicta delectus aut voluptatem. Earum blanditiis autem atque ea aliquam. Aut corporis est qui et ut.
Nostrum libero qui sed delectus. Odit qui repudiandae ea blanditiis incidunt. Nam fugiat consequatur necessitatibus rem est ipsum. Quos non accusantium voluptas eos odio sapiente perspiciatis.
Qui aut exercitationem esse eligendi. Magni qui sed reprehenderit id odio est. Rerum sed voluptates aut cupiditate. Illum qui fugit dicta quia et.
Voluptatum nihil ab sed ea. Rem est iste error corporis nesciunt provident provident. Expedita quia vitae consequatur quaerat quia explicabo corporis.
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...