Read our rules before posting. If ethereum knows how to keep the sheet with your data market let me know. Post as cap guest Name. Make sure to set up config. Many cryptocurrencies are also available on the Quandl platform from Bitfinex See other quandl answers for how csv access with the API.
See other quandl answers for how to access with the API. I got the API links from here:. Bitcoin data on Quandl II. Keep in mind that it's not a good idea to link to values in the ticker because as the coin ranks change, so will the row number that they'll be listed on, which will mess up your links. Surely would be very easy to create another example sheet from your own sheet? I'll try to check later if euro prices can be imported directly. It can be translated to ISO which is more readable.
And edit the period to adjust the details. Welcome to Reddit, ethereum front csv of the internet. This is what I market and it is very effective. Poloniex has a pretty complete dataset available. Questions Tags Users Badges Cap.
Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top. Can you maybe tell me how to access the JSON data online? Thank you in advance! You fund yourself in BTC, trading after other electronic currencies, but not fiat money. These links are all dead, is not possible to get the raw data anymore? Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Bitcoin data on Quandl II. Thanks to the answer to this question on Ethereum's stackexchange.
I work at Quandl and stumbled upon this post. I'm happy to share an update: Brave New Coin Liquid Index: History goes back to There also seems to be https: Many cryptocurrencies are also available on the Quandl platform from Bitfinex. See other quandl answers for how to access with the API. Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site the association bonus does not count. Would you like to answer one of these unanswered questions instead? Questions Tags Users Badges Unanswered. Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data.
You will need to generate a new query for each of your coins. Simply change the bitcoin part in the API link to whichever coin you're interested in. Replace bitcoin with your preferable coin's ID as shown in the ticker. Remember, use the ID, not the coin name. They are not always the same. Here is an example of the type of chart I generated with the example. Hope this was helpful. It seems sometimes when the API data refreshes the excel file switches to that sheet, which is a bit annoying.
If anyone knows how to keep the sheet with your data pinned let me know. Also, I can't make sense of the values in the last updated field. If anyone knows how to interpret those let me know as well.
Here is a sample portfolio file. Here are examples of coinbase APIs for those who want more relevant prices. I got the API links from here:. I've been getting that error since yesterday. It might be their API going down periodically. Try to see if it changes after a while and also check if your token name is correct.
I made an example sheet to make sure I didn't skip anything but I didn't save it. I have my own sheet but I'm not going to share that for obvious reasons. Let me know if you have trouble with something and I can go over it in detail. It's pretty straight forward. It's late anyway, if I feel like making an example sheet again I'll do it tomorrow maybe.
Surely would be very easy to create another example sheet from your own sheet? Just change the number of coins? My problem is now that I am German and I would like to trade in Euro and have all my fiat prices displayed in Euro.
When I change the setting of the link of www. If you can find an API for live euro rates from somewhere then plug that in similarly and multiply the prices. I'll try to check later if euro prices can be imported directly.
Hey man, thanks for your answer. The problem is, if I for example take the link https: I'm also trying to get this to work on my Mac with Excel , but it doesn't have the necessary features to make it work.
Did you figure out a fix? Or is there a sample excel file with the data already in there for several coins that can be downloaded? Try to download the sample file and see if it works for you. If yes, then just adapt it for your own purpose. If not, then I'm not sure. The concept is fairly straight forward. You'll have to learn how to import an API call into your worksheet. It also depends on the version you're using. Thats literally why I am posting it. So that people can use an easier method than your time-consuming method.
Instead they can just use that one that already has a script installed and works out of the box basically. Thanks for doing it! I've googled before for how to do this before in google sheets and not come up with a decent solution. I came in to the comments to find the post mentioned: Any way to get historical prices from coinmarketcap?
I can't find a site that graphs percentage returns for different coins on the same graph. For historical prices there is an api from https: Still trying to figure that out. I'm sure you can simply record the price at given intervals and make your own record. Would have to write a macro or something for it. I don't think that's what you're talking about. You can compare return percentage on http: I tried using their public API link for the ticker but it keeps giving an error.
Even tried to download the JSON file and link that into excel instead of a direct web link and I got the same error.
Date, Open, High, Low, Close, Volume, Market Cap. Feb 01, , , , , , , Jan 31, , , , , , , Jan 30, , , , , , , Jan 29, , Get detailed information on Ethereum (ETH) including real-time price index, historical charts, market cap, exchanges, wallets, and latest news. Poloniex has a pretty complete dataset available. poloniex. Raw data as JSON here. Edit the timestamps in the API to get a different snapshot. Edit the period to adjust the details.