Using Bitcoin Data in Python. Getting Started with the

30sec, 1min, 3min, 5min .csv historical data? /r/Bitcoin

30sec, 1min, 3min, 5min .csv historical data? /Bitcoin submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Does anyone have a raw text file (CSV) with historical bitcoin price data accurate to the hour? /r/BitcoinMarkets

Does anyone have a raw text file (CSV) with historical bitcoin price data accurate to the hour? /BitcoinMarkets submitted by BitcoinAllBot to BitcoinAll [link] [comments]

For Cold and Warm Bitcoin Blockchain Game I need historic block header data in ASCII, CSV or json format /r/Bitcoin

For Cold and Warm Bitcoin Blockchain Game I need historic block header data in ASCII, CSV or json format /Bitcoin submitted by BitcoinAllBot to BitcoinAll [link] [comments]

For Cold and Warm Bitcoin Blockchain Game I need historic block header data in ASCII, CSV or json format

Promise is promise. I have promised my students to come with Cold and Warm Bitcoin Game, based on Bitcoin Blockchain block header data, as soon as possible but it took me already months since I am stuck making efforts to download historic block header data in ASCII format, to be entered into mining simulator. A student should play cold and warm game entering his guess nonce as input to let mining algorithm (block hashing) to verify his lucky number.
Other students having known the winning nonce should give him/her commands cold or warm, colder, warmer, hot.
Block number should be random selected and nonce should be entered by a slider
There are many websites offering API to block explorer service but none is known to me to let me download full Bitcoin blockchain historic header data.
For the most services, nonce is missing or is set to "0" by default.
I would greatly appreciate your help and advice.
submitted by GlobalInnovator to Bitcoin [link] [comments]

Tool for calculating the USD value of staking income for a particular address and timeframe

Hey Tezos community,
Is there a tool I can point at a Tezos address that will tell me the cumulative USD staking income for that address over a specified timeframe?
Tax day in the US is coming up, and I need to report my staking income in terms of the USD market price of XTZ at the time of each reward.
I looked briefly at a couple tools, including bitcoin.tax and koinly.io, but didn't see an easy way to calculate my staking income. In theory it should be simple - you just need historical XTZ prices and a transaction history like any Tezos explorer provides - so I'm guessing the tool is out there, somewhere.
Thanks!
UPDATE 2020 June 29: I ended up downloading historical XTZ / USD prices as a CSV from https://coinmetrics.io/community-network-data/ and my wallet histories as CSVs from https://tzkt.io/. Then I did the analysis in a Google Colab. I didn't find any online tools that worked for me, despite the comments below.
submitted by emchristiansen to tezos [link] [comments]

Help me decode this Coinbase Bitcoin dataset

