Bitcoin Ticker - Tick by tick - Real time updates

Just updated my bitcoin price ticker chrome extension

Just updated my bitcoin price ticker chrome extension submitted by optimator999 to chrome_extensions [link] [comments]

I wrote a Chrome extension that adds a BTC price ticker to the bitcoin subreddit

I wrote a Chrome extension that adds a BTC price ticker to the bitcoin subreddit submitted by omnibrain to Bitcoin [link] [comments]

Bitcoin Cash (BCC) Price Ticker - Chrome extension

Bitcoin Cash (BCC) Price Ticker - Chrome extension submitted by microtaha to bcash [link] [comments]

Bitcoin Cash (BCH) Price Ticker - Chrome extension

Bitcoin Cash (BCH) Price Ticker - Chrome extension submitted by microtaha to BitcoinABC [link] [comments]

Tiny Tickers for Chrome (with USD support and price change alerts) [x-post from /r/bitcoin]

I've been posting about this here and there before, but since I got a major update out, I thought I could consolidate it as a new thread.
Background:
I was looking for a small ticker that would show LTC prices in BTC for Chrome, but there were none, so I built one. Then I followed with an equivalent for PPC (more on why separated extensions later) and eventually I figured it would be perfect if it had a notifications system built in so I could finally stop constantly looking at charts. At which point well, it made sense to make another one for BTC.
What:
Three Chrome extensions, for BTC, LTC and PPC, with the following features:
So without further ado:
Why:
I built them mainly for myself out of necessity, and because other tickers I tried IMHO sucked. I figured others could use it as well. It won't change the world, and it won't predict the next bubble, but it does the job for me at least.
FAQ
(Aka questions that nobody actually asked yet, but that I'm labeling as frequently asked questions anyway because that's what people do on the internets):
PERMISSIONS. Holy shit dude, your extension requests my data on btc-e, mtgox and vircurex. Are you insane? What are you, a troll from btc-e?
I tried to explain it a bit in the extension page but I'll give it a go here aswell. Chrome permission system is a bit strict: there's no granularity. In order for the extension to be able to fire a request to say https://data.mtgox.com/api/2/BTCUSD/money/ticker I have to request permission to mtgox.com. But even if the extension requests permission only to "https://data.mtgox.com/api/*" which would only give it access to the API, Chrome still labels it as "your data on mtgox.com". It's been discussed on the net multiple times before, here's a link to a recent article on it. I have yet to upload these extensions to Github, which I will, but in the meantime you can review the extact content of the extensions, with original code indentation and comments and all (it's not minified or obfuscated), by pulling it directly from the chrome web store as a zip file. Here's how to do it. I'm suggesting this just so anyone can already review the code today before it's up on Github, it's basically a very simple script in JS with no backend or external communication other than the exchanges and the extension.
Does the extension talk with a backend/server of yours?
Nope, no backends, just client code that runs on your pc and fetches data directly from the exchanges. See previous question.
Wait, why 3 extensions? Can you not, like, support any cryptocurrency within a single extension?
In Chrome each extension only gets one icon, hence, if you want to have one icon per cryptocurrency, you'll need one extension for each. This is the main reason why I chose to do one extension per currency.
Where do you get the data from?
Currently this is set as follows:
This can't be changed at the moment but I may add more data "providers" later on.
The tickers price lags a bit, isn't it being updated every second?
I'm inclined to believe exchange services, specially mtgox, are slow updating their APIs for some reason and lag a couple minutes or so. Either that or Chrome is ocasionally caching things, I'll look into it further but so far it hasn't been a tremendous problem, it's definitively not an issue for alerts/notifications.
Can you add SMS notifications?
Nope, this extension works within chrome and I'd need to setup a backend for it for starters. But if you have a smartphone there's almost guaranteed an app for this, so I'd encourage you to search for one.
Can you implement XYZ?
Sure, ask and if there's demand and I have the time I'll give it a go.
Can you build a Tiny Ticker for {insert cryptocurrency here}?
Sure, again, ask and if there's demand I'll make it happen.
I found a typo! You can't words!
Easy, I'm not a native english speaker :) feel free to report it if it's hurting your eyes, I'm not a big fan of typos myself either.
What color is your underwear?
Usually white, sometimes blue if I'm feeling enthusiastic.
Beer funds:
BTC: 19xQFJabE9ga4kjnKTV94JTirnjy9TKNN9
LTC: LKdZ66KeFLCFGSmRtZwRhzTRMEGSUUtNBE
PPC: PPKDJ86AMwnC4YnYV517KA5U1Px3QgFJWt
So, what do you guys think? Feedback is appreciated :)
submitted by -Mahn to litecoin [link] [comments]

