Create excel file with formula when calculating returns
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →
Go to Yahoo (or an alternative site) and download 5 years of historical monthly prices for two assets:
1) Stock Name – Union Pacific Corporation
NYSE – UNP
2) The S&P 500 (^GSPC)
These will need to be converted to annual rates of returns.
Go to FRED and download the series for 3-month Treasury securities (monthly average)
https://fred.stlouisfed.org/series/DTB3#0
Calculated the Sharpe ratio for UNP
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds