Get Crypto Prices In Excel. Click on that new icon. (see the below image to see what you get) select 'close & load'.
Get historical data (name, price, market, stats) at a given date for a coin. Latest cryptocurrency quotes in excel. Feel free to come and ask your questions here.
Tell excel your data is stock data.
If the page works, we’ll see a table full of daily prices. If the page works, we’ll see a table full of daily prices. Now, there are a few ways to get data displayed on the web page into excel. Here’s comes the fun part of creating the google script that will pull prices and create a custom function that we can use anywhere in our spreadsheet.