Approach 1 Show NA for missing items

enter image description here

Approach 2 Show - sign for missing items enter image description here

I have a table that displays crypto prices, volume etc. There are often times when I don't have data in a particular column. I tried 2 approaches

  1. Show 'NA' for missing items
  2. Show '-' for missing items

What is the right way to do this? Thank you for your answers in advance

1 Answer 1


Why don't you have the relevant information? If there aren't any trades the volume is just 0.

Edit: let me explain myself a bit more clear as I did in the comments. You would have to check if you are dealing with financial data why you don't have any value there, since the crypto markets are always open. I see two possibilities, the first being there is a technical error and for some reason you are unable to retrieve the most recent data. The second one is that the API doesn't offer you new data for that time period. I you don't have values for the Volume column, that means that there were no trades so it defaults to zero. Same goes for percentage change etc. I would ask myself WHY you aren't getting any data. It would be useful to include the table headers here.

  • 2
    There's a difference between Zero and 'no information' though.
    – JonW
    Jan 5, 2018 at 10:27
  • 1
    Your answer does not answer the question, as it is incorrect. Zero can not be represent missing data as zero is a value, whilst missing information is literally nothing. Jan 5, 2018 at 11:38
  • Not exactly true if this is financial data. Some APIs do not provide any data if there was no change, ie if there was no trading volume or the value was unchanged. Jan 5, 2018 at 11:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.