A look at Q4 crude price data (1)13 Nov 2017 20:25
Looking at crude price data for Q4 so far:
Date Price Open High Low Vol. Change %
Nov 13, 2017 63.13 63.65 63.7 62.62 0 -0.61
Nov 10, 2017 63.52 63.8 64.27 63.35 307.97K -0.64
Nov 09, 2017 63.93 63.52 64.25 63.26 319.86K 0.69
Nov 08, 2017 63.49 63.69 64.64 62.95 418.07K -0.31
Nov 07, 2017 63.69 64.12 64.65 63.5 389.46K -0.9
Nov 06, 2017 64.27 62.27 64.44 62.08 356.99K 3.54
Nov 03, 2017 62.07 60.88 62.23 60.6 272.74K 2.39
Nov 02, 2017 60.62 60.5 60.86 60.02 289.30K 0.21
Nov 01, 2017 60.49 61.07 61.7 60 337.76K -1.43
Oct 31, 2017 61.37 60.86 61.41 60.53 29.12K 0.77
Oct 30, 2017 60.9 60.66 61 60.14 168.54K 0.76
Oct 27, 2017 60.44 59.37 60.65 58.82 209.89K 1.92
Oct 26, 2017 59.3 58.42 59.55 58.05 232.28K 1.47
Oct 25, 2017 58.44 58.44 58.74 57.85 260.55K 0.19
Oct 24, 2017 58.33 57.41 58.57 57.04 334.68K 1.67
Oct 23, 2017 57.37 57.95 58.05 57.27 353.07K -0.66
Oct 20, 2017 57.75 57.32 57.94 56.6 369.89K 0.91
Oct 19, 2017 57.23 58.24 58.3 57.02 430.67K -1.58
Oct 18, 2017 58.15 58.16 58.54 57.74 329.33K 0.47
Oct 17, 2017 57.88 57.78 58.35 57.18 405.22K 0.1
Oct 16, 2017 57.82 57.28 58.47 57.12 341.78K 1.14
Oct 13, 2017 57.17 56.44 57.57 56.34 332.60K 1.64
Oct 12, 2017 56.25 56.74 56.83 55.88 339.53K -1.21
Oct 11, 2017 56.94 56.56 57.09 56.14 310.14K 0.58
Oct 10, 2017 56.61 55.78 56.91 55.73 290.34K 1.47
Oct 09, 2017 55.79 55.5 55.98 55.06 301.15K 0.31
Oct 06, 2017 55.62 56.99 57.28 55.13 395.65K -2.42
Oct 05, 2017 57 55.77 57.24 55.7 379.30K 2.15
Oct 04, 2017 55.8 55.67 56.2 55.38 330.85K -0.36
Oct 03, 2017 56 56.1 56.4 55.7 275.42K -0.21
Oct 02, 2017 56.12 56.73 56.76 55.5 352.05K -2.47
Highest:64.65 Lowest:55.06 Difference:9.59 Average:59.14 Change %:9.71
This data set tells us that thus far in Q4, Brent is averaging $59.14 and has been consistently averaging higher day-on-day since Oct 26th, so this average is trending higher right now. This compares to the Q3 results that were predicated on Brent at an average price of $52.
If you were to assume that Brent traded no higher and no lower than the current weekly average of $63.55 from today until Q4 ends on 31/12/2017, the average price of Brent will be around $61.48 compared to Q3's $52 - 18% higher.
Therefore you can either project what you think Brent will trade at - whether higher or lower than the current $63.44 from today until Q4 and determine what your projected Q4 average price for Brent will be.
I honestly cannot predict whether Brent prices will go up or down from here on any more than a toss of a sixpence.
So I can't predict whether prices will trend higher, lower or stay roughly as is - and I don't need to. I will just watch the data accumulate day by day until we near the end of the year and then, there you have it. A full data set will be available a whole 5 weeks before Q4 and finals are reported so that you can feed into your mathematical models for this stock.
.....