Oil price history and analysis updating

The nearest support is the major 50% level at .07.If this price fails then the market could retreat into a steep uptrending angle at .26. June West Texas Intermediate crude oil futures are trading flat shortly before the regular session opening. The main trend is down according to the daily swing chart.

oil price history and analysis updating-68

These plots automatically refresh when you update the prices The actual data is safely stored in another sheet called “Data”.

Just click the update button on the “Parameters” sheet to update the spreadsheet with the latest WTI prices.

The correlation between oil and share prices changes over time.

Historically, both have been negatively correlated. However, during the financial crisis of 2008-2010 and the associated macro-economic shocks, oil and share prices became positively correlated.

The data is sourced from the US Energy Information Authority (EIA), and can be used your for own analyses.

You also get a plot of the historical oil prices, and the monthly percentage change in prices.Benchmarks from Thomson Reuters include Brent (OILBRDT) and WTI (OILWTIN) crude oil.Global Financial Database (GFD) also have these benchmark oil prices.West Texas Intermediate (or WTI) is one of several grades used when determining oil prices. Analysts use historical oil prices for historical back-testing correlation analyses, momentum-based price indicators and more. Simply specify the start and end date on the “Parameters” sheet, and click the update button.Some VBA downloads the historical monthly data into the spreadsheet, from your start date to your end date.It is the third in a series on crude oil pricing issues.

Tags: , ,