如何通过 CoinMarketCap 获取比特币交易数据 - 知乎

Bitcoin XT - discussing Satoshi's Vision

A subreddit focused on providing open discussion on all things Bitcoin (BSV).
[link]

NiceHash - buy & sell hashing power

NiceHash offers you to buy or sell hashing power directly, no contracts, no limitations, pay-as-you-go if you're a buyer and be-paid-as-you-go if you're a seller. Why bother renting rigs, when you can rent hashing power? NiceHash brings more to renters and rig owners. Visit https://www.nicehash.com today! Simply create order and you are already mining your favorite coin or point your rig to our stratum server and you are already earning bitcoins.
[link]

Cryptocurrency news and discussions.

Cryptocurrency news and discussion. Bitcoin, Litecoin, Ethereum, Ripple, Monero, Dash, NEO, IOTA Lightning Network, SegWit, Augur, Steemit, privacy, ICO, block time, Proof of Work, Proof of Stake, NEM, Peercoin, Vertcoin, Iconomi, Dogecoin, Zcash, BitShares, Walton, mining, hashrate, mining difficulty, blockchain, coinbase, merkle, transaction rate, decentralized exchange, annual inflation rate, total market cap, bitcoin cash, BTC
[link]

[TASK] Show the latest price of bitcoin with the coinmarketcap API [$10]

As title states, already got the PHP file and the api key implemented. I just want to show the latest price plainly in a wordpress page. ( and show how much money you have if you bought $1000 worth of bitcoin, when its price was $5000. )
Thanks a lot!
submitted by DonnieEstacado to slavelabour [link] [comments]

Coinbase Adds British Pound | Bitcoin Mining TV | CoinMarketCap Pro API

Coinbase Adds British Pound | Bitcoin Mining TV | CoinMarketCap Pro API submitted by ososru to Bitcoin4free [link] [comments]

Coinbase Adds British Pound | Bitcoin Mining TV | CoinMarketCap Pro API

Coinbase Adds British Pound | Bitcoin Mining TV | CoinMarketCap Pro API submitted by Rufflenator to 3bitcoins [link] [comments]

I wrote a simple Programm that shows you the current Bitcoin Price using the coinmarketcap API. Its open source and I will acept pull request. Hope you like it. Plattform: Mac, Linux

I wrote a simple Programm that shows you the current Bitcoin Price using the coinmarketcap API. Its open source and I will acept pull request. Hope you like it. Plattform: Mac, Linux submitted by FutureDomi to Bitcoin [link] [comments]

Pulling Cryptocurrency Prices into Google Sheets using JavaScript and the CoinMarketCap API /r/Bitcoin

Pulling Cryptocurrency Prices into Google Sheets using JavaScript and the CoinMarketCap API /Bitcoin submitted by HiIAMCaptainObvious to BitcoinAll [link] [comments]

Anyone know the CoinMarketCap API minimum amount of calls? /r/Bitcoin

Anyone know the CoinMarketCap API minimum amount of calls? /Bitcoin submitted by BitcoinAllBot to BitcoinAll [link] [comments]

I wrote a simple Programm that shows you the current Bitcoin Price using the coinmarketcap API. Its open source and I will acept pull request. Hope you like it. Plattform: Mac, Linux

I wrote a simple Programm that shows you the current Bitcoin Price using the coinmarketcap API. Its open source and I will acept pull request. Hope you like it. Plattform: Mac, Linux submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Bitcoin mentioned around Reddit: Coinmarketcap pull api issue /r/algotrading

Bitcoin mentioned around Reddit: Coinmarketcap pull api issue /algotrading submitted by BitcoinAllBot to BitcoinAll [link] [comments]

08-31 21:12 - 'I've tried to use Coinmarketcap's API but it's slightly differently formatted as the hitbtc and bitstamp apis, where you need to go into the first item of the json array,, I can't figure out how to do this in an AppleScript...' by /u/watermaniak removed from /r/Bitcoin within 2-12min

