Transcalc FAQ


What would you like to know about Transcalc – capital gains and tax calculator?

What does Transcalc do?
Transcalc allows you to calculate the profitability of finance transactions. If you trade stocks, ETFs or crypto-currencies, Transcalc can show you which transactions were good or bad.
Why do I need this
Transcalc measures portfolio performance which is the quality control of your investment decisions and allows you to assess how good or bad you invested your money.
What data do I need to calculate the profitability of transactions?
You need a file (preferably CSV) with information about transactions you made, among them, the date of the transaction, buy or sell price and amount of goods. Most trading brokers allow you to generate and export such a file. It should be a text file with clear columns containing your transaction data. See the manual for an example
I cannot export a CSV file with my transactions.
Usually, the trade broker allows you to export the transaction list in other formats. If this is an editable format, e.g. MS Excel or a text file (txt), the conversion to CSV can be done automatically, provided the file contains all necessary data. Other formats, like XML or PDF, will require some programming knowledge. If your transaction list is not long, it may be easier to manually enter the transaction into a spreadsheet and export it to a CSV file.
Is it possible to calculate the cost of my transactions?
Yes, Transcalc estimates the cost of your transaction based on the information in your data about commission or provision. If this data is not available, you can specify the provision as a percentage of your transaction. If you are a day trader or a short-term investor, you may be surprised by how high the aggregated cost of your transactions are.
Is it possible to calculate a capital gain tax?
Transcalc allows you to estimate the tax from capital gains using the FIFO or LIFO method. However, this is only an estimation as the tax depends on many other factors not included in an imported transaction file.
Can I track my investment portfolio in real-time?
No. Transcalc shows the profitability of the positions which are already closed. It doesn’t evaluate open positions against current equity prices from stock exchanges. This tool calculates the performance of longer-term investments.
Is my data safe? Do other users can access my transaction?
TransCalc implements security mechanisms prevent other users from accessing your data, e.g. it uses secure protocol (SSL) to send your data from your computer to the server. TransCalc also generates a temporary user account for you which is separated and inaccessible from other user accounts. Your data is stored in a database and attached to your temporary account while you browse your portfolio performance. After about 10 minutes of your inactivity, your transaction data is removed from the database. Thus, no user can access your data either during its transmission or its temporary storage. The database keeps information about your import profiles, which allows you easily import your transaction when you use TransCalc again.