How to Create Custom Zipline Bundles From Binance Data ...

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]

Keeping your private keys secure Python Requests Tutorial - Bitcoin Price API Bitcoin API - Bitcoin, Crypto currency live and historical ... Download historical Bitcoin data directly into Excel Google Spreadsheet for Historical Crypto Market Data Recording and Trading Strategy Backtesting Cointracking Tutorial  How to manage your cryptoportfolio Binance & Api Keys Tutorial Binance API Tutorial (Part 2) - Real-Time Crypto Price Data over Websockets Binance Tax Reporting - Instant Tax Forms  CryptoTrader.Tax Demo Tutorial: How to Compare All the Coins Listed on Binance Exchange with Python

Now if we were to push it we could write a script like this which collects all the data for each currency pair and saves it to a CSV file. That gives you all the historical OHLC trading data from ... In tutorial part 1, I am going to show you how to create the data bundle from csv files. In part 2, we are going to skip downloading csv files and create Zipline data bundles directly from Binance public API. First, create a file named binance_csv.py, and import all the modules we need. I found this python script on the web, it gets OHLCV historical data from Binance api by wanted dates, assets and time intervals. The script currently returns the data for UTC time. I want to modify it so it will return the data (daily/hourly) according to a specified timezone. I guess it takes only to change one function or add an argument but ... How can I get Bitcoin’s historical price data in CSV format? We will request historical Bitcoin price data from the Binance API and then outline four options to save that data to a CSV file. We want data that goes as far back as possible. Fortunately, there is a function within the library that allows us to determine the first available price point. # valid intervals - 1m, 3m, 5m, 15m, 30m ... bitcoin csv historical data - For individual cryptoassets – for example, on the Ethereum price page – there are download buttons on the Markets and Historical Data tabs. Choose Markets for trading pairs (e.g. ETH/BTC) and Historical Data for OHLCV records. To download market or coverage data for all cryptocurrency exchanges, click the “Free CSV” button on the main ... This data set contains all Binance tick by tick historical trade data, i.e. one line per executed trade. All currency pairs listed below are included in this data set. Major cryptocurrencies (Bitcoin, Ethereum, Litecoin, Ethereum Classic...) and many alt coins are included and trade on this exchange. The Binance API will not give you a full year of historical data, so you have to download several different types of reports in csv format. Binance limits you to 3 months of data. To get a full year of transactions, you will need to download each CSV 4 times with different time windows. We suggest the following windows: January 1 to March 31; April 1 to June 30; July 1 to September 31; October ...

[index] [2055] [21745] [1595] [21174] [2859] [14072] [4708] [13285] [5629] [20583]

Keeping your private keys secure

This is a quick overview on how to manage your crypto-currency portfolio using cointracking.info In this video I will show you how to import live data and Historical data for Bitcoin, Ethereum, Ripple and other 1384 coins from web to excel. Data is refre... Binance Tutorial on how to get registered & set up your 2FA. In this video I also go over how to get your API Keys & set them up with the Personal bot. For more information about Arbstar 2.0 ... In this video I talk about the basics of using Python requests by showing you how to call the Coinbase Bitcoin Price Index API. You can see the API docs here... Google Spreadsheet for Historical Cryptocurrency Market Data Recording and Strategy Backtesting: - Download and Append historical crypto OHLCV data into your Google Spreadsheet every 5 min ... In this video, I will show you how to get the historical prices of all the coins listed on Binance exchange in order to compare their risk adjusted returns of the past year, reaching a list of top ... In this video, we retrieve bitcoin price data over Websockets in 2 ways. First, we use wscat to receive the information from the command line and save the price data to a file. Second, we use ... This video demonstrates how you can import your Binance trades into CryptoTrader.Tax to generate one-click tax reports. For more information on doing your Bi... Binance Academy 8,808 views. 6:03 . How To Keep Your Cryptocurrency Safe - Duration: 6:21. Ameer Rosic Recommended for you. 6:21. Blockchain/Bitcoin for beginners 3: public/private keys ... 🚀Steve Ballmer interview: Debt, Crypto, Bitcoin BTC Halving, Crisis and Money Steve Ballmer 146,946 watching Live now Bitcoin 101 - Calling All APIs - Coding Live Price Data From Bitcoin ...

#