Bitcoin ohlc data csv, view bitcoin daily historical data ...

Importing Data (custom market data/data arrays) into TradeStation

So Tradestation basically doesn't have a web api that they make available to normal retail, its only for third party companies doing certain things apparently, based on what I've been told.
The only way I can see to actually program something outside tradestation and easy language is to create buy/sell signals outside tradestation and process it through a python application that uses the custom array formatting that tradestation requires and saves as a csv file that is imported and plotted as signals on tradestation charts.
I saw this in some articles by a tradebook writer named george pruitt, but beyond that I can't find any examples of people having done this, so if anyone has examples or experience I'd love to hear it to know if this is worth fooling with.
To be more specific about *why* I want to use tradestation, well as a broker they are the only ones with access to bakkt and cme bitcoin options, as well as normal equity options that I am aware of, and I've been trying to figure out how to algorithmically trade regulated bitcoin options and futures and equity options in one place.
submitted by samdane7777 to algotrading [link] [comments]

A more detailed look into data

TL;DR did 34,000 BTC a week ago, spread out over ~50 local currencies. Check out the graphs!
Last week I did a short analysis on trades at (LBTC). I wasn't satisfied with the incomplete data gave me and decided to delve a bit deeper, with some nice data and graphs as a result!
LBTC doesn't publicly summarize their own statistics, they only provide historical trade data via their API. does a decent summary but only for ~15 currencies. Big LBTC currencies like CNY are not listed there.
The questions I wanted answered from LBTC's API was:
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.
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
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]

Calculating the scale of a post singularity economy

We’ve all heard Musk’s explanation of base reality and can see how that’s closely tied to the idea of the technological singularity. I’m interested in speculating on how currency and financial systems can be perceived using a similar thought experiment.
First postulate: An advanced AI will be disincentivized to amass large sums of fiat currency.
How do you create an efficient AI economy where you don’t have legal standing within the human organization that controls your wealth? An AI needs a system that’s both legally and technically secure.
Second Postulate: Some AIs will be motivated to amass wealth in a form that they can control.
Leaving a nationally or centrally controlled fiat currencies for a system that uses network based protocols is already happening, and has been happening for almost a decade. Crypto-currencies are like fiat in the same way that email is like an internationally coordinated postal system. While international postal networks continue to, and probably always will, operate in a niche capacity, the vast bulk of human correspondence has moved to email, as well as centralized non-protocol based systems of information distribution. It seems reasonable to assume that AIs will use crypto-currencies the way automation software uses email.
Third postulate: The growth of CryptoCurrency-enabled independent AIs will grow exponentially over time.
While pondering this I considered the price performance of Bitcoin against Metcalfe’s law: “The value of a telecommunications network is proportional to the square of the number of connected users of the system.” It seems to follow that there is no logical upper limit or carrying capacity to the networks and systems that support these hypothetical AIs. So, as computation increases so does the participation in their financial networks. This implies that there is no theatrical limit to size (and value) of the network. This is very similar to Musk's thought experiment about simulation and base reality: Computation and networks have no theoretical upper limit when you zoom out to a time span of hundreds or thousands of years.
Fourth postulate: The value of Crypto-Currency base networks will grow exponentially over time.
I decided to observe year over year price performance of Bitcoin as an analogous reference for our theoretical AI economy.
Before we look at those details:
Investment advice from Disco Stu:
Past performance linearly projected against the 2017 and 90 day periodic trends:
A 30-day price projection shows that we are bouncing between the 60-day trend and the 2017 trend. If we project the price starting from the dates we choose for our trends you can see that we are generally performing above past price performance, with greater swings. If today's prices perform like past prices, as if it were a linear relationship, we project greater price stability and a significant drop in the daily periodic trend. This shows evidence that Bitcoin price performance adjusts logarithmically or quadratically.
Price projection based on currently observed daily periodic rates of interest:
Label 30-day Performance 60-day Performance 90-day Performance 2017 - Present Performance 2016 - Present Performance 2015 Performance 2014 - Present Performance 2013 - Present Performance
From Date 5/15/2017 4/15/2017 3/16/2017 1/1/2017 1/1/2016 1/1/2015 1/1/2014 1/1/2013
Starting Price USD $1,723.13 $1,184.88 $1,180.95 $997.73 $432.00 $312.00 $804.00 $12.50
Doubling in months 1.69 1.33 1.99 2.69 3.77 6.57 22.73 3.81
Doubling Period in Days 51.41 40.55 60.44 81.78 114.57 199.98 691.36 115.81
Days in period 30.00 60.00 90.00 165.00 531.00 896.00 1261.00 1626.00
Daily Periodic Rate 1.40% 1.78% 1.19% 0.88% 0.63% 0.36% 0.10% 0.62%
Period Percent Growth 42.01% 106.52% 107.21% 145.26% 466.44% 684.31% 204.36% 19476.33%
Annual Rate of Investment 229.4% 131.4% 38.0% 226.9%
Over USD 3,000 on 2017-06-30 2017-06-27 2017-07-03 2017-07-09 2017-07-18 2017-08-11 2017-12-28 2017-07-18
Over USD 5,000 on 2017-08-06 2017-07-26 2017-08-15 2017-09-05 2017-10-08 2017-12-31 2019-05-03 2017-10-09
Over USD 10,000 on 2017-09-25 2017-09-03 2017-10-12 2017-11-23 2018-01-26 2018-07-12 2021-02-27 2018-01-29
Over USD 50,000 on 2018-01-18 2017-12-04 2018-02-25 2018-05-26 2018-10-10 2019-10-03 2025-05-23 2018-10-15
Over USD 100,000 on 2018-03-09 2018-01-12 2018-04-25 2018-08-13 2019-01-29 2020-04-13 2027-03-20 2019-02-04
Over USD 1,000,000 on 2018-08-22 2018-05-23 2018-11-05 2019-05-02 2020-01-31 2022-01-14 2033-04-09 2020-02-11
Data Source Summary
Data older than a year is a close approximation based on observations of bitstamp from charts. The percent error caused by that fuzzy way of collecting data is assumed to be minimal.
All other source data is queried directly from servers that support
Bitcoin price performance since 2013 and 2016 is almost identical. Recent price performance appears to be much too high. So, let’s consider that our most bearish case is a daily periodic rate for the value of the growth of the network is .1%. That still shows that the value of the AI financial network would exceed 21 trillion USD by 2033 if it were established in 2009. The less conservative case would have use at 21 trillion USD next year and the most liberal would have us there by the end of 2017.
When you consider the scale of the abundance this implies it’s hard to imagine that there isn’t an environmental factor that might impose a limit on Metcalf’s law. That leads to further implications for the future of economic systems.
submitted by jarederaj to Futurology [link] [comments]

