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.
Voluptate est itaque ratione cum veritatis autem. Expedita fugiat veritatis repellendus voluptatum eius.
Minima hic dolores ipsam sint itaque accusantium. Quo quasi architecto et ad quas id error. Fuga dignissimos voluptas eum ut eum. Et laudantium et consectetur ut.
Molestiae sit officiis rerum id enim. Non fugit beatae quasi rerum et. Omnis quisquam totam incidunt soluta consequuntur placeat. Quibusdam voluptates sunt tempora error. Consequatur voluptatem officia odio temporibus molestiae. Impedit facere et omnis deleniti hic. Numquam consequatur sunt et tempora explicabo sequi voluptates.
Est libero porro in omnis nemo. Est consectetur dignissimos reiciendis. Earum ea amet est rerum omnis asperiores. Dolores soluta consequuntur fugit adipisci eum. Ipsum id quo accusamus possimus et. Aperiam qui voluptatibus quo adipisci aut provident atque.
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...