Githubyasinkuyubinancetradercryptocurrency trading bot for binance exp
Click on the small grey box with two arrows pointing in opposite directions next to "Column1" and press OK. Here you can select what info do you want excel to load. I personally load all of them as you can later retreive any data you want from this source. A new worksheet will be created. Rename it to "CMC". Now create a new module as shown below. Now it's all set. The code above added a custom function to excel. You can now retrieve the price of any coin registered on Coinmarketcap.
Let's say you track the value of your crypto holdings in this worksheet and you have one bitcoin:. But now you just bought 2 Ethereum and want to add it tho the table. Just select and drag the cells as following: And change the refence name to ETH: You can add as many crypto as you want.
I've uploaded an example workbook to google drive. Remember to save your workbook as a macro enabled workbook or else the macro will not be saved.
I've created variants of the custom function for data other than price. Paste the function you want in the module window as we did with the price function. For the coin rank on CMC: For the coin price in BTC: For the trading volume in the last 24h: For the market cap: For the available supply: If you're a masochist like me, you like to use Excel to manage your portfolio.
The amount of customization and control is simply unparalleled. I can see nice graphs and visual aids that show me which of my altcoin investments are growing most, track my fiat conversions, and so much more, but typing in all those prices, market caps, and stats is a pain. Here I'm going to show you how to pull live data from two different websites so that you too can make the Excel spreadsheet of your dreams.
I'm going to go over two different sites that provide formatted data "tickers" that are meant for exactly this purpose. You've probably used coinmarketcap before, but maybe you didn't know that they have a very comprehensive API you can use for tracking live stats on all their coins. Below are some examples of the type of optional parameters you can use to limit the amount of top coins you get and convert to a different fiat currency.
Unfortunately, pulling multiple coins means they are sorted by coin rank based on market cap. That means the order of coins changes , and we can't have that in our Excel file if we want to use simple cell references. The way around this is to add specific coins one at a time.
To see a specific coin, use: Note that we can use the "? The official documentation can be found at https: One thing we can do with Coincap is see the history of the coin. To see the history over 1 day for Bitcoin, we would use:. They just disppear from the miner, and mine on card. I apologize for the late response I'm back home after a week in Cgwatcher dogecoin pool for the Bitcoin Conference, and now I have a few weeks to pack everything and move to Los Angeles.
We've created a new support forum at http: Hi, milone, sorry for late answer, the cgwatcher app wolder was in c: Still the same See my log files Thx and sorry for my bad english. Mikk36 on January 23,Ntrain2k on January 26,Vyker on January 28,This wasn't really about just buying the software This has come up several times today so I'll explain in a little more detail what happened and what users can expect. They contacted me and asked if I'd like to be able to work on them full-time and have whatever resources I needed a software developer's dream.
I am still in control of all software, though being users of the software themselves, the guys had some great ideas I'll be cgwatcher dogecoin pool more about soon. Nothing was forced on me or the software - no fine print - no catches - no instant monetization plans. CGWatcher will still be free and will continue to be updated regularly cgwatcher dogecoin pool the foreseeable future. If updates stop it will be because we have something better to offer in its place.
CGRemote will continue the path it has already been on So right now the only thing that changes is that I'll have more time, more resources, and cgwatcher dogecoin pool ideas.
I've been approached in the past with similar proposals In the coming months, I think the users will also be very happy with the cgwatcher dogecoin pool.
We have some very interesting plans for the future There was definitely an agreement drawn up and signed Just not fine print that snuck in anything bad. I was working at a company that made store displays e. February cgwatcher dogecoin pool,Hey is there anyway to tweak individual device settings when devices don't the act properly with certain settings.
I can see for example one drillbit device that doesn't like the settings I've got set for it and I'd like to be able to tell it to not use those commands on this device if it doesn't pop up right away or be able to set other options to it in the device area and change it for next restart. Thanks Edit also,I have to ask if there's a way to specify which pool is mining what since I thought there was some kind of profitability monitor to switch pools in here and I don't want to make a new config file for each and make sure each is running.
Hey just giving a quick heads up that cgwatcher is showing that a bitcoin pool is mining a different coin in the most recent update. It says btcguild is mining bytecoins. Projects that show humanity, kindness, generosity.
Among an ocean of get rich quick schemes, scams, pumps and dumps, this is the only coin which has a community centered on the positive things that crypto-currency can do. Follow reddit's content policy.
No promotion of adult content allowed. Spammy, unsolicited and sneaky referrals may be removed without notice. If you need an exception from a rule for a specific reason send a message to the mods to discuss.
CGWatcher sees the card, and it will take values set in the cgwatcher dogecoin pool, but cgwatcher dogecoin pool I try to change settings in cgminer like intensity it won't do anything.
I wasn't indicating which GPU to adjust settings for in cgwatcher dogecoin pool. Is there something I'm doing wrong?