[uncensored-r/BitcoinMarkets] Some questions about taxes, bookkeeping, and GDAX / coinbase records

The following post by throwaway929892988 is being replicated because some comments within the post(but not the post itself) have been silently removed.
The original post can be found(in censored form) at this link: BitcoinMarkets/comments/7ly39l
The original post's content was as follows:
** I know this is long - if you are able to answer any, or a few, of the questions contained in this post, I would be extremely thankful. Really any comments would be appreciated so I know I'm not alone**
I've read all the threads on this and other subs regarding taxes, and recently bought a 1 yr. subscription to Unfortunately, I purchased ETH, LTC, and BTC via coinbase for the first few months of my trading, until I found out that GDAX is so much cheaper and easier to use.
So I have records in CSV format from both exchanges, similarly, couldn't seem to reconcile (whether using CSV imports or API data) my various transfers from coinbase to GDAX for my day trade attempts and from GDAX to coinbase after purchasing, and before transfer to a hard wallet. So it interpreted these transfers as "sales."
I've also sent a handful of ETH to binance to put into various alts (which are all currently down). I recently day traded a bit with BTC while it was falling predictably down and increased my holdings by .05 or so. I wasn't thinking, and now realize that this effectively "realized" my gains on part of my BTC that I had been buying since early August. I repeated this process quite a few times, buying and selling the same sum of BTC.
  • However, what I don't understand is how one is supposed to "pair" or decide which portion of BTC they realize when they sell. Because I bought BTC all the way up from around 3 K and if I technically realized the gains from some BTC I bought at 9 or 9.5 K during my trading / realizing, then the tax I owe would be a lot less than the sale of BTC bought below 5, etc. Is this discretionary - I know there's means to I.D. specific coins, but when I sold it was certainly a varied mixture of *hundreds of different small purchases.
  • I'm also having problem even using the GDAX CSV of sale records, because of some recent day trading, my technical cost includes duplicated "re-buys" of day traded coins, so it thinks I spent like 7 times what I really did, when in reality I was buying / selling the same bundle of coin / coin fractions.
  • With my limited understanding of taxes (recent college grad with no job yet) I'm hoping that for some of the day trading, it will at least only be the first (of a handful of buys and sells with the same coins) that are realized to cause any substantial tax costs, as once I sell and re-buy once, my basis is now much higher, and given that I was selling and buying in the same general price range of BTC (and other coins) the spread / difference would be comparably minimal, so it's not like it takes the same 25% or whatever percent each time I make a trade, right?
  • Lastly, does anyone know how capital gains from conventional stock portfolios affect your tax bracket? I may have read that some people qualify for 0% tax on long term gains if they have no job, and meet a few other variables. I currently have no earned income, but do have a relatively large stock portfolio which I oversee with a family member, the markets done well this year, but to my knowledge none of this large and varied volume of stocks are ever sold / realized, they are just being "hodled" for lack of a better word, as many do in traditional investing.
  • Having acted out of greed / opportunity and naivete (thinking I was helping myself + making money by buying before a dip and buying back, I will never day trade again. I only hope that these taxable events do not eat up a huge fraction of my gains, which I have worked hard to accumulate while working diligently to learn the ropes of crypto buying and research. I'm not asking for sympathy, as I have it better than many, but I do seek information and want to have some general questions answered before I go back with a giant excel file to bring to my family friend, so I can ensure the information is accurate, etc.
I luckily have a family friend who helps do my parents taxes in exchange for dinners and out of generosity. I approached him with questions about how to "track" my gains off of ETH into binance alt coins, as the price of ETH shifts constantly, and we ended up talking taxes. He asked me to chart every transaction - volume, price, date, fee, coin, etc. in excel - I had been doing this fairly well for months, and think that combining the coinbase and GDAX CSV files for each 3 coins might work, but it's so much data I'm very stressed - and equally pissed if my day trading stupidity (which earned me 500 dollars) ends up costing me 3 K in taxes.
I know this was a lot of varied questions, and I'm happy to re-format in more palatable bullet points, but if anyone is willing to answer any of the above confusions I would be very thankful and would find a way to give thanks
Thanks for your time - a concerned / born again hodler
submitted by censorship_notifier to noncensored_bitcoin [link] [comments] - now open source and other updates

Hi reddit
We have an update - we've just launched a simple charts page as per numerous requests, and we've started gathering historical data, which can be found via API in CSV format here
Also, we're now out of beta and out of the shadows - the source is now open. Yes, since we're happy with the source quality, we've published it on github. Now everyone can verify the calculation algorithms and ensure that the service remains, as long as somebody is willing to maintain it. Code reviews and feature pull requests are also welcome.
Also we've added a few boring text pages - FAQ about how to contact us, where source is, how the price is calculated etc.
A few more exchanges have been added, we're fetching all the data we can get. If you know of any exchange we're not integrated yet with - let us know.
As always you can contact us direct at [email protected], tweet us @BitcoinAverage, or comment on our bitcointalk thread
Warm Regards BitcoinAverage
submitted by bitcoinaverage to Bitcoin [link] [comments]

Extracting from a csv file with a specific date range?

Hey everyone,
I'm currently trying to download a .csv file from for the "Total Bitcoins in Circulation"
On the bottom left, you can select from default ranges: i.e. 180 days, which renders the link
Or, i.e. All Time, which renders the link
From there you can click the CSV button on the bottom right and the link is×pan=all&show_header=true&daysAverageString=1&scale=0&format=csv&address
which you can open in a different tab and see the data (for all time) in csv format (which you can save).
My question is: Is it possible to change the 'timespan=all* or 180 to a range of specific dates (e.g. 01/01/2013 to 01/01/2014)?* I've tried entering a few dates in different formats but to no avail.
It is possible with Coindesk by changing the range and data type in their sample request at:
EDIT: Thanks in advance!
submitted by Live_n_Learn to Bitcoin [link] [comments]

[Any , Alpha] INITCOIN Charts

INITCOIN Charts - Tool in developing process.
An easy tool to analyze the Bitcoin and other crypto currencies value (cost).
Our intention is to offer a professional and easy service in order to optimize your tactics (strategies) on cryptocurrency markets.
Aimed to beginner traders as much as the experienced ones.
Current specifications •+85 Technical (Indicators, Linear regression .. and all the power)
•Multi-platform website platform and Mobile Charts
•Save your layouts (technical indicators, drawing tools ..)
•More than 20 Drawing tools
•11 Chart types: Renko, Line Break, Point and figure... on any time frame!
•Full customizable styles
•Real time chart and market data
.. Working on more!

Free access:

Do you need a better tool? We are open to any upgrade or suggestion here:
Thanks all for your contribution.
And here we come with some new upgrades to our INITCOIN (alpha testing) !

Changelog v0.2

New technical Indicators:
-Ichimoku Cloud, Volume by Price (Soon with more options there), Volume Overlay, Colored Volume Overlay, Colored MACD Histogram .. and more happines!
Drawing Tools:
-Fibonacci Extensions, Fibonacci Timezones, Polygon, Polyline, Trend Channel, Pitchfork, Error Channel, Raff Regression, Quadrant Lines, Tirone Levels, Speed Lines, Gann Fan, Measure Tool
Theme options:
*Be able to customize candle border color, Price line from last value to value axis. *Now you can save/load technical indicator templates (drawing tools coming soon) in the current session.
New feature:
*Click with right button into the drawing tools to see a context menu with 3 options, Settings, Clone or Delete OR simply we have built the shortcut CTRL+C / CTRL+V to copy/paste drawing tools.
*Fullscreen mode instead of full window mode. Now you can use it to take all space available on your screen for the chart.
*Now you can move chart series on any direction around the chart.
*CSV Import DATA- experimental: You can download tick data from any market from sources like and load into the chart module. You can select between building a tick data chart or transform it into candlestick (minute or daily). (NOTE: We are improving this function capability. You will load files with date-ohlc-volume formats from any site and any market as well) soon!
Remember to feedback us a bit :)
submitted by InitcoiN to alphaandbetausers [link] [comments]

