Bitcoincharts Markets API

Moon Math: How are bands determined?

https://www.moonmath.win
The approach I'm taking to draw the bands probably requires a full conversation again. I think the answer I'll give you here will lead to more questions, so I'll try to anticipate that some. In many places I'll slip in and out of metaphors to save time. I'll probably fail to make it clear when that's happening, but if I were to be accurate and specific all the time I feel it would be uncomfortable to read.
The images on the site are rendered pragmatically as an SVG using D3 (that's why you can zoom in so much without degrading resolution and it's also why the image sizes are so incredibly small). The data that D3 uses to draw on the SVG canvas is generated using an algorithm that creates a few different CSV files.
Band lines are determined by data in a CSV file, but visual band width is somewhat arbitrary; band width is just brush width that effectively fills in space between lines. The band lines connect points of data that are calculated and stuck into a csv I talked about earlier. So, the charts are a fancy way to draw specific data as a graph.
The fluctuations that make the chart's bands look a bit shabby deviate subtly from day to day because the images are drawn using data that changes. The waviness you're seeing is kind of like a hash; No two rainbow charts are ever exactly identical but they appear to be identical if you're not looking closely.
The crux to drawing azop 's original rainbow charts are the compounding rates of interest. Specifically, compounding daily periodic rates (CDPR) are observed to project exponential growth that's apparent in the rainbows. azop set rates by fiddling with his CDPR equation. If memory serves, that rate fluctuated between 0.29% and 0.35% CDPR He'd fit the data manually by offsetting the starting price of the projection. He did all this using MS Excel.
Let's pause and think about a rate of growth that's between 0.29% and 0.35% every day. It's Absurd! That's why I include doubling rate in days in the moon math table. You can't look at the charts and tables on the moon math site and think about them clearly if you're not considering the implications in human terms. A CDPR of 0.3% doubles a principal investment in less than 8 months.
0.3% is a conservative CDPR for bitcoin. In the last runup we'd observe rates over 2.0%. 2% CDPR doubles the principal every 36 days.
In contrast, Moon Math has a table that determines CDPR and projects the rainbow using those derived rates. The chart most like azop 's observations is the one in the top left. That chart draws the rainbow chart using a calculated CDPR. That CDPR is the "2012 CDPR" and uses the start date value of January 1 2012. The end date is the end of the previous day. The start price and end price are the relevant closing prices.
I manually adjust the offset of azop's rainbow charts so they closely reflect his most recent post (November 2017). If I didn't do that the price projection would move with price fluctuations up and down the rainbow dramatically enough to make comparison to azop's charts silly. So, after major price adjustments I adjust the starting price offset so that charts visually match the latest post at azopstability.com. I could adjust the algorithm to do this for me, but I haven't got around to figuring out how best do that mathematically yet.
Bands are determined by finding the highest deviation from the model price and using that to determine a exponentially increasing bands; they appear evenly spaced only because they're projected onto a log scale.
The log equation that's cast over the price determines band lines and width using basically the same method I described above with 1 exception: there's no starting price offset and it's never tweaked. The yellow band has a much higher R-squared value as compared to azop's CDPR projections on the rainbow chart. It's also a much older prediction for price performance. You can generate a log equation that has a better R-squared value today, but it's not going to be as good as the original observation made in 2014 by Trolololo.
By now it should be clear that moon math is less a technical analysis of bitcoin's price and more an overview of a couple famous predictions by bitcoin TA enthusiasts. The predictions these enthusiasts made were observed by many people when they originated and they continue to provoke discussion in bitcoin's TA community and beyond.
One problem we find in these predictions is that they're not actually predictive; there is no efficacy. If you look at the width of a rainbow it seems to encapsulate any possible value for the price at any given time. So, these data are most interesting when the price is approaching an extreme.
These models exist for participants to observe and reflect on the market; Does the market price fit the narrative then and now? Is the identity of bitcoin consistent with the narrative that the market is implying? Is the continuity of bitcoin's architecture consistent with the market and network effects it was designed to capitalize on? These charts provide a visual reference that we can use for our personal debates about the ephemeral nature of markets and value as they relate to bitcoin's design and price performance.
submitted by jarederaj to BitcoinMarkets [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]

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]