I finally found a free source for historical 1-minute-or-better Bitcoin price data. This data is supposedly from the Coinbase exchange. Here are the first 10 lines from the CSV:
1417412036,300.000000000000,0.010000000000 1417412423,300.000000000000,0.010000000000 1417415048,370.000000000000,0.010000000000 1417416612,370.000000000000,0.026555540000 1417498166,377.000000000000,0.010000000000 1417517949,377.750000000000,0.250000000000 1417517949,378.000000000000,3.750000000000 1417518257,378.000000000000,4.900000000000 1417518340,378.000000000000,5.200000000000 1417545780,378.000000000000,0.100000000000
Here are the last 10 lines from the CSV:
1546898806,4005.990000000000,0.011924900000 1546898807,4006.000000000000,0.004597620000 1546898807,4006.000000000000,0.003690980000 1546898808,4006.000000000000,0.008201680000 1546898809,4005.990000000000,0.007748090000 1546898809,4006.000000000000,0.075850860000 1546898812,4006.000000000000,0.011924980000 1546898814,4005.550000000000,0.075015730000 1546898815,4005.990000000000,0.012918520000 1546898819,4005.990000000000,0.025079380000
My best guess is the first column is some sort of time/tick, the second column is the price (it goes up to the 19000's as expected, but did the price did to 4000 recently?), and the third column is the order quantity. There are 56.6 million lines in this CSV. I'd like to figure out how to turn the first column into an actual data/time. My guess is it's in seconds, since there are multiple orders with the same number in the first column later in the CSV. Which is fine, I can average all the lines with the same time index, but anyone have a clue how to get the date out of it? I see Coinbase starting trading in late 2012, but why do these numbers start at 1.4 billion?
submitted by Skycks to Bitcoin [link] [comments]

US Tax Guide for ETH and other cryptocurrencies

Introduction:  
Greetings, fellow ethtraders! Happy New Year! In the next few months, taxpayers across the US will be filing their 2017 tax returns. As an Enrolled Agent and a ETH/cryptocurrency investor and enthusiast, I wanted to write up a brief guide on how your investments in ETH and other cryptocurrencies are taxed in the US.
 
 
1. Are ETH/cryptocurrency realized gains taxable?
Yes. The IRS treats virtual currency (such as cryptocurrency) as property. That means if you sell ETH, BTC, or any other cryptocurrency that has appreciated in value, you have realized a capital gain and must pay taxes on this income. If you held the position for one year or less, it is a short-term capital gain which is taxed at your ordinary income tax rate. If you held the position for more than one year, it is a long-term capital gain which is taxed at your long-term capital gains tax rate. In most cases, this is 15%, but could also be 0% or 20% depending on your specific ordinary income tax bracket.
 
2. If I sell my ETH for USD on Coinbase but do not transfer the USD from Coinbase to my bank account, am I still taxed?
Yes. The only thing that matters is that you sold the ETH, which creates a taxable transaction. Whether you transfer the USD to your bank account or not does not matter.
 
3. If I use my ETH to buy OMG or another cryptocurrency, is this a taxable transaction?
Most likely yes. See #4 below for a more detailed explanation. If assuming crypto to crypto trades are not able to be like-kind exchanged, then continue on to the next paragraph here.
This is actually two different transactions. The first transaction is selling your ETH for USD. The second transaction is buying the OMG with your USD. You must manually calculate these amounts. For example, I buy 1 ETH for $600 on Coinbase. Later on, the price of 1 ETH rises to $700. I transfer that 1 ETH to Bittrex and use it to buy 37 OMG. I have to report a capital gain of $100 because of this transaction. My total cost basis for the 37 OMG I purchased is $700.
 
4. If I use my ETH to buy OMG or other cryptocurrency, could that be considered a tax-free like-kind exchange?
Probably not. The new tax law says that like-kind exchanges only pertain to real estate transactions. This was done with Section 13303, which replaced “property” with “real property” for all of Section 1031 (page 72 near the bottom). My personal interpretation:
In 2018 and going forward, cryptocurrencies can definitely not be like-kind exchanged.
In 2017 and before, it is a very gray area. I personally am not taking the position that they can be like-kind exchanged, because if the IRS went after a taxpayer who did this, the IRS would probably win and the taxpayer would owe taxes, interest, and probably penalties on every single little gain made from trading one cryptocurrency for another.
Here is a great interpretation of why trading cryptocurrency for cryptocurrency is probably not a like-kind transaction.
In my opinion, the biggest factor is that like-kind exchanges must be reported on Form 8824 and not just ignored. Therefore, if a taxpayer is claiming like-kind exchanges on crypto to crypto exchanges, he or she would have to fill out a Form 8824 for each individual transaction of crypto to crypto, which would be absolutely cumbersome if there are hundreds or thousands of such trades.
Here is another article about like-kind exchanges.
Here is the American Institute of CPAs' letter to the IRS, dated June 10, 2016, asking them to release guidance on whether crypto to crypto can be like-kind exchanged or not. The IRS has not responded to the letter.
 
5. How do I calculate the realized capital gain or loss on the sale of my cryptocurrency?
The realized gain or loss is your total proceeds from the sale minus what you purchased those positions for (your cost basis). For example, you bought 1 ETH for $300 in June of 2017. In December of 2017, you sold that 1 ETH for $800. Your realized gain would be $800 - $300 = $500. Since you held it for one year or less, the $500 would be a short-term capital gain taxed at your ordinary income tax rate.
 
6. Which ETH's cost basis do I use if I have multiple purchases?
The cost basis reporting method is up to you. For example, I buy my first ETH at $300, a second ETH at $530, and a third ETH at $400. Later on, I sell one ETH for $800. I can use:
FIFO (first in first out) - cost basis would the first ETH, $300, which would result in a gain of $500.
LIFO (last in first out) - cost basis would be the third ETH, $400, which would result in a gain of $400.
Average cost - cost basis would be the average of the three ETH, $410, which would result in a gain of $390.
Specific identification - I can just choose which coin's cost basis to use. For example, I can choose the second ETH's cost basis, $530, which would result in the lowest capital gains possible of $270.
 
7. If I end up with a net capital loss, can I claim this on my tax return?
Capital gains and capital losses are netted on your tax return. If the net result of this is a capital loss, you may offset it against ordinary income on your tax return, but only at a maximum of $3,000 per year. The remaining losses are carried forward until you use them up.
 
8. What is the tax rate on my capital gains?
If long-term, the tax rate is 0%, 15%, or 20%, depending on your ordinary income tax bracket. If short-term, the tax bracket you’ll be in will depend on your total income and deductions. The ordinary income tax brackets are 10%, 15%, 25%, 28%, 33%, 35%, and 39.6% in 2017 and 10%, 12%, 22%, 24%, 32%, 35%, and 37% in 2018 and going forward.
Here are the 2017 and 2018 ordinary income tax brackets.
Here are the 2017 and 2018 long-term capital gains tax brackets.
Here is a detailed article on how the calculation of long-term capital gains tax work and how you can take advantage of the 0% long-term capital gains rate, if applicable.
 
9. If I mine ETH or any other cryptocurrency, is this taxable?
Yes. IRS Notice 2014-21 states that mining cryptocurrency is taxable. For example, if you mined $7,000 worth of ETH in 2017, you must report $7,000 of income on your 2017 tax return. For many taxpayers, this will be reported on your Schedule C, and you will most likely owe self-employment taxes on this income as well. The $7,000 becomes the cost basis in your ETH position.
 
10. How do I calculate income for the cryptocurrency I mined?
This is the approach I would take. Say I mined 1 ETH on December 31, 2017. I would look up the daily historical prices for ETH and average the high and low prices for ETH on December 31, 2017, which is ($760.35 + $710.12) / 2 = $735.24. I would report $735.24 of income on my tax return. This would also be the cost basis of the 1 ETH I mined.
 
11. Can I deduct mining expenses on my tax return?
If you are reporting the income from mining on Schedule C, then you can deduct expenses on Schedule C as well. You can deduct the portion of your electricity costs allocated to mining, and then you depreciate the cost of your mining rig over time (probably over five years). Section 179 also allows for the full deduction of the cost of certain equipment in year 1, so you could choose to do that if you wanted to instead.
 
12. If I receive ETH or other cryptocurrency as a payment for my business, is this taxable?
Yes. Similar to mining, your income would be what the value of the coins you received was. This would also be your cost basis in the coins.
 
13. If I received Bitcoin Cash as a result of the hard fork on August 1, 2017, is this taxable?
Most likely yes. For example, if you owned 1 Bitcoin and received 1 Bitcoin Cash on August 1, 2017 as a result of the hard fork, your income would be the value of 1 Bitcoin Cash on that date. Bitcoin.tax uses a value of $277. This value would also be your cost basis in the position. Any other hard forks would probably be treated similarly. Airdrops may be treated similarly as well, in the IRS' view.
Here are a couple more good articles about reporting the Bitcoin Cash fork as taxable ordinary income. The second one goes into depth and cites a US Supreme Court decision as precedent: one, two
 
14. If I use ETH, BTC, or other cryptocurrency to purchase goods or services, is this a taxable transaction?
Yes. It would be treated as selling your cryptocurrency for USD, and then using that USD to purchase those goods or services. This is because the IRS treats cryptocurrency as property and not currency.
 
15. Are cryptocurrencies subject to the wash sale rule?
Probably not. Section 1091 only applies to stock or securities. Cryptocurrencies are not classified as stocks or securities. Therefore, you could sell your ETH at a loss, repurchase it immediately, and still realize this loss on your tax return, whereas you cannot do the same with a stock. Please see this link for more information.
 
16. What if I hold cryptocurrency on an exchange based outside of the US?
There are two separate foreign account reporting requirements: FBAR and FATCA.
A FBAR must be filed if you held more than $10,000 on an exchange based outside of the US at any point during the tax year.
A Form 8938 (FATCA) must be filed if you held more than $75,000 on an exchange based outside of the US at any point during the tax year, or more than $50,000 on the last day of the tax year.
The penalties are severe for not filing these two forms if you are required to. Please see the second half of this post for more information on foreign account reporting.
 
17. What are the tax implications of gifting cryptocurrency?
Small gifts of cryptocurrency do not have a tax implication for the gift giver or for the recipient. The recipient would retain the gift giver's old cost basis, so it could be a good idea for the gift giver to provide records of the original cost basis to the recipient as well (or else the recipient would have to assume a cost basis of $0 if the recipient ever sells the cryptocurrency).
Large gifts of cryptocurrency could start having gift and estate tax implications on the giver if the value exceeds more than $14,000 (in 2017) or $15,000 (in 2018) per year per recipient.
Here's a good article on Investopedia on this issue.
An important exception applies if the gift giver gives cryptocurrency that has a cost basis that is higher than the market value at the time of the gift. Please see the middle of this post for more information on that.
 
18. Where can I learn even more about cryptocurrency taxation?
Unchained Podcast: The Tax Rules That Have Crypto Users Aghast
IRS Notice 2014-21
Great reddit post from tax attorney Tyson Cross from 2014
 
19. Are there any websites that you recommend in helping me with all of this?
Yes - I have used bitcoin.tax and highly recommend it. You can import directly from an exchange to the website using API, and/or export a .csv/excel file from the exchange and import it into the website. The exchanges I successfully imported from were Coinbase, GDAX, Bittrex, and Binance. The result is a .csv or other file that you can import into your tax software.
I have also heard good things about cointracking.info but have not personally used it myself.
 
20. Taxation is theft!
I can't help you there.
 
 
That is the summary I have for now. There have been a lot of excellent cryptocurrency tax guides on reddit, such as this one, this one, and this one, but I wanted to post my short summary guide on ethtrader which hopefully answers some of the questions you all may have about US taxation of ETH and other cryptocurrencies. Please let me know if you have any more questions, and I’d be happy to answer them to the best of my ability. Thank you!
Regarding edits: I have made many edits to my post since I originally posted it. Please refresh to see the latest edits to my guide. Thank you.
 
Disclaimer:
The information contained within this post is provided for informational purposes only and is not intended to substitute for obtaining tax, accounting, or financial advice from a professional.
Any U.S. federal tax advice contained in this post is not intended to be used for the purpose of avoiding penalties under U.S. federal tax law.
Presentation of the information via the Internet is not intended to create, and receipt does not constitute, an advisor-client relationship. Internet users are advised not to act upon this information without seeking the service of a tax professional.
submitted by Nubboi to ethtrader [link] [comments]

Is there a bitcoin historical database where I can input exact time and get amount it was at that time?

submitted by MeditateErrDay to Bitcoin [link] [comments]

BitcoinTaxes Podcast: Crypto Audits w/ Alex Kugelman

BitcoinTaxes Podcast Link
TLDR; Alex Kugelman, a tax controversy lawer, discusses crypto audits and how to avoid them.
Highlights:
IRS audits are a real possibility for anyone who has traded cryptocurrencies. Our guest today is Alex Kugelman, a tax controversy lawyer with an abundance of knowledge concerning cryptocurrency audits. He's here to share his expertise on IRS cryptocurrency audits, including risk reduction strategies as well as enforcement predictions and misconceptions.
Alex Kugelman specializes in IRS audits. His experience includes four years of Federal government court experience at the U.S. Tax Court and a U.S. District Court. [00:40]
Alex: I'm an attorney out in California. I clerked for a US District Court judge and as well as the United States Tax Court. I've been in private practice exclusively doing tax controversy work for the past five years or so. I kind of got involved with crypto towards the end of 2016. I tended to represent clients mainly with compliance & disclosure issues with respect to cryptocurrency. I just really like it. Really interesting area.
The Coinbase summons in 2018 played a major role in Alex's interest in crypto audits. [01:19]
Alex: What started me into the crypto space was when the IRS first issued summons for Coinbase. We started getting some interesting calls regarding that. And at that time I thought to myself, this might be an interesting area. So I started following the actual summons enforcement proceeding at the District Court here in San Francisco - from there kind of worked with people under different types of compliance, including international disclosures. Now we're starting to see some of the first cryptocurrency audits come through.
First, let's get a brief rundown of how IRS audits work. [02:00]
Alex: It is important to understand the IRS as an administrative agency and all different layers of it. So when it comes to an audit the term that the IRS uses is an examination and there's three basic levels.
The first is a correspondence exam. That's where you get a letter that says, dear taxpayer, so-and-so reported that you had $100 of interest income that wasn't on your tax return - we're going to increase your tax. If you want to challenge that, you can. And that's basically termed an under reporter notice. That's probably not going to be a cryptocurrency audit if you get that notice.
The next one is an office exam. That is someone in the local IRS office sending you a letter that says, we have selected a certain tax return for audit and we're going to look at these issues. We'd like you to call us to schedule an appointment. That's going to be usually a tax compliance officer that is doing that.
The third and probably the most serious level of exam is a field examination. That's also going to be a local IRS representative, typically a revenue agent. There, the revenue agent may come to your work or ask come to your work or business to kind of conduct the audit.
All three of those are going to start the same: a letter that's sent to you at your most recent address provided to the IRS.
Cryptocurrency audits follow a similar protocol. [05:40]
Alex: I think it's likely that most crypto audits are going to start with one of two things happening. One is that there is information from the Coinbase summons that is inconsistent with what was on a taxpayer's tax return. I think for someone who's involved with that issue, they're going to have a good sense of that one because they should've gotten an email notice from Coinbase.
Or two, the audit notice is going to identify older tax years - 2013, 2014 or 2015 because those are the years that the information related to.
Another reason I think people will get audited is going to be because information on the return is incomplete, in the sense that the taxpayer or the cryptocurrency owner reports some transactions, without enough detail to figure out the actual cost basis.
Does reporting your data in an aggregated fashion increase your chances of being audited? [06:45]
Alex: I mean one - to the extent that there's going to be a lot of taxpayers - a lot of people use TurboTax, right? If that's the way TurboTax is preparing all of those returns, it would seem to me you're kind of in a herd of people like that. And at least it's consistent with what a lot of people are doing. The second part of that is going to be at least those people who have prepare the returns in that manner, they're going to, or should have, the underlying data. So even if it's an aggregate reporting of each asset class as opposed to each individual trade, if there ever were questions then you're going to have your CSV files, you're going to have your Bitcoin.tax exports, you're going to have all the information that you need to back that up.
Alex is an advocate of over-reporting your information to the IRS. [09:30]
Alex: I'm a big proponent of over-reporting - and I don't mean paying too much tax. I just mean including too much information. Because at some point there's kind of two ways that your returned can be flagged: a computer flags the return for some reason or there's a special unit or a person who actually flags it. At the end of the day, a human being will be looking at that return and deciding whether it actually is going to go all the way through to an audit. I want them to completely understand what's being reported, why it's been reported, and if there's too much information, that's fine - it's less likely that someone's going to have more questions.
A crypto audit is very likely to be a field exam - and it's important to hire a good rep. [11:00]
Alex: It's very likely going to be a field exam, which means you're going to have a revenue agent - and those are kind of the best of the best auditors for an IRS audit. And remember - an IRS audit is a civil matter. It is not criminal at this point. Again, it's unlikely that it will become criminal. It is, however, the highest level of audit you're going to get.
If you're going to hire a representative, which you have every right to do, you should contact that person, let them know what's going on and probably have them interface with the auditor. You should receive, as part of the opening notice or letter, the information document request - which is identifying what things to bring for the auditor. Also, it'll tip to what topics might be important. For example the typical things you're going to see will be bank statements, financial or asset account statements, which I view as requesting exchange statements or exchange CSV files. Any documents that show the cost basis for your cryptocurrency trades.
Audits are more art than science. [13:35]
Alex: The auditor has a fair amount of power. So if you play real hardball - that's not going to prevent the auditor from expanding to other years. So when you get that audit notice ,and let's say that you're going to deal with this yourself, the first thing you want to kind of figure out is what are the areas that I wouldn't want to go into, and what are the areas that I don't have good records? That will help guide the way to respond or what information to pull together.
The reality is, and let's just be honest here - for most people reporting cryptocurrency gains, they have all of the information. The IRS does not have much. They might have some records from Coinbase, but it's not as if they have a treasure trove of third party data.
The burden is really going to be, in every audit, on the taxpayer to prove their tax return is correct.
It's difficult to say how lenient the IRS will be regarding past years. [15:35]
Alex: I think the way that I would look at it is that maybe the standard of of records required to really substantiate older years might be a little bit lower for older years as opposed to now because it's different now. There's a lot better information provided by some of the exchanges. There's a lot more software out there to help you, especially for people who are newer to crypto. You should have access to all your bank records. You should still have a lot of emails, reflecting on-ramping off-ramping, or other purchases. You should be able to kind of pull this all together.
I can understand when we have clients who come in and are early adopters and they're missing chunks of information. So I do think that in those types of circumstances, yes, I think there would be a little bit of leniency. But I don't think if you're asking, hey, I reported my gains in 2017 but I never really did it 14, 15 or 16 - I don't think that's going to be viewed very favorably.
It is possible to substantiate your data without all of your records. [19:00]
Alex: I think the first thing is, I mean, outside of cryptocurrency and just generally in audits, how many people have complete records to support everything on their tax return from three years ago? Right? It's just not the reality.
The best source of information in a lot of these cryptocurrency clients are the clients themselves. They kind of know what they did and they can remember. There's some who take good notes and other people don't, but as you go through and ask people: what exchanges have you've been on, what type of coins, if you bought any ICOs, have you ever sold for actual US cash, and have you ever bought goods or services? As you talk through things people tend to recall what happened. We use that information and we cross check that against bank statements, as well as CSV files, to pick out what those transactions look like.
Most people have some sort of records, at least reflecting the transfer in and the transfer back out of that exchange. So you can use historical data and historical pricing information to essentially estimate what that transaction would have been. And then what we do is we provide a written statement summary of what we're doing and why we're doing it.
The other big one that we see all the time - and anybody listening to this, please hear this, do not trade for your friends on your exchange accounts - because that type of commingling causes such major problems. Essentially you are walking into those taxable gains just because you're allowing someone access to the exchange to make sales.
If you need representation for an audit, get representation. [23:00]
Alex: My general rule is that I think experienced representatives are really important. I probably would not hire the CPA that prepared my return unless they were: one, experienced with being a representative in audits. And two, you felt comfortable that they weren't going to go in there with a conflict of interest. But I do think if you're worried about going into audit - hiring a skilled, and experienced rep is really, really important.
If they're experienced with this, they should understand the appropriate ethical standards and go in there and essentially help resolve portions of the audit and move it to a resolution that you can deal with.
Taxpayers actually have a lot of leverage in an audit. And that sounds crazy to say, but there is a lot of truth to that. And so as you're kind of working through the audit itself, you want to make sure that you're not just agreeing to something to be done with it. You're not agreeing to something just because you think that you'll get in more trouble or get a worse result otherwise.
There are important risk-reduction strategies you can utilize to avoid a crypto audit. [28:15]
Alex: The first thing that you really want to do, is just assess; for those of you that are really worried about an audit - just assess what it is you've actually done over the years. When did you start trading, what exchanges were you on, do you have records that reflect on-ramping and off-ramping? And that's going to be your bank account statements. Do you know where you've been, what exchanges you've been on?
For foreign exchanges, there may not be as much of that AML & KYC compliance, but I really believe that you do have reporting requirements under FATCA for FBAR and something called an 8938, which if you listen to the podcast with Tyson, he kind of explains what that is. But it's basically if you have ownership of a foreign bank account or asset, you have certain reporting requirements, whether you've had income or not.
You want to make sure you at least track when you've actually exchanged crypto for cash or vice versa. That's partly because that's one of those areas where when people can get in trouble with some sort of federal investigators - because those types of transactions can be potentially considered money laundering.
For those who believe that they've used like-kind exchange rules to defer taxable gains -you should look on your tax returns to see if you filed the form 8824, which is where like kind exchanges are actually reported. That kind of goes back to the over reporting issue I was talking about before. I think that if you didn't report the actual trades that you're taking like-kind treatment for in past years, I don't know that you've actually taken like-kind treatment to be frank with you. I think, objectively, that might be viewed as just not reporting certain transactions.
You want to make sure that you address these issues sooner rather than later.
1099-K forms can be misleading - to the recipient and, potentially, the auditor. [32:40]
Alex: A 1099-K is actually a merchant processing third party information returns. And it really is typically associated with people who have credit card sales - so it's going to reflect a gross amount and typically on a monthly basis.
It shows the gross amount and what I've seen too is that sometimes transfers actually get caught into that amount as well. So it's not even just gross sales or purchases - it may have other information. So the 1099-K can be really inflated. That's why reconciling that against accounting records is really, really important because that is one of those issues that I think could lead to an exam.
To those who think crypto isn't beholden to tax laws: you are not correct. [37:38]
Alex: The current commissioner of the IRS is Charles Rettig, and he's a really well known practitioner in tax controversy. I know from people that know him well, that he's actually mentioned Reddit as one of the reasons that cryptocurrency enforcement is his number one enforcement priority right now.
The other person that I've seen speak a couple of times is the head of the IRS Criminal Investigation Unit. His name is Don Fort and every year he does a presentation at the National Tax Controversy and Criminal Tax Conference. The last two years cryptocurrency has been number two and number one on his list. As much as the IRS lacks the funding and the manpower that it needs for all the enforcement, the IRS CI are really, really good and they are probably best agency at dealing with cryptocurrency enforcement issues.
I really think that it's gaining steam and I think once the audits from the Coinbase summons kind of get going, I think it's going to be a really scrutinized area. I think the people who have gone through the cost and the pain of disclosing and amending returns and doing everything they can will be happy that they did in a couple of years. I think the other people are going to be sweating it out - I don't know if it's ever really worth it to be honest with you. I would recommend people do their best to get in compliance.
In summary: do your best to report your crypto gains and losses - and don't try to pull one over on the IRS. [42:36]
Alex: For people who have potential issues with past years, one is getting a consistent record and just amending your past years, so they're consistent.
For people who have the foreign account issues - let's just say, for example, had an account with Binance, and that Binance account was never reported. The IRS has disclosure programs that allow you to amend certain returns, pay the tax that you report and pay a penalty, which would be 5% of the the highest account value that you have.
For people who don't want to deal with this, I think taking evasive steps is the best way to get the worst result possible. One of the things that I learned very early in dealing with audits and tax compliance, is that you can always make things worse. I think you really just want to address it and resolve the issue while you have a good opportunity.
We may see criminal prosecution of some of the "big fish" tax evaders from the Coinbase summons. [46:43]
Alex: Yeah, and I think the two things that I'm fairly certain we're going to see: one is we're going to see the IRS use the information provided by Coinbase to start auditing the biggest account holders from that period. I think that's very likely.
Probably the second one that I would say is very likely is that you're going to see limited criminal prosecutions related to cryptocurrency. And these are going to be people that have some sort of level of notoriety, whether actually famous or maybe famous in the cryptocurrency world. That's typically how the IRS and Department of Justice uses limited resources to prosecute criminal tax tax crimes.
Alex is a great guy to reach out to with any audit-related questions, crypto or otherwise. [48:50]
Alex: You can go to my website: www.kugelmanlaw.com. You can email me at [email protected]. I have clients all over the country, international clients. If you need any sort of help, whether that's representing you, or at least doing the nitty gritty audit investigation, we're always willing to talk to people and help them out as best we can.

If you enjoyed our podcast, be sure to check back frequently for more great discussions about a range of topics in the crypto space. If you have any questions for Alex Kugelman, or want to schedule a consultation with him, he can be reached via his website www.kugelmanlaw.com, or via email at [email protected].
If you would like to request a topic for an interview, or have any questions related to this podcast, be sure to reach out to us at [email protected].
submitted by Sal-BitcoinTax to bitcointaxes [link] [comments]

Possible to get detailed Bitcoin historical pricing data?

Possible to get detailed Bitcoin historical pricing data?
I've searched around quite a bit, but maybe I'm not using the right words. I'm looking for a tight interval bitcoin pricing data-set over time, perhaps in CSV format or something. Is this a crazy ask? I'm looking for something similar to the pic below. I know some APIs exist for extracting historical data, but I'd be rate limited before I could get the kind of data I'm after. Sorry if I'm asking in the wrong place, but thanks for reading.

https://preview.redd.it/o9zw48n1q6p21.png?width=272&format=png&auto=webp&s=f82f474ca2dce9c83c45368376a35671198783cd

submitted by joshsmad to Bitcoin [link] [comments]

Historical minute-by-minute prices on bitcoin, (preferably with 2nd level prices and altcoin prices too)

I am looking for high-resolution historical prices on bitcoin and possibly altcoins. I want the most complete source out there, with the most exchanges, most pairs and historical order books, if possible. I don't mind paying for the data.
Here is what I discovered so far:
High-resolution data (better than hourly):
Hourly data (free):
Daily data
If you know any other source, please share.
submitted by johnturtle to BitcoinMarkets [link] [comments]

Where to find Bitcoin historical data from 2011/2013

Do you have ideas where I can find Bitcoin historical data in a file (csv, txt, etc) from 2010/2011 or from 2013? The smaller the time frame the better.
submitted by siderealiq to algotrading [link] [comments]

Bitcoin & IRS Auditing - A Podcast Discussion

I recently interviewed Alex Kugelman, a tax controversy lawyer - I asked him about IRS audits in relation to crypto trading. Below is a link to the podcast interview itself, as well as a summary I wrote up. Thought this would be a good place to post (let me know if I'm wrong about that).
BitcoinTaxes Podcast Link

Highlights:
IRS audits are a real possibility for anyone who has traded cryptocurrencies. Our guest today is Alex Kugelman, a tax controversy lawyer with an abundance of knowledge concerning cryptocurrency audits. He's here to share his expertise on IRS cryptocurrency audits, including risk reduction strategies as well as enforcement predictions and misconceptions.
Alex Kugelman specializes in IRS audits. His experience includes four years of Federal government court experience at the U.S. Tax Court and a U.S. District Court. [00:40]
Alex: I'm an attorney out in California. I clerked for a US District Court judge and as well as the United States Tax Court. I've been in private practice exclusively doing tax controversy work for the past five years or so. I kind of got involved with crypto towards the end of 2016. I tended to represent clients mainly with compliance & disclosure issues with respect to cryptocurrency. I just really like it. Really interesting area.
The Coinbase summons in 2018 played a major role in Alex's interest in crypto audits. [01:19]
Alex: What started me into the crypto space was when the IRS first issued summons for Coinbase. We started getting some interesting calls regarding that. And at that time I thought to myself, this might be an interesting area. So I started following the actual summons enforcement proceeding at the District Court here in San Francisco - from there kind of worked with people under different types of compliance, including international disclosures. Now we're starting to see some of the first cryptocurrency audits come through.
First, let's get a brief rundown of how IRS audits work. [02:00]
Alex: It is important to understand the IRS as an administrative agency and all different layers of it. So when it comes to an audit the term that the IRS uses is an examination and there's three basic levels.
The first is a correspondence exam. That's where you get a letter that says, dear taxpayer, so-and-so reported that you had $100 of interest income that wasn't on your tax return - we're going to increase your tax. If you want to challenge that, you can. And that's basically termed an under reporter notice. That's probably not going to be a cryptocurrency audit if you get that notice.
The next one is an office exam. That is someone in the local IRS office sending you a letter that says, we have selected a certain tax return for audit and we're going to look at these issues. We'd like you to call us to schedule an appointment. That's going to be usually a tax compliance officer that is doing that.
The third and probably the most serious level of exam is a field examination. That's also going to be a local IRS representative, typically a revenue agent. There, the revenue agent may come to your work or ask come to your work or business to kind of conduct the audit.
All three of those are going to start the same: a letter that's sent to you at your most recent address provided to the IRS.
Cryptocurrency audits follow a similar protocol. [05:40]
Alex: I think it's likely that most crypto audits are going to start with one of two things happening. One is that there is information from the Coinbase summons that is inconsistent with what was on a taxpayer's tax return. I think for someone who's involved with that issue, they're going to have a good sense of that one because they should've gotten an email notice from Coinbase.
Or two, the audit notice is going to identify older tax years - 2013, 2014 or 2015 because those are the years that the information related to.
Another reason I think people will get audited is going to be because information on the return is incomplete, in the sense that the taxpayer or the cryptocurrency owner reports some transactions, without enough detail to figure out the actual cost basis.
Does reporting your data in an aggregated fashion increase your chances of being audited? [06:45]
Alex: I mean one - to the extent that there's going to be a lot of taxpayers - a lot of people use TurboTax, right? If that's the way TurboTax is preparing all of those returns, it would seem to me you're kind of in a herd of people like that. And at least it's consistent with what a lot of people are doing. The second part of that is going to be at least those people who have prepare the returns in that manner, they're going to, or should have, the underlying data. So even if it's an aggregate reporting of each asset class as opposed to each individual trade, if there ever were questions then you're going to have your CSV files, you're going to have your Bitcoin.tax exports, you're going to have all the information that you need to back that up.
Alex is an advocate of over-reporting your information to the IRS. [09:30]
Alex: I'm a big proponent of over-reporting - and I don't mean paying too much tax. I just mean including too much information. Because at some point there's kind of two ways that your returned can be flagged: a computer flags the return for some reason or there's a special unit or a person who actually flags it. At the end of the day, a human being will be looking at that return and deciding whether it actually is going to go all the way through to an audit. I want them to completely understand what's being reported, why it's been reported, and if there's too much information, that's fine - it's less likely that someone's going to have more questions.
A crypto audit is very likely to be a field exam - and it's important to hire a good rep. [11:00]
Alex: It's very likely going to be a field exam, which means you're going to have a revenue agent - and those are kind of the best of the best auditors for an IRS audit. And remember - an IRS audit is a civil matter. It is not criminal at this point. Again, it's unlikely that it will become criminal. It is, however, the highest level of audit you're going to get.
If you're going to hire a representative, which you have every right to do, you should contact that person, let them know what's going on and probably have them interface with the auditor. You should receive, as part of the opening notice or letter, the information document request - which is identifying what things to bring for the auditor. Also, it'll tip to what topics might be important. For example the typical things you're going to see will be bank statements, financial or asset account statements, which I view as requesting exchange statements or exchange CSV files. Any documents that show the cost basis for your cryptocurrency trades.
Audits are more art than science. [13:35]
Alex: The auditor has a fair amount of power. So if you play real hardball - that's not going to prevent the auditor from expanding to other years. So when you get that audit notice ,and let's say that you're going to deal with this yourself, the first thing you want to kind of figure out is what are the areas that I wouldn't want to go into, and what are the areas that I don't have good records? That will help guide the way to respond or what information to pull together.
The reality is, and let's just be honest here - for most people reporting cryptocurrency gains, they have all of the information. The IRS does not have much. They might have some records from Coinbase, but it's not as if they have a treasure trove of third party data.
The burden is really going to be, in every audit, on the taxpayer to prove their tax return is correct.
It's difficult to say how lenient the IRS will be regarding past years. [15:35]
Alex: I think the way that I would look at it is that maybe the standard of of records required to really substantiate older years might be a little bit lower for older years as opposed to now because it's different now. There's a lot better information provided by some of the exchanges. There's a lot more software out there to help you, especially for people who are newer to crypto. You should have access to all your bank records. You should still have a lot of emails, reflecting on-ramping off-ramping, or other purchases. You should be able to kind of pull this all together.
I can understand when we have clients who come in and are early adopters and they're missing chunks of information. So I do think that in those types of circumstances, yes, I think there would be a little bit of leniency. But I don't think if you're asking, hey, I reported my gains in 2017 but I never really did it 14, 15 or 16 - I don't think that's going to be viewed very favorably.
It is possible to substantiate your data without all of your records. [19:00]
Alex: I think the first thing is, I mean, outside of cryptocurrency and just generally in audits, how many people have complete records to support everything on their tax return from three years ago? Right? It's just not the reality.
The best source of information in a lot of these cryptocurrency clients are the clients themselves. They kind of know what they did and they can remember. There's some who take good notes and other people don't, but as you go through and ask people: what exchanges have you've been on, what type of coins, if you bought any ICOs, have you ever sold for actual US cash, and have you ever bought goods or services? As you talk through things people tend to recall what happened. We use that information and we cross check that against bank statements, as well as CSV files, to pick out what those transactions look like.
Most people have some sort of records, at least reflecting the transfer in and the transfer back out of that exchange. So you can use historical data and historical pricing information to essentially estimate what that transaction would have been. And then what we do is we provide a written statement summary of what we're doing and why we're doing it.
The other big one that we see all the time - and anybody listening to this, please hear this, do not trade for your friends on your exchange accounts - because that type of commingling causes such major problems. Essentially you are walking into those taxable gains just because you're allowing someone access to the exchange to make sales.
If you need representation for an audit, get representation. [23:00]
Alex: My general rule is that I think experienced representatives are really important. I probably would not hire the CPA that prepared my return unless they were: one, experienced with being a representative in audits. And two, you felt comfortable that they weren't going to go in there with a conflict of interest. But I do think if you're worried about going into audit - hiring a skilled, and experienced rep is really, really important.
If they're experienced with this, they should understand the appropriate ethical standards and go in there and essentially help resolve portions of the audit and move it to a resolution that you can deal with.
Taxpayers actually have a lot of leverage in an audit. And that sounds crazy to say, but there is a lot of truth to that. And so as you're kind of working through the audit itself, you want to make sure that you're not just agreeing to something to be done with it. You're not agreeing to something just because you think that you'll get in more trouble or get a worse result otherwise.
There are important risk-reduction strategies you can utilize to avoid a crypto audit. [28:15]
Alex: The first thing that you really want to do, is just assess; for those of you that are really worried about an audit - just assess what it is you've actually done over the years. When did you start trading, what exchanges were you on, do you have records that reflect on-ramping and off-ramping? And that's going to be your bank account statements. Do you know where you've been, what exchanges you've been on?
For foreign exchanges, there may not be as much of that AML & KYC compliance, but I really believe that you do have reporting requirements under FATCA for FBAR and something called an 8938, which if you listen to the podcast with Tyson, he kind of explains what that is. But it's basically if you have ownership of a foreign bank account or asset, you have certain reporting requirements, whether you've had income or not.
You want to make sure you at least track when you've actually exchanged crypto for cash or vice versa. That's partly because that's one of those areas where when people can get in trouble with some sort of federal investigators - because those types of transactions can be potentially considered money laundering.
For those who believe that they've used like-kind exchange rules to defer taxable gains -you should look on your tax returns to see if you filed the form 8824, which is where like kind exchanges are actually reported. That kind of goes back to the over reporting issue I was talking about before. I think that if you didn't report the actual trades that you're taking like-kind treatment for in past years, I don't know that you've actually taken like-kind treatment to be frank with you. I think, objectively, that might be viewed as just not reporting certain transactions.
You want to make sure that you address these issues sooner rather than later.
1099-K forms can be misleading - to the recipient and, potentially, the auditor. [32:40]
Alex: A 1099-K is actually a merchant processing third party information returns. And it really is typically associated with people who have credit card sales - so it's going to reflect a gross amount and typically on a monthly basis.
It shows the gross amount and what I've seen too is that sometimes transfers actually get caught into that amount as well. So it's not even just gross sales or purchases - it may have other information. So the 1099-K can be really inflated. That's why reconciling that against accounting records is really, really important because that is one of those issues that I think could lead to an exam.
To those who think crypto isn't beholden to tax laws: you are not correct. [37:38]
Alex: The current commissioner of the IRS is Charles Rettig, and he's a really well known practitioner in tax controversy. I know from people that know him well, that he's actually mentioned Reddit as one of the reasons that cryptocurrency enforcement is his number one enforcement priority right now.
The other person that I've seen speak a couple of times is the head of the IRS Criminal Investigation Unit. His name is Don Fort and every year he does a presentation at the National Tax Controversy and Criminal Tax Conference. The last two years cryptocurrency has been number two and number one on his list. As much as the IRS lacks the funding and the manpower that it needs for all the enforcement, the IRS CI are really, really good and they are probably best agency at dealing with cryptocurrency enforcement issues.
I really think that it's gaining steam and I think once the audits from the Coinbase summons kind of get going, I think it's going to be a really scrutinized area. I think the people who have gone through the cost and the pain of disclosing and amending returns and doing everything they can will be happy that they did in a couple of years. I think the other people are going to be sweating it out - I don't know if it's ever really worth it to be honest with you. I would recommend people do their best to get in compliance.
In summary: do your best to report your crypto gains and losses - and don't try to pull one over on the IRS. [42:36]
Alex: For people who have potential issues with past years, one is getting a consistent record and just amending your past years, so they're consistent.
For people who have the foreign account issues - let's just say, for example, had an account with Binance, and that Binance account was never reported. The IRS has disclosure programs that allow you to amend certain returns, pay the tax that you report and pay a penalty, which would be 5% of the the highest account value that you have.
For people who don't want to deal with this, I think taking evasive steps is the best way to get the worst result possible. One of the things that I learned very early in dealing with audits and tax compliance, is that you can always make things worse. I think you really just want to address it and resolve the issue while you have a good opportunity.
We may see criminal prosecution of some of the "big fish" tax evaders from the Coinbase summons. [46:43]
Alex: Yeah, and I think the two things that I'm fairly certain we're going to see: one is we're going to see the IRS use the information provided by Coinbase to start auditing the biggest account holders from that period. I think that's very likely.
Probably the second one that I would say is very likely is that you're going to see limited criminal prosecutions related to cryptocurrency. And these are going to be people that have some sort of level of notoriety, whether actually famous or maybe famous in the cryptocurrency world. That's typically how the IRS and Department of Justice uses limited resources to prosecute criminal tax tax crimes.
Alex is a great guy to reach out to with any audit-related questions, crypto or otherwise. [48:50]
Alex: You can go to my website: www.kugelmanlaw.com. You can email me at [email protected]. I have clients all over the country, international clients. If you need any sort of help, whether that's representing you, or at least doing the nitty gritty audit investigation, we're always willing to talk to people and help them out as best we can.
---
If you would like to request a topic for an interview, or have any questions related to this podcast, you can reach out to me at [email protected].
submitted by Sal-BitcoinTax to btc [link] [comments]

I created a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

https://spreadstreet.io
My name is John, and back in February of this year I started working on a website where Bitcoin traders and investors could go to get easy access to datasets and trading tools (such as technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.
Quick About Me
I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.
I think Bitcoin and crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.
Features at a Glance
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to BitcoinMarkets [link] [comments]

US Tax Guide for Cryptocurrencies

Introduction:  
Greetings, cryptax! Tax season is upon us, and in the next couple of months, taxpayers across the US will be filing their 2017 tax returns. As a tax professional, an Enrolled Agent, and a cryptocurrency investor and enthusiast, I wanted to write up a brief guide on how your investments in cryptocurrencies are taxed in the US.
 
 
1. Are cryptocurrency realized gains taxable?
Yes. The IRS treats virtual currency (such as cryptocurrency) as property. That means if you sell BTC, ETH, or any other cryptocurrency that has appreciated in value, you have realized a capital gain and must pay taxes on this income. If you held the position for one year or less, it is a short-term capital gain which is taxed at your ordinary income tax rate. If you held the position for more than one year, it is a long-term capital gain which is taxed at your long-term capital gains tax rate. In most cases, this is 15%, but could also be 0% or 20% depending on your specific ordinary income tax bracket.
 
2. If I sell my BTC for USD on Coinbase but do not transfer the USD from Coinbase to my bank account, am I still taxed?
Yes. The only thing that matters is that you sold the BTC, which creates a taxable transaction. Whether you transfer the USD to your bank account or not does not matter.
 
3. If I use my BTC to buy another cryptocurrency (XMR for example), is this a taxable transaction?
Most likely yes. See #4 below for a more detailed explanation. If assuming crypto to crypto trades are not able to be like-kind exchanged, then continue on to the next paragraph here.
This is actually two different transactions. The first transaction is selling your BTC for USD. The second transaction is buying the XMR with your USD. You must manually calculate these amounts (or use a website such as bitcoin.tax or software to calculate it for you). For example, I buy 1 BTC for $8,000 on Coinbase. Later on, the price of 1 BTC rises to $9,000. I transfer that 1 BTC to Bittrex and use it to buy 38 XMR. I have to report a capital gain of $1,000 because of this transaction. My total cost basis for the 38 XMR I purchased is $9,000.
 
4. If I use my BTC to buy another cryptocurrency, could that be considered a tax-free like-kind exchange?
Probably not. The new tax law says that like-kind exchanges only pertain to real estate transactions. This was done with Section 13303, which replaced “property” with “real property” for all of Section 1031 (page 72 near the bottom). My personal interpretation:
In 2018 and going forward, cryptocurrencies can definitely not be like-kind exchanged.
In 2017 and before, it is a very gray area. I personally am not taking the position that they can be like-kind exchanged, because if the IRS went after a taxpayer who did this, the IRS would probably win and the taxpayer would owe taxes, interest, and probably penalties on every single little gain made from trading one cryptocurrency for another.
Here is a great interpretation of why trading cryptocurrency for cryptocurrency is probably not a like-kind transaction.
In my opinion, the biggest factor is that like-kind exchanges must be reported on Form 8824 and not just ignored. Therefore, if a taxpayer is claiming like-kind exchanges on crypto to crypto exchanges, he or she would have to fill out a Form 8824 for each individual transaction of crypto to crypto, which would be absolutely cumbersome if there are hundreds or thousands of such trades.
Another is that there has to be a Qualified Intermediary that facilitates a like-kind exchange. So, it's a more involved process, and that's why I think cryptocurrency cannot be like-kind exchanged.
Here is another article about like-kind exchanges.
Here is the American Institute of CPAs' letter to the IRS, dated June 10, 2016, asking them to release guidance on whether crypto to crypto can be like-kind exchanged or not. The IRS has not responded to the letter.
 
5. How do I calculate the realized capital gain or loss on the sale of my cryptocurrency?
The realized gain or loss is your total proceeds from the sale minus what you purchased those positions for (your cost basis). For example, you bought 1 BTC for $3,000 in June of 2017. In December of 2017, you sold that 1 BTC for $18,000. Your realized gain would be $18,000 - $3,000 = $15,000. Since you held it for one year or less, the $15,000 would be a short-term capital gain taxed at your ordinary income tax rate.
 
6. Which BTC's cost basis do I use if I have multiple purchases?
The cost basis reporting method is up to you. For example, I buy my first BTC at $3,000, a second BTC at $5,300, and a third BTC at $4,000. Later on, I sell one BTC for $8,000. I can use:
FIFO (first in first out) - cost basis would the first BTC, $3,000, which would result in a gain of $5,000.
LIFO (last in first out) - cost basis would be the third BTC, $4,000, which would result in a gain of $4,000.
Average cost - cost basis would be the average of the three BTC, $4,100, which would result in a gain of $3,900.
Specific identification - I can choose which coin's cost basis to use. For example, I can choose the second BTC's cost basis, $5,300, which would result in the lowest capital gains possible of $2,700.
The IRS has not given any guidance on cost basis accounting methods for cryptocurrency, but I am taking the position that any method can be used, and that you can change your method at any time as you please (e.g. FIFO for one year, LIFO for another. Or, FIFO for the sale of a specific lot, then LIFO for the sale of another lot on the same day).
 
7. If I end up with a net capital loss, can I claim this on my tax return?
Capital gains and capital losses are netted on your tax return. If the net result of this is a capital loss, you may offset it against ordinary income on your tax return, but only at a maximum of $3,000 per year. The remaining losses are carried forward until you use them up.
 
8. What is the tax rate on my capital gains?
If long-term, the tax rate is 0%, 15%, or 20%, depending on your ordinary income tax bracket. If short-term, the tax bracket you’ll be in will depend on your total income and deductions. The ordinary income tax brackets are 10%, 15%, 25%, 28%, 33%, 35%, and 39.6% in 2017 and 10%, 12%, 22%, 24%, 32%, 35%, and 37% in 2018 and going forward.
Here are the 2017 and 2018 ordinary income tax brackets.
Here are the 2017 and 2018 long-term capital gains tax brackets.
Here is a detailed article on how the calculation of long-term capital gains tax work and how you can take advantage of the 0% long-term capital gains rate, if applicable.
 
9. If I mine BTC or any other cryptocurrency, is this taxable?
Yes. IRS Notice 2014-21 states that mining cryptocurrency is taxable. For example, if you mined $8,000 worth of BTC in 2017, you must report $8,000 of ordinary income on your 2017 tax return. For many taxpayers, this will be reported on your Schedule C, and you will most likely owe self-employment taxes on this income as well. The $8,000 becomes the cost basis in your BTC position.
 
10. How do I calculate income for the cryptocurrency I mined?
This is the approach I would take. Say I mined 0.01 BTC on December 31, 2017. I would look up the daily historical prices for BTC and average the high and low prices for BTC on December 31, 2017, which is ($14,377.40 + $12,755.60) / 2 = $13,566.50. I would report $13,566.50 * 0.01 = $135.67 of income on my tax return. This would also be the cost basis of the 0.01 BTC I mined.
 
11. Can I deduct mining expenses on my tax return?
If you are reporting the income from mining on Schedule C, then you can deduct expenses on Schedule C as well. You can deduct the portion of your electricity costs allocated to mining, and then you depreciate the cost of your mining rig over time (probably over five years). Section 179 also allows for the full deduction of the cost of certain equipment in year 1, so you could choose to do that if you wanted to instead.
 
12. If I receive BTC or other cryptocurrency as a payment for my business, is this taxable?
Yes. Similar to mining, your income would be what the value of the coins you received was. This would also be your cost basis in the coins.
 
13. If I received Bitcoin Cash as a result of the hard fork on August 1, 2017, is this taxable?
Most likely yes. For example, if you owned 1 Bitcoin and received 1 Bitcoin Cash on August 1, 2017 as a result of the hard fork, your income would be the value of 1 Bitcoin Cash on that date. Bitcoin.tax uses a value of $277. This value would also be your cost basis in the position. Any other hard forks would probably be treated similarly. Airdrops may be treated similarly as well, in the IRS' view.
Here are a couple more good articles about reporting the Bitcoin Cash fork as taxable ordinary income. The second one goes into depth and cites a US Supreme Court decision as precedent: one, two
 
14. If I use BTC or other cryptocurrency to purchase goods or services, is this a taxable transaction?
Yes. It would be treated as selling your cryptocurrency for USD, and then using that USD to purchase those goods or services. This is because the IRS treats cryptocurrency as property and not currency.
 
15. Are cryptocurrencies subject to the wash sale rule?
Probably not. Section 1091 only applies to stock or securities. Cryptocurrencies are not classified as stocks or securities. Therefore, you could sell your BTC at a loss, repurchase it immediately, and still realize this loss on your tax return, whereas you cannot do the same with a stock. Please see this link for more information.
 
16. What if I hold cryptocurrency on an exchange based outside of the US?
There are two separate foreign account reporting requirements: FBAR and FATCA.
A FBAR must be filed if you held more than $10,000 on an exchange based outside of the US at any point during the tax year.
A Form 8938 (FATCA) must be filed if you held more than $75,000 on an exchange based outside of the US at any point during the tax year, or more than $50,000 on the last day of the tax year.
The penalties are severe for not filing these two forms if you are required to. Please see the second half of this post for more information on foreign account reporting.
 
17. What are the tax implications of gifting cryptocurrency?
Small gifts of cryptocurrency do not have a tax implication for the gift giver or for the recipient. The recipient would retain the gift giver's old cost basis, so it could be a good idea for the gift giver to provide records of the original cost basis to the recipient as well (or else the recipient would have to assume a cost basis of $0 if the recipient ever sells the cryptocurrency).
Large gifts of cryptocurrency could start having gift and estate tax implications on the giver if the value exceeds more than $14,000 (in 2017) or $15,000 (in 2018) per year per recipient.
Here's a good article on Investopedia on this issue.
An important exception applies if the gift giver gives cryptocurrency that has a cost basis that is higher than the market value at the time of the gift. Please see the middle of this post for more information on that.
 
18. Where can I learn even more about cryptocurrency taxation?
Unchained Podcast: The Tax Rules That Have Crypto Users Aghast
IRS Notice 2014-21
Great reddit post from tax attorney Tyson Cross from 2014
 
19. Are there any websites that you recommend in helping me with all of this?
Yes - I have used bitcoin.tax and highly recommend it. You can import directly from an exchange to the website using API, and/or export a .csv/excel file from the exchange and import it into the website. The exchanges I successfully imported from were Coinbase, GDAX, Bittrex, and Binance. The result is a .csv or other file that you can import into your tax software.
I have also heard good things about cointracking.info but have not personally used it myself.
 
20. If I move my BTC from one exchange to another, or into a hard wallet, is this a taxable event?
No - you are not selling anything, so no gains are realized.
 
21. Where do I report cryptocurrency sales on my tax return?
The summary of your sales would reported on Schedule D on line 3 and/or line 10 depending on short-term or long-term. Supplemental Form 8949 must also be included with Box C or Box F checked depending on short-term or long-term. Form 8949 is where you must list each individual sale.
 
22. If coins become lost or inaccessible (e.g. lost or forgotten passphrase or thrown away hard drive), can I claim that as a loss? What about coins that have gotten stolen? What about losing money in investment or ICO scams (e.g. Bitconnect or Confido)?
These are really tricky questions. Unfortunately, the potential to claim such a loss against ordinary income is very low, especially with the new tax law. At the very least, capital losses can be claimed, but the deduction is capped at $3,000 per year against ordinary income with the rest carrying forward indefinitely.
The new tax law changed the casualty and theft loss to only apply to presidential disaster areas, so at least in the case of a loss passphrase, I think the answer is no for 2018 and going forward. For 2017, the answer is possibly yes. Here is an article on the subject if you are interested in reading more.
 
23. Taxation is theft!
Sorry, I can't help you there.
 
 
That is the summary I have for now. There have been a lot of excellent cryptocurrency tax guides on reddit, such as this one and this one, but I wanted to post my guide on cryptax which hopefully answers some of the questions you all may have about US taxation of cryptocurrencies. Please let me know if you have any more questions, and I’d be happy to answer them to the best of my ability. Thank you!
Regarding edits: I may make many edits to my post after I originally post it. Please refresh to see the latest edits to my guide. Thank you.
 
Disclaimer:
The information contained within this post is provided for informational purposes only and is not intended to substitute for obtaining tax, accounting, or financial advice from a professional.
Any U.S. federal tax advice contained in this post is not intended to be used for the purpose of avoiding penalties under U.S. federal tax law.
Presentation of the information via the Internet is not intended to create, and receipt does not constitute, an advisor-client relationship. Internet users are advised not to act upon this information without seeking the service of a tax professional.
submitted by Nubboi to cryptax [link] [comments]

I created a website where Ethereum traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

https://spreadstreet.io
My name is John, and back in February of this year I started working on a website where Digital Currency traders and investors could go to get easy access to datasets and trading tools (such as add-ins, charting, and technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.
Quick About Me
I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.
I think Ethereum and crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.
Features at a Glance
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates and Strategies
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to ethtrader [link] [comments]

I created a website where Crypto traders and investors could go to get easy access to datasets and trading tools. This platform would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.

https://spreadstreet.io
My name is John, and back in February of this year I started working on a website where Digital Currency traders and investors could go to get easy access to datasets and trading tools (such as add-ins, charting, and technical analysis templates). This platform would require no coding knowledge, and would be tailored to folks who prefer to do analysis within spreadsheets such as Excel and Google Sheets.
Quick About Me
I am a former Fortune 500 financial analyst, where I managed two $3 billion portfolios. I've been investing/trading since 2002/2003. If you take a look at my kindle cloud reader, you will see over 100 books dedicated to trading and investing of all sorts - technical analysis, fundamental analysis, daily options trading strategies, value investing, volatility trading, quantitative trading, algorithmic trading, and bullshit trading.
I think crypto is the future, and I believe that it is on an unstoppable path. My ultimate goal is to become a cost-leader in the field, and be tailored towards the individual investor. You shouldn't have to pay hundreds to thousands of dollars for top-notch tools.
Features at a Glance
Databases currently included (updated daily)
All datasets are available as a tab-delimited, CSV file. The datasets are a mix between raw tick data, OHLCV, spreads, mining and economic statistics. They can be used for backtesting, analysis, and charting.
Investing/Trading Templates and Strategies
On The Horizon
Potential Ideas
I'm open to answer questions or talk more about the project if there's interest. Hope it helps the traders and investors out there.
John
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

A more detailed look into Localbitcoins.com data

TL;DR
Localbitcoins.com did 34,000 BTC a week ago, spread out over ~50 local currencies. Check out the graphs!
Summary
Last week I did a short analysis on trades at Localbitcoins.com (LBTC). I wasn't satisfied with the incomplete data Bitcoincharts.com gave me and decided to delve a bit deeper, with some nice data and graphs as a result!
Problem
LBTC doesn't publicly summarize their own statistics, they only provide historical trade data via their API. Bitcoincharts.com does a decent summary but only for ~15 currencies. Big LBTC currencies like CNY are not listed there.
Questions
The questions I wanted answered from LBTC's API was:
Approach
So to get a complete picture I sharpened my Python skills and went straight into the LBTC API myself, scraping all currencies I could find and summing the numbers on a weekly basis, starting at 11 march 2013 (the start of LBTC trading).
My aggregates differ from Bitcoincharts as I believe they take a different weekly cutoff point. As of right now, their new week with timestamp "2015-06-15" has already started even though in GMT terms it's still 2015-06-14. (My next week starts at 2015-06-15 00:00 UTC which I believe is in line with GMT?) In that light, the week isn't over yet, so my data will seem incomplete.
To calculate total Fiat volume, I calculated the weighted USD price per BTC on LBTC and applied it to every currency. This is not ideal, however since USD accounts for over 50% of all LBTC trades, it's close enough. Note that the LBTC price per BTC is usually 5-10% higher than on centralized exchanges.
Data
Summary Graphs
I was going to write something interesting, but a picture says a thousand words:
The top 5 currencies (USD, GBP, EUR, AUD, RUB) account for roughly 80% of LBTC's volume. What's interesting though is that smaller currencies are growing rapidly:
Interesting currencies
Here are some interesting currencies that are trading on LBTC and not visible on Bitcoincharts.com:
Conclusion
I don't know how trustworthy LBTC is as a source. All I can say is, if it's data is valid, we're only at the beginning of global BTC acceptance -- which of course doesn't mean the growth we see now is going to continue.
I'm personally very excited to see hard numbers for Kenya, Philippines, Ukraine, Venezuela etc. etc. even though those numbers are still very small.
Thanks for your attention!
Edited for layout
Edit2 Thanks everyone for the kind remarks and generous tips, true gentlepeople all around! I will try to update the data now and then, but don't take my word for it :)
submitted by Caprica__One to Bitcoin [link] [comments]

I created a Free Tax Calculator and subtly promote NANO in it. Please Read!

Edit: The "historical Price Download", is not working anymore as bandwidth on Github LFS is limited (I didnt know that). I am reuploading it on Google Drive after work :))
Hi together! I created a Free Python Script to process your trade histories.
I am a big NANO supporter and I subtly promote NANO in it :P (Check out the Logo and Screenshots) As I could only use my transaction histories I need your help.
Please follow the HOWTO (below) and try to calculate your profits! If you run into any problems (and there will be bugs!) or if you need more exchanges write it in the comments and I will add them! (I could only integrate the ones I use, cause I only got csv files from there)
The tool is working fine for me and I could perfectly calculate my profit, payed fees and last buy times to determine the 12 month holding time.

The code is not that complex, so take a look at it and feel free to add, correct or modify stuff and make sure to push it :)

CryptoProfIT (Alpha Version)

https://github.com/LucidSkyWalkeCryptoProfIT/blob/masteREADME.md
The profit result can be used to calculate the tax on your crypto. The output are two csv-files. Example Screenshots can be found below.
The output files contain: - Sorted full trade history (converts all exchange exports to the same formatting) - Fees per Trade (inklusive Overall Payed fees) - Profit per trade (Overall profit. This can be used to easily calculate your personal capital taxes) - Profit can be calculated in EUR or USD. (Data from European Central Bank) - Amount of your Cryptocurrencies - Display the different BUY-INs by amount and date. So you can control the 12 month holding period.
Supported Exchanges: Binance, Bitfinex, Bittrex, Kraken, Mercatox, Poloniex, Costum*
*A dummy file is included that can be used to easily add trades of other exchanges. If you give me a csv-file export from other exchanges (you can modify the digits for privacy) I will add them.
PLEASE READ: I wrote this tool to calculate my taxes and it did the job fine! Nevertheless it is not well tested yet. If you run into trouble, please write an issue and I will fix it! Thank you :)