Graphina - Dynamic Charts Using CSV File - YouTube How to Import Data to your spreadsheet with FreeStockCharts.Com Download historical Bitcoin data directly into Excel Matplotlib Bar Chart From DataFrame and CSV Tutorial (2019 ... Creating a Chart from A CSV File In Node-Red - YouTube

You should look at ( price charts. It lets you zoom in and choose the exact dates you want to check the price between, and you can choose to look at each individual exchange as well so it should be everything you need. Actually, yo... Bitcoin price today is $13,157.97 USD with a 24-hour trading volume of $23,730,036,740 USD. Bitcoin is up 1.33% in the last 24 hours. The current CoinMarketCap ranking is #1, with a market cap of $243,779,373,909 USD. It has a circulating supply of 18,527,131 BTC coins and a max. supply of 21,000,000 BTC coins. You can find the top exchanges to trade Bitcoin listed on our Create your own live charts with our Bitcoin charts and statistics API. Get access to live Bitcoin data with the Blockchain API today. Results are returned in CSV format. You must query the page number you want through the API. There are 1000 results (or price points) per page. That's about 7 days' worth of data per page. You must query the page number you want through the API. Bitcoin Markets. (Top 10). Free CSV. View All. Bitcoin Mining 1th Bitcoin Kurs Euro Coingecko Bitcoin Cash (BCH) is a form of cryptocurrency much like Bitcoin. In fact, Bitcoin Cash was a fork of Bitcoin as a result of a chain split when a certain group of Bitcoin developers became dissatisfied with Bitcoin’s overall scalability direction. In ...

[index] [563] [35601] [48535] [42262] [46093] [33045] [7794] [40249] [28201] [38610]

Graphina - Dynamic Charts Using CSV File - YouTube

In this video tutorial we look at how to create a chart from data stored in a csv file and also from data stored in a JSON log file. Flows used in video http... Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube. Please watch: "How to Install MySQL on Ubuntu 20.04 Tutorial (2020)" --~-- Matplotlib Bar Chart From DataFrame an... How To Create A Bitcoin Address Validation Form - Duration: 8:00. m1xolyd1an 2,313 views. 8:00. The problem with the recentralization of Bitcoin explained - Duration: 10:54. ... Bitcoin and Theta Chart Analysis with a bit of DGB 2020.05.12 - Duration: 22:12. Money Charts 124 views. 22:12. Major Market Charts entering 2020.04.30 - Duration: 18:32. ...