Decred Journal — April 2018

This post covers what happened in Decred last month. Let's get down to business and have About section at the end.

Development

Wallet and node software version 1.2.0 has been released. Decrediton wallet highlights: improved startup experience, redesigned overview page, added basic graphs to visualize statistics and an export to CSV (helpful for tax reporting). dcrd node software highlights: significantly faster startup and compact filters to support light clients. See full release notes and downloads here, for Decrediton use 1.2.1 bugfix release.
The release process has been improved. Instead of announcing a release date and trying to meet it, a Release Candidate 1 (RC1) will now be posted. After it has been tested an bugfixed with the help of the community, a second candidate (RC2) will be released. This is repeated until an RC version with no apparent bugs becomes the final release. The new process removes a ton of pressure from developers and users and gives more time for testing. As our primary consumer-facing product, Decrediton, is growing in features and complexity, more testing will be required for new releases.
Politeia is "Getting close to a public beta of voting" (slack). Decred plugin merged, paywall and voting are in the testing stage. Ticket voting works on testnet via CLI.
Trezor support got closer as Decred patch was merged. Please note this is only firmware support, to be usable it also needs wallet integration.
WooCommerce Decred plugin alpha version is ready for testing.
Decred.org received a new sleek exchanges page.
The contributors page has been updated to add 10 new faces. Some of them are new to the project but others have been contributing for a while.
Dev activity stats for April: 152 active PRs, 125 commits, 21,656 added and 10,288 deleted lines spread across 7 repositories done by 2-7 developers per repository. (chart)

Network

Hashrate: April started at 2.0-2.7 PH/s range and seen a general increase with some big fluctuations between lows at 2.2 and new all time high above 5.2 PH/s.
Nodes: there are 200 public listening and 500 normal nodes per dcred.eu as of May 1. 169 nodes already upgraded to version 1.2.0. Some 30 nodes were observed to be testing Release Candidate versions before the final release.
Ticket price 30-day average has seen a steady rise to 87.5 DCR. Stake participation is solid 46.1% with 3.53 million DCR as of May 1.

ASICs

Updates from Obelisk's Taek:
We got results back. They are more or less on line with the simulations I didn't realize this, but we don't get the real chips back for 3 more weeks. The ones we've been testing are hacked together into a DIP package (they are BGA chips) that really screws up the results There's a decent chance that the full bga chips perform better For the time being though, we're pretty much on track for the hashrates estimated on the website (slack, Apr 12)
And regarding the June delivery date:
We're still on track for batch 1. We've ordered most of the parts we'll need, including the chips. We've got working chips, we've got test boards, test units, test everything. We've signed manufacturers to produce everything. Obelisk is going strong. (reddit, Apr 23)
We are thankful for his updates in our #pow-mining channel and hope other ASIC manufacturers will also join.
Fellow Sia miners are discussing the design of Obelisk SC1 case.
Halong: B29 units are shipping. The amount of units in first batch was estimated 450-600 by our community member. Review of DragonMint B29 published, people are discussing shipping and running the miners.
By surprise, Innosilicon announced the sale of D9 DecredMaster ASIC miner with specs identical to Halong B29 while being much cheaper ($6800 Inno vs $10499 Halong). Expected shipping date of the first batch is April 28-30. The company is active on their bitcointalk thread, also see our reddit.
Just 9 days later Innosilicon announced second batch with delivery on May 7-11 and same price of $6800. (reddit)

Integrations

