Namebase account transaction history CSV

We've long had an API to export every action that has modified your HNS balance, but now you can download that same data in CSV form! It has less information but most of what you'd probably want. This is just your HNS account, will add support for USD/BTC balance history soon.

Additional note: it will include the most recent 50k actions. If you have more than this then you should probably be using the API and not using a CSV, but if enough people feel strongly about this we can up the limits.

Comments
8
anthony.namebase/
1 points

P.S. We'll expose a UI for this soon but the backend was done so I thought I'd share early

anthony.namebase/
1 points

Oops link is broken since it starts with http, try this:

brob/
1 points

This is a start but still missing a key piece of information that people will need in order to use this for taxes. Should add a column for "HNS Price" at time of "timestamp" and/or "USD Equivalent" of amount shown in "hnsDelta" column. Otherwise people need to reconcile this information on their own by looking up the price in order to figure out cost basis for every single transaction which is very labor intensive for active users of the platform.

anthony.namebase/
0 points

I agree this would be a good addition. Realistically, this probably will not happen in time for tax season this year. I recommend:

1. Create a new column that parses the timestamp into a date
2. Create a new sheet with the HNS price each day (only needs to happen once, and the community can share this with each other).
3. Do some Google sheets/Excel magic to pull in the HNS price corresponding to the date of each transaction.

brob/
0 points

Yes I agree that's what one would have to do to reconcile on their own.

I found an excel plugin called Cryptosheets that allegedly has a function to pull the price of any crypto based on a date, however, I'm having trouble getting it to work. Perhaps others will have better luck or a different solution.

faltrum/
1 points

I apreciate it a lot. I will wait the UI. One question, Will can see a finance balance about bought, sell, mining fee, Namebase fee, etc?Thnks

anthony.namebase/
0 points

The CSV is just a transaction log, but it should be pretty easy to make a formula in excel that sums up all the transactions at each row to see the balance at a particular point in time. Is that what you're wondering?

easycat/
0 points

I'm using the API and would just like to filter a list showing just the domains I won the auction on.

I hope just filtering the transaction type would do it but can't figure which of the options would suit? e.g. redeemBid, revealBid etc

Any suggestions would be appreciated and sorry if I'm being naïve.