Bitcoin Generator - Hack and Bypass payments Tool - · GitHub

How to legally document online revenue?

I have a website where all proceedings go toward helping others. I have not claimed it to be a non-profit. I want the users to trust and know where their money is going so I decided to make the revenue reports public on the website. Is this a good approach or is there anything else I can do?
Since the website is fairly new, I can’t really afford paying an accounting service to bookkeep. Therefore, the most feasible option for me is to use an Excel worksheet and document the money going in and out. I plan to update the worksheet monthly.
My questions: Will users trust the excel worksheet since the creator of the website is updating it? How can I verify that the data on the worksheet is true? (The site uses bitcoin transactions only)
Thanks for your help.
submitted by randomtakenuser to Accounting [link] [comments]

10 Statistical Price Predictions for 10 Cryptocurrencies — January 2018

TL;DR: I simulated a 1-year movement of 10 top cryptocurrencies using an advanced statistical method called geometric Brownian motion, which you can find below. I also created a spreadsheet to simulate prices of ~24 different cryptocurrencies, which you can download here: https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy. The sheet utilizes a paid add-in, which I provide free of cost to those who are less fortunate.

THE MYSTERY OF PRICE MOVEMENT

So, you’re sitting at your computer with money to invest.
You have made some good money already in the market, but you want more.
Cryptocurrencies have reached a record $600 billion in market value after the recovery, with the inevitable $700 billion mark right around the corner.
The price movement of top currencies remains a mystery. But it doesn’t have to be.

THE PAIN OF UNCERTAINTY

Cryptocurrencies are volatile, irrational beasts.
Simple methods of forecasting grossly oveunderestimate the potential of a volatile currency.
For example, moving averages are used frequently to estimate future prices. Moving averages, however, suffer from many pitfalls that make them poor estimators of volatile markets.
Every great and successful investor has a plan. You will add one more tool to your arsenal today.

A BETTER METHOD FOR ESTIMATING CRYPTO PRICES

In my prior article about estimating the movement of Bitcoin Prices, I spoke of a method that is used frequently in the stock world to estimate prices.
This method is a Monte Carlo simulation using the geometric Brownian motion model.
I won’t cover off on the full methodology here, but essentially I am going to:
  1. Get historical daily prices for 10 top cryptocurrencies
  2. Calculate daily returns
  3. Simulate a year
  4. Simulate a year many times
By the end of the article, you will have the following:
A note on forecasting, simulations, and recommendations: Monte Carlo simulations are to be used as guidelines and tools, not as gospel. I am not offering financial or investing advice.

BITCOIN

What is Bitcoin?

You know what Bitcoin is, stop it.

One-Year Simulation

1-Year Simulation of Bitcoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin prices will fall between $9,095, and $371,588 with a median of $60,837.

BITCOIN CASH

What is Bitcoin Cash?

From the Bitcoin Cash project website:
“Bitcoin Cash is peer-to-peer electronic cash for the Internet. It is fully decentralized, with no central bank and requires no trusted third parties to operate.”
Really, it was an additional currency that was created after a fork from Bitcoin core.

One-Year Simulation

1-Year Simulation of Bitcoin Cash Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Cash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin Cash prices will fall between $197, and $180,288 with a median of $4,839.

ETHEREUM

What is Ethereum?

Ethereum is a decentralized platform that runs smart contracts: applications that run exactly as programmed without any possibility of downtime, censorship, fraud or third party interference.
Ethereum has been busy recently. Multiple steps have been pushed in motion for the upcoming large change — reaching a new consensus method.
From Jordan Daniel at ethnews.com:
Ethereum’s Byzantium hard fork was only one half of a two-part process designed to transition the decentralized application platform to a new method for reaching consensus — proof-of-stake. The next hard fork, called Constantinople, was recently discussed during an Ethereum core developer meeting and could include Vitalik Buterin’s Casper update.

One-Year Simulation

1-Year Simulation of Ethereum Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ethereum Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ethereum prices will fall between $193, and $8,027 with a median of $1,267.

EOS

What is EOS?

EOS is a blockchain-based, decentralized operating system, designed to support commercial-scale decentralized applications by providing all of the necessary core functionality, enabling businesses to build blockchain applications in a way similar to web-based applications.

One-Year Simulation

1-Year Simulation of EOS Prices and Returns

One-Year Simulated 1,000 Times

1-Year EOS Prices Simulated 1,000 times

Verdict

We can be 95% certain that EOS prices will fall between $0.98, and $1,386 with a median of $33.

LITECOIN

What is Litecoin?

Litecoin’s claim to fame is faster transaction processing times. It uses a scrypt-based mining proof-of-work algorithm to target the regular computers and GPUs most people already have.
The ability to target regular computers and GPU’s happens to be a huge differentiator from the crowded mining population of Bitcoin.

One-Year Simulation

1-Year Simulation of Litecoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Litecoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Litecoin prices will fall between $42, and $12,241 with a median of $745.

OMISEGO

What is OmiseGO?

OmiseGO is building a couple of things:
  1. Decentralized exchange
  2. Liquidity provider mechanism
  3. Clearinghouse messaging network
  4. Asset-backed blockchain gateway
OmiseGO is not owned by any single one party. Instead, it is an open distributed network of validators which enforce behavior of all participants.
According to Blocknight:
Also, OmiseGo counts Vitalik Buterin (Ethereum), and Joseph Poon (Lightning Network Co Author) among their advisers. Joseph Poon is actually billed as author of the OmiseGo whitepaper.
Those are some pretty big names.

One-Year Simulation

1-Year Simulation of OmiseGO Prices and Returns

One-Year Simulated 1,000 Times

1-Year OmiseGO Prices Simulated 1,000 times

