Cryptocurrency market value based on timestamp

Hello Guys,

I'm trying to get the values of my crypto portfolio day by day (for several timestamps/dates).
I found a way to get the value of cryptos at a particular date and time but now the challenge is to automate the process so I can keep the historical data and get the trend of my portfolio.
I've found the way to get the value of any crypto in this tutorial (which is in French but basically it uses Power Query to run)
Then I've created a table in which I have the list of dates from today to one year ahead and the challenge is to get automatically the table filled every day based on the date on the column A.
Could you please guys help me to figure out a way to do this?

Thanks

Regards