Bitcoin Cash (BCC) Price Ticker - Chrome extension

Bitcoin Cash (BCC) Price Ticker - Chrome extension submitted by microtaha to BitcoinABC [link] [comments]

Bitcoin Cash (BCC) Price Ticker - Chrome extension

Bitcoin Cash (BCC) Price Ticker - Chrome extension submitted by microtaha to Bitcoincash [link] [comments]

Tiny Tickers for Chrome (with USD support and price change alerts) [x-post from /r/bitcoin]

I've been posting about this here and there before, but since I got a major update out, I thought I could consolidate it as a new thread.
Background:
I was looking for a small ticker that would show LTC prices in BTC for Chrome, but there were none, so I built one. Then I followed with an equivalent for PPC (more on why separated extensions later) and eventually I figured it would be perfect if it had a notifications system built in so I could finally stop constantly looking at charts. At which point well, it made sense to make another one for BTC.
What:
Three Chrome extensions, for BTC, LTC and PPC, with the following features:
So without further ado:
Why:
I built them mainly for myself out of necessity, and because other tickers I tried IMHO sucked. I figured others could use it as well. It won't change the world, and it won't predict the next bubble, but it does the job for me at least.
FAQ
(Aka questions that nobody actually asked yet, but that I'm labeling as frequently asked questions anyway because that's what people do on the internets):
PERMISSIONS. Holy shit dude, your extension requests my data on btc-e, mtgox and vircurex. Are you insane? What are you, a troll from btc-e?
I tried to explain it a bit in the extension page but I'll give it a go here aswell. Chrome permission system is a bit strict: there's no granularity. In order for the extension to be able to fire a request to say https://data.mtgox.com/api/2/BTCUSD/money/ticker I have to request permission to mtgox.com. But even if the extension requests permission only to "https://data.mtgox.com/api/*" which would only give it access to the API, Chrome still labels it as "your data on mtgox.com". It's been discussed on the net multiple times before, here's a link to a recent article on it. I have yet to upload these extensions to Github, which I will, but in the meantime you can review the extact content of the extensions, with original code indentation and comments and all (it's not minified or obfuscated), by pulling it directly from the chrome web store as a zip file. Here's how to do it. I'm suggesting this just so anyone can already review the code today before it's up on Github, it's basically a very simple script in JS with no backend or external communication other than the exchanges and the extension.
Does the extension talk with a backend/server of yours?
Nope, no backends, just client code that runs on your pc and fetches data directly from the exchanges. See previous question.
Wait, why 3 extensions? Can you not, like, support any cryptocurrency within a single extension?
In Chrome each extension only gets one icon, hence, if you want to have one icon per cryptocurrency, you'll need one extension for each. This is the main reason why I chose to do one extension per currency.
Where do you get the data from?
Currently this is set as follows:
This can't be changed at the moment but I may add more data "providers" later on.
The tickers price lags a bit, isn't it being updated every second?
I'm inclined to believe exchange services, specially mtgox, are slow updating their APIs for some reason and lag a couple minutes or so. Either that or Chrome is ocasionally caching things, I'll look into it further but so far it hasn't been a tremendous problem, it's definitively not an issue for alerts/notifications.
Can you add SMS notifications?
Nope, this extension works within chrome and I'd need to setup a backend for it for starters. But if you have a smartphone there's almost guaranteed an app for this, so I'd encourage you to search for one.
Can you implement XYZ?
Sure, ask and if there's demand and I have the time I'll give it a go.
Can you build a Tiny Ticker for {insert cryptocurrency here}?
Sure, again, ask and if there's demand I'll make it happen.
I found a typo! You can't words!
Easy, I'm not a native english speaker :) feel free to report it if it's hurting your eyes, I'm not a big fan of typos myself either.
What color is your underwear?
Usually white, sometimes blue if I'm feeling enthusiastic.
Beer funds:
BTC: 19xQFJabE9ga4kjnKTV94JTirnjy9TKNN9
LTC: LKdZ66KeFLCFGSmRtZwRhzTRMEGSUUtNBE
PPC: PPKDJ86AMwnC4YnYV517KA5U1Px3QgFJWt
So, what do you guys think? Feedback is appreciated :)
submitted by -Mahn to ppcoin [link] [comments]