Verdict

We can be 95% certain that OmiseGO prices will fall between $0.62, and $185.35 with a median of $8.56.

NEO

What is NEO?

NEO (formerly known as AntShares) is a smart asset platform and the first open source public blockchain project in China. Smart assets are the combination of smart blockchain contracts and digital assets.

One-Year Simulation

1-Year Simulation of NEO Prices and Returns

One-Year Simulated 1,000 Times

1-Year NEO Prices Simulated 1,000 times

Verdict

We can be 95% certain that NEO prices will fall between $3, and $3,076 with a median of $115.

RIPPLE

What is Ripple?

Ripple is a system created for banks to enable immediate payments and lower costs.
The vision of the Ripple creators is to allow a bank transfer in a few seconds (instead of the horribly annoying 2–3 business days).
Of note, is that Ripple is a U.S. based company. From the xrphodor blog:
Ripple is a US-based company.
Why is this an important point to consider? A US-based company like Ripple is subject to some very stringent laws regarding securities trading and money transmission. These include requirements that define how Ripple might interact with crypto markets and both institutional and retail crypto traders.

One-Year Simulation

1-Year Simulation of Ripple Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ripple Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ripple prices will fall between $0.05, and $163 with a median of $2.71.

MONERO

What is Monero?

Monero attempts to solve privacy and fungibility issues that persist in Bitcoin.
Part of the algorithm for Monero automatically mixes transactions with previous transactions and does this by implementing ring signatures.

One-Year Simulation

1-Year Simulation of Monero Prices and Returns

One-Year Simulated 1,000 Times

1-Year Monero Prices Simulated 1,000 times

Verdict

We can be 95% certain that Monero prices will fall between $68, and $8,142 with a median of $760.

Zcash

What is Zcash?

From the Blockchainhub infographic:
Zcash is a permissionless cryptocurrency that can fully protect the privacy of transactions using zero-knowledge cryptography.

One-Year Simulation

1-Year Simulation of ZCash Prices and Returns

One-Year Simulated 1,000 Times

1-Year ZCash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Zcash prices will fall between $54, and $6,259 with a median of $549.

YOUR VERY OWN FORECASTING TOOL

Since i’m so nice, I went ahead and created a forecasting tool for you to use:
https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy

SERVICES USED:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A NOTE ON SECURITY

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

WHAT IT PULLS:

GETTING THE SPREADSHEET TO WORK FOR YOU

Install the Spreadstreet add-in for Google Sheets
Get sheet ready for use with the add-in
After logging into the add-in, change the dropdown reference

TROUBLESHOOTING

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Candles” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “SELECT CURRENCY” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
When I try and change a coin, I get a #DIV/0 error
Login to the Spreadstreet add-in, and keep the window open. Try changing the dropdown again.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“candles-bitfinex”, ticker, “1D”, “hist”, true, “”, “”, “”, “0”)

CONCLUSION

Whether you are investing in Bitcoin, Ethereum, or SpankCoin, it is imperative to have a plan. Most notably, a worst-case scenario.
The Monte Carlo simulation is a fantastic way to get a range of prices for a cryptocurrency. And after reading this, you can see how the final values change drastically depending on what you are looking at.
I urge you to download the sheet and try your own hand at simulating different coins. The sheet is setup to pull in every single coin from CoinMarketCap.
Cheers, and happy hunting
Original article can be found here: https://medium.com/@spreadstreet/10-statistical-price-predictions-for-10-cryptocurrencies-january-2018-3dcf04bf9d9a

RELATED POSTS

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain
A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

10 Statistical Price Predictions for 10 Cryptocurrencies — January 2018

TL;DR: I simulated a 1-year movement of 10 top cryptocurrencies using an advanced statistical method called geometric Brownian motion, which you can find below. I also created a spreadsheet to simulate prices of ~24 different cryptocurrencies, which you can download here: https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy. The sheet utilizes a paid add-in, which I provide free of cost to those who are less fortunate.

THE MYSTERY OF PRICE MOVEMENT

So, you’re sitting at your computer with money to invest.
You have made some good money already in the market, but you want more.
Cryptocurrencies have reached a record $600 billion in market value after the recovery, with the inevitable $700 billion mark right around the corner.
The price movement of top currencies remains a mystery. But it doesn’t have to be.

THE PAIN OF UNCERTAINTY

Cryptocurrencies are volatile, irrational beasts.
Simple methods of forecasting grossly oveunderestimate the potential of a volatile currency.
For example, moving averages are used frequently to estimate future prices. Moving averages, however, suffer from many pitfalls that make them poor estimators of volatile markets.
Every great and successful investor has a plan. You will add one more tool to your arsenal today.

A BETTER METHOD FOR ESTIMATING CRYPTO PRICES

In my prior article about estimating the movement of Bitcoin Prices, I spoke of a method that is used frequently in the stock world to estimate prices.
This method is a Monte Carlo simulation using the geometric Brownian motion model.
I won’t cover off on the full methodology here, but essentially I am going to:
  1. Get historical daily prices for 10 top cryptocurrencies
  2. Calculate daily returns
  3. Simulate a year
  4. Simulate a year many times
By the end of the article, you will have the following:
A note on forecasting, simulations, and recommendations: Monte Carlo simulations are to be used as guidelines and tools, not as gospel. I am not offering financial or investing advice.

BITCOIN

What is Bitcoin?

You know what Bitcoin is, stop it.

One-Year Simulation

1-Year Simulation of Bitcoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin prices will fall between $9,095, and $371,588 with a median of $60,837.

BITCOIN CASH

What is Bitcoin Cash?

