fetching price/transaction data

[bkelly]

Does anyone have any experience with getting price/transaction data from any web sites?  Any preferences for sites to use?  I see that Excel 2019 and Office 365 have some ability to fetch data and load it into Excel.  I have Office 2019, not 365.  I can write code, have done some Excel VBA, but have never written anything that accesses the internet to fetch data.

[MrSpasybo]

Here are a few websites where you can download bitcoin price data. I also downloaded data from here to write a price prediction program, I think Investing.com give the most complete results. In the past I downloaded BTC price history from coinmarketcap but temporarily could not find where to download this data

https://www.investing.com/crypto/bitcoin/historical-data
https://www.statista.com/statistics/326707/bitcoin-price-index/
https://finance.yahoo.com/quote/BTC-USD/history/

For the price history of other cryptocurrencies, you can try a Google search. We hope to see the interesting results you get.

[bkelly]

Thank you for taking the time to reply.  I need to back up a level and go for more the beginner perspective.  When looking at the investing.com site, and selecting their Tools items, then sub items, I did not recognize anything tells me how the data gets from their site into a CSV or Excel file.  What do I need to do on my end to initiate that transaction?  And please, I am hoping for a link somewhere as I am sure this has been explained many times.
A day or two ago I found that Excel has a built in feature called "Get <something>" that does that.  Now I cannot find a trace of it.  My ability to create search terms that others use is rather poor and often frustrating.  But just now I did find something different that looks like a formula: "=STOCKHISTORY(...)  Are one of those two the way to go?

Oh please, something someone has written is much preferred over a video.
Edit:  Oops, I now see that stock history is only with MS 365, which I do not use. I have Office 2019.

Edit: Please point me to an example app that will go to a site and download the data for a selected crypto-coin.  I will have to edit in my API key and some information about the specific coin and the time frame.  But other than that, I need a function app rather than a subroutine.