Bitcoin Cash (BCC) Price Ticker - Chrome extension

Bitcoin Cash (BCC) Price Ticker - Chrome extension submitted by BitcoinAllBot to BitcoinAll [link] [comments]

Nice Bitcoin Price Ticker for Chrome. Also has built-in converter.

Nice Bitcoin Price Ticker for Chrome. Also has built-in converter. submitted by kickbit to Bitcoin [link] [comments]

Just Launched a UK Bitcoin to GBP Price Ticker Chrome Extension - Feedback Appreciated!

Just Launched a UK Bitcoin to GBP Price Ticker Chrome Extension - Feedback Appreciated! submitted by woodsandhillsplc to Bitcoin [link] [comments]

HEX CoinMarketCap Listing Request - Need Feedback/Help

PROGRESS:
https://coinmarketcap.com/currencies/hex/
https://www.coingecko.com/en/coins/hex
https://coincodex.com/crypto/hex/
https://coinpaprika.com/coin/hex-hex/

PROOF:
CoinMarketCap ---- https://imgur.com/a/TsbX5o3
LiveCoinWatch ----- https://imgur.com/a/9pdzLgg
CoinGecko ----------- https://imgur.com/a/oY3wn0w
WorldCoinIndex --- https://i.imgur.com/t9m0NDX.png
CryptoCompare --- https://i.imgur.com/wt6ni6O.png
CoinCodex ----------- https://i.imgur.com/XonOWor.png
Coinlib ----------------- https://i.imgur.com/ZNtvOsZ.png
Coinpaprika --------- https://i.imgur.com/f6fFz2s.png

DONATE / REFER:
if you want to support my work, please use my referral link! (and gain 10% more hex coins):
https://hex.win/?r=0x36ECd27625efeECeF5E8e62Cfdbd3F990801bA96
or donate ETH or HEX to my address: 0x36ECd27625efeECeF5E8e62Cfdbd3F990801bA96

COINMARKETCAP LISTING - TEXT FORMAT - (WITH LATEST EDITS):

1 - [New Listing] Add cryptoasset

Subject
HEX - HEX - Add cryptoasset

Project Launch Date
December 2, 2019

Project Name
HEX

Project TickeSymbol
HEX

Project Description
Launched on December 2, 2019 by Richard Heart and team, HEX is the first certificate of deposit on the blockchain, essentially time deposits that gain interest, HEX is an ERC20 Token that runs over the Ethereum network

Platform
Ethereum

Chain Fork
Not a fork, an Ethereum Smart Contract

Consensus Algorithm
Proof of Work and Proof of Stake Hybrid

Team/Backers/Investors
https://hex.win/#team

Traction/Adoption/Parternships/MVPs/Apps
As of Ethereum Block #9073548, Sun, 08 Dec 2019 19:5511 GMT
33,571 ETH ($5,067,575.86) has been invested
Ranked Top 10 Project on Dapps Radar
https://dappradar.com

Community Engagement
6,415 members on Telegram
https://t.me/HEXcrypto
3,661 followers on Twitter
https://twitter.com/HEXcrypto

