search

eprbell / rp2

Privacy-focused, free, open-source cryptocurrency tax calculator for multiple countries: it handles multiple coins/exchanges and computes long/short-term capital gains, cost bases, in/out lot relationships/fractioning, and account balances. It supports FIFO, LIFO, HIFO and it outputs in form 8949 format. It has a programmable plugin architecture
https://pypi.org/project/rp2/
Apache License 2.0
270 stars 43 forks source link

Data element provenance #19

Closed stevendavis closed 2 years ago

stevendavis commented 2 years ago

I'm manually entering transaction data from multiple sources. It's not unusual for a single transaction to have data provided by multiple exchanges, quote lookup sources, or blockchain viewers. Sometimes after being away from the data for a few days, I look at the spreadsheet and find myself wondering what was the source of a particular data element.

I've added new columns in the spreadsheet for this purpose. For example: Timestamp, Timestamp Source, Spot Price, Spot Price Source, retc.

Maybe there is a better way to track this information. Any suggestions on a good way to keep track of the sources of the data elements?

eprbell commented 2 years ago

Custom columns (that RP2 skips) with whatever extra information you need are definitely OK. Also the Notes column can be used to provide additional context in English, if needed. Finally the unique_id can be used to provide unique identity for the transaction (e.g. hash or exchange-specific id), if you have this information.