14

# Brent Oil Price History in Excel

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.

Filed in: Portfolio Analysis

### 14 Responses to "Brent Oil Price History in Excel"

1. Philippe says:

Hello Invest Excel,

Best Regards¨
Philippe

2. Al says:

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?

• Samir says:

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)

3. Jaco Visser says:

What are the limits on using the web service?

• Samir says:

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.

4. Ting says:

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.

5. Andy says:

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?

• Samir Khan says:

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

6. Hridayesh Dua says:

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,

7. Enrique says:

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

• Samir Khan says:

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)

• Enrique says:

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

8. Alex says:

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!

Alex B

9. Michaelfap says:

azwdndeg owsyciab[url=http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_599.html]バーバリー 札幌[/url]
[url=http://mercom21.brinkster.net/js/burberry/burberry_japan_bag_5572.html]バーバリー コート 定価[/url]
[url=http://jmgomezdelara.brinkster.net/js/burberry/burberry_japan_bag_2031.html]バーバリー シャツ メンズ 中古[/url]
[url=http://hawkinshomes.brinkster.net/js/burberry/burberry_japan_bag_2818.html]バーバリー ブルーレーベル オンラインショップ[/url]
[url=http://jmgomezdelara.brinkster.net/js/burberry/burberry_japan_bag_5603.html]バーバリー 洋服 メンズ[/url]
[url=http://jhowell2006.brinkster.net/js/burberry/burberry_japan_bag_2150.html]???????? ????????????????? ???n[/url]
http://jhowell2006.brinkster.net/js/burberry/burberry_japan_bag_7.html
[url=http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_993.html]???????? ????? ??????[/url]
http://jmgomezdelara.brinkster.net/js/burberry/burberry_japan_bag_4766.html
http://jhowell2006.brinkster.net/js/burberry/burberry_japan_bag_2837.html
[url=http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_1008.html]バーバリー コート 女性[/url]
[url=http://hawkinshomes.brinkster.net/js/burberry/burberry_japan_bag_5164.html]バーバリー 指輪 修理[/url]
[url=http://mercom21.brinkster.net/js/burberry/burberry_japan_bag_1016.html]???????? ?????? ????[/url]
http://jhowell2006.brinkster.net/js/burberry/burberry_japan_bag_5185.html
[url=http://hawkinshomes.brinkster.net/js/burberry/burberry_japan_bag_1833.html]バーバリー 日傘 メンズ[/url]
http://mercom21.brinkster.net/js/burberry/burberry_japan_bag_755.html
[url=http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_5612.html]???????? ????[/url]
[url=http://jhowell2006.brinkster.net/js/burberry/burberry_japan_bag_3335.html]???????? ?r?? ??[/url]
[url=http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_1318.html]バーバリー ハンカチ 池袋[/url]
http://horleyhc.brinkster.net/js/burberry/burberry_japan_bag_3038.html
ldrtbscp hfjefpqe ynnezvvu wlbmpuhw mihdhowd