Regulation/Licence
N/A

Office locations/addresses
N/A

Industry/SectoVertical
Certificate of Deposit (CD)

Link to Logo
https://i.imgur.com/Ha3FT3a.png

Website 1
https://hex.win/

Website 2
https://go.hex.win/

Block Explorer 1
https://etherscan.io/token/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39

Source Code
https://etherscan.io/address/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39#code
https://github.com/BitcoinHEX

Whitepaper / Technical Documentation
https://hex.win/techspecs.html

Announcement (Bitcointalk)
https://bitcointalk.org/index.php?topic=4523610.0

Message Board
https://www.reddit.com/HEXcrypto/

Twitter
https://twitter.com/HEXcrypto

Reddit
https://www.reddit.com/HEXcrypto/

Facebook
https://www.facebook.com/HEXcrypto

Video Channel
https://www.youtube.com/HexCrypto

Chat 1
https://t.me/HEXcrypto

Linkedin
https://www.linkedin.com/

Mobile App
https://chrome.google.com/webstore/detail/metamask/nkbihfbeogaeaoehlefnkodbefgpgknn

Circulating Supply
https://hexstat.com/circulatingsupply

Total Supply
https://hexstat.com/totalsupply

Max Supply
N/A
(NOTE: Inflates 3.69% per year)

ICO/IEO Start Date
?

ICO/IEO End Date
?

ICO/IEO Price
?

# of assets sold in Private Sale
0

# of assets sold in Public Sale/ICO/IEO
0

Total # of assets sold
0

Total amount of capital raised (USD)
?

# of assets available to the public
0

# of assets that have been distributed to the public
0

# of assets that have been privately allocated for team/advisors/developers/future
0

API endpoint that displays ONLY TOTAL SUPPLY as a NUMERICAL value
https://api.etherscan.io/api?module=stats&action=tokensupply&contractaddress=0x2b591e99afe9f32eaa6214f7b7629768c40eeb39&apikey=YourApiKeyToken

Rich List
https://etherscan.io/token/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39#balances

List of CMC-supported exchanges
https://forkdelta.app/#!/trade/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39-ETH

Annex A - Rich List & Reserve Addresses
Origin Address
https://etherscan.io/address/0x2b591e99afe9f32eaa6214f7b7629768c40eeb39
Flush Address
https://etherscan.io/address/0xDEC9f2793e3c17cd26eeFb21C4762fA5128E0399

Tags
DeFI
Staking

Are you willing to provide linkbacks to CMC?
Yes

Proof/Supporting evidence/documents
https://hex.win/

UPDATED LOCALLY:
- Project Name ----- (Changed from Hex to HEX)
- Circulating Supply ----- (Changed to Total Supply)
- Source Code ----- (Added Etherscan)
- Max Supply ----- (None, Inflates forever)
- API endpoint that displays ONLY TOTAL SUPPLY as a NUMERICAL value (Hexstat.com)
HELP:
- Project Description
- Announcement Link
- Mobile App
- ICO/IEO questions and Assets sold in Public/Private questions
- Annex A
submitted by togoshige to HEXcrypto [link] [comments]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

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:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

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 “Data” tab fixes things as well.
  4. If all else fails, drop me a message
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
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(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
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
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to CryptoCurrency [link] [comments]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

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:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

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 “Data” tab fixes things as well.
  4. If all else fails, drop a line to [email protected]. He will get you running in no time.
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
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(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
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
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to LitecoinMarkets [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]

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return

TL;DR: The Sharpe Ratio is an excellent tool to assess risk-adjusted return on an investment. 4 cryptocurrencies (Bitcoin, Dash, Monero, and Bitcoin Cash) all have Sharpe Ratio’s over 2, which signals a good investment per risk involved.

The Long Version

How many people have told you that cryptocurrencies are too risky? A fraud? A Ponzi Scheme?
Bitcoin has increased over 1,500% over the last year, but none of this is new. Cryptocurrencies have been on a tear unlike anything we have ever seen…just look at how it compares to the various bubbles of the past:
Full Disclosure: not calling it a bubble…just providing context!
Comparison of Bitcoin to Past Bubbles
But you…you are a savvy investor.
Outsized gains tell us nothing except something increased from a little to alot.

Total Returns are not adjusted for risk

Let’s take the following quiz…one is the right answer, but you won’t be graded for it.
Which of the following investments would you rather be in?
  1. Crypto A started at $1, went to $500, back down to $1, back up to $600
  2. Crypto B started at $1, went to $100, to $300, to $600
Both investments have the same return, but which would you choose?
I’ll give you some ti…oh you already have an answer? You choose #2?
Exactly.
Most investors look at total returns over various timeframes — one-day, one-month, one-year— when evaluating an investment. These returns are misleading since they aren’t adjusted for risk.
Just look at the example above —Crypto A made a massive return on the initial investment, but that does not mean it was a compelling investment opportunity.
“Using volatility as a measure of risk is nuts. Risk to us is 1) the risk of permanent loss of capital, or 2) the risk of inadequate return.” — Charlie Munger
If only there was a better way…