Screenshots

Screenshot1 Screenshot of the output.csv. The data of all exchanges is formatted in its specific ways and displayed in a uniform style. Type always refers to the first token of the pair! (First transaction shows buying XRP by BTC) Base Price always refers to the second token of the pair. Base Price in USD shows the price of the second token in USD.
Screenshot2 Screenshot of the holding_output.csv. This file can be used to specify your remaining holding times, as Capital gains do not need to be taxed in many countries after 12 month The picture shows (in red), that the first of the remaining ETH were bought on 2017-06-02, meaning that this amount is tax-free one year later. The blue frame shows the date for the next tokens...
Screenshot3 Console output of the Python script (Not my real data ;)

Requirements

For now, there is no Gui so you have to use the python script. If some dev likes to help, making a gui or a brython version would be neat.

HOWTO:

Setting up Python:

Using the script:

* This package uses the European Central Bank as source for EUUSD to get the historical exchange rates. Author: Alex Prengère Home Page: https://github.com/alexprengere/currencyconverter

Fork information:

A tax accountant told me, you need to pay taxes on the profit of your received forked coins as soon as you get them. Therefore a "dummy" trade needs to be manually added to one of the csv export files in "trade_history_files". * Add a "Buy" transaction at the moment you reveived the coins. (with price "0") * Add a "Sell" transaction a few seconds later (price = initial price of forked coin) you made the inital profit. * Add a "Buy" transaction a few seconds later than before (price = initial price) Because you know still got the coins Simplifing this could be a feature in a future version...