From the Bitcoin Cash project website:
“Bitcoin Cash is peer-to-peer electronic cash for the Internet. It is fully decentralized, with no central bank and requires no trusted third parties to operate.”
Really, it was an additional currency that was created after a fork from Bitcoin core.

One-Year Simulation

1-Year Simulation of Bitcoin Cash Prices and Returns

One-Year Simulated 1,000 Times

1-Year Bitcoin Cash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Bitcoin Cash prices will fall between $197, and $180,288 with a median of $4,839.

ETHEREUM

What is Ethereum?

Ethereum is a decentralized platform that runs smart contracts: applications that run exactly as programmed without any possibility of downtime, censorship, fraud or third party interference.
Ethereum has been busy recently. Multiple steps have been pushed in motion for the upcoming large change — reaching a new consensus method.
From Jordan Daniel at ethnews.com:
Ethereum’s Byzantium hard fork was only one half of a two-part process designed to transition the decentralized application platform to a new method for reaching consensus — proof-of-stake. The next hard fork, called Constantinople, was recently discussed during an Ethereum core developer meeting and could include Vitalik Buterin’s Casper update.

One-Year Simulation

1-Year Simulation of Ethereum Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ethereum Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ethereum prices will fall between $193, and $8,027 with a median of $1,267.

EOS

What is EOS?

EOS is a blockchain-based, decentralized operating system, designed to support commercial-scale decentralized applications by providing all of the necessary core functionality, enabling businesses to build blockchain applications in a way similar to web-based applications.

One-Year Simulation

1-Year Simulation of EOS Prices and Returns

One-Year Simulated 1,000 Times

1-Year EOS Prices Simulated 1,000 times

Verdict

We can be 95% certain that EOS prices will fall between $0.98, and $1,386 with a median of $33.

LITECOIN

What is Litecoin?

Litecoin’s claim to fame is faster transaction processing times. It uses a scrypt-based mining proof-of-work algorithm to target the regular computers and GPUs most people already have.
The ability to target regular computers and GPU’s happens to be a huge differentiator from the crowded mining population of Bitcoin.

One-Year Simulation

1-Year Simulation of Litecoin Prices and Returns

One-Year Simulated 1,000 Times

1-Year Litecoin Prices Simulated 1,000 times

Verdict

We can be 95% certain that Litecoin prices will fall between $42, and $12,241 with a median of $745.

OMISEGO

What is OmiseGO?

OmiseGO is building a couple of things:
  1. Decentralized exchange
  2. Liquidity provider mechanism
  3. Clearinghouse messaging network
  4. Asset-backed blockchain gateway
OmiseGO is not owned by any single one party. Instead, it is an open distributed network of validators which enforce behavior of all participants.
According to Blocknight:
Also, OmiseGo counts Vitalik Buterin (Ethereum), and Joseph Poon (Lightning Network Co Author) among their advisers. Joseph Poon is actually billed as author of the OmiseGo whitepaper.
Those are some pretty big names.

One-Year Simulation

1-Year Simulation of OmiseGO Prices and Returns

One-Year Simulated 1,000 Times

1-Year OmiseGO Prices Simulated 1,000 times

Verdict

We can be 95% certain that OmiseGO prices will fall between $0.62, and $185.35 with a median of $8.56.

NEO

What is NEO?

NEO (formerly known as AntShares) is a smart asset platform and the first open source public blockchain project in China. Smart assets are the combination of smart blockchain contracts and digital assets.

One-Year Simulation

1-Year Simulation of NEO Prices and Returns

One-Year Simulated 1,000 Times

1-Year NEO Prices Simulated 1,000 times

Verdict

We can be 95% certain that NEO prices will fall between $3, and $3,076 with a median of $115.

RIPPLE

What is Ripple?

Ripple is a system created for banks to enable immediate payments and lower costs.
The vision of the Ripple creators is to allow a bank transfer in a few seconds (instead of the horribly annoying 2–3 business days).
Of note, is that Ripple is a U.S. based company. From the xrphodor blog:
Ripple is a US-based company.
Why is this an important point to consider? A US-based company like Ripple is subject to some very stringent laws regarding securities trading and money transmission. These include requirements that define how Ripple might interact with crypto markets and both institutional and retail crypto traders.

One-Year Simulation

1-Year Simulation of Ripple Prices and Returns

One-Year Simulated 1,000 Times

1-Year Ripple Prices Simulated 1,000 times

Verdict

We can be 95% certain that Ripple prices will fall between $0.05, and $163 with a median of $2.71.

MONERO

What is Monero?

Monero attempts to solve privacy and fungibility issues that persist in Bitcoin.
Part of the algorithm for Monero automatically mixes transactions with previous transactions and does this by implementing ring signatures.

One-Year Simulation

1-Year Simulation of Monero Prices and Returns

One-Year Simulated 1,000 Times

1-Year Monero Prices Simulated 1,000 times

Verdict

We can be 95% certain that Monero prices will fall between $68, and $8,142 with a median of $760.

Zcash

What is Zcash?

From the Blockchainhub infographic:
Zcash is a permissionless cryptocurrency that can fully protect the privacy of transactions using zero-knowledge cryptography.

One-Year Simulation

1-Year Simulation of ZCash Prices and Returns

One-Year Simulated 1,000 Times

1-Year ZCash Prices Simulated 1,000 times

Verdict

We can be 95% certain that Zcash prices will fall between $54, and $6,259 with a median of $549.

YOUR VERY OWN FORECASTING TOOL

Since i’m so nice, I went ahead and created a forecasting tool for you to use:
https://docs.google.com/spreadsheets/d/1eUIgBowJs2NyKw7kYbx5z_VeCOxsMQdNELfbngs4XnY/copy