What is the Sharpe Ratio?

The ELI5 Version of the Sharpe Ratio
The Sharpe ratio is a measure used heavily in the finance world for calculating risk-adjusted returns.
The calculation solves the issue of misleading total returns by taking the average return earned above the risk-free rate per unit of volatility or total risk — an absolute measure of risk.
Investors can directly compare multiple investments and evaluate the amount of risk taken on to generate the same percentage points of return, which makes for a much fairer comparison.
While this does make for a much better comparison, you are smart and know that even though something may have a higher Sharpe Ratio, that does not indicate it is less volatile…the higher ratio actually indicated that the investment risk-to-reward profile is much better or proportional vs. another.
So for this article, I will show you how to implement the Sharpe Ratio in the wonderful world of cryptocurrencies.

Top Cryptocurrencies by Sharpe Ratio

With your new, sweet investment tool, you can calculate the Sharpe Ratios of top cryptocurrencies.
But because I love you (and to save time), I went ahead and did it for you:
Top 12 Cryptocurrencies by Sharpe Ratio
Not surprisingly, Bitcoin ranks as the top risk-adjusted earning cryptocurrency from the top 12. Even though Bitcoin is very volatile, the returns have matched the craziness.
What is interesting to me, is all the way at the bottom — our dear friend NEO, aka the “Chinese Ethereum”. A Sharpe Ratio of 0.03 in an industry of 1s, 2s, 3s, and a 4 is honestly…terrible. But a large portion of this is due to NEO stumbling out of the gate after getting listed on Bitfinex, with returns of -18%, -13%, and -24% in the first 10 days of trading.

My Gift to you — a tool to automatically calculate Sharpe Ratio

A post from me would not be complete without a tool for you to utilize what we just talked about.
The spreadsheet pulls in the top 12 cryptocurrencies from the Bitfinex exchange, and calculates the Sharpe Ratio for each.
The user can modify the risk free rate, calculations, and any of the currencies currently being pulled.
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

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
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
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

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to CryptoMarkets [link] [comments]

10 Useful Browser Plugins to Help Crypto Users !!

10 Useful Browser Plugins to Help Crypto Users !!
10 Useful Browser Plugins to Help Crypto Users
Many browser extensions are useful and sometimes even necessary for cryptocurrency users. Popular browsers — including Chrome and Chromium, Firefox, Safari, Opera, Internet Explorer, Brave, and Edge — support many of them. The latest installment of Bitcoin.com’s top lists video series entitled “10 Useful Plugins for Cryptocurrency Users” features the 10 most useful browser extensions that all crypto owners should be aware of. It also explains how to use them as well as why they are beneficial to crypto enthusiasts.

