Hi Nitrous,
wanted to write you yesterday but didn't find the time to do so..
One problem occured in the field price when i looked at the data:
...
i remember that in the BigQuery table you had to divide the price field by 10.000. Here something seems to have gone wrong you know what?
The field Volume i divided by 100.000.000 for adjusting to full coins, might something similiar have happened in this field too?
Bye
Edit: I just saw that the .csv you script created is fine, it must have happened during import to Excel. Do you have an idea what might have caused this?
wanted to write you yesterday but didn't find the time to do so..
One problem occured in the field price when i looked at the data:
...
i remember that in the BigQuery table you had to divide the price field by 10.000. Here something seems to have gone wrong you know what?
The field Volume i divided by 100.000.000 for adjusting to full coins, might something similiar have happened in this field too?
Bye
Edit: I just saw that the .csv you script created is fine, it must have happened during import to Excel. Do you have an idea what might have caused this?
Hi BNO, Excel gets stranger and stranger!
I just did a test CSV export myself and the CSV is definitely fine, I'm not sure how or why excel is mangling the data like this. Dividing one column by 1e8 should not affect any other column, especially as inconsistently as the price column seems to be being affected :S What is the exact procedure by which you imported the data into excel?