Decred's Brazilian community made good progress with integrations this month.
emiliomann: On April 2nd @Rhama will launch the first BR exchange of altcoins with fiat market and totally within the laws of the Brazilian government. Decred will have the two markets DCBTC and DCBRL. It’s very difficult to fulfill all the legal requirements and get authorization to work with FIAT here.
The exchange turned out to be Profitfy. Profity is innovating by using dcrtime for their blockchain ID login via Original My. Great to see this deeper engagement with the tools that Decred provides, and not a surprise that it comes from @Rhama, who has been a community member since day one.
This seems to have spurred another exchange, Braziliex, to bring forward their launch of DCBRL and DCBTC pairs, coming just 2 hours after Profitfy launched.
Not stopping there,
emiliomann: Hey guys, this is a poll of the biggest Bitcoin exchange in Brazil that is planning to open altcoins markets. Please, help the Brazilian community by voting for Decred! Just one click. Thank you! https://twitter.com/mercadobitcoin/status/981602483268194307
Finally,
viniciusfrias: We're excited to announce PagueCripto.com, a Brazilian crypto-to-fiat payment gateway which accepts Decred among other cryptocurrencies for Brazilians to pay daily bills, such as credit cards, energy, rent, etc, and also to make local bank transfers. Our service is both a web platform and an Android app, and as our community is relevant in Brazil, we are offering a discount coupon (50%) in service fees using DCR until May 14, 2018. Check it out at paguecripto.com and in Google Play Store. (slack)
Moving to other countries, good news from Canada:
michae2xl: Decred is now available on @ezBtcCanada, an exchange with DCCAD trading pair. From Toronto – ezbtc.ca
i2Rav announced i2trading.com, a new trading desk that will be offering DCEUR pair:
Eventually we hope to offer the pair in GBP and YEN as well
changenow.io, a non-custodian exchange for fast conversions, added DCR.
You can see all exchanges known to support Decred in a spreadsheet maintained by snr01. Many of them are missing from coinmarketcap.

Adoption

The Crypto Lawyers, LLP, a crypto exclusive U.S. law firm began accepting Decred (reddit):
RAurelius: I think that a law firm accepting Decred is a worthy distinction from other previously publicized companies that accept Decred for typical consumer products. Legal services are severely lacking in the Crypto-sphere, so the publicity is good for everyone in this arena.
Great to see business owners reaching us directly in chat.
VotoLegal is migrating from Ethereum to Decred blockchain:
emiliomann: VotoLegal, a Brazilian project that uses blockchain technology to allow election campaign funding to be transparent and that all transactions conducted are tracked and made available to the citizens, now uses dcrtime and Decred blockchain. https://twitter.com/decred_bstatus/986610826051276800 (slack)

Partnerships

YBF Ventures and Decred announced partnership in building a blockchain-focused development and business hub in Australia.
With the YBF Ventures partnership, Decred hopes to grow their Australian contractor network and scale their operations throughout the Asia-Pacific region. (btcmanager.com)
We specifically chose Decred for a more robust corporate partnership, and it is the first time that a decentralised autonomous organisation is partnering with a ‘traditional’ organisation in such a capacity. (ybfventures.com)

Marketing

Dustorf joined on the marketing front and is conducting a brand discovery analysis:
Decred is soliciting the input of our user community. In order to better understand you, what you think of Decred, and where you would like it to focus its efforts, we've come up with a short (4 minute) survey. Your input of all varieties is most appreciated https://www.surveymonkey.com/2LHK3FV
April targeted advertising report released (previous March report here). Reach @timhebel for full version.
The iconic "Not Overly Scammy" t-shirt by cryptograffiti is available for purchase. For those wondering, the meme originates from @fluffypony.
Some hilarious promos by @jackliv3r: one two three.

Events

Community event at YBF Ventures in Australia.
Meetup in Wroclaw, Poland.
BBQ with @scalarcapital team in Austin, USA.
Blockchain Expo in London, UK. Decred was well represented at this large-scale industry event. Project Lead Jake took part in several interview and the Decred stand manned by community members was flooded with inquisitive visitors. (video, photo 1 2 3)
First Decred meetup in Hangzhou, China. (slack)
Business of Blockchain at MIT Media Lab in Cambridge, USA. Presentation: Blockchain Sovereignty and Blockchain Integration for Businesses by Jake Yocom-Piatt. (event, reddit, photo 1 2 3)
Cambridge Blockchain Meetup in Cambridge, USA. Talk: Cutting the Head off the Snake by Jake Yocom-Piatt. (event, photo 1 2 3)
Upcoming events:

