• Breaking News

    Tuesday, August 7, 2018

    Home Unlabelled Crypto Currency Markets Weekly Discussion Megathread - 06/Aug/2018

    Crypto Currency Markets Weekly Discussion Megathread - 06/Aug/2018

    August 07, 2018

    Crypto Currency Markets Weekly Discussion Megathread - 06/Aug/2018

    Weekly Discussion Megathread - 06/Aug/2018

    Posted: 06 Aug 2018 10:11 AM PDT

    Welcome to the /r/CryptoMarkets Weekly Discussion thread. The thread guidelines are as follows:

    The thread guidelines are as follows:

    • Discussion topics include, but are not limited to, events of the day, technical analysis, and minor questions.
    • Breaking news or other important content should be submitted as a separate post.
    • Cryptocurrency discussion not related to trading should be referred to the r/CryptoCurrency general discussion thread, see here.

    • Follow the golden rule and be excellent to each other.

    Resources and Tools:

    • Consider joining one of the r/CryptoMarkets chat groups, see here.
    • If you are using RES, please click the subscribe button below to be notified when new comments are posted.

    • To view live streaming comments for this thread, click here. Account permissions are required to post comments through Reddit-Stream.com.

    Thank you in advance for your participation. Enjoy!

    submitted by /u/AutoModerator
    [link] [comments]

    3,500 Bitcoin ATMs Are Now Available To Use Across The Globe

    Posted: 07 Aug 2018 10:41 AM PDT

    Strategic Investment in Tokenomy, DAEX Officially has a new Clearing Node in Southeast Asia!

    Posted: 07 Aug 2018 05:08 PM PDT

    I created a spreadsheet that automates pulling CoinMarketCap data, and segments the data by Top Gainers and Losers over various timeframes

    Posted: 07 Aug 2018 06:56 PM PDT

    TL;DR: I created a spreadsheet that automates pulling the entire 1,700+ library of cryptocurrencies from CoinMarketCap. You can find the spreadsheet here:

    https://www.dropbox.com/s/19l2bksgojeah4w/Pulling_CoinMarketCap_Data_into_Excel.xlsx?dl=1

    CoinMarketCap is the most popular cryptocurrency website in the world. With over 100M page views per month, the website is the go-to resource for cryptocurrency quotes and aggregated spot rates.

    While not a perfect solution (we all remember the removal of Korean exchanges event) it still represents the prime place to check cryptocurrency aggregated pricing.

    The Problem

    While CoinMarketCap does include historical pricing for each coin on it's website, they do not offer an "Export to CSV" option to easily transfer the data to an outside source (such as Excel, Google Sheets, etc.)

    Even then, the "Export" option brings a host of problems, such as:

    • No auto refresh option

    • Big potential for mistakes

    • Requirement to spot check the results

    Power users in Excel want the ability to analyze the data for their own trading strategies, but this becomes difficult and cumbersome with the current environment.

    A CoinMarketCap dashboard for Excel

    Here is a quick gif demonstrating the power of the dashboard

    We at Cryptosheets developed a simple, beautiful Excel dashboard utilizing the Cryptosheets add-in and CoinMarketCap data.

    The workbook features include:

    • Pulling all 1,700+ cryptocurrencies from CoinMarketCap directly into a worksheet

    • Name, symbol, rank, Price USD, Price BTC, 24h volume, Market cap, Available supply, Total Supply, Max supply, Percent change (1h, 24h, 7d), Last updated (timestamp, human-readable)

    • Automatic refresh of data down to every 5-min intervals

    • Automatic views of Top Gainers, Top Losers, segmented further down by time (last hour, last 24 hours) and market cap

    Since we place the data neatly into a worksheet, this gives the user further ability to perform any calculations they want.

    Services used:

    • Microsoft Excel (Excel 2016 for Windows or Mac, Excel Online)

    • Cryptosheets Add-in*

    Note*: The Cryptosheets add-in has a free tier that grants 100 requests per day. Each request equals 100 rows. The CoinMarketCap pull brings in around 1,700 coins, which equals 17 requests.

    If you find yourself hitting the request limit but want to continue using the add-in, send me a message and we can work something out. No one should be left in the dark.

    If you have Office 365, you are golden.

    Summary tab

    Example summary tab

    The summary tab is the re-creation of the CoinMarketCap front page. Here, you will see all of the coins listed, as well as a few selected metrics for a quick snapshot of the market.

    Statistics tab

    Example statistics tab

    The statistics tab contains a few interesting views that make it easy for the user to see what coins are making the most moves (both positive and negative).

    Top Gainers 1 Hour

    Example top gainers

    In the Statistics tab, you will find a ranking of the Top Gainers and Top Losers by the following time periods: 1 hour, 24 hours, and 7 days.

    How to use the dashboard

    Click here to download the workbook

    A note on security — the cryptocurrency industry is rife with corruption, hacks, etc. I know the hesitation in downloading an Excel workbook, so I recommend all users run files through an online virus checking service such as VirusTotal.

    Installing Cryptosheets to pull the data

    Click here and click the button "Get it now".

    Updating the data

    The worksheet uses the "Data" tab to pull in the 1,700+ tickers from CoinMarketCap.

    To pull the data, we will log into Cryptosheets, find CoinMarketCap, and export the data

    Here is a quick gif showing how to pull down data

    1. In the Cryptosheets ribbon, click Dashboard

    2. Login to the service through Google, or sign-up option

    3. Click the orange + button

    4. Click CoinMarketCap Tickers

    5. Click the Limit dropdown and choose All

    6. Click the Table Headers toggle

    7. Click into A1 of the "Data" tab, click Highlight Range, and Place Data

    8. Verify that data has updated

    9. You also have the option to choose a timed refresh interval. *Note — CoinMarketCap data refreshes no faster than once every 5 minutes

    After implementing, you will now have an auto-updating CoinMarketCap dashboard in Excel that gives 'at-a-glance' statistics to follow the big movers in the cryptocurrency space.

    Changing the statistics timeframe

    Click the links to see stats by different timeframes

    Changing the market cap

    Click the dropdown and change the market cap value

    Download the workbook

    Click here to download the workbook

    Resources

    Help: https://intercom.help/cryptosheets

    Pulling your first dataset into Excel

    How to pull OHLCV for thousands of cryptocurrencies directly into Excel

    Related Posts

    Financial Modeling for Cryptocurrencies: A CoinMarketCap Spreadsheet That Doesn't Suck

    Introducing Cryptosheets: Real-time Excel Add-in for Cryptocurrencies

    submitted by /u/1kexperimentdotcom
    [link] [comments]

    Bitcoin ETF Decision Postponed By SEC Until Sept 30th

    Posted: 07 Aug 2018 01:33 PM PDT

    Centralized crypto exchanges are the largest source of bad publicity crypto industry gets

    Posted: 07 Aug 2018 09:13 AM PDT

    Crypto exchanges are a single point of failure and so are a target for hackers.

    The issue with crypto exchanges is how transactions are cleared and settled via their platforms. As cryptocurrencies exist within an unregulated space, clearing and settlement cannot occur through traditional, regulated channels, making clearing and settlement risks abnormally high.

    Moreover, exchanges aren't willing to act as anything other than a third party that only arranges trades between buyers and sellers. This means that they are not a direct counterparty to every transaction that takes place and so are not bearing much responsibility for what takes place on their platforms.

    That is why I think we need blockchain-based decentralized clearing system and I am not sure why is almost nobody working on that (I only heard of a chinese team - daex.io that focuses on it) although it is one of the bottlenecks for adoption and one of the most frequent sources of bad publicity for crypto in general.

    submitted by /u/Hance1983
    [link] [comments]

    Bitmain investing $500 million in new Texas facility

    Posted: 07 Aug 2018 05:32 AM PDT

    U.S. SEC: We Will Make a Decision Regarding VanEck-SolidX Bitcoin ETF by 30 September 2018

    Posted: 07 Aug 2018 02:54 PM PDT

    "Our lives may run on smartphone devices, but WiFI access is the fuel."

    Posted: 07 Aug 2018 08:13 PM PDT

    Looking into a project called OIcoin - precious metal backed ERC20 Token

    Posted: 07 Aug 2018 08:56 AM PDT

    As a large part of my portfolio contains metals, I´m particulary interested in this project coming up called osmium investment coin. The Token itself doesn´t have much of a functionality besides a revenue share model, actually you take part in all the turnover of the global distribution. They kinda have a monopoly going on as the institution holds and produces almost everything of the global distribution, which pretty much means they influence the price and that´s my key factor why I´m looking into it right now. I also did my research on the institutions involved and from my findings it seems legit, still it sounds a bit too good to be true.

    With all the tokens being completely driven by hype right now we all know only a few with a real business behind will survive. Would love to hear your guys opinion if this project is legit and a good investment opportunity?

    submitted by /u/Papyhands
    [link] [comments]

    100,000 Motion $XMN Fund for Community development projects

    Posted: 07 Aug 2018 06:32 PM PDT

    SEC delays VanEck SolidX Bitcoin ETF decision

    Posted: 07 Aug 2018 04:13 PM PDT

    Swiss Bank Maerki Baumann Will Accept Cryptocurrency Firms as Clients

    Posted: 07 Aug 2018 07:07 AM PDT

    Invictus Hyperion Fund Investment Report

    Posted: 07 Aug 2018 11:26 AM PDT

    Ethereum Classic (ETC) shows upward trends, briefly becomes world's 10th largest token

    Posted: 07 Aug 2018 09:29 AM PDT

    Philippines SEC publishes new ICO regulations

    Posted: 07 Aug 2018 07:13 AM PDT

    ATMs Proliferate Across the Globe Despite Bitcoin ATM Fees – Currently Over 3,400

    Posted: 07 Aug 2018 01:25 PM PDT

    These Are the Best Cryptocurrency Debit Cards You Must Try in 2018

    Posted: 07 Aug 2018 01:00 PM PDT

    Bitcoin Cash Creator Banned from Bitcoin Cash Slack, Showing Need for Governance

    Posted: 07 Aug 2018 12:59 PM PDT

    CoolWallet S Integrates with ShapeShift to Give Users Trading Capabilities

    Posted: 07 Aug 2018 06:36 PM PDT

    CoolBitX's CoolWallet S is a revolutionary mobile cold storage hardware wallet for your Bitcoin, Litecoin, Ethereum, Ripple, Bitcoin Cash, and ERC20 Tokens. Custody over your cryptocurrency investment has never been more protected or convenient to use. Quickly store and send coins at any time, any location, and with anyone.

    Learn more at coolwallet.io, follow us on twitter at twitter.com/coolwallet, or ask us questions on their Telegram: t.me/CoolWalletS.

    submitted by /u/ManhattanMadMan
    [link] [comments]

    Coinbase ETC rollout final plan (apologies for the icon, speaks to my tech limitations)

    Posted: 07 Aug 2018 06:08 PM PDT

    Scaling Po.et to Millions of Users – Po.et Blog

    Posted: 07 Aug 2018 11:55 AM PDT

    Korean Exchange UPbit Cleared of Manipulating Balance Sheets and Trading Volumes

    Posted: 07 Aug 2018 08:05 AM PDT

    A Case For Crypto: Banks Could Share Your Info With Facebook In The Future

    Posted: 07 Aug 2018 06:51 AM PDT

    Thai Banks Are Now Allowed To Invest In Digital Assets

    Posted: 07 Aug 2018 07:42 AM PDT

    Undiscovered Treasures: Top 5 Undervalued Coins With Huge Potential | TechBullion

    Posted: 07 Aug 2018 03:07 PM PDT
    Read more
    at

    No comments:

    Post a Comment