Jump to content

Export csv for taxes


bitcoinranger

Recommended Posts

@gregor Thanks a lot if been waiting for this functionality!

It is in plain sight if you know where to look. The fields are Time,TX hash,Type,Amount,Currency,Currency Issuer Address,Currency Issuer Name,Balance.

Performance was really good I exported transactions from 1-1-201x to 31-12-201x within seconds, but I'm not actively trading so there is not a lot to export.

Link to comment
Share on other sites

12 hours ago, ThomasTheTGV said:

@gregorWhile testing I noticed you have separated the column Time with comma's between date, year and time. 

2017-09-16_0005.png.b1fa2ec615b07a791d417a1d877a560f.png

If I import the csv in excel and use comma as the separator, this places the headers on the wrong column.

2017-09-16_0006.png.64922d77e21f43f244d317bf63a57c83.png

Solution use semicolon as separator for the headers.

There is an option that treats text between two quotation marks as one column (in this case comma won't "split" the column in two columns).

@gregor, maybe you could output dates and times in ISO 8601 format with timezone. Your date/time format is non-standard and cannot be easily parsed, sorted, etc.

Link to comment
Share on other sites

56 minutes ago, T8493 said:

There is an option that treats text between two quotation marks as one column (in this case comma won't "split" the column in two columns).

@gregor, maybe you could output dates and times in ISO 8601 format with timezone. Your date/time format is non-standard and cannot be easily parsed, sorted, etc.

Even though one can use commas in CSV between double-quotes, personally I think it is a bad idea to do that as well as date formats with months in letters (like "Dec", "Sep" etc.). Date and time in separate columns in formats like 2017-12-14 and 13:14:59 respectively (with seconds and no time zone info needed as it should be in UTC). That way if one needs ISO date, with some column concatenation it is easy to get ISO date in Excel.

Edited by velmet
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...