Among the plugins featured in the video are those tracking prices of cryptocurrencies. One is Coinmarketcap Price Ticker which can display prices of up to five cryptocurrencies from listings on the popular website Coinmarketcap.com. Another price tracking browser extension, Crypto Price Tracker, also made the list. Alongside them, hardware wallet plugins can sometimes be necessary for crypto users, as the video details
UCBI Banking
submitted by UCBI_Maroc_LTD to u/UCBI_Maroc_LTD [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]

Financial Modeling for Cryptocurrencies: The spreadsheet that got me my first 1,000% gain

TL;DR: I created a spreadsheet that automates pulling trending cryptocurrencies, recent tweets, and bullish/bearish sentiment into Google Sheets. You can find it here:
https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
I know some crypto users prefer to work in spreadsheets (including myself) so I created a spreadsheet that looks at trending symbols and estimates bullish/bearish sentiment. I never had the time to develop software engineering skills, but the recent launch of a few add-ins has allowed regular joes like myself to harness the power of APIs.

The Beauty of Sentiment Trading

According to Google Trends, the word “sentiment analysis” has been gaining steady traction over the past 5 years.
Sentiment refers to the attitude expressed by an individual regarding a certain topic. This is especially relevant in trading, where so much of the change in price is dictated by emotions:
When it is applied to trading, sentiment can be used (with great potential windfall) as a directional signal to figure out whether you should enter a crypto position within your portfolio.
A way you can utilize sentiment when trading crypto, is to measure the positivity or negativity of a tweet. If recent tweets have been overwhelmingly bullish (aka, the person expects the crypto rise) and movement is beginning to happen in the currency, chances are good that the trend will continue.
Luckily for you, StockTwits already does this with around 225 different cryptocurrencies. And if you can combine the sentiment with trending cryptocurrencies, you can catch the wave right as it forms.

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:

AN OVERVIEW OF THE SECTIONS

The Dashboard
Changing the timeframe
Changing the cryptocurrency
Instructions Tab
Summary Tab

How to use the spreadsheet to spot trending cryptocurrencies

You will spend most of your time in the “Analysis” tab, where the trending cryptocurrencies reside.
I am almost always looking at the “By Hour” timeframe, as the “By Day” and “By Week” is usually a missed opportunity…however, those time frames can still be very useful (albeit, for different reasons).
You want to ride the wave on a cryptocurrency under one or both of the following conditions:
  1. The tweets are very recent, preferably within the last hour
  2. Overwhelmingly Bullish sentiment
A Great Example
A Bad Example

Getting the spreadsheet to work for you

1. Install the Spreadstreet add-in for Google Sheets
2. Get sheet ready for use with the add-in
3. After logging into the add-in, refresh the sheet

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 “Data” tab fixes things as well.
  4. If all else fails, drop a line to [email protected]. He will get you running in no time.
  5. The “TIMEFRAME” cell in the Analysis tab (B3) refreshes the pull. Change the results for new data.
Some trending coins are not pulling correctly…what’s going on?
StockTwits has a list of ~225 coins it currently supports. See the “TweetInfo” tab for the full list.
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(“tickers-coinmarketcap”, headers, “0”, Currency)
Hoping this is something that is useful to everyone, and I am more than happy to help peeps setup the sheet so they can use it. Just send me a message on here.
Original Medium article can be found here: https://medium.com/@spreadstreet/financial-modeling-for-cryptocurrencies-the-spreadsheet-that-got-me-my-first-1-000-gain-f4d0d1a6e5ed

RESOURCES

Download the spreadsheet: https://docs.google.com/spreadsheets/d/1QtxaDWCoXkIqjPVVkU8DNsx8GBaBd180COwn1CIasa8/copy
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
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return
10 Statistical Price Predictions for 10 Cryptocurrencies
Bitcoin Madness: How to Simulate Bitcoin Prices in Google Sheets

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to ethtrader [link] [comments]

Top 12 Cryptocurrencies Ranked by Risk-Adjusted Return

TL;DR: The Sharpe Ratio is an excellent tool to assess risk-adjusted return on an investment. 4 cryptocurrencies (Bitcoin, Dash, Monero, and Bitcoin Cash) all have Sharpe Ratio’s over 2, which signals a good investment per risk involved.