'''
I've tried to use Coinmarketcap's API but it's slightly differently formatted as the hitbtc and bitstamp apis, where you need to go into the first item of the json array,, I can't figure out how to do this in an AppleScript though.. has anyone else got this to work? (i.e. [link]1 starts with the [ sign instead of {)
'''
Context Link
Go1dfish undelete link
unreddit undelete link
Author: watermaniak
1: a*i.c**n*arketca*.com*v1/**ck*b**coin/?co*vert=*UR
Unknown links are censored to prevent spreading illicit content.
submitted by removalbot to removalbot [link] [comments]

How do I get a real time BTC price to Google Sheets with CoinMarketcap.com API? /r/Bitcoin

How do I get a real time BTC price to Google Sheets with CoinMarketcap.com API? /Bitcoin submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Zano Newcomers Introduction/FAQ - please read!

Welcome to the Zano Sticky Introduction/FAQ!

https://preview.redd.it/al1gy9t9v9q51.png?width=424&format=png&auto=webp&s=b29a60402d30576a4fd95f592b392fae202026ca
Hopefully any questions you have will be answered by the resources below, but if you have additional questions feel free to ask them in the comments. If you're quite technically-minded, the Zano whitepaper gives a thorough overview of Zano's design and its main features.
So, what is Zano? In brief, Zano is a project started by the original developers of CryptoNote. Coins with market caps totalling well over a billion dollars (Monero, Haven, Loki and countless others) run upon the codebase they created. Zano is a continuation of their efforts to create the "perfect money", and brings a wealth of enhancements to their original CryptoNote code.
Development happens at a lightning pace, as the Github activity shows, but Zano is still very much a work-in-progress. Let's cut right to it:
Here's why you should pay attention to Zano over the next 12-18 months. Quoting from a recent update:
Anton Sokolov has recently joined the Zano team. ... For the last months Anton has been working on theoretical work dedicated to log-size ring signatures. These signatures theoretically allows for a logarithmic relationship between the number of decoys and the size/performance of transactions. This means that we can set mixins at a level from up to 1000, keeping the reasonable size and processing speed of transactions. This will take Zano’s privacy to a whole new level, and we believe this technology will turn out to be groundbreaking!
If successful, this scheme will make Zano the most private, powerful and performant CryptoNote implementation on the planet. Bar none. A quantum leap in privacy with a minimal increase in resource usage. And if there's one team capable of pulling it off, it's this one.

What else makes Zano special?

You mean aside from having "the Godfather of CryptoNote" as the project lead? ;) Actually, the calibre of the developers/researchers at Zano probably is the project's single greatest strength. Drawing on years of experience, they've made careful design choices, optimizing performance with an asynchronous core architecture, and flexibility and extensibility with a modular code structure. This means that the developers are able to build and iterate fast, refining features and adding new ones at a rate that makes bigger and better-funded teams look sluggish at best.
Zano also has some unique features that set it apart from similar projects:
Privacy Firstly, if you're familiar with CryptoNote you won't be surprised that Zano transactions are private. The perfect money is fungible, and therefore must be untraceable. Bitcoin, for the most part, does little to hide your transaction data from unscrupulous observers. With Zano, privacy is the default.
The untraceability and unlinkability of Zano transactions come from its use of ring signatures and stealth addresses. What this means is that no outside observer is able to tell if two transactions were sent to the same address, and for each transaction there is a set of possible senders that make it impossible to determine who the real sender is.
Hybrid PoW-PoS consensus mechanism Zano achieves an optimal level of security by utilizing both Proof of Work and Proof of Stake for consensus. By combining the two systems, it mitigates their individual vulnerabilities (see 51% attack and "nothing at stake" problem). For an attack on Zano to have even a remote chance of success the attacker would have to obtain not only a majority of hashing power, but also a majority of the coins involved in staking. The system and its design considerations are discussed at length in the whitepaper.
Aliases Here's a stealth address: ZxDdULdxC7NRFYhCGdxkcTZoEGQoqvbZqcDHj5a7Gad8Y8wZKAGZZmVCUf9AvSPNMK68L8r8JfAfxP4z1GcFQVCS2Jb9wVzoe. I have a hard enough time remembering my phone number. Fortunately, Zano has an alias system that lets you register an address to a human-readable name. (@orsonj if you want to anonymously buy me a coffee)
Multisig
Multisignature (multisig) refers to requiring multiple keys to authorize a Zano transaction. It has a number of applications, such as dividing up responsibility for a single Zano wallet among multiple parties, or creating backups where loss of a single seed doesn't lead to loss of the wallet.
Multisig and escrow are key components of the planned Decentralized Marketplace (see below), so consideration was given to each of them from the design stages. Thus Zano's multisig, rather than being tagged on at the wallet-level as an afterthought, is part of its its core architecture being incorporated at the protocol level. This base-layer integration means months won't be spent in the future on complicated refactoring efforts in order to integrate multisig into a codebase that wasn't designed for it. Plus, it makes it far easier for third-party developers to include multisig (implemented correctly) in any Zano wallets and applications they create in the future.
(Double Deposit MAD) Escrow
With Zano's escrow service you can create fully customizable p2p contracts that are designed to, once signed by participants, enforce adherence to their conditions in such a way that no trusted third-party escrow agent is required.
https://preview.redd.it/jp4oghyhv9q51.png?width=1762&format=png&auto=webp&s=12a1e76f76f902ed328886283050e416db3838a5
The Particl project, aside from a couple of minor differences, uses an escrow scheme that works the same way, so I've borrowed the term they coined ("Double Deposit MAD Escrow") as I think it describes the scheme perfectly. The system requires participants to make additional deposits, which they will forfeit if there is any attempt to act in a way that breaches the terms of the contract. Full details can be found in the Escrow section of the whitepaper.
The usefulness of multisig and the escrow system may not seem obvious at first, but as mentioned before they'll form the backbone of Zano's Decentralized Marketplace service (described in the next section).

What does the future hold for Zano?

The planned upgrade to Zano's privacy, mentioned at the start, is obviously one of the most exciting things the team is working on, but it's not the only thing.
Zano Roadmap
Decentralized Marketplace
From the beginning, the Zano team's goal has been to create the perfect money. And money can't just be some vehicle for speculative investment, money must be used. To that end, the team have created a set of tools to make it as simple as possible for Zano to be integrated into eCommerce platforms. Zano's API’s and plugins are easy to use, allowing even those with very little coding experience to use them in their E-commerce-related ventures. The culmination of this effort will be a full Decentralized Anonymous Marketplace built on top of the Zano blockchain. Rather than being accessed via the wallet, it will act more as a service - Marketplace as a Service (MAAS) - for anyone who wishes to use it. The inclusion of a simple "snippet" of code into a website is all that's needed to become part a global decentralized, trustless and private E-commerce network.
Atomic Swaps
Just as Zano's marketplace will allow you to transact without needing to trust your counterparty, atomic swaps will let you to easily convert between Zano and other cyryptocurrencies without having to trust a third-party service such as a centralized exchange. On top of that, it will also lead to the way to Zano's inclusion in the many decentralized exchange (DEX) services that have emerged in recent years.

Where can I buy Zano?

Zano's currently listed on the following exchanges:
https://coinmarketcap.com/currencies/zano/markets/
It goes without saying, neither I nor the Zano team work for any of the exchanges or can vouch for their reliability. Use at your own risk and never leave coins on a centralized exchange for longer than necessary. Your keys, your coins!
If you have any old graphics cards lying around(both AMD & NVIDIA), then Zano is also mineable through its unique ProgPowZ algorithm. Here's a guide on how to get started.
Once you have some Zano, you can safely store it in one of the desktop or mobile wallets (available for all major platforms).

How can I support Zano?

Zano has no marketing department, which is why this post has been written by some guy and not the "Chief Growth Engineer @ Zano Enterprises". The hard part is already done: there's a team of world class developers and researchers gathered here. But, at least at the current prices, the team's funds are enough to cover the cost of development and little more. So the job of publicizing the project falls to the community. If you have any experience in community building/growth hacking at another cryptocurrency or open source project, or if you're a Zano holder who would like to ensure the project's long-term success by helping to spread the word, then send me a pm. We need to get organized.
Researchers and developers are also very welcome. Working at the cutting edge of mathematics and cryptography means Zano provides challenging and rewarding work for anyone in those fields. Please contact the project's Community Manager u/Jed_T if you're interested in joining the team.
Social Links:
Twitter
Discord Server
Telegram Group
Medium blog
I'll do my best to keep this post accurate and up to date. Message me please with any suggested improvements and leave any questions you have below.
Welcome to the Zano community and the new decentralized private economy!
submitted by OrsonJ to Zano [link] [comments]

Decentr ($DEC) - foundational cross-chain and cross-platform DeFi protocol

  1. SUMMARY
Decentr is a protocol designed to make blockchain/DLT mainstream by allowing DeFi applications built on various blockchains to “talk to each other”. Decentr is a 100% secure and decentralised Web 3.0 protocol where users can apply PDV (personal data value) to increase APR on $DEC that users loan out as part of of our DeFi dLoan features, as well as it being applied at PoS when paying for stuff online. Decentr is also building a BAT competitor browser and Chrome/Firefox extension that acts as a gateway to 100% decentralised Web 3.0
Allows DeFi Dapps to access all Decentr’s dFintech features, including dLoan, dPay. Key innovation is that the protocols is based on a user’s ability to leverage the value of their data as exchangeable “currency”.
  1. KEY CONCEPTS

  1. REVENUE MODEL
A fee is charged for every transaction using dPay whereby an exchange takes place between money (fiat and digital) and data, and vice versa, either as part of DeFi features or via a dApp built on Decentr. They are launching pilot programmes in the following industries:
  1. Banking/PSP Industry: On Product launch, due to Decentr’s powerful PSP connections (including the worlds #2 PSP by volume), a medium-scale pilot program will be launched, which will seed the network with 150,000 PSP customers in primarily the Spanish/LAC markets, generating revenue from day one.
  2. “Bricks and Mortar” Supermarket/Grocery Industry: Decentr aims to ensure the long-term competitiveness of “bricks and mortar” supermarkets against online-only grocery retailers, such as Amazon, by a) building secure tech that allows supermarkets to digitise every aspect of their supply chains and operational functions, while b) allowing supermarkets to leverage this incredibly valuable data as a liquid asset class. Expected revenue by Year 5: $114Mn per year.
  3. Online Advertising Industry: Decentr’s 100% decentralised platform credits users secure data with payable value, in the form of PDV, for engaging with ads. The Brave browser was launched in 2012 and in 8 years has reached over 12 million monthly active users, accented by as many as 4.3 million daily active users.
  4. TOKEN $DEC AND SALE
Decentr recently complete their token sale on a purchase portal powered by Dolomite where they raised $974,000 in 10 minutes for a total sale hardcap of 1.25M. The $DEC token is actively trading on multiple exchanges including Uniswap and IDEX. Listed for free on IDEX, Hotbit, Hoo, Coinw, Tidex, BKex. Listed on CoinGecko and Coinmarketcap. Listed on Delta and Blockfolio apps.
➡️ Circulating supply: 61m $DEC.
➡️ Release schedule and token distribution LINK -> NO RELEASE UNTIL 2021.
➡️Contract Address - 0x30f271C9E86D2B7d00a6376Cd96A1cFBD5F0b9b3
➡️Decimals - 18, Ticker - DEC
➡️Uniswap link: https://uniswap.info/pai0x3AEEE5bA053eF8406420DbC5801fC95eC57b0E0A
⭐️ HOW TO BUY VIDEO: https://www.youtube.com/watch?v=iloAiv2oCRc&feature=youtu.be
$DEC Token utility:
A tradeable unit of value that is both internal and external to the Decentr platform.A unit of conversion between fiat entering and exiting the Decentr ecosystem.A way to capture the value of user data and combines the activity of every participant of the platform performing payment (dPay), or lending and borrowing (dLend), i.e a way to peg PDV to tangible/actionable value.Method of payment in the Decentr ecosystem.A method to internally underwrite the “Deconomy.
  1. NOTABLE SUPPORTERS
Simon Dedic - chief of Blockfyre: https://twitter.com/scoinaldo/status/1283787644221218817?s=20https://twitter.com/scoinaldo/status/1283719917657894912?s=21
Spectre Group Pick : https://twitter.com/SPECTREGRP/status/1284761576873041920https://twitter.com/llluckyl/status/1283765481716015111?s=21
Patrons of the Moon/Lil Uzi: https://t.me/patronsofthemoon/6764
CryptoGems: https://twitter.com/cryptogems_com/status/1283719318379925506?s=09t
tehMoonwalker pick who is a TOP 5 influencer per Binance:https://twitter.com/tehMoonwalkestatus/1284123961996050432?s=20https://twitter.com/binance/status/1279049822113198080
Holochain was one of their earliest supporters and they share a deep connection (recently an AMA was conducted in their TG group): https://medium.com/@DecentrNet/decentr-holochain-ama-29d662caed03
  1. UPCOMING NEWS
--------------------------------------------
  1. RESOURCES:
Website: https://decentr.net
Telegram: https://t.me/DecentrNet
Medium: https://medium.com/@DecentrNet
Twitter: https://twitter.com/DecentrNet
Whitepaper: https://decentr.net/files/Decentr_Whitepaper_V1.4.pdf
Technical Whitepaper: https://decentr.net/files/Decentr_Technical_Whitepaper_Data_As_Economic_Currency.pdf
Recent Articles:
⚡️- https://medium.com/@DecentrNet/decentr-token-sale-metrics-and-distribution-483bb3c58d05
⚡️- https://medium.com/@DecentrNet/how-decentrs-defi-dloan-function-benefits-dec-holders-97ff64a0c105
⚡️- https://medium.com/@DecentrNet/3-vertical-revenue-streams-decentr-is-targeting-4fa1f3dd62de
⚡️- https://medium.com/@DecentrNet/brave-browser-the-good-the-bad-and-the-fundamentally-misguided-8a8593b0ff5b
⚡️- https://medium.com/@DecentrNet/how-decentrs-dfintech-replaces-swift-sct-inst-clearing-house-and-other-payment-solutions-78acacbb4c3f
Chad Gang STRONG Community: https://t.me/decentrtrading
Community News Channel: https://t.me/chadnews
Recent Uniswap trades: https://t.me/dectrades
Wallet holder tracker: https://t.me/DEC_WALLETS_COUNT
submitted by ldd999 to CryptoMoonShots [link] [comments]

Track Your Crypto Portfolio - SyncExchanges & Wallets from a spreadsheet

CRYPTOCURRENCY SPREADSHEET THAT ROCK by Moosy Research Cryptocurrency spreadsheet | cryptosheets | cryptosheet excel | google sheets api apis bitcoin coinmarketcap - cointrexer ctrxl botmon rex json rest script crypto sheets cool private public binance bitmex more sheet

See all sheets on:https://sites.google.com/site/moosyresearch/projects/cryptos

CRYPTOCURRENCY SPREADSHEET THAT ROCK - by Moosy Research | Cryptocurrency spreadsheet | cryptosheets | cryptosheet excel | google sheets api apis bitcoin coinmarketcap - cointrexer botmon rex json rest script crypto sheets cool private public bitmex binance huobi and many more
Bibox
Binance
Binance Jersey
Bit2C
Bitfinex
bitFlyer
BitForex
BitMEX
Bitpanda
Bitpanda Global Exchange
Bitsane
Bitstamp
Bittrex
BKEX
Bybit
CEX.IO
CoinAll
Coinbase
Coinbase Pro / GDAX
Cryptopia
Currency.com
Deribit
Etherscan.io
FTX
Gate.IO
Gemini
Gopax
HitBTC
Huobi
IDEX
Indodax
Kraken
Kucoin
Liquid
Luno (formerly BitX)
OKEx
Poloniex
gas google apps script javascript app script google sheets code sha256 signature private request api call rest
submitted by moosylog to Cointrexer [link] [comments]

AGA. (Gem Call)

AGA
https://etherscan.io/address/0x2d80f5f5328fdcb6eceb7cacf5dd8aedaec94e20
Uniswap
Meet AGA, the mining backed, high APY, DEFI, governance token managed by an experienced team of professionals with diverse experience in technology and construction at companies like Accenture, Microsoft, NetApp and University Mechanical Contractors!
Today there are countless tokens offering various levels of staking rewards. Decred voting, XTZ staking, ZEN nodes, and many more. New generation of DeFi tokens have cropped up and offer yield farming rewards in return for pooled liquidity on Uniswap, Balancer and others. Some even offer 10,000% APY returns (in their native unlimited supply token). Unfortunately, with only few exceptions most of these tokens don’t have any source of revenue to fund these rewards and to justify their price. Furthermore, these rewards dilute the supply and ultimately drive the price down.
AGA Token changes this by using Cryptocurrency mining to fund its staking rewards and to back its price. This simple, yet, revolutionary approach aims to deliver substantial returns to all AGA Token holders through liquidity pool staking and price appreciation. Aga Platform is a profitable ASIC and FPGA cryptocurrency mining operation with mining facilities located in Eastern Washington, where electricity prices are one of the lowest in the world. Primarily we mine Bitcoin, Bitcoin Cash, Litecoin, Dash, Digibyte, Verge and Decred. You can monitor mining profitability via our NiceHash dashboard by clicking the screen on the right.
AGA Token and Aga Platform are managed by an experienced team of professionals with diverse experience in technology and construction at companies like Accenture, Microsoft, NetApp and University Mechanical Contractors.
📌 MC at time of writing ~ 800K 📌 Total supply: 10.9M 📌 Circulating supply 843K
‼️SOME IMPORTANT LINKS ‼️ 📍CMC - https://coinmarketcap.com/currencies/aga/ 📍Website -https://agatoken.com/ 📍Etherscan - https://etherscan.io/token/0x2d80f5f5328fdcb6eceb7cacf5dd8aedaec94e20 📍Telegram - https://t.me/agatokengroup 📍Twitter - https://twitter.com/agatkn 📍Facebook: https://www.facebook.com/Aga-Token-107736531016089 📍AGA Rewards: https://agatoken.com/promotions/#agatoken 💹💹 Where to Buy: https://app.uniswap.org/#/swap?inputCurrency=0x2d80f5f5328fdcb6eceb7cacf5dd8aedaec94e20
Found By: @BlueDemise Written By: @alexanderthethrid
submitted by hamoudii31 to CryptoMoonShots [link] [comments]

DataSource.Error: Unable to connect to the remote server

Does anyone know what the correct syntax is to get a query returned?
I created a Day Trading Spreadsheet that includes an external query to coinmarketcap.com that used to work, but no longer does. I believe it is due to them requiring that you have an API account with them as they can monitor the amount of queries to their database on a daily/monthly basis.
My query that used to work is this:
= Json.Document(Web.Contents("https://api.coinmarketcap.com/v1/tickebitcoin"))
I have since signed up with coinmarketcap.com and recieved my API key, but I can't find the procedure to use my API key within Excel. Does anyone know what the correct syntax would be to return a query from coinmarketcap.com?
The URL that it goes to is: https://api.coinmarketcap.com/v1/tickebitcoin
And Open File As is set to Json.
submitted by rogue30 to excel [link] [comments]

Plugin or php code (or any other way) to display Bitcoin price

Hi all,
I want to create a single web page that shows just the price of Bitcoin from CoinBase Pro. Not even sure if WordPress is the right CMS for something like this (so I'm open to suggestions)
For example, if you load the page https://pro.coinbase.com/trade/BTC-USD you see a current price like $9876.54. What I want is that number (in bold), with or without the "$" sign. I would also like to have the page re-fetch the latest price every 15-30 seconds and either reload or display the updated price automatically without reloading. The end page would be just a white background with black digits showing the price. I can do that with CSS, provided that I somehow acquire the price itself.
I have found quite a few plugins but they are either not free, or far too complex for the simple thing I need, and only use CoinMarketCap for the price (or some other sources which I don't want to use).
I understand that I need to use CoinBase's API, but I am not familiar with APIs or json at all and I find the API Guide too hard to understand with my limited knowledge.
Could someone please help?
submitted by Idiots-R-Invincible to Wordpress [link] [comments]

A made a Bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).

A made a Bitcoin tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).
I have posted this previously however since then coinmarketcap have changed their api. This version has a workaround for that - with the downside that it takes much longer to fetch price data. You will need to be patient when opening the file and when you press the price refresh button.
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/f9w12ene5yo41.png?width=1536&format=png&auto=webp&s=be4af166ad3c3f22ecddac47084b8de358400bf0
No need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)
https://preview.redd.it/uob5u0sf5yo41.png?width=1380&format=png&auto=webp&s=f24ed6e1a342c97844f9b7f784b03839f2b529e2
https://preview.redd.it/ql1yqsvg5yo41.png?width=602&format=png&auto=webp&s=ebfd082edb817a1d6b614fe127aa685d3414f65c
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/gwagpfth5yo41.png?width=929&format=png&auto=webp&s=cbb9177ff457efa598dc92a61d346ddc38c296cf
There are plenty of 'moon math' and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.

https://preview.redd.it/ewafzx4j5yo41.png?width=1455&format=png&auto=webp&s=1b2079600be53d855573707d13822323a9fdacee
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;
https://preview.redd.it/g145x5u16yo41.png?width=767&format=png&auto=webp&s=180321b1b8641da48ffeb1de5cfb982d1fccf0da
free download from below. Instructions inside. You will need macros enabled if you want it to do the fancy stuff
https://www.dropbox.com/s/yjba4y6qdsye2qo/Cryptoprices11%20-%20for%20others.xlsm?dl=0
Edit: there seems to be a problem where there is a link to an old version of the spreadhseet. to fix; Open the workbook and go to Data>edit links https://imgur.com/yRk5juh
Then press 'change source' and select the same excel sheet that you have open (wherever you have it saved locally). https://imgur.com/pBJyZM9
submitted by Fly115 to Bitcoin [link] [comments]

A made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).

A made a Cryptocurrency tracking spreadsheet complete with live crypto price updates, moon math, and a full history of your Portfolio and trading performance (fixed).
I have posted this previously however since then coinmarketcap have changed their api. This version has a workaround for that - with the downside that it takes much longer to fetch price data. You will need to be patient when opening the file and when you press the price refresh button.
This is a spreadsheet that I have developed for myself gradually over the last couple years. I have found it very helpful for keeping track of my bitcoin holdings (great for tax purposes). No need to trust third party apps to keep your personal information - track it yourself.
There is a lot in here including;
Automatically updates prices from coinmarketcap. The top 200 coins included. Just select which ones you want to track by typing in the name.
You can even choose your local Fiat currency and get live conversion rates for any country.
https://preview.redd.it/zmt33x8q6yo41.png?width=1536&format=png&auto=webp&s=734fc117610d6eaa3bcc10670241fbf436e902b1
You don't need to record details of every trade. Just keep track of your crypto purchases (from fiat) and what coins you currently hold. The spreadsheet will calculate the rest and keep a record of how your portfolio and holdings have changed over time (it logs this data every time you save the sheet)

https://preview.redd.it/ha3gel8r6yo41.png?width=1380&format=png&auto=webp&s=7bdbd351b866ff70f160810f2515a32953a5249b
https://preview.redd.it/mzkt96js6yo41.png?width=602&format=png&auto=webp&s=45fefffe6f92f2ad4fefac67320ffe3454a7155b
I find this very handy to see if your trading is actually profitable compared to the HODL method.

https://preview.redd.it/ggg2utxu6yo41.png?width=929&format=png&auto=webp&s=010ab01b6424d525b1913a3d27acdd499cda25b8
Oh yes and there are plenty of 'moon math' and analytics to see how bitcoin is trending. This includes a full history of bitcoins price which updates every time you open the sheet.

https://preview.redd.it/upyy3qzv6yo41.png?width=1455&format=png&auto=webp&s=29db32fa7e6ce9156d27cea99afa35ab6fec2950
This version has some bug fixes and a few new features including a 'Stock to flow' price prediction model;
https://preview.redd.it/3vx5tq3x6yo41.png?width=767&format=png&auto=webp&s=e5d43c1394e979ff9069b9f9dbb40038bdee514a
free download from here. Instructions inside. You will need macros enabled if you want it to do the fancy stuff.
https://www.dropbox.com/s/yjba4y6qdsye2qo/Cryptoprices11%20-%20for%20others.xlsm?dl=0
Let me know if you have any issues.
Edit: there seems to be a problem where there is a link to an old version of the spreadhseet. to fix; Open the workbook and go to Data>edit links https://imgur.com/yRk5juh
Then press 'change source' and select the same excel sheet that you have open (wherever you have it saved locally). https://imgur.com/pBJyZM9
submitted by Fly115 to CryptoCurrency [link] [comments]

Crypto API from CoinMarketCap for excel

Hey,
I usually used API link from CoinMarketCap to see in real time the evolution of crypto like Bitcoin or Eth in excel ( https://api.coinmarketcap.com/v1/tickeethereum for exemple).
But it seems like they migrate something. when I go to the link I have this error message :
{"statusCode": 410,"error": "Gone","message": "WARNING: This API is now offline. Please switch to the new CoinMarketCap API. (https://pro.coinmarketcap.com/migrate/)"}
Can you give me the good link or if you know other link to help me ?

Thx
submitted by gorzhak06 to CoinMarketCap [link] [comments]

HEX CoinMarketCap Listing Request - Need Feedback/Help

PROGRESS:
https://coinmarketcap.com/currencies/hex/
https://www.coingecko.com/en/coins/hex
https://coincodex.com/crypto/hex/
https://coinpaprika.com/coin/hex-hex/

PROOF:
CoinMarketCap ---- https://imgur.com/a/TsbX5o3
LiveCoinWatch ----- https://imgur.com/a/9pdzLgg
CoinGecko ----------- https://imgur.com/a/oY3wn0w
WorldCoinIndex --- https://i.imgur.com/t9m0NDX.png
CryptoCompare --- https://i.imgur.com/wt6ni6O.png
CoinCodex ----------- https://i.imgur.com/XonOWor.png
Coinlib ----------------- https://i.imgur.com/ZNtvOsZ.png
Coinpaprika --------- https://i.imgur.com/f6fFz2s.png

DONATE / REFER:
if you want to support my work, please use my referral link! (and gain 10% more hex coins):
https://hex.win/?r=0x36ECd27625efeECeF5E8e62Cfdbd3F990801bA96
or donate ETH or HEX to my address: 0x36ECd27625efeECeF5E8e62Cfdbd3F990801bA96

COINMARKETCAP LISTING - TEXT FORMAT - (WITH LATEST EDITS):

1 - [New Listing] Add cryptoasset

Subject
HEX - HEX - Add cryptoasset

Project Launch Date
December 2, 2019

Project Name
HEX

Project TickeSymbol
HEX

Project Description
Launched on December 2, 2019 by Richard Heart and team, HEX is the first certificate of deposit on the blockchain, essentially time deposits that gain interest, HEX is an ERC20 Token that runs over the Ethereum network

Platform
Ethereum

Chain Fork
Not a fork, an Ethereum Smart Contract

Consensus Algorithm
Proof of Work and Proof of Stake Hybrid

Team/Backers/Investors
https://hex.win/#team

Traction/Adoption/Parternships/MVPs/Apps
As of Ethereum Block #9073548, Sun, 08 Dec 2019 19:5511 GMT
33,571 ETH ($5,067,575.86) has been invested
Ranked Top 10 Project on Dapps Radar
https://dappradar.com

Community Engagement
6,415 members on Telegram
https://t.me/HEXcrypto
3,661 followers on Twitter
https://twitter.com/HEXcrypto

Regulation/Licence
N/A

Office locations/addresses
N/A

Industry/SectoVertical
Certificate of Deposit (CD)

Link to Logo
https://i.imgur.com/Ha3FT3a.png

Website 1
https://hex.win/

Website 2
https://go.hex.win/

Block Explorer 1
https://etherscan.io/token/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39

Source Code
https://etherscan.io/address/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39#code
https://github.com/BitcoinHEX

Whitepaper / Technical Documentation
https://hex.win/techspecs.html

Announcement (Bitcointalk)
https://bitcointalk.org/index.php?topic=4523610.0

Message Board
https://www.reddit.com/HEXcrypto/

Twitter
https://twitter.com/HEXcrypto

Reddit
https://www.reddit.com/HEXcrypto/

Facebook
https://www.facebook.com/HEXcrypto

Video Channel
https://www.youtube.com/HexCrypto

Chat 1
https://t.me/HEXcrypto

Linkedin
https://www.linkedin.com/

Mobile App
https://chrome.google.com/webstore/detail/metamask/nkbihfbeogaeaoehlefnkodbefgpgknn

Circulating Supply
https://hexstat.com/circulatingsupply

Total Supply
https://hexstat.com/totalsupply

Max Supply
N/A
(NOTE: Inflates 3.69% per year)

ICO/IEO Start Date
?

ICO/IEO End Date
?

ICO/IEO Price
?

# of assets sold in Private Sale
0

# of assets sold in Public Sale/ICO/IEO
0

Total # of assets sold
0

Total amount of capital raised (USD)
?

# of assets available to the public
0

# of assets that have been distributed to the public
0

# of assets that have been privately allocated for team/advisors/developers/future
0

API endpoint that displays ONLY TOTAL SUPPLY as a NUMERICAL value
https://api.etherscan.io/api?module=stats&action=tokensupply&contractaddress=0x2b591e99afe9f32eaa6214f7b7629768c40eeb39&apikey=YourApiKeyToken

Rich List
https://etherscan.io/token/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39#balances

List of CMC-supported exchanges
https://forkdelta.app/#!/trade/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39-ETH

Annex A - Rich List & Reserve Addresses
Origin Address
https://etherscan.io/address/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39
Flush Address
https://etherscan.io/address/0xDEC9f2793e3c17cd26eeFb21C4762fA5128E0399

Tags
DeFI
Staking

Are you willing to provide linkbacks to CMC?
Yes

Proof/Supporting evidence/documents
https://hex.win/

UPDATED LOCALLY:
- Project Name ----- (Changed from Hex to HEX)
- Circulating Supply ----- (Changed to Total Supply)
- Source Code ----- (Added Etherscan)
- Max Supply ----- (None, Inflates forever)
- API endpoint that displays ONLY TOTAL SUPPLY as a NUMERICAL value (Hexstat.com)
HELP:
- Project Description
- Announcement Link
- Mobile App
- ICO/IEO questions and Assets sold in Public/Private questions
- Annex A
submitted by togoshige to HEXcrypto [link] [comments]

Tether Stablecoin Launches on Its Seventh Blockchain

Tether Stablecoin Launches on Its Seventh Blockchain


Tether, the world's largest stablecoin by market value, is now live on the Bitcoin Cash (BCH) network.
Announced Thursday, Tether is using the Simple Ledger Protocol (SLP) as the technical means to launch its tether stablecoins (USDT) on the BCH blockchain. Tether aims for the token's price to consistently match the U.S. dollar on a 1:1 ratio and backs its value with assets.
Running directly on the BCH blockchain, SLP allows users to issue and manage tokens of various types. Tether said the launch means bitcoin.com wallet users – which supports BCH and bitcoin (BTC) – will be able to to send and receive USDT via SLP tokens, without the need for other applications.
Tether is currently live on the Algorand, EOS, Ethereum, Liquid Network, Omni and Tron blockchains with a total market capitalization – total units in circulation multiplied by spot price – of more than $5.6 billion, according to Tether Inc.'s treasury data. However, that does not seem to include any tokens on BCH as yet.
“Our latest collaboration with Bitcoin Cash will provide Tether with a variety of benefits," said Paolo Ardoino, Tether CTO. "We expect the adoption after launch to be pretty easy for any integrator. The launch will also support more applications on the Bitcoin Cash chain, with Tether facilitating payment for these applications.”
Data aggregators such as Nomics, Messari and CoinMarketCap display differing data for Tether's market cap.
Nick Gauthier, CTO and co-founder and Nomics, told CoinDesk the firm's API now tracks Tether's total liabilities. The firm is now displaying around $5.6 billion for USDT, matching Tether's stated figure.
CoinMarketCap, meanwhile, is currently displaying $4.6 billion, while Messari is closer to Tether's figure with $5.2 billion.
submitted by 3333A3 to u/3333A3 [link] [comments]

WG functions for returning cryptocurrency values

So in this post in /androidthemes, Kyokenshin was kind enough to help me out with setting up that particular function to return price for Monero, and it does look much cleaner now. In looking through the cryptowatch API site, there's a lot of other good stuff I'd like to integrate. Namely the "summary" call. Which is found about halfway down and the site says about this...
Summary Returns a market’s last price as well as other stats based on a 24-hour sliding window.
High price Low price % change Absolute change Volume Example:
https://api.cryptowat.ch/markets/gdax/btcusd/summary
Example response:
{ "result": { "price":{ "last": 780.31, "high": 790.34, "low": 772.76, "change": { "percentage": 0.0014373838, "absolute": 1.12 } }, "volume": 5345.0415 } }
So when I replace the formula that user gave me with summary it returned this output which is correct data, but how is it parsed into something more readable?
Appreciate all help
submitted by fo0you to kustom [link] [comments]

USING COINMARKETCAP TO BUY CRYPTOCURRENCY EXPLAINED TUTORIAL Using the CoinMarketCap API in Google Sheets Bitcoin API - Bitcoin, Crypto currency live and historical ... Pull Prices into Google Sheets via the CoinMarketCap API CoinMarketCap API Tutorial Using Python3 - YouTube

Use CoinMarketCap's free crypto API to get the best, most accurate real-time, historical cryptocurrency and exchange trade data for Bitcoin, Ethereum and more Über aktuelle Daten hinaus liefert Coinmarketcap Daten für historische Momentaufnahmen und allgemeine Marktdaten über die Gesamtmarktkapitalisierung aller Kryptowährungen und die Dominanz einzelner Kryptowährungen wie Bitcoin. Coinmarketcap bietet eine eigene API für Entwickler, die zum Betrieb von Preisdaten in anderen Anwendungen oder ... Check out the CoinMarketCap API on the RapidAPI API Directory. Learn more about this API, its Documentation and Alternatives available on RapidAPI. Sign Up Today for Free to start connecting to the CoinMarketCap API and 1000s more! From Bitcoin Wiki. Jump to: navigation, search. File:CoinMarketCap.png . CoinMarketCap front page. Coinmarketcap is a website for tracking capitalization of various cryptocurrencies. Contents. 1 Summary; 2 Addition of the new coins; 3 See also; 4 References; Summary. The page provides various data about several listed coins, such as their price, available supply, trade volume over last 24 ... 那么可以直接使用网站:Bitcoin (BTC) 历史数据 CoinMarketCap,选择好你需要的数据的日期,然后复制网站的数据,然后粘贴到 Excel 中,可能粘贴过程中会有问题,可以尝试先粘贴到空白文本,然后修改分隔符,转化成 CSV 格式。 不过根据我的尝试,比特币最早的数据应该只有2013年04月28日,更靠前的 ...

[index] [17196] [8630] [42619] [41620] [49433] [36392] [15313] [50116] [8071] [7898]

USING COINMARKETCAP TO BUY CRYPTOCURRENCY EXPLAINED TUTORIAL

In this video I will show you how to import live data and Historical data for Bitcoin, Ethereum, Ripple and other 1384 coins from web to excel. Data is refre... This is part 2 of our Bitcoin API tutorial. Here we parse the JSON data. JSON parser https://jsonformatter.org/json-parser Create a free account to get an AP... CoinMarketCap API v2 Tutorial Using Python3 - Duration: 21:39. ... Bitcoin 101 - Calling All APIs - Coding Live Price Data From Bitcoin Exchanges - Duration: 10:53. CRI 28,387 views. 10:53. Best ... Udemy Course (95% off): https://goo.gl/V9tcFp Python Code (GitHub): https://goo.gl/QzSpnf Video Referenced: https://goo.gl/FDHq2d This video explains the bas... coinmarketcap bitcoin coinmarketcap khmer coinmarket api google sheets coinmarketcap api tutorial coinmarketcap api excel binance binance exchange binance coin binance tutorial binance review ...

#