Using the dummy-file:

You can use this file to add trades from exchanges that do not provide trade history exports. Important: You have to use the same formatting like the sample data in the file. Ensure the right date formatting, and use "." for decimals.

Other Information:

Disclaimer:

I wrote this tool to calculate my taxes and thought I share it. I do not guarantee that the results are 100% accurate, but the script might help you getting a well formatted output csv you can work with.

Contact

If you run into any problems, don't hesitate to contact me at any time.

XBR TO THE MOON Donations: xrb_3mwnrhq1d4pdcrgegyygic1a1wpcbnsaj6pd5656dg3yxio3cyg1rn4u1umx
submitted by LucidSkywalker91 to nanocurrency [link] [comments]

CryptoProfIT: Free Tool for Tax Calculation. (Community Project, Please Read!)

Hi together! I created a Free Python Script to process your trade histories.
It would be awesome if this would become a community project which everybody involved in Cryptos can use for FREE.
The logic should be ready and next steps would be: -testing -creating gui or webapplication -adding features
Follow the HOWTO (below) and to calculate your profits etc.! If you run into any problems or if you need more exchanges write it in the comments and I will add them! (I could only integrate the ones I use, cause I only got csv files from there)
The tool is working fine for me and I could perfectly calculate my profit, payed fees and last buy times to determine the 12 month holding time.

