Wait until tomorrow.
Over $70k?
Is it tomorrow yet?
Seriously, I have no idea.
Are we talking ZTC, BTC, UTC...
It is tomorrow as soon as the candle closes.. so yeah, these days we are using midnight UTC as our day differentiator - which I think has become somewhat standard with the closing of a lot of the daily candles.
I had too much fun to not post this pittance of data. I didn't realize how big of an impact only getting 365 days of free "Data provided by CoinGecko" (they asked me to say that) would impact. But I guess we have a growing list, and I'm investigating other api sources. This is a 9 hours late update feature, for now.
Wow!!! Great work sleuthing the interwebs in order to spot some kind of data that works to give us some other currencies in there.
Rank CoinGecko/Yahoo EUR/BTC
1 2024-03-05 62750
2 2024-03-10 62606
3 2024-03-09 62437
4 2024-03-08 61139
5 2024-03-07 60682
6 2024-03-06 59251
7 2021-11-08 58274
8 2024-03-04 58153
9 2021-11-09 57771
10 2024-02-29 57734
11 2024-03-01 56757
12 2021-11-10 56574
13 2021-10-20 56560
* * Chart Explanation * *
Do these numbers look correct?
Sure it appears that the numbers do not exactly match up because the
latest was Kraken rather than Coingecko/Yahoo.. but that is o.k. if they don't match exactly, they still give something to compare rather than having nothing... Of course, if there is more than one choice in any currency pair, then there may need to be some thinking about which exchange or reporting entity might be best out of the available options.
Edit - after reading your further below descriptions of the data: on the other hand if the prices are not based on daily trade-weighted volume for any of the historical (or the current) data then that should be clearly pointed out.
In a canonical post from dooglus "
So the volume weighted average is (total USD volume of all trades) / (total BTC volume of all trades)
"
did they mean total BTC volume of all trades in USD?
I am pretty sure that it means what it says since if you take the total dollar value and you divide by the total number of BTC traded, then the results ends up being a dollar value.
I used the basically the following:
daily_volumes_eur = from CoinGecko all exchanges
daily_volumes_btc = from CoinGecko all exchanges in Euro?or all BTC transacted in any curreny. I think the former, becuase the numbers work out... i think.
vwap_eur = [daily_volumes_eur / daily_volumes_btc]
That's correct.
Let me know if you have any good APIs for historical data. I'm looking at Coinbase api, and data.bitcoinity has downloadable csv data I think.
If you are referring to the Euro and you able to show some results that fills in the full 100 slots for the Euro or any other currency, then I am not sure if there would be much of a significant difference between Coinbase and Bitcoinity.. or course on bitcoinity, you should be able to choose which exchange within those results.. so that could be better.. but I am not really sure off the top of my head without potentially comparing results.. or maybe how easy it might be for you to extract from whatever data set that you would end up drawing upon..
EDIT: Phrasing. Think like a proton. Always positive.
The 2021 EUR prices are the closing prices on those days according to the clickable Yahoo link, which I know is not the volume weighted average price, but close to it for now. For sure though, I think the left justified rank works much better.
Despite your positive thinking, I am not sure whether it would be helpful to mix and match data that is not volume weighted with data that is volume weighted, unless you clearly make a note that it is the best data for the day, or maybe you take the opening price and the closing price and then you average them (or probably better yet to take the highest price for the day and the lowest price for the day and average them), yet none of those results are going to bring you even close to the accuracy of the daily weighted volume price... .. In the end, you are at least making it clear how the numbers are derived, then we could at least have a way to give some weight to the comparative value of the numbers that end up in the tables.