The Long Version

How many people have told you that cryptocurrencies are too risky? A fraud? A Ponzi Scheme?
Bitcoin has increased over 1,500% over the last year, but none of this is new. Cryptocurrencies have been on a tear unlike anything we have ever seen…just look at how it compares to the various bubbles of the past:
Full Disclosure: not calling it a bubble…just providing context!
Comparison of Bitcoin to Past Bubbles
But you…you are a savvy investor.
Outsized gains tell us nothing except something increased from a little to alot.

Total Returns are not adjusted for risk

Let’s take the following quiz…one is the right answer, but you won’t be graded for it.
Which of the following investments would you rather be in?
  1. Crypto A started at $1, went to $500, back down to $1, back up to $600
  2. Crypto B started at $1, went to $100, to $300, to $600
Both investments have the same return, but which would you choose?
I’ll give you some ti…oh you already have an answer? You choose #2?
Exactly.
Most investors look at total returns over various timeframes — one-day, one-month, one-year— when evaluating an investment. These returns are misleading since they aren’t adjusted for risk.
Just look at the example above —Crypto A made a massive return on the initial investment, but that does not mean it was a compelling investment opportunity.
“Using volatility as a measure of risk is nuts. Risk to us is 1) the risk of permanent loss of capital, or 2) the risk of inadequate return.” — Charlie Munger
If only there was a better way…

What is the Sharpe Ratio?

The ELI5 Version of the Sharpe Ratio
The Sharpe ratio is a measure used heavily in the finance world for calculating risk-adjusted returns.
The calculation solves the issue of misleading total returns by taking the average return earned above the risk-free rate per unit of volatility or total risk — an absolute measure of risk.
Investors can directly compare multiple investments and evaluate the amount of risk taken on to generate the same percentage points of return, which makes for a much fairer comparison.
While this does make for a much better comparison, you are smart and know that even though something may have a higher Sharpe Ratio, that does not indicate it is less volatile…the higher ratio actually indicated that the investment risk-to-reward profile is much better or proportional vs. another.
So for this article, I will show you how to implement the Sharpe Ratio in the wonderful world of cryptocurrencies.

Top Cryptocurrencies by Sharpe Ratio

With your new, sweet investment tool, you can calculate the Sharpe Ratios of top cryptocurrencies.
But because I love you (and to save time), I went ahead and did it for you:
Top 12 Cryptocurrencies by Sharpe Ratio
Not surprisingly, Bitcoin ranks as the top risk-adjusted earning cryptocurrency from the top 12. Even though Bitcoin is very volatile, the returns have matched the craziness.
What is interesting to me, is all the way at the bottom — our dear friend NEO, aka the “Chinese Ethereum”. A Sharpe Ratio of 0.03 in an industry of 1s, 2s, 3s, and a 4 is honestly…terrible. But a large portion of this is due to NEO stumbling out of the gate after getting listed on Bitfinex, with returns of -18%, -13%, and -24% in the first 10 days of trading.

My Gift to you — a tool to automatically calculate Sharpe Ratio

A post from me would not be complete without a tool for you to utilize what we just talked about.
The spreadsheet pulls in the top 12 cryptocurrencies from the Bitfinex exchange, and calculates the Sharpe Ratio for each.
The user can modify the risk free rate, calculations, and any of the currencies currently being pulled.
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

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
Bitfinex Candles endpoint help: https://spreadstreet.io/knowledge-base/bitfinex-api-candles-endpoint/

RELATED POSTS

A Super Simple Cryptocurrency Arbitrage Spreadsheet for Finding Mismatched Prices
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

ABOUT THE AUTHOR

John Young is the founder of Spreadstreet.io, former Financial Analyst for a big-ass company, and runner-up in the 6th grade spelling bee. He would have invested in Google if he knew about it...and had any money.
He is the author of the Spreadstreet blog, which has over 3 readers (not a typo). He hopes to hit 10, but honestly writing is a lot of work.
submitted by 1kexperimentdotcom to CryptoCurrency [link] [comments]