SERVICES USED:

  1. Google Sheets
  2. Spreadstreet Google Sheets Add-in
  3. StockTwits
  4. CoinMarketCap API
Full disclosure: The google sheets add-in is a 14-day free trial, and $15 per month after. However, no one should be refused access on the basis of money (especially true for students and less fortunate). Send me a message, and I will make sure you are not left in the dark.

A NOTE ON SECURITY

Users have expressed hesitation about running a google sheets add-in on their main computer, so I will attempt to ease those concerns:

WHAT IT PULLS:

GETTING THE SPREADSHEET TO WORK FOR YOU

Install the Spreadstreet add-in for Google Sheets
Get sheet ready for use with the add-in
After logging into the add-in, change the dropdown reference

TROUBLESHOOTING

  1. Important Open the template, click the menu Add-ons / Spreadstreet / Help / View in store, and then click Manage and in the dropdown menu click “Use in this document.”
  2. A reload of the entire worksheet fixes quite a few problems.
  3. Deleting and re-pasting the formula in A1 of the “Candles” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “SELECT CURRENCY” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
When I try and change a coin, I get a #DIV/0 error
Login to the Spreadstreet add-in, and keep the window open. Try changing the dropdown again.
I have tried logging in, activating the template with “Use in this document” and refreshed the sheet…still nothing.
Head to the “Data” tab. Delete the formula in cell A1, and repaste the following: =SS(“candles-bitfinex”, ticker, “1D”, “hist”, true, “”, “”, “”, “0”)

CONCLUSION

Whether you are investing in Bitcoin, Ethereum, or SpankCoin, it is imperative to have a plan. Most notably, a worst-case scenario.
The Monte Carlo simulation is a fantastic way to get a range of prices for a cryptocurrency. And after reading this, you can see how the final values change drastically depending on what you are looking at.
I urge you to download the sheet and try your own hand at simulating different coins. The sheet is setup to pull in every single coin from CoinMarketCap.
Cheers, and happy hunting
Original article can be found here: https://medium.com/@spreadstreet/10-statistical-price-predictions-for-10-cryptocurrencies-january-2018-3dcf04bf9d9a

RELATED POSTS

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain
A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to CryptoCurrency [link] [comments]

[Review] Bitcoin.tax

I've had a heck of a time filing taxes since I've had a flood of transactions last year (just under 5,000). A lot of people on crypto subs have been talking about https://bitcoin.tax and I thought I'd jump in.
I contacted the person who wrote the thing - bitcointaxes - who is very approachable. They told me the registration process is totally anonymous as far as they don't need to know your name, SSN, etc. They DO need read-only access to your trading account which you can set up OR you can enter it all manually (good luck!). I use GDAX (though it supports other exchanges) and had zero problems giving them this read-only access for transaction history which is part of the GDAX system. The website told me how to get this access and how to make sure I don't give too much access.
Considering I've had a ton of transactions, I had to buy the $40 account plan so I can import my trades. Their basic plan is $30 for 1,000 transactions but it goes up from there. You CAN get a free account for I think 20 trades just to see how this looks.
The import took about 5 minutes and I was able to get all the tax forms I needed. It also gave me options for FIFO vs. LIFO, etc to see what's best from a tax perspective plus a neat chart of my monthly gains (though I already had this on my own system).
Overall, I'm pretty impressed with it. I really didn't feel like spending even more days calculating everything and, worse yet, importing the dozens and dozens of worksheets into the H&R Block's software. This software did it all for me pretty quickly and without issues. $40 for days of work, likely making a mistake, and having the IRS on my back? It's worth it for me.
I'm pretty impressed and I recommend using the site which I'll likely be using again next year for tax time.
Disclosure I did not receive any compensation for writing this post.
submitted by SsurebreC to LitecoinTraders [link] [comments]

A Super Simple Cryptocurrency Arbitrage Spreadsheet (with ETH examples) for Finding Mismatched Prices

Crazy stat of the day: You can trade cryptocurrencies on over 170+ different exchanges throughout the world.
Compare this to the stock markets in the United States which have a whopping…2. You know them very well by now (NYSE and Nasdaq), but these markets have had decades of consolidation and mergers.
While this is not an apples-to-apples comparison, cryptocurrency exchange consolidation is a natural market force that will happen eventually.
However, we do not know if this will take months, years…or even decades.
The abundance of choices in exchanges presents a multitude of problems, one of which is a large distribution of prices across all platforms.

Many Exchanges Breeds Many Problems

New markets such as cryptocurrencies all experience the following problems:
  1. Transactional inefficiency
  2. Differences in prices
  3. Illiquidity
  4. Changing spreads
These problems exist due to imbalances in supply and demand. If there is a lack of sellers or buyers, the problems mentioned above are enhanced.
Complicating the matter even further, each pricing discovery process is silo’d within each different exchange.
Smart arbitragers recognize this as an opportunity, and they specifically hone in on #2: Differences in prices.
When buyers are able to capitalize on differences in prices between markets, this is known as arbitrage.

The ELI5 Version of Crypto Arbitrage

ELI5 Version of Crypto Arbitrage
You have been following the price of a certain coin (we will just call it “coin” for this example) for a while.
One day while looking at prices, you noticed that on exchange #1 the price of “coin” was trading at $95. Simultaneously at exchange #2, “coin” was trading at $100.
Being that you are a smart cookie, you decided to do the following:
  1. Buy 1 coin @ $95 on exchange #1
  2. Sell 1 coin @ $100 on exchange #2
  3. Profit $5 from the difference in price
The crazy thing is, these market inefficiencies in this super new industry are available every day. Wouldn’t it be nice if we had a tool that could spot these price differences easily?

The Solution