Media

Second episode of Lightning Network educational series is out, exploring topics such as payment channels, onion routing, centralization risk, and challenges that still lie ahead. (youtube)
A user’s perspective and introduction to blockchain governance (Richard Red)
The Importance of Governance: Analyzing the Aftermath of the Monero Hard Fork by Noah Pierau (btcmanager.com)
The Crypto Show w/ Marco from Decred (youtube)
Interview with Jake at @Blockchain_Expo by Crypto Coin Growth (youtube)
Interview with Jake at @Blockchain_Expo by Cryptocurrency Academy (youtube)
Alternative Blockchain Governance Systems With Jake & Kyle From Decred at @Blockchain_Expo by Crypto Disrupt (youtube)
Decred Looks Ahead: An Interview with Project Lead Jake Yocom-Piatt (Exclusive) (sludgefeed.com)
How Complex Bitcoin Politics Led to the Creation of Decred (btcmanager.com)
Interview with Decred’s Project Lead Jake Yocom-Piatt on Crypto Ad Bans and Market Volatility (cryptoslate.com)
Decred’s Jonathan Zeppettini: The Industry Is Going To Be Displacing Wall Street (blocktribune.com)
On Chain VS. Off Chain Governance: The Ins And Outs (coinjournal.net)
Decred: On true decentralisation, Bitcoin communities, and avoiding the ICO route [Video] (blockchaintechnology-news.com)
Marco in shitcoin talk episode 54 (youtube)

Community Discussions

Reddit highlights: A debate on Decred protocol security and attack cost, a comparison of expected and actual block production times, a write-up on distribution of powers and how Monero could benefit from a PoS governance layer, two other threads on ASIC resistance, and one discussing different types of decentralization.
Very thoughtful discussion on whether it is appropriate to use half naked photos in marketing, followed by meta-discussion how to handle very polarizing issues and unwanted contributions to the marketing efforts of a decentralized project. (slack, continued)
A new #governance channel was created to discuss governance in Decred and other projects.
politeia subreddit was recovered for Decred community. Thanks to Tivra for filing the request. Politeia can bring a lot of value outside Decred so it well deserves its own sub.
A new Slack invite page has been setup and onboarded 40 people in 48 hours.
Decred StackExchange site proposal was closed due to inactivity in a 7 day period, according to Area 51 rules.

Markets

In April Decred showed a confident recovery after previous months. DCUSD moved from below $40 to nearly $90 and the more liquid DCBTC from 0.0058 to 0.0093.
OOOBTC showed unexpectedly huge DCR trading volume of $19 m on April 10 (reddit), it went back to normal 2 weeks later.
On April 25 a wild rush took the price from 0.00777 to 0.0177 BTC in under 30 minutes on Poloniex, setting a new USD all time high of ~$165 ($141 world average). Prices on other exchanges followed to a lesser degree. Possible causes were discussed on reddit. Talking about all time highs, an indicator tracking difference between ATH and current price shows Decred is competitive at retaining USD value.

Relevant External

Bittrex finally opened registrations again.
ASIC debates are raging after Bitmain stealth-launched ASICs for Sia, Monero and Ethereum. Most opinions reflect on whether and how to resist ASICs, but some are recognizing the Decred way, like this excellent piece.
The importance of governance is gaining recognition as well. One notable example is Mike Hearn's AMA where it was a hot topic.

About This Issue

This project was motivated by the desire to expose just how much is happening in Decred and save the time for people unable to actively follow our channels. It aims to cover all relevant developments with a short description and links to read further. It shows the depth of the project and the involvement of the community. We also plan to launch a newsletter and consider a shorter version if there is such a demand.
This is the first issue and feedback is welcome to discover what is best for our readers. Please join our Slack and write us on #writers_room or comment directly on GitHub. Any help is welcome too.
Credits (Slack names, alphabetical order): bee, jazzah, Richard-Red, snr01 and vj.
submitted by jet_user to decred [link] [comments]

