Altcoins Talks - Cryptocurrency Forum
Crypto Discussion Forum => Cryptocurrency Trading => Topic started by: bkelly on March 13, 2021, 05:36:37 AM
-
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.
-
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.
-
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.