Importing Coin Market Cap Data into an Excel Sheet

in cryptocurrency •  8 years ago  (edited)

Hello Steemit Community,

Someone asked me how I am able to import refreshable data from a website into an excel sheet. In this video I show you all how I import market cap and price data from the website 'CoinMarketCap.com' into excel in order to use it for further analysis.

Thanks You and Take Care,
McKenzie Gary

dd8bd8753d41da7.gif

cryptocurrency coinmarketcap technology blog video
8 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$6.56
  • Past Payouts $6.56
  • - Author $4.94
  • - Curators $1.62
32 votes
10
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  • Trending
    • [-]
      ·  8 years ago 

    This kind of post is gonna catch on. Nice informative vid. Sharing the heck out of this.

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      1 vote
      [-]
        ·  8 years ago 

      Thank you Jacob, I appreciate it!

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.00
        [-]
          ·  8 years ago 

        This is exactly how I do it as well. It's too bad that their sites tables are all screwed up, but I guess that beggars can't be choosers, right? LOL

        Also, how did you build that follow button?

        Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

        • Disagreement on rewards
        • Fraud or plagiarism
        • Hate speech or trolling
        • Miscategorized content or spam

        Submit
        $0.00
          1 vote
          [-]
            ·  8 years ago 

          If you have discord and have a moment to stop by the From The Ground Up Discord I'd be very happy to show you!

          Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

          • Disagreement on rewards
          • Fraud or plagiarism
          • Hate speech or trolling
          • Miscategorized content or spam

          Submit
          $0.00
            1 vote
            [-]
              ·  8 years ago 

            Thx!

            Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

            • Disagreement on rewards
            • Fraud or plagiarism
            • Hate speech or trolling
            • Miscategorized content or spam

            Submit
            $0.00
              [-]
                ·  8 years ago 

              Good job, thanks for the info!

              Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

              • Disagreement on rewards
              • Fraud or plagiarism
              • Hate speech or trolling
              • Miscategorized content or spam

              Submit
              $0.00
                [-]
                  ·  8 years ago (edited)

                Thank you

                Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                • Disagreement on rewards
                • Fraud or plagiarism
                • Hate speech or trolling
                • Miscategorized content or spam

                Submit
                $0.00
                  [-]
                    ·  8 years ago 

                  Great Job Gary, thanks for sharing the knowledge.Very helpful!

                  Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                  • Disagreement on rewards
                  • Fraud or plagiarism
                  • Hate speech or trolling
                  • Miscategorized content or spam

                  Submit
                  $0.00
                    [-]
                      ·  7 years ago 

                    Do you know how to download the historical data? On their charts, they list the price every five minutes. I want to access that 5-minute data so that I can calculate prices. For instance, if I traded BTC for LTC a week ago, I want to download the data for BTC for the 20 minutes or so which surrounds the time of the trade, find the nearest prices, do an average, do some calculations...
                    Thanks

                    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                    • Disagreement on rewards
                    • Fraud or plagiarism
                    • Hate speech or trolling
                    • Miscategorized content or spam

                    Submit
                    $0.00
                      [-]
                        ·  7 years ago 

                      Thank you very much!

                      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

                      • Disagreement on rewards
                      • Fraud or plagiarism
                      • Hate speech or trolling
                      • Miscategorized content or spam

                      Submit
                      $0.00