Any good data sources to get BTC & BCH daily transactions and price

Was hoping to run some simple analysis. I found a lot of BTC only data on bitcoin.com (https://charts.bitcoin.com/chart/price), but was hoping for something that also included BCH (ideally using the same source for both data for consistency reasons). It would also be helpful if I could export the data to a CSV or something else for excel.
submitted by lovebch to btc [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:
np.reddit.com/ 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 cointracking.info. 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, cointracking.info 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]

Crypto questionnaire: are you a hodler?

Since I haven't seen any before: I've made a crypto questionnaire!
A questionnaire can provide some great insight into our diverse community of hodlers, spedners, day traders, miners and otherwise tech enthusiasts. I want to learn more about what kind of risk people feel comfortable with in trading or holding crypto and how invested people around here are.
These results can tell us how typical is it to have just some of your savings in crypto versus all of it. I want to share these results as soon as they've stopped trickling in so we can learn a little more about ourselves.
Please take note that this is completely anonymous. I don't want you to give any personal details and you shouldn't give any personal details. If you don't like the questions anymore, just close the questionnaire. Of course I hope most of you will be as curious as I am and will therefore participate!
Link again: the crypto questionnaire
I've also posted this at /bitcoin but since this is a general crypto questionnaire, it seems more fitting to post here.
Edit: results (22) are in!
To anyone who's lurking, you can download the results from this link: https://drive.google.com/file/d/1DDKqeACFsB0HQwkH9_U3kCWS-wZRECYU/view?usp=sharing
I have imported the CSV with results in Excel and made some pie charts to summarize the results. Feel free to play with these results and see what you can come up with.
To me, the most interesting results are that a majority of those who responded (small sample, I know) think BTC will go over 10K this year, that by far most people can take some risk and are holding crypto for the long term and a significant portion has 80-100% of their savings invested in crypto. That signals to me just how much people around here believe in crypto's potential. It means that people put their money where their mouth is.
By no means do these results mean a lot. It's only a small sample after all and some of these results you may already be familiar with just by browsing this subreddit. However, I still like seeing these results and may follow up with a next questionnaire some time again in the future.
submitted by Roenneman to CryptoCurrency [link] [comments]

How to Add Real Time Currency Converter in Excel Sheet ... How to Create Interactive Charts from Excel Data - Five ... Link Google Finance Stock Data to Excel Worksheet #Excel # ... Download historical Bitcoin data directly into Excel Finance in Excel 2 - Import and Chart Historical Stock ...

CSV-Dateien können Sie problemlos mit MS Excel öffnen. Wir stellen Ihnen zwei Methoden vor - eine simple, sowie eine anspruchsvolle für komplexere CSV-Dateien. 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 Bitcoincharts is the world's leading provider for financial and technical data related to the Bitcoin network. It provides news, markets, price charts and more. This more of a question about excel than it is actually about Bitcoin. But the answer is actually pretty easy. The first thing is that the data that you want to import from the web may not be easily isolated, so you might have to import much more data than you want into a second excel sheet, then link the cell with the data you are interested to a cell in your actual sheet. You should look at (coincrypto.tech) 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...

[index] [4767] [28224] [17100] [47113] [47644] [15821] [48392] [11364] [23732] [42723]

How to Add Real Time Currency Converter in Excel Sheet ...

Premium Course: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube Learn how to Import and quickly Chart historical stock p... In this video we show you How to Link Google Finance Stock Data to Excel Worksheet To make a site page inquiry in Excel 2016, you click the From web order ca... Add and Calculate All Currencies in Real time in Excel Sheet also update currency.. Click here for more detail... http://www.bsocialshine.com/2016/04/how-to-... Pull a Spreadstreet dataset into Excel in minutes with the Excel Add-In. No programming skills required. Just a few clicks through our interface and you are good to go. No programming skills required. Even if you create an org chart in Visio Pro by starting with data in a list or Excel sheet, the diagram is not linked to the Excel data. Learn the few extra...

#