<p>You cannot obtain that information with the data provided.</p>
<p>You would need periodic samples throughout the day.</p>

CC BY-SA 4.0
2020-10-30T06:13:21.733Z
Well, I don't have that data. Then what am I calculating with my algorithms?
Jelani
CC BY-SA 4.0
2020-10-30T06:10:46.743Z
2020-10-30T06:10:46.743Z
RegressForward
<p>I would use A = (low + high)/2. I am not aware of this being a common technical indicator.</p>
<p>In regard to common practices &quot;VWAP&quot; refers to any algorithm that calculates a volume weighted average price. I have seen a few references that define simple VWAP = volume x (low + high + close)/3.</p>
<p><a href="https://www.investopedia.com/ask/answers/031115/what-common-strategy-traders-implement-when-using-volume-weighted-average-price-vwap.asp" rel="nofollow noreferrer">https://www.investopedia.com/ask/answers/031115/what-common-strategy-traders-implement-when-using-volume-weighted-average-price-vwap.asp</a></p>
<p>This simple algorithm is used for a period which aggregates tick data.</p>
<p>If all tick data is available for a period then VWAP would not be estimated from low, high, and close data, it would be calculated directly from the actual trade price and volume for each trade.</p>
<p>One application of VWAP is to buy or sell a large stock position over time. Instead of trying to buy or sell large blocks of shares all at once, the large order is broken into smaller trades that execute close to the VWAP. The theory is that this will produce the best execution.</p>

CC BY-SA 4.0
2020-10-30T14:11:58.637Z
2020-10-30T14:11:58.637Z
SystemTheory
<p>You can't calculate an actual average from that data. An average is the sum of all values divided by the count of values. If you are just making a trend-line or time series, just use Open or Close.</p>

CC BY-SA 4.0
2020-11-04T00:43:15.030Z
2020-11-04T00:43:15.030Z
Mox
<blockquote>
<p>Open,High,Low,Close</p>
</blockquote>
<p>I have these fields, representing the &quot;opening&quot; amount, the highest for the day, the lowest for the day, and what it closed at.</p>
<p>I'm trying to determine the &quot;average&quot; price for the day.</p>
<p>I currently do this:</p>
<pre><code>(Open + High + Low + Close) / 4
</code></pre>
<p>Is this correct? I get slightly different numbers if I do:</p>
<pre><code>(High + Low) / 2
</code></pre>
<p>Which one is correct? Or, most common/used?</p>

CC BY-SA 4.0
2020-10-30T07:50:55.320Z
In an ideal scenario, I think you need transaction data with volume and price for each transaction. Then you can calculate weighted mean.
Dayne
CC BY-SA 4.0
2020-10-30T12:10:12.787Z
Since many sources only give close data, fairly typical to use the close. Argument is that almost all the information released on a day has settled by then. The open/hi/lo information is used for candlestick charts.
Brian Romanchuk
<statistics><financial-markets><trading>
What is the correct way of calculating the "average" price based on the "Open,High,Low,Close" daily trade fields?
Jelani
# What is the correct way of calculating the "average" price based on the "Open,High,Low,Close" daily trade fields?

(Asked by: username_0 on 2020-10-30)

Open,High,Low,Close

I have these fields, representing the "opening" amount, the highest for the day, the lowest for the day, and what it closed at.
I'm trying to determine the "average" price for the day.
I currently do this:
(Open + High + Low + Close) / 4

Is this correct? I get slightly different numbers if I do:
(High + Low) / 2

Which one is correct? Or, most common/used?

**Tags:** statistics, financial-markets, trading
> **Comments:**
> **username_1**: In an ideal scenario, I think you need transaction data with volume and price for each transaction. Then you can calculate weighted mean.  
> **username_2**: Since many sources only give close data, fairly typical to use the close. Argument is that almost all the information released on a day has settled by then. The open/hi/lo information is used for candlestick charts.  

---

## 3 answers

### Answer by username_3 on 2020-10-30. Score: 3

You cannot obtain that information with the data provided.

You would need periodic samples throughout the day.

> **Comments:**
> **username_0**: Well, I don't have that data. Then what am I calculating with my algorithms?  

---

### Answer by username_4 on 2020-10-30. Score: 1

I would use A = (low + high)/2. I am not aware of this being a common technical indicator.

In regard to common practices "VWAP" refers to any algorithm that calculates a volume weighted average price. I have seen a few references that define simple VWAP = volume x (low + high + close)/3.

<https://www.investopedia.com/ask/answers/031115/what-common-strategy-traders-implement-when-using-volume-weighted-average-price-vwap.asp>

This simple algorithm is used for a period which aggregates tick data.

If all tick data is available for a period then VWAP would not be estimated from low, high, and close data, it would be calculated directly from the actual trade price and volume for each trade.

One application of VWAP is to buy or sell a large stock position over time. Instead of trying to buy or sell large blocks of shares all at once, the large order is broken into smaller trades that execute close to the VWAP. The theory is that this will produce the best execution.


---

### Answer by username_5 on 2020-11-04. Score: 0

You can't calculate an actual average from that data. An average is the sum of all values divided by the count of values. If you are just making a trend-line or time series, just use Open or Close.


---