The code is not that complex, so take a look at it and feel free to add, correct or modify stuff and make sure to push it :)

CryptoProfIT (Alpha Version)

https://github.com/LucidSkyWalkeCryptoProfIT/blob/masteREADME.md
The profit result can be used to calculate the tax on your crypto. The output are two csv-files. Example Screenshots can be found below.
The output files contain: - Sorted full trade history (converts all exchange exports to the same formatting) - Fees per Trade (inklusive Overall Payed fees) - Profit per trade (Overall profit. This can be used to easily calculate your personal capital taxes) - Profit can be calculated in EUR or USD. (Data from European Central Bank) - Amount of your Cryptocurrencies - Display the different BUY-INs by amount and date. So you can control the 12 month holding period.
Supported Exchanges: Binance, Bitfinex, Bittrex, Kraken, Mercatox, Poloniex, Costum*
*A dummy file is included that can be used to easily add trades of other exchanges. If you give me a csv-file export from other exchanges (you can modify the digits for privacy) I will add them.
PLEASE READ: I wrote this tool to calculate my taxes and it did the job fine! Nevertheless it is not well tested yet. If you run into trouble, please write an issue and I will fix it! Thank you :)

Screenshots

Screenshot1 Screenshot of the output.csv. The data of all exchanges is formatted in its specific ways and displayed in a uniform style. Type always refers to the first token of the pair! (First transaction shows buying XRP by BTC) Base Price always refers to the second token of the pair. Base Price in USD shows the price of the second token in USD.
Screenshot2 Screenshot of the holding_output.csv. This file can be used to specify your remaining holding times, as Capital gains do not need to be taxed in many countries after 12 month The picture shows (in red), that the first of the remaining ETH were bought on 2017-06-02, meaning that this amount is tax-free one year later. The blue frame shows the date for the next tokens...
Screenshot3 Console output of the Python script (Not my real data ;)