Screenshot of the arbitrage spreadsheet
I created a spreadsheet that aggregates coin prices across multiple exchanges for all of the top cryptocurrencies. The spreadsheet uses the following services:
  1. Spreadstreet Google Sheets Add-in
  2. Cryptonator API
  3. Google Sheets

How to Use the Spreadsheet

Quick gif on how the tool works
First time install
The tool is nice and simple to use. It requires about 2 minutes to setup, then after that you are good to go.
  1. Make of copy of the worksheet: Click here
  2. Install the Spreadstreet Google Sheets Add-in
  3. Follow the instructions and log-in to the add-in
  4. Formulas in the sheet should update
Changing the primary currency
Cell B7 houses the primary currency (aka, the BTC in BTC/USD). Cryptonator has a massive list of currencies, but some of the more popular ones include BTC (Bitcoin), ETH (Ethereum) and LTC (Litecoin).
Changing the secondary currency
Cell C7 houses the secondary currency (aka, the USD in BTC/USD). Once again, Cryptonator has a massive list of secondary currencies, with the most popular being USD (United States Dollar) and EUR (Euro).

How to Read the Graph

The graph will list all the exchanges that Cryptonator currently has trade volume, based on the user’s pairing choice.
Spreadsheet graph
In this example, we are using the Ethereum vs. United States Dollar (ETH/USD) pairing.
Cryptonator currently tracks 10 different exchanges, all of which have their own price and volume statistics for ETH/USD.
Using this graph, a savvy investor (AKA you) could:
  1. Purchase ETH/USD at the Kraken exchange for $463.17
  2. Sell ETH/USD at the Cex.io exchange for $479.99
  3. For a potential profit of $16.82

The Pitfalls of Crypto Arbitrage

Of course you, being a savvy investor, know that nothing in life is this simple. This form of trading comes with it’s own pitfalls, and it would be irresponsible of me not to point them out.

Conclusion

Arbitrage is a classic technique in profiting off of assets, and cryptocurrency is no exception.
The large amount of exchanges present in the market creates unprecedented arbitrage opportunity, as each exchange carries it’s own pricing discovery mechanisms.
Take some time and download the cryptocurrency arbitrage tool I created, and see if you can uncover any inefficiencies currently in the market.
Cheers, and happy hunting
Original article found at: https://medium.com/@spreadstreet/a-super-simple-cryptocurrency-arbitrage-spreadsheet-for-finding-mismatched-prices-a6e8b12dd8b0

Download Now

Click here to download the spreadsheet

Resources

Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Help: https://spreadstreet.io/docs
First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg
Cryptonator Ticker endpoint help: https://spreadstreet.io/knowledge-base/cryptonator-api-complete-ticker-endpoint/

Related Posts

10 Statistical Price Predictions for 10 Cryptocurrencies
High-Flyers and Shitcoins: What I Learned from Analyzing CoinMarketCap Data in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to EthAnalysis [link] [comments]

A helpful Excel spreadsheet to help automate and monitor your assets - including historical metrics on profitability and asset holdings

