Investors have varied definitions of success, but no one can argue the significance of beating benchmarks such as the S&P 500. Since the index leveled off at 500 companies in 1957, the average annual return hovers around 8%. All investors consider beating the S&P 500 a massive win, especially if you can do so consistently.
The blockchain industry has yet to adopt an index that tracks the growth of the overall crypto landscape, but many investors see bitcoin as the leading indicator. As such, Bitcoin Market Journal has constructed a portfolio optimization tool to help you beat Bitcoin!
The model provides two separate portfolios, one with ten digital assets and the other with three. The model takes historical pricing into account to determine the optimal weights for each digital asset. If done correctly, investors can use historical data to predict the probability of beating Bitcoin returns on a daily, weekly, and yearly basis.
To help with setting up your optimal portfolio, BMJ has included detailed instructions throughout the rest of the article.
Its no secret that some of the top performing digital assets have little to do with bitcoin. Scores of altcoins have realized incredible gains in the past few years, surpassing even the most notable assets on the market.
The five coin portfolio uses historical price data from Ether (ETH), Ripple (XRP), Monero (XMR), Litecoin (LTC), and NEM (XEM) to demonstrate those impressive gains in comparison to bitcoin over the last few years.
An evenly weighted five coin portfolio, for example, would produce 3.5x the return of an all bitcoin portfolio, according to our historical data range of approximately three years.
Analyzing and experimenting with the evenly weighted portfolio is the first step in the process. Investors should prioritize their asset allocations based on personal investment goals. The portfolio optimizer can help by using historical pricing to establish trends and forecast future results.
Although an evenly weighted portfolio could outperfom bitcoin should the altcoin market continue its impressive increase in value there is still plenty of room for portfolio optimization.
The BMJ portfolio optimization model gives historical pricing for bitcoin and other digital assets from August 2, 2016 to October 14, 2019. Although the range is not ideal, the majority of altcoins have appeared over the last few years, so there isnt much price data available.
In the model, investors can construct portfolios using the five or three asset models that maximize their chances of beating bitcoin. The five asset model includes Ether (ETH), XRP (XRP), Monero (XMR), Litecoin (LTC), and NEM (XEM). The three asset model has only ETH, XRP, and XMR.
Investors have two options when it comes to optimizing their portfolios. The first will use 0s and 1s to indicate the weeks in which the constructed portfolio has a lesser return (marked by 0) and those weeks it has a higher return (marked by 1) than BTC. The average of all 0s and 1s yields the probability of beating bitcoin.
The other method uses the daily change in price to optimize the digital asset weights. The goal is to maximize the difference between the daily growth rate of the portfolio and that of bitcoin.
NOTE:You must download Evolver as an Excel add-on in order to use the portfolio optimizer. The following instructions are meant specifically for the five coin portfolio. The three coin model runs the same way but with data in different cells.
Step 1: Maximize Probability using Evolver
It is important to keep in mind that solutions may vary due to processing speed and quality of personal computer. The goal is to beat an equally weighted portfolio by optimizing the Validation and Estimation data probabilities of beating bitcoin.
Having said that, the 0s and 1s do not tell the whole story. Using 1 to indicate that we beat the Bitcoin does not tell us by how much. For example, the model might beat bitcoin over 50 percent of the time on a day-to-day basis but still have a lower return over those two years. To solve this issue, we can maximize the difference between the compound daily growth rates (CDGR) of Bitcoin and the portfolio.
Step 2: Maximize Difference in CDGRs
The portfolio will display the optimal weights of each asset to maximize the difference between the CDGR of both bitcoin and our portfolio. Investors should expect to see some assets with weights of 0 percent as the model has only one goal in mind: optimize our chances of beating bitcoin.
Savy Excel users can alter the model and add constraints such as minimum 5 percent for each asset. The more time spent tinkering with the model, the easier it becomes to manipulate it for optimal returns.
The blockchain investment world has always suffered from a major issue: its nearly impossible to evaluate altcoins. Investors choose their digital assets based on anything they see as significant to price movements. The randomness in crypto investing must end at some point, so why not today?
Using the crypto portfolio optimizer tool, investors can use real historical data to assist in their portfolio construction. Allocating the right amount of funds to each asset is one of the most important decisions when investing, so it is important to utilize Excel models to optimize your portfolio based on historic trends.
Having said that, past trends do not yield future results. That means that optimal portfolios that you construct using our model may not outperform bitcoin in the future, should your altcoin portfolio components not generate similar returns as in the past three years.
Download the BMJ Crypto Portfolio Optimization Tool here.
Related Articles:
Subscribe to Bitcoin Market Journal to stay up to date with the latest trends in digital asset investing.
Continued here:
How to Beat Bitcoin With Altcoins (Using the BMJ Crypto Portfolio Optimization Tool) - Bitcoin Market Journal
- The Great Debate - Bitcoin vs Altcoin - Video [Last Updated On: April 12th, 2014] [Originally Added On: April 12th, 2014]
- Altcoin Bitcoin Trading Bot BTCE, Cryptsy, Mintpal, Poloniex, etc - Video [Last Updated On: April 22nd, 2014] [Originally Added On: April 22nd, 2014]
- UniversityCoin UVC Project Initiatives - New PoS Altcoin 2014 - Video [Last Updated On: May 6th, 2014] [Originally Added On: May 6th, 2014]
- Bitcoin and altcoin speculation - Video [Last Updated On: May 27th, 2014] [Originally Added On: May 27th, 2014]
- Bitcoin Faucet / Altcoin Faucet FREE BITCOINS - Video [Last Updated On: May 29th, 2014] [Originally Added On: May 29th, 2014]
- ULTIMATE ALTCOIN DAYTRADERS SPREADSHEET (The Demo:) - Video [Last Updated On: June 4th, 2014] [Originally Added On: June 4th, 2014]
- Zedomax Compound w/ 300Mh/s Altcoin Farm/Android Gallery! #HighOnAndroid - Video [Last Updated On: June 5th, 2014] [Originally Added On: June 5th, 2014]
- How to Password Protect Your Bitcoin / Altcoin Wallet Backups on a USB Flash Drive - Video [Last Updated On: June 14th, 2014] [Originally Added On: June 14th, 2014]
- Ultimate Altcoin Daytraders Spreadsheet with Portfolio (2of2) - Video [Last Updated On: June 17th, 2014] [Originally Added On: June 17th, 2014]
- Bitcoin Mafia's Altcoin Spotlight for 6/13/14 - SuperCoin [SUPER] - Video [Last Updated On: June 17th, 2014] [Originally Added On: June 17th, 2014]
- Beat boxing before Altcoin panel. - Video [Last Updated On: June 23rd, 2014] [Originally Added On: June 23rd, 2014]
- ALTCOIN GENERATOR - Video [Last Updated On: June 25th, 2014] [Originally Added On: June 25th, 2014]
- NEW FEATURES altcoin daytraders spreadsheet CHARTS CHARTS CHARTS + AUTO PORTFOLIO - Video [Last Updated On: June 28th, 2014] [Originally Added On: June 28th, 2014]
- Create your own Altcoin - by Wideo.co - Video [Last Updated On: June 30th, 2014] [Originally Added On: June 30th, 2014]
- Bitcoin and Altcoin Coin Mining - GoCoin Payment Processor - Video [Last Updated On: July 10th, 2014] [Originally Added On: July 10th, 2014]
- Multisig Coin - Most Secure Altcoin Ever - Video [Last Updated On: July 24th, 2014] [Originally Added On: July 24th, 2014]
- Coin Brief Podcast #8: New York Bitcoin Regulations, Altcoin Value, Mining Decentralization & More - Video [Last Updated On: July 24th, 2014] [Originally Added On: July 24th, 2014]
- AUTO-TRADING - Running the Free Quatloo Trader for the first time (Altcoin Auto-trader software) - Video [Last Updated On: August 1st, 2014] [Originally Added On: August 1st, 2014]
- Bittrex Altcoin Auto-Tracker Demo - Video [Last Updated On: August 1st, 2014] [Originally Added On: August 1st, 2014]
- A great new Altcoin idea..."Gayfishcoin" - Video [Last Updated On: August 6th, 2014] [Originally Added On: August 6th, 2014]
- Altcoin Investment 101: Today's tip - Video [Last Updated On: August 12th, 2014] [Originally Added On: August 12th, 2014]
- Anatomy of an altcoin with Doug Pike of Vericoin - Video [Last Updated On: August 28th, 2014] [Originally Added On: August 28th, 2014]
- Plankton WhaleFOOD - Benefits for Supporters of the FOOD Altcoin - Video [Last Updated On: August 29th, 2014] [Originally Added On: August 29th, 2014]
- Basic Trading Tactics - Bitcoin Trading Bot - Altcoin Trading Bot - Video [Last Updated On: September 25th, 2014] [Originally Added On: September 25th, 2014]
- 2) PREVIOUS TRADES (Ultimate Altcoin Daytraders Spreadsheet) - Video [Last Updated On: October 10th, 2014] [Originally Added On: October 10th, 2014]
- 1) GETTING STARTED/ Entering BTC (Ultimate Altcoin Daytraders Spreadsheet) - Video [Last Updated On: October 10th, 2014] [Originally Added On: October 10th, 2014]
- Updates: Personal, Bitcoin, Altcoin! - Video [Last Updated On: October 11th, 2014] [Originally Added On: October 11th, 2014]
- 4) CONTINUATION TRADES (Ultimate Altcoin Daytraders Spreadsheet) - Video [Last Updated On: October 16th, 2014] [Originally Added On: October 16th, 2014]
- 5) TWEAKS; ICO'S, IPO'S, MINING (Ultimate Altcoin Daytraders Spreadsheet) - Video [Last Updated On: October 23rd, 2014] [Originally Added On: October 23rd, 2014]
- Can an Altcoin Cure Cancer? CureCoin - Video [Last Updated On: October 24th, 2014] [Originally Added On: October 24th, 2014]
- BTC2B - Altcoin disscusion Panel - Video [Last Updated On: November 10th, 2014] [Originally Added On: November 10th, 2014]
- Poker Totty Venus's Weekly Altcoin Flyers And Divers On Gwapex - Video [Last Updated On: November 12th, 2014] [Originally Added On: November 12th, 2014]
- Altcoin & Bitcoin Trade Bot - Slowly Buy and Sell - Video [Last Updated On: November 16th, 2014] [Originally Added On: November 16th, 2014]
- Haasbot 2.0 Beta - Bitcoin Trade Bot, Altcoin Trade Bot, Bitfinex, Huobi,Bittrex,Poloniex and more, - Video [Last Updated On: January 26th, 2015] [Originally Added On: January 26th, 2015]
- Bitcoin / Altcoin Exchange to Other Payment Processors Tutorial - Video [Last Updated On: January 31st, 2015] [Originally Added On: January 31st, 2015]
- What is an altcoin? - Video [Last Updated On: February 4th, 2015] [Originally Added On: February 4th, 2015]
- How To: Altcoin Trades - Video [Last Updated On: February 14th, 2015] [Originally Added On: February 14th, 2015]
- Shocking interview! - In the mind of an altcoin developer - Video [Last Updated On: March 6th, 2015] [Originally Added On: March 6th, 2015]
- How to Pronounce Altcoin - Video [Last Updated On: March 6th, 2015] [Originally Added On: March 6th, 2015]
- Sell Altcoin Part2 - Video [Last Updated On: March 31st, 2015] [Originally Added On: March 31st, 2015]
- WCHangout 12 -- BitTrex -- Altcoin Futures, USD pairs, & #AltsAreBack - Video [Last Updated On: April 21st, 2015] [Originally Added On: April 21st, 2015]
- Armis, picisi, crowdfunding, altcoin, bitcoin, tra - Video [Last Updated On: April 23rd, 2015] [Originally Added On: April 23rd, 2015]
- Bitcoin and Altcoin price charts / graphs [Last Updated On: May 20th, 2015] [Originally Added On: May 20th, 2015]
- Altcoin faucets - Dailycoins.net [Last Updated On: May 23rd, 2015] [Originally Added On: May 23rd, 2015]
- What is an Altcoin? - CryptoCoinsNews [Last Updated On: May 30th, 2015] [Originally Added On: May 30th, 2015]
- Lumbridgecity - Bitcoin and Altcoin Trading Community [Last Updated On: June 13th, 2015] [Originally Added On: June 13th, 2015]
- How to mine dogecoins | Dogecoin Review | Is Doge Coin ... [Last Updated On: July 3rd, 2015] [Originally Added On: July 3rd, 2015]
- The Altcoin Guys - Cryptocurrency Development [Last Updated On: August 17th, 2015] [Originally Added On: August 17th, 2015]
- mining - Is there an altcoin that is only feasible to mine ... [Last Updated On: August 17th, 2015] [Originally Added On: August 17th, 2015]
- Haasbot Bitcoin Bot | Automate Bitcoin and Altcoin Trades [Last Updated On: August 20th, 2015] [Originally Added On: August 20th, 2015]
- Altcoin Forecast [Last Updated On: September 18th, 2015] [Originally Added On: September 18th, 2015]
- The AltcoinBoard - Index [Last Updated On: September 11th, 2016] [Originally Added On: September 11th, 2016]
- Altcoin News [Last Updated On: September 11th, 2016] [Originally Added On: September 11th, 2016]
- My New Best Bitcoin (and altcoin) Wallet Exodus Wallet ... [Last Updated On: October 8th, 2016] [Originally Added On: October 8th, 2016]
- Altcoin News - Daily Cryptocurrency Articles - CoinDesk [Last Updated On: October 16th, 2016] [Originally Added On: October 16th, 2016]
- The Altcoin Report #3: Zcash - Genesis MiningGenesis Mining [Last Updated On: November 14th, 2016] [Originally Added On: November 14th, 2016]
- CoinDesk How to Mine Litecoin - A Guide on Litecoin Mining ... [Last Updated On: November 14th, 2016] [Originally Added On: November 14th, 2016]
- LCF Coin Prelaunch Review: Rothschilds & Chinese govt altcoin? [Last Updated On: February 2nd, 2017] [Originally Added On: February 2nd, 2017]
- The Altcoin Report #4: Litecoin - Genesis Mining [Last Updated On: February 5th, 2017] [Originally Added On: February 5th, 2017]
- Creditbit May Soon Find Itself among the Top 10 Altcoins - NEWSBTC - newsBTC [Last Updated On: February 7th, 2017] [Originally Added On: February 7th, 2017]
- Interest in Bitcoin Services Grows as Altcoin Platforms Lose Traction - The Merkle [Last Updated On: February 13th, 2017] [Originally Added On: February 13th, 2017]
- Crypto Traders Flock to Altcoins Amid Bitcoin Price Malaise ... - CoinDesk [Last Updated On: February 20th, 2017] [Originally Added On: February 20th, 2017]
- Why altcoins are dying and how to make one in under an hour ... [Last Updated On: February 20th, 2017] [Originally Added On: February 20th, 2017]
- What is altcoin? - Definition from WhatIs.com [Last Updated On: February 20th, 2017] [Originally Added On: February 20th, 2017]
- Altcoin Uptick Ends as Bitcoin Prices Pass $1050 - CoinDesk [Last Updated On: February 21st, 2017] [Originally Added On: February 21st, 2017]
- Markets Update: The Top Ten Altcoins Then and Now - Nigeria Today [Last Updated On: February 27th, 2017] [Originally Added On: February 27th, 2017]
- Opinion: What's the Difference Between a Bitcoin Hard Fork and an Altcoin? - CoinJournal (blog) [Last Updated On: February 28th, 2017] [Originally Added On: February 28th, 2017]
- Livecoin, the Fourth Largest Altcoin Exchange, Is Now Available in Eight Languages - Coinspeaker [Last Updated On: March 1st, 2017] [Originally Added On: March 1st, 2017]
- Karbowanec a Ukrainian local altcoin used with mobile top ups - TechAnnouncer (press release) (registration) (blog) [Last Updated On: March 2nd, 2017] [Originally Added On: March 2nd, 2017]
- Bittrex Altcoin Exchange Review - The Merkle [Last Updated On: March 2nd, 2017] [Originally Added On: March 2nd, 2017]
- Livecoin, the Fourth Largest Altcoin Exchange Is Now Available in Eight Languages - Blockchain News [Last Updated On: March 9th, 2017] [Originally Added On: March 9th, 2017]
- Altcoins Make a Comeback in Wake of Bitcoin ETF Decision - The Merkle [Last Updated On: March 13th, 2017] [Originally Added On: March 13th, 2017]
- Bitcoin Dominance Index Crashes Below 80% as Ethereum and Dash Rise - CoinJournal (blog) [Last Updated On: March 14th, 2017] [Originally Added On: March 14th, 2017]
- PoSWallet Offers Online Altcoin Staking and Exchange Services - newsBTC [Last Updated On: March 18th, 2017] [Originally Added On: March 18th, 2017]
- Several Exchanges Face Connectivity Issues During Bitcoin and Altcoin Trading Craze - newsBTC [Last Updated On: March 18th, 2017] [Originally Added On: March 18th, 2017]
- allcoinsnews.com Bitcoin, Altcoin & Blockchain Tech News [Last Updated On: March 21st, 2017] [Originally Added On: March 21st, 2017]
- SpectroCoin Announces Altcoin Support for Bitcoin Debit Cards - Yahoo Finance [Last Updated On: March 22nd, 2017] [Originally Added On: March 22nd, 2017]
- YoCoin Review: Pump and dump altcoin with recruitment [Last Updated On: March 22nd, 2017] [Originally Added On: March 22nd, 2017]
- SpectroCoin Announces Altcoin Support for Bitcoin Debit Cards - PR Newswire (press release) [Last Updated On: March 24th, 2017] [Originally Added On: March 24th, 2017]
- Op-Ed: Will Bitcoin's High Transaction Fees Open the Door for Altcoin Adoption? - CoinJournal (blog) [Last Updated On: March 24th, 2017] [Originally Added On: March 24th, 2017]