Requirements

For now, there is no Gui so you have to use the python script. If some dev likes to help, making a gui or a brython version would be neat.

HOWTO:

Setting up Python:

Using the script:

* This package uses the European Central Bank as source for EUUSD to get the historical exchange rates. Author: Alex Prengère Home Page: https://github.com/alexprengere/currencyconverter

Fork information:

A tax accountant told me, you need to pay taxes on the profit of your received forked coins as soon as you get them. Therefore a "dummy" trade needs to be manually added to one of the csv export files in "trade_history_files". * Add a "Buy" transaction at the moment you reveived the coins. (with price "0") * Add a "Sell" transaction a few seconds later (price = initial price of forked coin) you made the inital profit. * Add a "Buy" transaction a few seconds later than before (price = initial price) Because you know still got the coins Simplifing this could be a feature in a future version...

Using the dummy-file:

You can use this file to add trades from exchanges that do not provide trade history exports. Important: You have to use the same formatting like the sample data in the file. Ensure the right date formatting, and use "." for decimals.

Other Information:

Disclaimer:

I wrote this tool to calculate my taxes and thought I share it. I do not guarantee that the results are 100% accurate, but the script might help you getting a well formatted output csv you can work with.

Contact

If you run into any problems, don't hesitate to contact me at any time.

