Get average price of cryptocurrency for given timeframe

teosanru

hero member

Activity: 2114

Merit: 619

Quote from: GreatArkansas on February 13, 2022, 05:51:45 AM

I want to ask if is there any way platform where I can get the average price of a particular cryptocurrency or pair for a given time?

Let's say, for example, I want to check the average price of Bitcoin from January 1, 2022 - February 1, 2022?
And I will get the average price of that timeframe.

Thanks!

Well you should detail your requirement a bit more because the average could be the average of daily closing prices, while it can also be the average of daily prices at a certain time, or it can be average of hourly closing price, all these values could differ a lot from each other. You can easily get daily details from this link:
https://coinmarketcap.com/currencies/bitcoin/historical-data/

You can just copy-paste the same in excel to find the average of closing price to get the average closing price of this time range or any time range.

so98nn

hero member

Activity: 2114

Merit: 603

Quote from: crwth on February 14, 2022, 01:22:21 AM

Any idea on how you would use it? Would it be like a baseline towards what you could make a support/resistance on a specific timeframe? Or probably correlating it with data that could've caused a drastic change and made the significant market turn around or something like that?

Would it be something similar to that?

Even I’m confused why would anyone need that info. Moreover it’s simple to plot the graph against timeline to take an average estimate of the highest and lowest cost of the asset. Though it’s useless if you wanna buy based on the average price because cryptos are never stable on eccentricity prices. They are always fluctuating and I don’t think anyone need to understand this after all these years. Anyways interesting to see the new discussion as it also sparked me one thing, average price could be used to calculate nett income and gross income for thr given time point.

hugeblack

legendary

Activity: 2702

Merit: 4002

It is difficult to find such a tool for altcoins or altcoin pairs, so if you are looking for it using Bitcoin, you can find some, for example: https://tenyearsbitcoin.com/
So you should do it yourself through APIs and then compare the results, if you are interested why not create a topic in the project development board and I think you will get some help.
or you can try to link some APIs from well known exchanges here --> https://cointracking.info/

tbct_mt2

hero member

Activity: 2366

Merit: 838

Quote from: GreatArkansas on February 15, 2022, 09:55:26 PM

I will just use this to identify my profits on a staking/P2E platform which I am able to earn their utility token. I want to know the price for a given time so I can compute if I already earning profits after my starting capital funds.

Sad to know that most of these are via API and could need some codes to be able to achieve it. I was looking for some ready-to-use tool like I will just input some numbers.

You can download data from coinmarketcap or coingecko and make some codes to calculate average prices in your investing time. If it is not Bitcoin or old altcoins, it does not take too much time for you to download price data in historical data tabs.

I think you are aiming at new tokens which launched recent months, not too old altcoins because you are saying about Play to Earn platforms.

crwth

copper member

Activity: 2940

Merit: 1280

https://linktr.ee/crwthopia

Quote from: GreatArkansas on February 15, 2022, 09:55:26 PM

I will just use this to identify my profits on a staking/P2E platform which I am able to earn their utility token. I want to know the price for a given time so I can compute if I already earning profits after my starting capital funds.

I see. So you just want to see it in terms of ~paper profits~ or not the realized position right? Then maybe once you get the actual realization of the profits then you would really see the gains that you have made. I now get why you have to average it.

Why not manually get it but you just have to put in the time? Like get the opening and closing in a candle then depending on what time range you have, that's just the total amount of number as the divisor.

GreatArkansas

legendary

Activity: 2506

Merit: 1394

Thanks, everyone for the answers. I am more looking for a tool that is ready to use like I will just input numbers or particular altcoin.

Quote from: crwth on February 14, 2022, 01:22:21 AM

Any idea on how you would use it? Would it be like a baseline towards what you could make a support/resistance on a specific timeframe? Or probably correlating it with data that could've caused a drastic change and made the significant market turn around or something like that?

Would it be something similar to that?

I will just use this to identify my profits on a staking/P2E platform which I am able to earn their utility token. I want to know the price for a given time so I can compute if I already earning profits after my starting capital funds.

Sad to know that most of these are via API and could need some codes to be able to achieve it. I was looking for some ready-to-use tool like I will just input some numbers.

slaman29

legendary

Activity: 2674

Merit: 1226

Livecasino, 20% cashback, no fuss payouts.

Quote from: crwth on February 14, 2022, 01:22:21 AM

Any idea on how you would use it? Would it be like a baseline towards what you could make a support/resistance on a specific timeframe? Or probably correlating it with data that could've caused a drastic change and made the significant market turn around or something like that?

Would it be something similar to that?

Yeah I would think so. It could be something to be used by those who like to think there's a correlation between festive periods for the price of Bitcoin (for example people seem to think Christmas and Lunar New Year have a predictable effect). I think it's been proven wrong already, or at least relies also on which part of the cycle we're at.

Halving would be the most important, but maybe also tax period?

crwth

copper member

Activity: 2940

Merit: 1280

https://linktr.ee/crwthopia

Any idea on how you would use it? Would it be like a baseline towards what you could make a support/resistance on a specific timeframe? Or probably correlating it with data that could've caused a drastic change and made the significant market turn around or something like that?

Would it be something similar to that?

OmegaStarScream

staff

Activity: 3500

Merit: 6152

It looks like you have the necessary technical background, so you can use Coingecko's API as mentioned above. You don't have to send a request for each date though, This will give you the historical price data within a range of timestamp (UNIX):

Code:

https://api.coingecko.com/api/v3/coins/bitcoin/market_chart/range?vs_currency=usd&from=1643716339&to=1644753139

You then just sum everything and calculate the average yourself.

hatshepsut93

legendary

Activity: 3024

Merit: 2148

You can take a public API like coingecko or coinmarketcap, fetch daily prices for a given period and find average as well as median and mode. They provide market data for thousands of coins/tokens and each of them is paired against 50+ currencies. Of course you will need to write a bit of code, but it's like a 20 minute task or so.

RickDeckard

legendary

Activity: 1148

Merit: 3117

You can use Investing.com[1] historical information to fetch this kind of information (I'm sure there are other similar websites that do this). For the specific period you mentioned here are the results [USD] :

Highest: 47,944.9
Lowest: 32,985.6
Difference: 14,959.3
Average: 41,019.2
Change %: -16.2

I'm not sure where do they grab this information from though - they claim that it was gathered from market makers (on their disc lamer message) - so expect to find some discrepancies if you compare these results to other pool of information that you may find elsewhere...

[1]https://uk.investing.com/crypto/bitcoin/historical-data

GreatArkansas

legendary

Activity: 2506

Merit: 1394

I want to ask if is there any way platform where I can get the average price of a particular cryptocurrency or pair for a given time?

Let's say, for example, I want to check the average price of Bitcoin from January 1, 2022 - February 1, 2022?
And I will get the average price of that timeframe.

Thanks!

Topic: Get average price of cryptocurrency for given timeframe (Read 166 times)