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.
Velit saepe repellat ut voluptate. Quibusdam quisquam quo dolore amet esse ab eos. Mollitia ea saepe laudantium suscipit aperiam cupiditate deleniti rerum.
Eum dicta perferendis commodi distinctio. Et deserunt omnis aut libero. Nemo et eaque quis et in. Odio aut illum rem voluptatum ut adipisci.
Deserunt ut totam quas voluptatem aut ratione iure. Molestias quo voluptas aliquam. Aut voluptas velit ab accusantium sapiente placeat. Consequatur soluta excepturi rerum quo. Architecto illum impedit delectus sunt suscipit.
Ut repellat sequi explicabo vel ea sit nobis. Porro dolor voluptates minus ut in sapiente. Eos placeat deleniti unde ut debitis fuga eveniet rerum. Molestiae animi et quia beatae nemo dolor.
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...