This Excel spreadsheet downloads historical prices for Brent crude oil from a web service. Employing the same techniques as the other spreadsheets for importing forex rates or stock quotes, all the work is automated through VBA; you don’t need to manually import text files..
You simply specify two dates (in month/day/year format) and click a button.
A VBA subroutine will then connect to a web service and download daily open and close prices, as well as daily highs and lows. The downloaded numerical data is kept in a separate sheet.
Additionally, the spreadsheet will plot the daily prices, and the daily percentage change in prices.
Many investments and ETFs provide exposure to Brent crude oil prices (either through oil futures or direct investment). This spreadsheet is a great starting point for analyzing historical trends, calculating the rolling price volatility and more.