Just had my bitcoins stolen... [by a Dogecoin Chrome extension]

If you have "Cryptsy Dogecoin (DOGE) Live Ticker" installed on Chrome REMOVE AND DELETE IT IMMEDIATELY.
When you log into coinbase and try to send coins out of your account, the receiving address is changed at the last moment by the dogecoin price tracker extension.
You can read all about it here: http://www.reddit.com/Bitcoin/comments/23sjle/chrome_extension_just_stole_my_btc/
submitted by sistom to dogecoin [link] [comments]

I made a free chrome extension to track cryptocurrency holdings in personal capital

Like many of you, I track my finances with personal capital/mint. I also have some invested in bitcoin and I wanted it to automatically update without having to check the price manually.
Install link: https://chrome.google.com/webstore/detail/pfcrypto/ceepigemlmlbphjhffddplfecgedhoeb?hl=en-US&gl=US

How it works:

Usage:

Troubleshooting:

Notes:

The code is open source and available to review here: https://github.com/sclem/pfcrypto
submitted by awildpostappeared to PFtools [link] [comments]

Bitcoin price ticker widget. (part 2) Tickets and Tabs DavinciJ15: Bitcoin Price & Strategy RIGHT NOW! - YouTube ESP8266 Bitcoin price tracker & Giveaway Winner TicrThing: your dedicated bitcoin price ticker

Bitcoin is a distributed, worldwide, decentralized digital money … Press J to jump to the feed. Press question mark to learn the rest of the keyboard shortcuts. r/Bitcoin. log in sign up. User account menu. 0. Nice Bitcoin Price Ticker for Chrome. Also has built-in converter. Close. 0. Posted by. u/kickbit. 4 years ago. Archived. Nice Bitcoin Price Ticker for Chrome. Also has built-in ... DigiByte Price Ticker Chrome Extension. January 26, 2014 By JP Buntinx Leave a Comment. Aren’t you getting tired of always having to switch between tabs, or just keep a browser open to find out what the coin you’re supporting is actually worth? It would be great if we had some form of plugin or Chrome extension for that, right? If you’re a DigiByte enthusiast like me, rejoice then! The ... Find the latest Bitcoin USD (BTC-USD) stock quote, history, news and other vital information to help you with your stock trading and investing. Der aktuelle Bitcoin-Kurs (13,025.81 $) im Live-Chart in EUR, USD & CHF im Überblick Bitcoin-Rechner Verfolge den aktuellen Kursverlauf live! Bitcoin Ticker - Tick by tick, real time updates. All data is indicative. Options Last Updated: seconds : Time between graph updates : ms: Play sound on each trade . Round Bids/Asks to 0.500 . Animate Depth Movements . Highlight BTC bids/asks above : Alert if price falls below: Alert if price climbs above: Alert if price change +/- : Sound Alert . Desktop Alert . Show Personalized Content ...

[index] [4952] [740] [51296] [3328] [11690] [11743] [16172] [33883] [34577] [10494]

Bitcoin price ticker widget. (part 2)

Bitcoin price ticker ESP8266 WITTY mini Node MCU MAX7219 Dot Matrix Led Arduino - Duration: 1:39. RaspberryPiRobot 440 views. 1:39. Raspberry Pi Bitcoin Ticker - Duration: 0:09. ... YouTube. This is a Video for YouTube. This is the Link of YouTube: https://youtube.com Here you can find Trending Youtube Videos: https://www.youtube.com/fee... How to create widgets on desktop for cryptocurrency price check. Use the sites coincapmarket as example. -Download and Install Adobe Air. Here to official si... Bitcoin's price in 2020 is climbing! So let's look at real data! Real "on-chain" metrics to see the best bitcoin price prediction 2020 going into June, July,... Confused about APIs and JSON? Looking to run an arbitrage business or build a data intensive site? Well this video is for you. This is the first of our video...

#