Donations: xrb_3mwnrhq1d4pdcrgegyygic1a1wpcbnsaj6pd5656dg3yxio3cyg1rn4u1umx
submitted by LucidSkywalker91 to CryptoCurrency [link] [comments]

Bitfinex Historical Price Data!

I am looking for bitfinex hourly bitcoin data since it has begun trading on the exchange. The historical data .csv file in the data section of the website is corrupted and doesnt show the price for for than year ago! On the other hand, Litecoin and ethereum data seem to be fine.
I need this data for important research. Does anyone know where to get it? (i have no idea how to operate APIs).
submitted by sandeman123 to bitfinex [link] [comments]

FYI: The all-time record BTCUSD high of June 2011 (31.9099) hasn't been broken yet (today's high is 31.699)

On Wedesday, 08 Jun 2011 17:10:38 GMT, 0.53 bitcoins were purchased for the price of 31.9099 USD/BTC.
This was followed, 4 seconds after (Wednesday, 08 Jun 2011 17:10:42 GMT), by two trades of, first, 1.094 BTC, then 0.003 BTC at the same price.
So the current high (as of this writing) of 31.699, which occurred at the following times (in GMT), is 0.2109 USD away from breaking the record.
2013-02-26 14:36:53 price:31.699000000000 vol:0.606562650000 2013-02-26 14:36:52 price:31.699000000000 vol:0.606562650000 2013-02-26 14:36:37 price:31.699000000000 vol:0.606562650000 2013-02-26 14:36:30 price:31.699000000000 vol:0.322758380000 2013-02-26 14:33:47 price:31.699000000000 vol:156.516048140000 
Source: Mt. Gox historical data from http://bitcoincharts.com/about/markets-api/
Parsed with this ugly Python script:
#!/usbin/python import urllib2, datetime, time all_time_high_url="http://bitcoincharts.com/t/trades.csv?symbol=mtgoxUSD&start=1307534400&end=1307707200" recent_high_url="http://bitcoincharts.com/t/trades.csv?symbol=mtgoxUSD" def print_high(URL): data = urllib2.urlopen(URL).read() newvar = data.split('\n') high = 0 high_trades = [] for trade in newvar: if float(trade.split(',')[1]) > high: high_trades.append(trade) high = float(trade.split(',')[1]) elif float(trade.split(',')[1]) == high: high_trades.append(trade) trade_val = float(high_trades[-1].split(',')[1]) for trade in high_trades[::-1]: array = trade.split(',') if (float(array[1]) == trade_val): #print "%s price:%s vol:%s" % (datetime.datetime.fromtimestamp(time.gmtime(int(array[0]))).strftime('%Y-%m-%d %H:%M:%S'), array[1], array[2]) print "%s price:%s vol:%s" % (time.strftime('%Y-%m-%d %H:%M:%S', time.gmtime(int(array[0]))), array[1], array[2]) else: break trade_val = float(array[1]) print "All time high:" print_high(all_time_high_url) print "Recent high:" print_high(recent_high_url) 
submitted by runeks to Bitcoin [link] [comments]

Extracting data from the bitcoin blockchain SPX500 GOLD OIL EURODOLLAR AND BITCOIN ELLIOTT WAVE UPDATE JULY 8TH 2020 How to create a crypto csv - ZenLedger.io Connect Excel to Coinmarketcap for live and historic data CSV Reading and Writing Streaming Data-Zerodha-KiteConnect-Python

Included here is historical bitcoin market data at 1-min intervals for select bitcoin exchanges where trading takes place. Happy (data) mining! Content. coinbaseUSD1-mindata2014-12-01to_2019-01-09.csv. bitstampUSD1-mindata2012-01-01to_2020-04-22.csv Data Disclaimer. The data on Cryptodatadownload.com is intended as a