Topic: CoinTracking - Profit/Loss Portfolio and Tax Reporting for Digital Currencies - page 25. (Read 122619 times)
May 25, 2021, 02:02:49 PM
We need support for Polygon and Polkadot
May 18, 2021, 05:29:44 AM
Has anyone used Excel Power Query with the CoinTracking API, to import CT data into Excel?
I'm trying to set this up, but not sure how to meet the following requirements, from the CT documentation, using Power Query:
- Send your key and sign as http header.
- The sign is a HMAC-SHA512 message of the method, the nonce and the POST data, signed with your API secret.
- The nonce must be increasing for each call. We recommend to use UNIX time or microtime.
I've raised a ticket for this, but also posting here, in case other users have relevant experience.
I know we can use CryptoSheets, but I'd like to understand how to do this with Power Query.
I'm trying to set this up, but not sure how to meet the following requirements, from the CT documentation, using Power Query:
- Send your key and sign as http header.
- The sign is a HMAC-SHA512 message of the method, the nonce and the POST data, signed with your API secret.
- The nonce must be increasing for each call. We recommend to use UNIX time or microtime.
I've raised a ticket for this, but also posting here, in case other users have relevant experience.
I know we can use CryptoSheets, but I'd like to understand how to do this with Power Query.
May 18, 2021, 03:12:54 AM
@vampyz
To check that we would need a ticket/E-Mail ([email protected]) from you with your account username to check it individually.
To check that we would need a ticket/E-Mail ([email protected]) from you with your account username to check it individually.
May 18, 2021, 02:57:01 AM
Hello again, while trying to fix my cointracking account I noticed there might have been a few errors.
For one, when fixing my VEN to VET swap, I read the article posted about how to do that and it says to look under the "cost" in the Gains page and then enter an entry (trade) to show the 1:100 ratio swap and then enter the asset value of the original costs of your VEN. However, when I go to that table and look for VEN, it shows a 0.009 under the "remaining amount" column rather than what it actually should be. Should I use the "cost" amount under VET and input that amount in the asset values for buy/sell to show no gain/loss has happened??
(sorry if that was confusing)
My next question is, my VET dollar earnings under "Summary" shows almost double what it's actually worth right now. What would cause this and how would I go about fixing this?
For one, when fixing my VEN to VET swap, I read the article posted about how to do that and it says to look under the "cost" in the Gains page and then enter an entry (trade) to show the 1:100 ratio swap and then enter the asset value of the original costs of your VEN. However, when I go to that table and look for VEN, it shows a 0.009 under the "remaining amount" column rather than what it actually should be. Should I use the "cost" amount under VET and input that amount in the asset values for buy/sell to show no gain/loss has happened??
(sorry if that was confusing)
My next question is, my VET dollar earnings under "Summary" shows almost double what it's actually worth right now. What would cause this and how would I go about fixing this?
May 17, 2021, 04:02:50 PM
Thanks for the clarification Andreas. I thought there wouldn't be an issue with combining them into one entry, but I wanted to double check.
Exactly, however the exchange (oceanex.pro) isn't supported on cointracking. I tried importing CSV but it would never work.
Thanks again.
Exactly, however the exchange (oceanex.pro) isn't supported on cointracking. I tried importing CSV but it would never work.
Thanks again.
May 17, 2021, 04:15:43 AM
@scatterbug
Yes, but we focus on Top15 coins in terms of market cap first. Thank you for your patience here.
@vampyz
Yes you can combine those trades into one entry.
If an API provides those data we would import all of them separately as it has different TradeIDs.
Yes, but we focus on Top15 coins in terms of market cap first. Thank you for your patience here.
@vampyz
Yes you can combine those trades into one entry.
If an API provides those data we would import all of them separately as it has different TradeIDs.
May 17, 2021, 01:38:28 AM
Hello, I am currently wanting to input trades from an exchange that isn't supported, but I had a question about this. The CSV and other types of importing provides errors so I thought of just doing it myself.
My question is, sometimes 1 trade has multiple entries due to filling and what time it was filled at. Can I add all those entries for that 1 trade (adding the fees as well) and make one singular entry on cointracking?
Example: I buy place an order to buy 1 BTC and I have 5 entries (on the exchange) that say I got filled for .2 with a second or so in between.
Instead of manually inputting 5 entries for that 1 trade, I simply add all the entries (which will equal 1 BTC)and the corresponding fees. For the transaction time, I would take an average.
Thanks and I hope this wasn't confusing of a question
My question is, sometimes 1 trade has multiple entries due to filling and what time it was filled at. Can I add all those entries for that 1 trade (adding the fees as well) and make one singular entry on cointracking?
Example: I buy place an order to buy 1 BTC and I have 5 entries (on the exchange) that say I got filled for .2 with a second or so in between.
Instead of manually inputting 5 entries for that 1 trade, I simply add all the entries (which will equal 1 BTC)and the corresponding fees. For the transaction time, I would take an average.
Thanks and I hope this wasn't confusing of a question
May 16, 2021, 08:53:12 AM
@Andreas_CoinTracking
Do you plan to integrate a blockchain importer for the Polygon/MATIC network?
Do you plan to integrate a blockchain importer for the Polygon/MATIC network?
May 11, 2021, 03:09:56 AM
@theratears
We do not support this wallet yet. For now, you can enter the transactions either manually on the "Enter Coins" page, with the "Excel Import" (all transaction types are supported) or with the "Custom Exchange Import" (only trades, deposits, withdrawals are supported). Both are very flexible and customizable and data can be uploaded in a bulk action.
We do not support this wallet yet. For now, you can enter the transactions either manually on the "Enter Coins" page, with the "Excel Import" (all transaction types are supported) or with the "Custom Exchange Import" (only trades, deposits, withdrawals are supported). Both are very flexible and customizable and data can be uploaded in a bulk action.
May 11, 2021, 12:46:02 AM
Is there a way to add in a sollet.io wallet or track transactions on the solana network?
May 10, 2021, 05:25:37 AM
@Andreas_CoinTracking my question is already fully answered with your response. All clear and thank you very much!
May 10, 2021, 03:31:05 AM
@lifeiscrypto
@elwon20
Please send us a ticket or E-Mail to [email protected] with your username and description to check your accounts.
A fee that is part of a trade gets added to the buy or sell amount of the trade and is therefore already part of the cost base. These fees are also displayed in the fee field, which in turn feeds the Trading Fees page. The fee field does not reduce the purchase pool. Most countries do not allow to deduct these fees as they are already part of the cost base and therefore they are not listed in the tax report. Should you be allowed to deduct them, please get the total from the trading fees page (https://cointracking.info/fees.php) and do so manually.
In the case that the fee is in a different currency than the two coins traded or the fee for a withdrawal is in a different coin than the coin sent, these fees can not be included in the transaction and therefore an additional transaction is necessary to reduce the purchase pool. These "third currency coin fees" are imported as "other fee" and then in turn listed in the fee report of the tax report, because they are legal to be deducted from the capital gains.
@elwon20
Please send us a ticket or E-Mail to [email protected] with your username and description to check your accounts.
A fee that is part of a trade gets added to the buy or sell amount of the trade and is therefore already part of the cost base. These fees are also displayed in the fee field, which in turn feeds the Trading Fees page. The fee field does not reduce the purchase pool. Most countries do not allow to deduct these fees as they are already part of the cost base and therefore they are not listed in the tax report. Should you be allowed to deduct them, please get the total from the trading fees page (https://cointracking.info/fees.php) and do so manually.
In the case that the fee is in a different currency than the two coins traded or the fee for a withdrawal is in a different coin than the coin sent, these fees can not be included in the transaction and therefore an additional transaction is necessary to reduce the purchase pool. These "third currency coin fees" are imported as "other fee" and then in turn listed in the fee report of the tax report, because they are legal to be deducted from the capital gains.
May 09, 2021, 04:15:37 PM
Hi, this issue is still ongoing for me 😞
Woke up this morning and my Bitfinex balance was way off.
Deleted all Bitfinex transactions and re-imported them. Same thing.
Noticed the 'API v2' message for margin trades (which I have used in the past) and checked that box, deleted all transactions and re-imported them again... still way off.
Did something change recently?
Deleted all Bitfinex transactions and re-imported them. Same thing.
Noticed the 'API v2' message for margin trades (which I have used in the past) and checked that box, deleted all transactions and re-imported them again... still way off.
Did something change recently?
May 09, 2021, 08:14:53 AM
Hi,
Is this still true? https://cointracking.freshdesk.com/en/support/solutions/articles/29000018276-missing-fees-in-the-tax-report
I noticed a difference on this since I did my tax reports on 2019 and now, I see now as part of report a summary of all the fees.
Is this still true? https://cointracking.freshdesk.com/en/support/solutions/articles/29000018276-missing-fees-in-the-tax-report
I noticed a difference on this since I did my tax reports on 2019 and now, I see now as part of report a summary of all the fees.
May 09, 2021, 04:37:49 AM
@Nerome
We are focused in the Top15 blockchains first.
@asdsvsdf
not all crypto income is taxed the same way therefore we do not upload the income report as a whole. Please enter your income manually in the respective section of the tax form. You find them on the income report as part of your tax report.
We are focused in the Top15 blockchains first.
@asdsvsdf
not all crypto income is taxed the same way therefore we do not upload the income report as a whole. Please enter your income manually in the respective section of the tax form. You find them on the income report as part of your tax report.
May 08, 2021, 06:59:02 PM
in the Tax reports I know you can export trade data in Turbotax format. Does this include the income reports too (i.e. staking income, gifts, etc)? if not, how would I import this data into Turbotax if I had a lot of staking income transactions?
i.e. lets say I have ten staking income transactions for 100 FOO (fake coin for this example) each. I immediately sell FOO on income for USDC after every staking income transaction. As such, I have capital gains records in the TurboTax file for the trade, but is the income of 1000 FOO in total included in the Turbotax export too? If not, how do I report this income on my taxes/import the income specific transactions into Turbotax?
i.e. lets say I have ten staking income transactions for 100 FOO (fake coin for this example) each. I immediately sell FOO on income for USDC after every staking income transaction. As such, I have capital gains records in the TurboTax file for the trade, but is the income of 1000 FOO in total included in the Turbotax export too? If not, how do I report this income on my taxes/import the income specific transactions into Turbotax?
May 08, 2021, 10:22:10 AM
Hey there, is there any plan to add Fantom (FTM) network to blockchain support?
https://ftmscan.com/
https://ftmscan.com/
May 08, 2021, 03:40:10 AM
@danjacksonuk
thank you for the design input. I will share this with our team.
@asdsvsdf
All transactions before midnight are included in the date filter setting.
thank you for the design input. I will share this with our team.
@asdsvsdf
All transactions before midnight are included in the date filter setting.
May 08, 2021, 12:56:07 AM
[...] the manual cost basis for unlisted tokens is not saved between backups or exports [...]
I only notice this on exports, but not on backups.
I.e. when I enter a custom cost basis (be it for listed or unlisted coins) and make a backup, then restoring from that backup also restores the cost basis.
I have a few transactions with custom values myself, so I made sure the backups restore those values.
But just to be safe I rechecked just now to confirm:
- Added a trade to buy 23 YYY (unlisted coin) for 42 USD
- Entered a custom YYY buy value of 8.15 USD
- Saved a backup
- Deleted all trades
- Restored from backup
-> Custom value of 8.15 USD was also restored.
thank you for confirming this!!!
for any lurkers, I fixed my issues by basically going tx by tx on etherscan and comparing the 'State' tab on each transaction with my logs. This is much clearer to reason about so I recommend this if anyone else has balance issues
and of course thanks Andreas for the solutions and timing answer. Re: your quote about the cutoff time being midnight, this is 00:00:00 relative to entered trades?
May 07, 2021, 11:46:08 AM
Hi Andreas
I love doing graphic design work for fun. Done a little modernisation of the site. Have a look here. Best tracking site out there but is definitely dated design. Here is my design, not much different from what's already live
https://dl.dropboxusercontent.com/s/yz02pe802mylenj/CoinTracking%20SIte.jpg
I love doing graphic design work for fun. Done a little modernisation of the site. Have a look here. Best tracking site out there but is definitely dated design. Here is my design, not much different from what's already live
https://dl.dropboxusercontent.com/s/yz02pe802mylenj/CoinTracking%20SIte.jpg
Jump to: