RE: Cryptocurrency Spreadsheet

You are viewing a single comment's thread from:

Cryptocurrency Spreadsheet

in cryptocurrency •  8 years ago 

It looks like you're using semi colons instead of commas in those quotations right after USD.

cryptocurrency
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
$0.00
    4
    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 

    Here is what I get with commas:

    JSON2 - 2017-05-04_153109.jpg

    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 

      Alright change that back. It looks like its being flagged because you're missing parentheses after JSON. Put one after JSON and then one after Headers"
      You should just be able to copy and paste this into the cell
      =VALUE(ImportJSON("https://min-api.cryptocompare.com/data/price?fsym=BTC&tsyms=USD","/USD","noHeaders"))

      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 

        No, parentheses are OK. I suspect this version of Excel is pure garbage :(

        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 

          Oh I didn't even notice it was excel. I'm using Google Sheets. Not sure about fixing it in excel, should work in Sheets just fine. Sorry about the confusion

          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