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.
Download Excel Spreadsheet to Automatically Import Brent Oil Price Data
Hello Invest Excel,
First,thanks for your great website.
Would you mind to share with me your password to get access to VBA code of “Brent Oil Price History” file?
Thanks in advance
Best Regards¨
Philippe
Hi – Thanks very much for your efforts in providing these spreadsheets. They form a wonderful basis for creating some new sheets. i would really appreciate the password. Also, would it be relatively easy to change Brent crude to WTIC (West Texas Intermediate crude) or even natural gas?
Thanks again for your efforts
If WTI historical price data is available as a free web service, then yes, this should be easy to do. Is this data available as a free web service anywhere? I had a brief look and I could only find paid options (unlike Brent price data)
What are the limits on using the web service?
There are no officially documented limits, in terms of volume of data or time. The data is grabbed from a 3rd party source, who could decide to switch off the tap at any time.
Thanks a lot for your good work. I started using Excel to back test some simple trading strategies, and found your website invaluable. Really appreciate it.
Thanks for this most helpful work! Since there are no limits in terms of volume of data or time. Is it possible to get more accurate data, say hourly or minutely?
The free webservice I use only has daily data. Unless you know of a free (and interrogable) source with hourly data, then no, you can’t get more accurate data
Thanks a lot for the wonderful work you have done in creating this easy to use excel file.
I have used it for getting some historical data for some business analysis work for the company (KUFPEC).
As part of requirement of management reporting I am supposed to inform the source as well.
Can you please let me know the source (the free web service your excel file uses to extract the data)?
Regards,
Thank you for a great spreadsheet. Do you mind sharing the password? I’d like to make a few modifications to include it in another spreadsheet I prepared.
Thank you
Sorry, I sell this VBA as a part of another product. If you want to buy this VBA, let me know (it’s just a few dollars)
Samir,
Apologies, didn’t know this was a commercial product. I’d be interested in purchasing your VBA. Only want to make sure the purchased version will allow me to examine and modify the code to fit my particular needs. I would only use it for my own personal investment analysis. Let me know and I’d be happy to do business. BTW, I’d also be interested in downloading WTI prices.
Best.
EMendez
Samir,
Firstly thank you very much for your efforts in creating these excel spreadsheets, very appreciated! However I have just downloaded the brent crude oil and WTI spreadsheets and having changed the dates and clicking on ‘get data’ I have received an error message. I was wondering whether you this is something you knew about or it could be something wrong with my computer settings?!
Also (if you don’t mind me asking!) which site do you get the data from for these two oil price sheets? I’m writing a research paper and I’m finding it incredibly hard to find the data I need!
Thanks in advance
Alex B
Dear Sir/Madam,
I am hoping if you could assist me in accessing the Brent crude price data commencing from 1st January 2012 to 31 August 2014.
Whats provided on the net is only data from 2nd Jan 2009 to 30th December 2011.
I am creating a price register for energy commodities and i request your kind assistance accessing the requested data.
Thank you,
Rex Duma
Port Moresby,
PAPUA NEW GUINEA
(+675) 3256333