<p>VWAP isn't calculated at a specific point in time, it is calculated over a period of time (commonly 24 hours or 30 days). A "24-hour VWAP at 1/1/2013 00:00:00" is actually the VWAP over the period from 12/31/2013 00:00:00 to 1/1/2013 00:00:00.</p>

<p>To calculate it, you'd want to use the exchange's API to get a list of the trades that were executed on the exchange during this period, where for each trade you have the execution price and the amount of BTC traded.</p>

<p>You then find the average of the price, weighted by volume; that it, you multiply each price with the corresponding amount, sum all these values, and divide it by the sum of all amounts traded.</p>

<p>Other sources can provide you with the needed data using their API, such as <a href="http://bitcoincharts.com/" rel="nofollow">http://bitcoincharts.com/</a>.</p>

<p>Bitcoincharts also offers this information via its web interface. For Bitstamp data, for example, go to <a href="http://bitcoincharts.com/charts/bitstampUSD" rel="nofollow">http://bitcoincharts.com/charts/bitstampUSD</a>, and click on "Load raw data" below the graph. You will get a table with each interval (day by default) and its "Weighted Price" in the last column. If the default chart does not contain the date you are interest in, you can change the date range with the "Time Period" control at the top.</p>

CC BY-SA 3.0
2013-08-30T06:55:28.487Z
Thanks, I am aware that a VWAP is defined over a period. Is there a page on bitcoincharts where I can choose a date and easily find that exact VWAP for that date?
ripper234
CC BY-SA 3.0
2013-08-30T10:34:22.047Z
@ripper234: ETA. If that's what you wanted all along, you should have said "find" rather than "calculate".
Meni Rosenfeld
CC BY-SA 3.0
2013-08-30T18:30:43.587Z
What do you mean by "ETA"? You're correct, I'll edit my question.
ripper234
CC BY-SA 3.0
2013-08-31T18:51:48.890Z
@ripper234: ETA = Edited to add, it means I edited my answer to address your clarified question.
Meni Rosenfeld
CC BY-SA 3.0
2013-08-28T19:47:19.690Z
2013-08-30T10:33:36.030Z
2013-08-30T10:33:36.030Z
Meni Rosenfeld
<p>Suppose I want to find the <a href="https://en.wikipedia.org/wiki/Volume-weighted_average_price" rel="nofollow">VWAP</a> of BTC-USD in a specific exchange (e.g. Bitstamp) at a specific point in time (e.g. 1/1/2013 00:00:00).</p>

<p>What's an easy way to do this?</p>

<exchange-rate>
How do you find historic VWAP at a given time in a specific exchange?
ripper234
# How do you find historic VWAP at a given time in a specific exchange?

(Asked by: username_0 on 2013-08-28)

Suppose I want to find the [VWAP](https://en.wikipedia.org/wiki/Volume-weighted_average_price) of BTC-USD in a specific exchange (e.g. Bitstamp) at a specific point in time (e.g. 1/1/2013 00:00:00).

What's an easy way to do this?

**Tags:** exchange-rate


---

## 1 answers

### Answer by username_1 on 2013-08-28. Score: 2 | Accepted answer

VWAP isn't calculated at a specific point in time, it is calculated over a period of time (commonly 24 hours or 30 days). A "24-hour VWAP at 1/1/2013 00:00:00" is actually the VWAP over the period from 12/31/2013 00:00:00 to 1/1/2013 00:00:00.

To calculate it, you'd want to use the exchange's API to get a list of the trades that were executed on the exchange during this period, where for each trade you have the execution price and the amount of BTC traded.

You then find the average of the price, weighted by volume; that it, you multiply each price with the corresponding amount, sum all these values, and divide it by the sum of all amounts traded.

Other sources can provide you with the needed data using their API, such as <http://bitcoincharts.com/>.

Bitcoincharts also offers this information via its web interface. For Bitstamp data, for example, go to <http://bitcoincharts.com/charts/bitstampUSD>, and click on "Load raw data" below the graph. You will get a table with each interval (day by default) and its "Weighted Price" in the last column. If the default chart does not contain the date you are interest in, you can change the date range with the "Time Period" control at the top.

> **Comments:**
> **username_0**: Thanks, I am aware that a VWAP is defined over a period. Is there a page on bitcoincharts where I can choose a date and easily find that exact VWAP for that date?  
> **username_1**: @username_0: ETA. If that's what you wanted all along, you should have said "find" rather than "calculate".  
> **username_0**: What do you mean by "ETA"? You're correct, I'll edit my question.  
> **username_1**: @username_0: ETA = Edited to add, it means I edited my answer to address your clarified question.  

---

