How to get price point/change from 30 days ago?

API Spot/Margin API
1

Hello,

I am using Excel to download data from Binance. I use https://api.binance.com/api/v3/ticker/24hr
and get price data from 24 hours before, but it is there a way to get data from 30days prior? Pretty new to this, so any help would be appreciated!

Thank you!

2

You might want to leverage on /api/v3/klines and specify the interval to 1d. Read this please - https://binance-docs.github.io/apidocs/spot/en/#kline-candlestick-data

3

Would you please explain how to get price data into excel.