Well... I put this together because it was fun (excel? fun?), but I figured I may as well share what I got- someone else out there might have some ideas to make it better, or might find it useful. It's a macro enabled excel spreadsheet which is understandably sketchy AF, so I included a 'dumb' .xlsx version and the actual macro in txt format if you're not comfortable downloading the macro version (I wouldn't blame you!)
Also: as you can see I'm pretty new and I bought a bunch during the bubble this Decembeearly January. I also may have picked some longer-term holds than I was expecting... Looks like it'll be a while before I recoup my capital investments, help a dude out with some BTC or ETH if you think this is useful (or if you're just feeling charitable)
Send me some BTC? 16W8XG2hXAmL1HJTzs5wWWoG8AUkyabdbT
Send me some ETH? 0x48dAbF6c5B02C4f9E09E2f5B95bb231C7e9f6049
DOWNLOAD HERE! https://www.dropbox.com/sh/68se9vl6dujcf3x/AADk6NlfkDdR-6WO1WeBl4QSa?dl=0
Let me know if you have any questions- I included instructions in the document on how to interact with it also see below:
Thanks for the great community, and I look forward to the rest of the year!
Also: If you just wanna make fun of my stupid investments, I fully deserve it. :)
Instructions (not great documentation, sorry)
WARNINGS
Purchases
  1. Any time you buy using Fiat currency you should add the purchase to the Purchases tab
  2. I tend to use coinbase/gdax to purchase, so I simply insert the date, the amount paid, the # of coin I got, and the fees paid, etc.
  3. Fiat purchase total will be flooded to the Assets tab as the capital investment
Adding a new Coin API call
  1. In Excel use the Data tab to add a new API call (from web)
  2. I'm just using CoinMarketCap until a better API comes up… use the documentation at https://coinmarketcap.com/api/
  3. Use the name for your new coin - ex: https://api.coinmarketcap.com/v1/tickeEthereum
  4. Here's the resource I used to figure it out
  5. It will create a new tab automatically but I thought that was annoying- copy the content of the new sheet into the "Data" tab (paste at the bottom)
  6. Delete the newly created sheet and the existing connection for it sheet…
  7. Rename the new data connection from "Ethereum(2)" to "Ethereum" if you want.
Add the Coin to Assets
  1. I have it split up by exchange for tracking where my assets are, where I bought them etc… not really necessary
  2. Add the new exchange, or simply use the TOTALS at the very top and get rid of the references to the exchanges
  3. Binance really screwed me with dust (I get it… buy BNB- bleh)… so I list those fractions as nLiq (non Liquid assets) so it's not counted in my actual return
  4. Reference the Data sheet for the BTC amount and the USD amount. Carry and calculations over. The IF logic was to handle zero values so it was easier to read.
  5. You'll probably need to add new coins to the TOTALS section- simply add a new record, name it, and reference the exchange below (or skip the exchange stuff and just list Totals) 5a. NOTE: The Bitcoin and Eth totals are summed from each exchange… I tend to use this as a worksheet for where I want to allocate resources too.
IMPORTANT:
  1. You'll need to manually add your new coins to the Historic Data sheet as a new column, it should be the same column order as the row order in the Assets TOTAL section WARNING: DO NOT SORT ANY TABLE or it'll screw up the Historic Data and macro stuff (see below)
Fees
  1. I got kind of lazy, and went with Bitcoin as the fee structure for each exchange… about .001 BTC for withdrawing funds back to a Fiat exchange.
  2. this is translated into USD fees and added up, you'll see the total fees in the TOTALS section at top
Asset Graphs
They should update automatically, but you might need to make sure they follow newly added rows in the tables.
Profits
  1. These are calculated for every trade and takes an average based on the existing price… 1a. It's a little janky, because if you buy some with BTC and some with ETH you can find the % away from each, but you have to adjust the formulas for each row accordingly
  2. the Average is taken for the Delta of each transaction from the current BTC or ETH price
  3. This data is compiled in the Historic Data sheet
Historic Stuff
On the Historical Assets tab there's a graph and it's derived from Historic Data sheet On the Historical Assets tab you'll see a button that says Start Macro and End Macro…
On the Historical Profit tab there's a graph which is derived from the Histroric Data sheet The Historic Data sheet is populated by a macro which basically just copies a bunch of stuff.
Macro does the following: (READ THE CODE COMMENTS)
  1. Refresh the data without locking up the application
  2. Copies the Liquid BTC column from the TOTALS table
  3. Pastes the current # of BTC for each coin in the next row of Historic Data sheet
  4. Get the Profit Analysis data and pastes it to a new row in its section of Historic Data sheet
  5. Waits 30 minutes (1800 seconds)
  6. Repeat
  7. ???
  8. Profit
submitted by ThaGuvNa to CryptoCurrency [link] [comments]

A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices

Crazy stat of the day: You can trade cryptocurrencies on over 170+ different exchanges throughout the world.
Compare this to the stock markets in the United States which have a whopping…2. You know them very well by now (NYSE and Nasdaq), but these markets have had decades of consolidation and mergers.
While this is not an apples-to-apples comparison, cryptocurrency exchange consolidation is a natural market force that will happen eventually.
However, we do not know if this will take months, years…or even decades.
The abundance of choices in exchanges presents a multitude of problems, one of which is a large distribution of prices across all platforms.

Many Exchanges Breeds Many Problems

New markets such as cryptocurrencies all experience the following problems:
  1. Transactional inefficiency
  2. Differences in prices
  3. Illiquidity
  4. Changing spreads
These problems exist due to imbalances in supply and demand. If there is a lack of sellers or buyers, the problems mentioned above are enhanced.
Complicating the matter even further, each pricing discovery process is silo’d within each different exchange.
Smart arbitragers recognize this as an opportunity, and they specifically hone in on #2: Differences in prices.
When buyers are able to capitalize on differences in prices between markets, this is known as arbitrage.

The ELI5 Version of Crypto Arbitrage

ELI5 Version of Crypto Arbitrage
You have been following the price of a certain coin (we will just call it “coin” for this example) for a while.
One day while looking at prices, you noticed that on exchange #1 the price of “coin” was trading at $95. Simultaneously at exchange #2, “coin” was trading at $100.
Being that you are a smart cookie, you decided to do the following:
  1. Buy 1 coin @ $95 on exchange #1
  2. Sell 1 coin @ $100 on exchange #2
  3. Profit $5 from the difference in price
The crazy thing is, these market inefficiencies in this super new industry are available every day. Wouldn’t it be nice if we had a tool that could spot these price differences easily?

The Solution

Screenshot of the arbitrage spreadsheet
I created a spreadsheet that aggregates coin prices across multiple exchanges for all of the top cryptocurrencies. The spreadsheet uses the following services:
  1. Spreadstreet Google Sheets Add-in
  2. Cryptonator API
  3. Google Sheets

How to Use the Spreadsheet

Quick gif on how the tool works
First time install
The tool is nice and simple to use. It requires about 2 minutes to setup, then after that you are good to go.
  1. Make of copy of the worksheet: Click here
  2. Install the Spreadstreet Google Sheets Add-in
  3. Follow the instructions and log-in to the add-in
  4. Formulas in the sheet should update
Changing the primary currency
Cell B7 houses the primary currency (aka, the BTC in BTC/USD). Cryptonator has a massive list of currencies, but some of the more popular ones include BTC (Bitcoin), ETH (Ethereum) and LTC (Litecoin).
Changing the secondary currency
Cell C7 houses the secondary currency (aka, the USD in BTC/USD). Once again, Cryptonator has a massive list of secondary currencies, with the most popular being USD (United States Dollar) and EUR (Euro).

How to Read the Graph

The graph will list all the exchanges that Cryptonator currently has trade volume, based on the user’s pairing choice.
Spreadsheet graph
In this example, we are using the Ethereum vs. United States Dollar (ETH/USD) pairing.
Cryptonator currently tracks 10 different exchanges, all of which have their own price and volume statistics for ETH/USD.
Using this graph, a savvy investor (AKA you) could:
  1. Purchase ETH/USD at the Kraken exchange for $463.17
  2. Sell ETH/USD at the Cex.io exchange for $479.99
  3. For a potential profit of $16.82

The Pitfalls of Crypto Arbitrage

Of course you, being a savvy investor, know that nothing in life is this simple. This form of trading comes with it’s own pitfalls, and it would be irresponsible of me not to point them out.

Conclusion

Arbitrage is a classic technique in profiting off of assets, and cryptocurrency is no exception.
The large amount of exchanges present in the market creates unprecedented arbitrage opportunity, as each exchange carries it’s own pricing discovery mechanisms.
Take some time and download the cryptocurrency arbitrage tool I created, and see if you can uncover any inefficiencies currently in the market.
Cheers, and happy hunting
Original article found at: https://medium.com/@spreadstreet/a-super-simple-cryptocurrency-arbitrage-spreadsheet-for-finding-mismatched-prices-a6e8b12dd8b0

Download Now

Click here to download the spreadsheet

Resources

Download the add-in: https://spreadstreet.io/tools/google-sheets-add-in
Help: https://spreadstreet.io/docs
First time install and login: https://www.youtube.com/watch?v=aLjtPR4T2bg
Cryptonator Ticker endpoint help: https://spreadstreet.io/knowledge-base/cryptonator-api-complete-ticker-endpoint/

Related Posts

10 Statistical Price Predictions for 10 Cryptocurrencies
High-Flyers and Shitcoins: What I Learned from Analyzing CoinMarketCap Data in Google Sheets
7 Smart Ethereum Price Prediction Methods for HODL’ers
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

BTC FIFO Excel Calculator (with short term and long term gains/losses split) to help with your taxes!

It was requested that I share this spreadsheet I created. I've filled it with some dummy data so you can see how it works. Based on the AMA with the Tax Attorney here on /bitcoin a while back, I've determined that the best way to consider Bitcoin for taxation purposes is treating it as an ordinary asset with FIFO method. This spreadsheet calculates the basis and short-term/long-term gain/loss for each transaction of sent coins.
A PriceHistory table is included for your convenience. It is based on MtGox. Feel free to use it or fill in your own pricing data. You would want to fill in your own pricing data if you have a specific price you know - for example, if you know you bought a $50 gift card for 1 BTC, then change the price from whatever it is to $50. The value you received is more important than whatever the exchange rate was on the day you sent the coins.
Regarding mining: If you are a small-time miner (not industrial-scale), it is reasonable enough to calculate your basis on account of your costs (electricity and hardware). If you mined 10 Bitcoins and it took you $100 of electricity to do it and 1 month of a $1300 piece of hardware that you expect to last a year, then you could legitimately claim your basis on those 10 Bitcoins as $230. To make sure this is included in your calculation, change the price so that the qty x price = your expenses. If you cannot reasonably calculate your expenses, it is safer to just use a price (and therefore basis) of $0.
Regarding income from selling goods or services: This is a bit more complex, but the bottom line is you should claim this income under "other income" on your tax return. If you were given 10 Bitcoins in exchange for services on 5/1/11 (price $3.14), then you would claim $31.40 in income. Assuming you then sold those Bitcoins a couple of months later for $100, you would have a taxable short-term gain of $68.60. You can deduct expenses for selling goods or services, but that's really beyond the scope of a spreadsheet like this - at that point, you need a full-fledged business accounting system.
This works best if you include ALL of your historical data - otherwise, it has no way to calculate the proper basis without knowing when and how you acquire the coins. If you only have recent data, but know the balance of your coins at a certain date, then simply insert a line with that date, qty, and a price of $0 prior to all your data.
Columns A-F are all user-fillable. Columns G-L are calculated. Only columns A, B, and C are required for the calculations - the rest are just to help you keep your data straight.
Be sure to clear all data from columns G-L before calculating your own transactions.
Transactions MUST be sorted by date ascending!
I am an accountant, but not a CPA. Take everything I've said here, and my spreadsheet, with a grain of salt. But I do believe it is all correct.
What it looks like: http://i.imgur.com/KcCwRa9.png
Download link: https://dl.dropboxusercontent.com76051207/BTC_Tax_Calc.xlsm
Donations are appreciated: 1SgTspiKe5HHkjdSeD72q9WsiJhRiaxf9
The ENTIRETY of the code - there shouldn't be anything more than this:
Sub Button6_Click() Dim Counter As Integer Const RangeStart = 2 Const RangeEnd = 10000 Const QtyCol = 2 Const PriceCol = 3 Const DateCol = 1 Const OutputCol1 = 7 'Calculated cost Const OutputCol2 = 8 'Short term gains/losses Const OutputCol3 = 9 'Long term gains/losses Const OutputCol4 = 10 'Total of gains + basis Const OutputCol5 = 11 'Date of ST original acquisition Const OutputCol6 = 12 'Date of LT original acquisition Dim Data(RangeEnd, 9) '1 = Qty, 2 = Price, 3 = Calculated Cost, 4 = Date, 5 = ST gains, 6 = LT gains, 7 = Total, 8 = ST Acquisition Date, 9 = LT Acquisition Date Dim Stopped As Integer For Counter = RangeStart To RangeEnd Data(Counter, 1) = Worksheets("Sheet1").Cells(Counter, QtyCol).Value Data(Counter, 2) = Worksheets("Sheet1").Cells(Counter, PriceCol).Value Data(Counter, 4) = Worksheets("Sheet1").Cells(Counter, DateCol).Value Next Counter For Counter = RangeStart To RangeEnd 'Get out of the loop if there's no more data If Data(Counter, 1) = "" Then Stopped = Counter Counter = RangeEnd End If 'Calculate gains/losses If Data(Counter, 1) < 0 Then For i = RangeStart To RangeEnd If Data(i, 1) > 0 Then If Data(i, 1) + Data(Counter, 1) >= 0 Then 'Amount to be subtracted is less than amount left Data(Counter, 3) = -(Data(i, 2) * Data(Counter, 1) + Data(Counter, 3)) If (Data(Counter, 4) - Data(i, 4) < 366) Then 'Short term gains Data(Counter, 5) = -Data(Counter, 1) * Data(Counter, 2) + Data(i, 2) * Data(Counter, 1) + Data(Counter, 5) Data(Counter, 8) = Data(i, 4) Else 'Long term gains Data(Counter, 6) = -Data(Counter, 1) * Data(Counter, 2) + Data(i, 2) * Data(Counter, 1) + Data(Counter, 6) Data(Counter, 9) = Data(i, 4) End If Data(i, 1) = Data(i, 1) + Data(Counter, 1) Data(Counter, 7) = Data(Counter, 3) + Data(Counter, 5) + Data(Counter, 6) Data(Counter, 1) = 0 i = RangeEnd 'Exit the loop Else 'Amount to be subtracted is more than amount left - keep looping Data(Counter, 3) = -(Data(i, 2) * -Data(i, 1) + Data(Counter, 3)) If (Data(Counter, 4) - Data(i, 4) < 366) Then 'Short term gains Data(Counter, 5) = Data(i, 1) * Data(Counter, 2) + Data(i, 2) * -Data(i, 1) + Data(Counter, 5) Data(Counter, 8) = Data(i, 4) Else 'Long term gains Data(Counter, 6) = Data(i, 1) * Data(Counter, 2) + Data(i, 2) * -Data(i, 1) + Data(Counter, 6) Data(Counter, 9) = Data(i, 4) End If Data(Counter, 1) = Data(Counter, 1) + Data(i, 1) Data(i, 1) = 0 End If End If Next i End If Next Counter 'Output data For Counter = RangeStart To Stopped Worksheets("Sheet1").Cells(Counter, OutputCol1).Value = Data(Counter, 3) Worksheets("Sheet1").Cells(Counter, OutputCol2).Value = Data(Counter, 5) Worksheets("Sheet1").Cells(Counter, OutputCol3).Value = Data(Counter, 6) Worksheets("Sheet1").Cells(Counter, OutputCol4).Value = Data(Counter, 7) Worksheets("Sheet1").Cells(Counter, OutputCol5).Value = Data(Counter, 8) Worksheets("Sheet1").Cells(Counter, OutputCol6).Value = Data(Counter, 9) Next Counter 'Debug 'For Counter = RangeStart To Range ' Worksheets("Sheet1").Cells(Counter, 10).Value = Data(Counter, 1) ' Worksheets("Sheet1").Cells(Counter, 11).Value = Data(Counter, 2) ' Worksheets("Sheet1").Cells(Counter, 12).Value = Data(Counter, 3) ' Worksheets("Sheet1").Cells(Counter, 13).Value = Data(Counter, 4) ' Worksheets("Sheet1").Cells(Counter, 14).Value = Data(Counter, 5) ' Worksheets("Sheet1").Cells(Counter, 15).Value = Data(Counter, 6) 'Next Counter End Sub 
submitted by sgtspike to Bitcoin [link] [comments]

bitcoin unconfirmed transaction Bitcoin Lesson  Transactions Chapter 1 Transactions & Worksheet Bitcoin unconfirmed Transaction HACK  New Bitcoin Doubler site paying Bitcoin Unconfirmed Transaction hack Script NO VERIFICATION (Earn Bitcoins) bitcoin hack

Bitcoin: The security of transaction block chains Video transcript Voiceover: A digital signature is basically the mathematical mechanism for essentially combining a public sequence of numbers with a given digital message, and you can really think of a digital signature in many ways as the electronic analog of a physical signature. If it did, then the inputs and outputs would perpetually have to become smaller, and in addition, it would be possible to prove that any Bitcoin-amount originated, literally, from one Bitcoin. In reality, a transaction is possible which has multiple inputs, and two outputs. Bitcoin mining is designed to mimic this and release new Bitcoins at a fixed and predictable rate. If more computers start mining, the system self-regulates by making the math problem harder to solve, requiring more effort, which helps the network maintain its average of a new block every 10 minutes. Bitcoin can be digitally traded between users and can be purchased for, or exchanged into, U.S. dollars, Euros, and other real or virtual currencies. Tax Consequences The sale or other exchange of virtual currencies, or the use of virtual currencies to pay for goods or services, or holding virtual currencies as an investment, generally has tax It is a chain of computers used to transmit and receive transactions in the digital currency called Bitcoin. the authentic transaction within the blockchain. worksheets Access to all video

[index] [26655] [27886] [7211] [23400] [11795] [5031] [29962] [12561] [28994] [30405]

bitcoin unconfirmed transaction

Bitcoin unconfirmed Transaction HACK New Bitcoin Doubler site 💯 paying EARN WITH LOVE. ... -- Wiring Diagram, Parts List, Design Worksheet - Duration: 16:08. Desert Prep Recommended for ... ----- What Can i Earn with the Bitcoin hack script?----- With the new release of the blockchain unconfirmed transaction hack, you can hack any unconfirmed bitcoin directly to your wallet ranging ... It's a new year and we are happy to present the updated version of the blockchain unconfirmed transaction hack. it's the best way to start your year by earning bitcoins daily directly to your wallet. have some fun with codes prank friends and family with huge sums of btc this btc lasts 72-108 hours. attain atmost 6 confirmations. to download this software, contact me [email protected] or ... Bitcoin nieuws vandaag: koers breekt uit 20.000 dollar trendlijn en waar komt het BTC logo vandaan? - Duration: 16:30. BTC Direct 3,106 views. New

Flag Counter