***Motley Fool Stock Advisor Performance Updated as of November 9, 2024***

Does the Motley Fool’s Stock Advisor newsletter provide good stock recommendations and is it worth the price?

At HowTheMarketWorks, one of the services we provide our users is that we subscribe to dozens of stock advisory services and we buy all of the recommended stocks from each service in a virtual trading account.

This allows us to have objective performance results of each service.

In this article I will review the performance of the Motley Fool Stock Advisor stock picks from years 2016 through 2024, and show you the profitability of all these stock picks. You’ll get to see: Is the Motley Fool legit? Is the Motley Fool worth it? Or is this stock picking service a scam?

I will show you some of the Motley Fool stock picks that were excellent stock picks and gave us huge profits. I will also show you how we used stop-loss orders to protect our initial capital.

Here are the 4 main things you get when you buy the Motley Fool Stock Advisor service. This is directly from the Motley Fool’s webpage:

Motley Fool Stock Advisor Details
First of all, note that you get TWO new Motley Fool stock picks each month.  These are the stocks that we are testing.  Their “Best Buys” and “Starter Stocks” are just re-recommendations of stocks that they have previously picked that they still like.

Motley Fool Background

The Motley Fool has been providing stock market commentary and specific stock recommendations to the general public since 1993. They truly exist to help you make money in the stock market. Currently they offer about a dozen stock recommendation newsletters that cover a variety of investment strategies. The price for these stock advisory services ranges from $199 a year to $13,999 a year for full access to all Motley Fool stock services.

The Motley Fool Stock Advisor is their most popular service and their most affordable.  Their marketing page says it has over 500,000 subscribers.

Their office is located in Alexandria, Virginia. I have even been to their offices several times over the 30+ years I have been in the stock market education business. As of 2024, the Motley Fool has over 700 employees.

The Motley Fool’s “Stock Advisor” newsletter is their most popular and their most advertised stock picking newsletter.

They claim this service has returned 908% versus the SP500’s 175% since the Stock Advisor’s launch in 2002 (as of November 23, 2024). See their latest ad below…

Motley Fool Stock Advisor Review December 1, 2024

Motley Fool Stock Advisor Returns
That claim is enough to get everyone’s attention. In fact this is the first service we bought so we could paper trade their picks to find out if their performance claims were realistic.

My Motley Fool Stock Advisor Performance

With the Motley Fool Stock Advisor newsletter they send you two NEW stock recommendations each month. You will also get updates on previous recommendations, and occasionally a few sell recommendations. The emails are short and concise, and if you want to click to get more information, you can read their full analysis.

This Motley Fool Stock Advisor Performance is based on my own experience as a subscriber since January 2016.  At 2 picks a month for 98 months that is 196 stock recommendations.

Here is a table summarizing the performance of those 196 stock picks:

Stock Advisor Performance

Summary of the Motley Fool Results

As of the date noted above, here are the highlights of the Motley Fool Performance for the last 8 years:

  • 83% of the Motley Fool stock picks were profitable
  • the average return of their 120 stock picks is 215% vs the market’s 80%
  • they achieved that incredible average by picking many stocks that have doubled and tripled:
    • 55 of those 120 stocks at least doubled
    • 37 of those 120 at least tripled
    • 23 of those 120 at least quadrupled
  • one of their 2016 stocks is up 4535% (Shopify)

The Motley Fool really does have a great knack for finding a few stocks each year that have fantastic returns. Think about it. If you buy 24 stocks a year, lose 8% on 4 stocks, make 10% on 16 of them, have 2 that double and 2 that triple, your portfolio will be up 30% in one year. In 3 years you will double your portfolio. That is essentially what the Motley Fool Stock Advisor has done for the last few years.

More About My Experiment

Since I work for HowTheMarketWorks, at first I set up a virtual Motley Fool account with $100,000 and just started buying $5,000 of each of the stocks they recommended. Like most of you, I am a busy person. I can’t always stop what I am doing when I get their emails. Generally I would place my buy orders as a market order within an hour or 2 after getting the Motley Fool stock picks. I have been burned (ie, lost money) from other stock services. So to be cautious, I placed a stop loss order at 30% below my purchase price.

After seeing the positive returns on 8 of the first 10 buy recommendations that I paper traded in my HowTheMarketWorks account, I decided to start buying the Motley Fool stock picks with my real brokerage account using my real money. At first I started buying $2,000 of each of their stock recommendations. I have to say that I am very, very pleased with the results. I just wished I had more money to buy more of their picks!

For their 2020 stock picks which on average are up 83%, 17 of those 24 are up as of August 13, 2021. Here are some of their specific recommendations:

  • January 2020 stock pick TSLA is up 733%
  • February 2020 pick DXCM is up 62%
  • March 2020 ZM is up 187%
  • April 20200 pick SHOP is up 332%
  • June 2020 stock pick CRWD is up 154%
  • July 2020 pick ASML is 106%

Obviously these are just some of the recent Motley Fool stock picks. My point of showing you these is that they really do pick stocks that double and triple each year. And THAT is how they have made the amazing returns they advertise.

In addition to the 2 picks per month, they also send out a few other BUY lists like this one…

Here is a sample email that they sent in May 2018 of their Starter Stocks recommendations. Here are 10 solid stocks.  I am showing you a 2018 email because the Motley Fool investing philosophy is that they recommend you hold their stock picks for at least 5 years.

Motley Fool Stock Advisor Sample Email

Motley Fool Stock Advisor Sample Email

Of those 10 stocks (AAPL, AMZN, ANET, FB, HAS ,MA, MAR, MKL, NFLX, PYPL), they have all gone up since I received that email.

The cost of the Motley Fool Stock Advisor has fluctuated over the years from as low as a few hundred dollars to $995 a year. Right now they show the price at $199 a year, but are currently offering 12 months for only $99 to new subscribers.

Motley Fool Stock Advisor Price

*** THE BEST STOCK NEWSLETTER OF 2020 -- March 1, 2021 UPDATE --

We are constantly monitoring over a dozen stock recommendation and advisory newsletters. There is one newsletter that is consistently outperforming all of the others and that is The Motley Fool Stock Advisor.

The BEST newsletter of 2020 was the Motley Fool Stock Advisor service who had 22 of 24 profitable stock picks with an average return of 89%, including 7 picks that more than doubled.

Most impressively, over the last 5 years that we have been tracking every recommendation, their average stock pick is up 201% compared to the the SP500's 53%. That means the Motley Fool is almost 4x better than the market! No other stock newsletter comes close to that. The Fool has done so well because they quickly identify stocks that will perform well BEFORE everyone else does. Now with a new President and a COVID vaccine, make sure you get their next stock pick!

Take a look at these recent picks as of March 1, 2021:

  • Their December 3, 2020 pick is already up 80%
  • Their November 5, 2020 picks is up 56%
  • October 1, 2020 pick is already up 84%
  • Fiverr Intl (FVRR) -- September 2, 2020 pick is already up 135%
  • CrowdStrike (CRWD) -- June 4, 2020 pick is already up 132%
  • ServiceNow (NOW) -- May 7, 2020 pick is already up 54%
  • Shopify (SHOP) – April 2, 2020 pick and it is already up 271%
  • Zoom Video (ZM) – March 19, 2020 pick and it is already up 239%
  • DexCom (DXCM) picked Feb 20, 2020 right before the market crashed and it is still up 35%
  • Tesla (TSLA) picked January 2, 2020 before the crash and it is up 890%
  • HubSpot (HUBS) picked December 5, 2019 and it is up 170%
  • Netflix (NFLX) picked November 21, 2019 and it is up 76%
  • Trade Desk (TTD) picked November 7, 2019 and up 343%
  • SolarEdge (SEDG) picked September 19, 2019 and it is up 244%

Now, no one can guarantee that their next picks will be as strong, but our 5 years of experience tracking the Fool shows that their picks are doing better than ever.

Normally the Fool service is $199 per year but there is a special offer page where NEW SUBSCRIBERS can try it for just $99/year if you click this link

Updated as of April 11, 2021 -- The Motley Fool Stock Advisor service has won our award for the Best Stock Newsletter of 2020--that's now four years in a row. The Motley Fool 2020 stock picks have a 78% return and 20 of those 24 stock picks were profitable. FIVE of those 24 stocks have now at least DOUBLED! TSLA was their top pick and is now up 687% since they recommended it in January 2020. Also their 2019 stock picks are now up 115% compared to SP500's 47%; and their 2018 stock picks are up 209% compared to SP 58%. Now with a new President and a COVID vaccine that seems to be working, most analysts expect the market to continue up. But make sure you have the right stocks in your portfolio so you can CRUSH THE MARKET like their last 5 years of stock picks have done!

In fact, over the last 5 years the average Motley Fool stock pick has almost tripled, being up 192%! This time period covers the 2016 election, the Trump administration, the China trade negotiation, COVID, and now the Motley Fool is continuing their excellent stock picks with one of their 2021 stock picks already up 23%. Don't miss out on the Motley Fool's next stock pick.  Here is their schedule for the next few weeks:

  • April 15, 2021 - David's New Stock Recommendation
  • April 22, 2021 - David's List of 5 Best Stocks to Buy Now List
  • May 6, 2021 - Tom's New Stock Recommendation
  • May 13, 2021 - Tom's List of 5 Best Stocks to Buy Now

FYI--Their October and November picks are already up 92%, 18%, 29% and 41%. And remember, if you are not impressed, you can always cancel within 30 days and get a full refund.


CLICK HERE to get the next 24 Motley Fool's Stock Picks for just $99 per Year! 


Other Considerations

If you subscribe to the Motley Fool Stock Advisor, you might find yourself making more stock trades than you normally do. So be careful of the commissions you pay with each trade. Commissions will eat up your profits if you are only investing a few hundred or thousand dollars.

If you don’t already have a real stock brokerage account, then open a new account and take advantage of the special “Commission Free” offers that a lot of the brokers have right now. To review all of the “Commission Free” stock broker offers for new accounts, CLICK HERE.

If you already have a brokerage account, don’t be shy to switch brokers or open a second or third account. I have 4 brokerage accounts myself. It has literally saved me thousands of dollars! I have 4 brokerage accounts for a reason. I take advantage of special offers to trade commission free, and you should too. A penny saved is a penny earned.

Also be warned, the Motley Fool business model is they use this service as their entry level subscription service. Once they have your email address, they try to upsell you to their other services. They don’t call you, they just send you emails. So I don’t find them annoying at all.

Final Thoughts

Some people ask me if the Motley Fool is a legitimate business. Yes, absolutely they are legit and they are there to help you make money. I have visited their offices in Alexandria, VA several times. I have met several of their key personnel and I see them at investor education conferences. They take their job seriously and are truly focused on helping their subscribers make money in the stock market. If you are ever unhappy, you can always cancel. And yes, when you call they will answer their phone! If you want to know how it rates against other stock picking services, then read this best stock newsletters.

My Conclusion

The Motley Fool Stock Advisor service is the best value for the money.

Don’t just take my word for it, feel free to read this other Motley Fool review.

If you are just getting started investing in the stock market, or even if you have been managing your stock portfolio for years, the Motley Fool Stock Advisor is a great service for the money. I never would have bought SQ, MAR and NVDA without their recommendations. If you want to try the service, click on the link below…

How to Order the Motley Fool Stock Advisor and Save…

Motley Fool Stock Advisor Coupon

The Stock Advisor newsletter is currently available to new subscribers for $99 for 12 months.  At this price it is a NO-BRAINER to spend $99 and get their next 12 months of stock picks and market commentary. All of their stocks will probably NOT go up. From my experience, however, most will go up over the long term. Most importantly, they seem to have a way of finding stocks that double or triple in a year. Stocks like NVDA, MAR, AMZN, and SQ did that for me. It’s always great to have a few stocks that double in a year to offset a few of their losing picks..Stock Advisor Total Average Returns


How Do I Open a Robinhood Account and Get up to $1,700 in FREE STOCK?

To open a Robinhood account, all you need is your name, address, and email. If you want to fund your account immediately, you will also need your bank account routing and account number.

As its current promotion, Robinhood is giving away a FREE STOCK (valued at $5 to $200) to anyone that opens a new account this month if you click on the promo image below.  Then, once you open and fund YOUR account with at least $1, you will receive more free stock (again valued at $5 to $200) for referring your friends and family. The more people you refer, the more free stock you get. Click on this promo below to start your Robinhood account application and get your first FREE stock.....

Is Robinhood Safe? Get Free Stock

Bonus Tip:  Use this link to get a free stock (up to $200 value) when you open and fund your account with at least $1 and start investing in stocks, options and cryptos:  sign up for Robinhood today, you'll get a free stock (up to $200 value!) FURTHERMORE, for each friend that you refer, you will receive ANOTHER free stock valued at up to $200. This is perfectly legit and you WILL get more free stock for every friend or family member you refer.

Why do they give away so much free stock? Because they spend their advertising dollars this way instead of buying TV, radio, print, or online ads! They WANT you to refer friends!

 

[noad]
NEW SUBSCRIBERS: CLICK HERE to get the next 12 months of of picks for only $99.

As a trader or investor, it is important to understand that the nature of the stock market has changed in some big ways over the last 20 years.  This article will highlight the 5 big trends.

Private Investors are Less Involved in Active Trading

In 1998 60% of U.S. adults had investments through mutual funds ore retirement plans, this has reduced to 38% in 2018 according to a 2018 Gallup Poll.  The exact reasons for this are unclear but all indications point to less disposable income as U.S. wages are not increasing as they used to in previous decades.  Also, younger investors up to the age of 35 have lived through 2 mighty crashes, the dotcom crash in 2000 and the financial crisis of 2007.  For younger investors this has weakened their confidence in the stock market and holds them back from long-term investing.

The Rise of the Robots

As the numbers of independent investors in the market have decreased, the amount of robotic or algorithmic trading has increased dramatically.  According to JP Morgan the robotic trading accounts for 90% of all volume in the stock market.  This one of the few sure-fire ways to make money in the markets as the robots are there to scalp small amounts from the bid and ask prices on the exchanges.

Improved Chart Analysis Tools

The last 20 years however have seen huge improvements in the quality of software available to the independent retail investor.  With advances in the compute power of PC’s and Tablets we see the rise of stock market charting software like MetaStock that can run complex systems to back test ideas and even forecast results into the future.

Also, with improvements in the stability of the internet and cloud storage, you do not even need a powerful computer to analyse the stock market, companies like TradingView enable a full chart analysis experience through a web browser using HTML5.

Microscopic Media Coverage

The rise of news outlets covering the financial sector and specifically the stock market has grown tremendously over the last 2 decades.  CNBC markets, CNN Money and of course Bloomberg cover the markets on TV but also over the internet there are thousands of news outlets, websites and blogs covering tiniest moves in the market.  It can be overwhelming.  Sometimes you need to simplify the overwhelming amount of information and distil it down to the essential analysis of what is actually happening in the stock market today.

 

Too Big to Fail

The concept of too big to fail gained popularity in the financial crisis of 2007 as the U.S. government and federal reserve worked to piece together the broken U.S. economy.  The too big to fail notion means refers to companies or institutions that are so large that if they were mismanaged and failed that they could break an economy.  The shadow of too big to fail still looms large and those institutions have not been broken up enough to remove the threat.

 

What Has Not Changed?

The market continues to go up over the long-term.  According to stock market statistics a single $1000 investment in 1930 in the S&P500 index would have yielded nearly $160,000 dollars, essentially a return of 160 times the original investment, despite 18 recessions and crashes.

When you’re a business owner, one of your biggest goals is likely to make that business a success. Unfortunately, not every owner has the know-how for getting to a period of sustained, long-term growth. That’s why we’ve put together this guide of 5 easy steps you can take to start seeing that growth you want, without all the mess of trial and error. Whether you’re a business owner who has been in the game a long time, or you’re a newcomer looking to make a mark on your industry of choice, these tips can help. Keep reading to get the details.

Look to your current customers

One of the biggest mistakes we’ve seen business owners make when trying to scale their company is to focus most, if not all, of their attention on establishing a new customer base. While trying to enter a new customer market isn’t bad in and of itself, neglecting your current customers is. If you can create a solid rate of customer retention, you’ll be flush with both happy customers and opportunities to get those new clients you were looking for. Those referrals from current customers are gold mines for business growth. The happier your customers are, the more likely they will be to refer others to your business. The more they do that, the more likely you will be to close deals.

Get creative with funding

In an ideal business world, you would never experience a cash shortage. Unfortunately, in today’s world, that isn’t the reality. In fact, 40% of small businesses have experienced a cash shortage in the last 12 months. Chances are, you’ve been among that number at some point in time. You may even be part of the 40% right now.

Luckily, there are ways to soften the blow, and sometimes even prevent it from happening. One of those options is to look into how to get trade credit for your business. This is a financing option that enables businesses that are low on cash flow to purchase products and supplies without paying right away. Another option is to establish passive income, which provides you with a steady stream of cash, but doesn’t require the same amount of attention that your business might. Doing either of these options enables you to experiment with your company structure without worrying about losing everything if something goes wrong.

Build a sales funnel

If you haven’t yet established a sales funnel for your business, then this step is essential. No company can expect to see solid, long-term growth without investing in a sales funnel. This is because sales funnels help automate your business so it can scale and grow quickly without breaking the bank. And although sales funnels can take time to execute well in the beginning, they are an incredible long-term investment that can help you see results and growth for years to come.

Research the competition

You’ve likely heard the phrase “killing two birds with one stone,” and if you haven’t, you’re about to learn how it can apply to business growth. Here’s what we mean. As a business, a major goal you have is likely to beat out your competitors. That means their successes and failures affect you and your bottom line. But what if we told you their wins don’t always have to mean your losses? In fact, let’s take it a step further. Their wins can also be your wins. If you emulate the tactics your competitors excel at, and beat them in the ones they don’t, you’ll be able to scale your business that much faster.

Conclusion

No matter what size your business is, or what your company’s current finances look like, we hope you’ll give these tips a try. It can be difficult to see the light of growth when you’re working in the depths of your business, but it is possible. By taking the time to read through these tips, you’ve become one step closer to achieving the growth model of your dreams. Good luck, and know that we believe in you, your goals, and your business.

All successful traders were newbies sometimes, who studied trading from the very foundations. The experience and success came in time. While many of them are self-taught, there are now many online courses to help you familiarize with the Forex platform, professional terms, trading principles, etc.

As a practice, vast of them mostly use fictitious demos that need to simulate trading day on Forex. Everything looks real, losses, profits, changes in courses, and this is about enough to start. True excitement (and stress) comes once you enter the platform for real.

As the initial step, you are just looking at trading on the Forex market. You know that some people managed to make money there, so you also decide to try it out. After completing a course or reading a couple of books, everything seems pretty clear to you. You can sit at home and make money, using all the benefits of modern technology. If it was easy, everyone could be a billionaire.

Go with the Strategy

But you realize it won’t happen overnight, and no one can guarantee you the success. Many strategies and tactics of trading were developed by companies and individual investors, who spent years of learning, examination of the market and following the news and daily, monthly or periodic rates.

Reviewing strategies and successful trading styles comes in the stage when you notice that the market “goes against you,” whatever you do (here something you can learn in order to deal with these situations). Entire copy-paste of a single tactic is not possible, as you have to adapt it to technical conditions, but also to your trading preferences and personality.

We’ll show you some of the strategies that are popular among today’s traders. Each of them has a detailed methodology, which you have to learn before the actual application. Each upgrade of tactics through creativity, constant analysis, and market monitoring, will bring new results and favorable trades. In the end, it forms a unique style of the trader.

Strategy of Daily Charts

For Daily Chart strategy, you need to know and monitor the smallest shifts in the value of the currency you are trading with. On charts that show everyday movements, over a hundred such changes, also known as pips, can be found. Although this is a short-term strategy, it can give good predictions for some future trading.

A good choice of trading strategy gives you the opportunity to “swim” smoothly on the market, using forex signals created by professionals. Movements in the currency market are cyclical, and the best predictions you’ll get if you monitor these over some extended period. In this way, you can determine in which direction your further trading will go. It is important not to rush, and to wait patiently for the right signal to enter the market. Also, set the real limits when you’ll leave the market after hitting a stop loss.

Hedging Strategy

In financial terms, the hedging serves to reduce the risk of some other investment. It’s like insurance that will prevent possible loss of funds. In other words, this is the Forex trading strategy of dealing on two sides with the currency pairs that are connected. Trading with one pair will go in one direction, the other in the other – it’s called opposite positions on correlated pairs.

The hedging strategy is relatively safe, but let’s be honest; without risk, there is no profit. That’s why it takes a bit of “toughening” the trading, through more detailed analysis and using additional methods for predicting trends because hedging can’t do that. It’s just here to push you to take advantage of the current dynamics of the market.

One-minute Trading Strategy

The one-minute scalping strategy is a simple strategy for beginners, which allows a high frequency of trading. As the name says, within minutes, you track the movements of your currency pair. Using one of the many programs, set the indicators to indicate which action you need to perform. You have to do this in just one click, through Forex trading programs and applications. So this strategy requires quick reflexes, good sense of trading and mathematical skills.

The appearance of the signal depends on the market movements and the setting of the indicators. They serve to anticipate rate changes or to inform you about future actions, based on previous “experiences.” The opening of “buy” or “sell” action depends on the position of the indicators. The point is to use “small shifts,” even when there are no significant changes on the market – scalping.

On the currency market, fluctuations in prices occur very often. The ability of a good trader is to anticipate and use it. Since it is impossible to rely only on your lucky star, you have to use some “scientific” methods. Besides a reliable strategy, a good “sense” for action on the market is essential. And you can’t learn this at the trading course; it’s a matter of practice.

The prevailing opinion about credit cards is that 7 in 10 Americans have at least one credit card— the largest number of the millennials’ demography could even own two credit cards. Beyond the obvious convenience that credit cards offer in making it easy to function in a cashless economy and access credit that you could pay off monthly, credit cards issuers offer a wide variety of perks and benefits designed to incentivize you to use their plastic over their competitors.

Some of the perks attached to credit cards are easy to understand, but many people still grapple with the concept of cash back rewards and some users still wonder if there’s a catch of sorts. This piece provides insight into four key points to understand about earning cash backs on credit cards.

  1. Your card issuer is not necessarily at a loss with the cash backs

There’s no catch in cash backs, your credit card issuer is not trying to trick you into anything by offering a cash back, and the issuer technically doesn’t run at loss by offering a cashback reward. When you sign up for a credit card, the card issuer is guaranteed to make money off the interest payments you make on the credit consumed. The credit card issuer also makes more money in the form of the card interchange fees that it charges merchants when you buy stuff with your card. The card processing fee is typically 2% to 3% of the value of your transaction; hence, for every $100 charged to your credit card, the merchant actually gets $98 or $97 in the end.

When your credit card issuer offers a cashback rewards plan, it is only giving you a fraction of the interchange that it collects from the merchant. The credit card company is making a long-term play by offering you a cash back to ensure your loyalty to their brand.

  1. You could have a flat rewards rate or rotating cash back categories

There are different types of cash back credit cards and the difference is based on how their rewards model is structured. Some cash-back rewards are structured along a flat rate such that you earn a specific percentage on all purchases. The key selling point of the flat rate rewards is its simplicity because you can make all purchases with a single card without any special calculations.

Some cash back rewards are structured to deliver cash backs on rotating bonus categories. For instance, you could get 3% cash backs at supermarkets, earn 1% cashbacks in gas stations, and earn 2% cash back in department stores – the percentage available however changes monthly or quarterly. Earning cash backs on bonus categories takes some deliberate calculation to maximize the cash backs but it offers more comparative returns that the flat fate model.

  1. There are more than one ways to cash out your rewards

There are varying options for redeeming your cash back rewards depending on the kind of rewards. One of the most popular methods for redeeming cash back rewards is to use a statement credit to reduce the amount that you eventually pay back as your credit card bill. For instance, if you have earned $300 in cash backs over the last couple of months and your credit card bill comes in at $1500, you can choose to redeem the $300 on your statement so that you only pay back $1300 on your credit card bill. You can also redeem your cash backs rewards for a paper check or direct deposit into your bank account. Another option is to redeem your cash back rewards for gift cards which you can then use to buy products/services at eligible stores.

  1. You might need to choose between a cash back or low APR

If you pay off your credit card balance each month, you’ll enjoy the full benefits of cashback rewards; however, if you tend to carry credit card debt, you might find out that you the temptation to get cash backs ultimately causes you to fall deeper into credit card debt. An interesting point to note is that credit card that have lower APRs typically don’t deliver a robust rewards program. The most promising and attractive rewards programs are usually seen in credit cards with higher APRs. Hence, you might need to think about what works best for your personal finances – a low APR or a competitive cashback rewards program.

The battle cry to cut the plastic, spend only cash, and never buy anything on credit has become increasingly louder over the last couple of years. There are far too many sad and unfortunate stories about how people fell into financial ruins because they overspent on their credit cards or didn’t manage late fees properly. However, the truth remains that credit cards bring an undeniable layer of convenience to financial transactions.

Credit cards are simply tools for accessing short-term loans for covering expenses so that you can pay off the bill at the end of the month technically without interest.  Many credit cards also offer a suite of interesting perks and benefits such as cashback rewards on qualifying orders. However, beyond the convenience and cashback rewards, there are many hidden benefits of using a credit card many users have missed over the years. Below are four benefits you may not know that a credit card offers you.

1.    Fraud prevention and protection

Cyber criminals are always roaming around the internet looking for vulnerabilities through which they can harvest people’s personal information and financial data. When data breaches happen, and your financial information is stolen, you may not even know until the bill arrives at the end of the month and you start seeing expenses you didn’t make. Many credit card companies have built customer profiling and risk prevention algorithms that know where and how much you are likely to shop. Hence, your credit card company is more likely to flag and halt a fraudulent transaction than a bank is likely to detect an unauthorized expense on your debit card.

Even when thieves succeed in charging expenses to you credit card, you can dispute the unauthorized expense and trust the charges to be reversed. The folks at Money Under 30 have graciously compiles a comprehensive list of credit cards that provide fraud protection perks. However, if an unauthorized charge goes through on your debit card, the bank is not likely to return the money to you until it has completed investigations.

2.    Extended warranty on qualifying purchases

When you buy stuff from retailers, they’ll most likely try to upsell you with extended warranty offers that prolongs your warranty for a fee. Hence, if the manufacturer’s warranty is for one year, an extended warranty cover for two years could still cover the costs of repairs or replacement if the device becomes faulty after the manufacturer’s warranty has expired. Interestingly, some credit card issuers will offer you extended warranty as a perk on electronics or home furnishing purchases charged to their cards. Of course, such purchases tend be capped at a certain amount across different categories; hence, you may want to contact your card issuer to find out about the specifics.

3.    Car rental insurance

Car rental collision insurance is probably one the simplest ways to lose money because you don’t think twice about how expensive it is – you’ll typically spend between $15 and $30 a day on auto rental insurance. If you charged the entire cost of your rental car to your credit card, you might be eligible to get free car rental insurance. Hence, you should take a moment to double check on the perks attached to your credit card before you allow to the car rental company to upsell insurance to you.

4.    Travel or missed-connection insurance

If you are a frequent flier and you have a travel-centric credit card, it might be a needless waste of funds buying travel insurance or missed-connection insurance when you travel. Your credit card will most likely offer complementary travel insurance that covers emergency medical situations, trip interruptions, lost/stolen baggage, flight delay, hotel/motel insurance or travel accident among others. Some of these elements of travel insurance when bought individually can cost you upwards of $500 – this is money that you could save if you take a moment to read the fine print or call your credit card issuer to know if they offer such perks.

5.    Price protection with refunds after price drop

Sometimes you’ll want into a store to buy stuff and go home feeling proud of your financial prudence only to walk into the store three weeks later and see the same item on sale at 40% off. If you paid with your debit card, you’ll only hate the fact that you bought the item too early and hope to catch a better deal next time. However, if you bought the item with your credit card, you might be able to get your credit card company to give you a refund of the difference between the old and new price up to a certain cap. In fact, many credit card issuers offer price protection refunds on qualifying items for up to $1000 in a calendar year for each account holder.

The price of cryptocurrency is volatile, and the volatility could see prices trade upwards or downward rapidly within minutes or hours. In January 2018, Bitcoin was trading around $17,000; over the last three quarters, the cryptocurrency has lost about 56% and it trades around $6,600. Before the end of the year, some analysts have predicted that could be trading up at $10,000 and some bulls believe that a $20,000 trading price is possible.

Unlike stocks or other traditional securities, the price of cryptocurrencies is not tied to any core fundamental analysis. Traditional investors who try to predict cryptocurrencies based on fundamental and technical analysis often find their models useless in the fast-paced world of cryptocurrencies. Nonetheless, below are five notable factors that have consistently proven powerful enough to influence the price of cryptocurrencies.

  1. Hype

Many people disdain the fact that cryptocurrencies tend to move on hype – but the disdain will not change the realities of the market. Influencer tweets, fake news, exaggerated promises, and misleading headlines could move the price of cryptocurrencies positively or negatively. Some traders choose to ignore the hype and trade cryptocurrencies purely on its merit as a disruptive force across target industries. Some other traders choose to ride the hype in buying coins during the rumor phase and selling the coins when the hype become public. If you are buying a coin for its long-term prospects, you can choose to ignore the hype around you. If you are trading coins for short-term gains, ride the hype and exit your trades before the hype simmers.

  1. Government regulation

Cryptocurrencies are essentially digital money existing outside the direct control/influence of governments or its agents. Nonetheless, the government has the law and the instruments of state at its disposal. Government regulations to encourage or stifle cryptocurrencies could trigger uptrends or downtrends in the prices of cryptocurrencies. The decision of the United States SEC to ban ICOs dampened the cryptocurrency exuberance. Conversely, you can expect the cryptocurrency markets to return to winning ways if the U.S. or any major country recognizes Bitcoin as a legal tender.

  1. Exchange listing/delisting

Another factor that subtly exerts enormous power on the pricing of a cryptocurrency is its listing or delisting on a cryptocurrency exchange. One of the major differences between Binance and Coinbase for instance, is that Coinbase has listed a handful of coins whereas Binance has hundreds of coins listed. However, the listing of a new coin on Coinbase will potentially cause the coin to record a bigger price surge than could be expected if the coin was listed on Binance. Conversely, delisting a coin from an exchange is probably one of the biggest casualties that a coin could suffer – delisting a coin is essentially a vote of no confidence and very few traders or investors would be interested in a coin that got kicked out of an exchange.

 

  1. Internal politics

Cryptocurrencies are built on blockchain technology; hence, they are inherently decentralized and beyond the control of anyone individual or group. The decentralized nature of cryptocurrencies however means that different people (or factions) with different agendas often have different views on what is best for a particular cryptocurrency per time. When these different ideas come into conflict the price of the cryptocurrency will become increasingly volatile because the market is often uncomfortable with uncertainty. The internal disagreements and politics of a cryptocurrency can lead to software upgrades or forking out of new coins such as Bitcoin Cash from Bitcoin and Ethereum Classic from Ethereum.

  1. Attempted/successful hacks and heists

Cryptocurrency transactions are technically irreversible; hence, a successful hack often means that the stolen funds can’t be recovered unless the perpetrators are apprehended and are willing to return the funds they stole. In 2018 alone, at least $731 million has been stolen across successful hacks on different exchanges. Hence, any news of a cryptocurrency hack on a major exchange will most likely trigger a sell-off as traders try to convert their cryptocurrency to fiat before they lose their funds to hackers. Paying attention to news about hacks and how much cryptocurrencies was stolen in the hack could provide insights into predicting where the price of a cryptocurrency is headed.

Sometimes to get better in any profession you have to monitor your work. And it has to be judged by you before anyone else notice what and how you are doing work. Thus you can improve all of your working technique from time to time. This is a good and really effective strategy to improve yourself in any working sectors or any jobs. And the plus point is, no one will be able to judge you for poor performance. In the trading business, the system is the same. Here you can also use this method to improve yourself. Though there is no one to judge your performance, you will still experience the effect of poor performance. So, why not improve yourself before performing badly? Today we are going to show you how you can monitor if you are trading well or bad.

Comparing winning and losing trades

Trading is a business and it acts like a business. Here you make an investment in your trading account. Then you deal with your products here which is known as trades. You start to trade by buying or selling. Then after some time, you close the trade doing the opposite of what you did earlier. And based on the change in pips, you get to make profit and loss. So, if you can count how many winning trades there is in your account and compare them with your losing ones, it might describe your performance all by itself.

Learning from your mistakes

Mistakes can be very useful if you can learn from it. Open a demo trading account and start to trade the market with the virtual dollar. It’s very obvious you will make mistake but try to learn from it. Majority of the rookie traders are overtrading the market and losing a significant portion of their investment. But if you overtrade the market it will be really hard to learn from your mistake. You need to focus on the long-term market trend and write the down the details of each trade execution. Stop thinking about securing big winners in this market. Set rational goal and trade the market with discipline. Never think you will be able to change your life within a day. Consider trading as a long-term plan to change your life.

Using risk to profit ratio

Another thing that you can use for monitoring your performance is the risk to profit ratio. It is for monitoring the performance on a particular trades or all individual trades. It is represented something like 1:1. It is the ration of what you have invested and what you are getting from a trade. If you are investing too much than making returns the ratio would be like 2:1. Or if you are making losses the ration would be something like 1:-1. If you’re doing ideal the ration would be 1:2 or 1:3. Expert’s results in most trades remain from 1:2 to 1:5. Combining multiple trade’s ratios, you can estimate your performance in each trades.

Observing your own strategy

Without any tool or data, you can justify your trading performance just by monitoring your trading strategy. If you are playing too aggressive, you will be making more random trades. And sometimes, the trades will be simultaneous. Your chart observation will be very frequent too, as your brain might not want to miss any chance. Worse than that, you will start micro-managing every plan of yours before trading. Then after opening a trade, you will start thinking about it. When you are worried about money, it won’t get out of your hard. Even after you have closed the trade, it can haunt you with emotional problems. As a result, you will again start getting too busy with your trading. But that is not the most appropriate thing for doing well in this business. If you can relax your senses, it will be the best for your career.

In the past investing and trading were things done pretty much solely by experts within the finance field and business moguls. Now it is actually possible for anyone with any sort of financial background, a decent amount of capital and internet access to become a trader and online trading is growing in popularity.

 

New traders will often enter the market with expectations of making large sums of money and they will quickly realise that trading isn’t a quick and easy way to get rich and often make many mistakes when starting out. It is very important to try and avoid making major mistakes, especially at the beginning as they could quite easily result in your whole bank getting wiped out. This is exactly why most respected trading platforms will have a section which covers the basics, so for example City Index explains CFD trading, forex and spread betting and even has Demo accounts to provide practical experience.

 

Some very important mistakes to avoid include not knowing when to stop, trading without enough preparation and training, failing to keep sufficient records of trades, not calculating the risk reward ratio correctly and believing you will see easy, large profits very quickly. It is also very important to not get too emotionally attached when trading, as this can result in reckless decisions being made.

 

There are a few things that can be done to make sure the risks of trading are kept to a minimum. Investing in the best equipment you can afford is vitally important and it is advisable to acquire a fast computer, stable internet connection and also the correct trading tools and platforms. It is also very wise to set yourself a stop-loss order to minimise the loss within each trade and therefore help to preserve capital. You can do this by setting a price with a broker in order to sell when a set price is reached, therefore limiting losses if the trade doesn’t go as hoped.

 

When starting out it would be wise to start off with small bets, until you feel totally comfortable with trading. It is also worth looking at trading on a margin, which means you are able to pay less than the cost of a full trade and then you will be able to enter into larger positions. This will mean you don’t need to bet money you can’t afford to lose that isn’t yours.

 

If you are going to start trading online, you need to view it as your own business and treat it as such. It is important to have a plan which sets out what you will trade, how you will trade and how much you would like to make and how much time you are willing to devote to do so. It is also very important to fully test everything listed in your plan on both historical data and a live market and then measured at regular intervals. This will help you to determine the style of trading you wish to take on, by figuring out which is best suited to the time you have available, your tolerance to risk and your expertise.

One of the most common requests we get from teachers is if students can see each other’s trades. Well, now they can!

 

We added a new contest rule, called “Public Portfolios”. If you turn on public portfolios for your contest, there will be a new “View” button on the rankings page next to each participant. This will let each participant see each other’s trades, open positions, trade notes, and more!

If you created your class contest before Public Portfolios were added, this is turned off by default. However, you can add it by editing your class rules, and setting “Public Portfolios” to “Yes!”

Click Here To Create Or Edit Your Class

Happy Trading!

PS. You must read this–If you are looking for stock ideas, we have also just published a complete Motley Fool Stock Advisor Review to share our experiences with their popular stock advisory service. You won’t be disappointed.

One of the most-requested new features in Spring 2018 was cryptocurrency trading, both from students and teachers. You asked and we listened – crypto trading is now available on HowTheMarketWorks!

crypto

Cryptocurrencies currently share some of the rules from Stocks, such as the commissions and position limits. However, you can trade cryptos both using a quantity (such as 10 “coins”), or specify a dollar amount (“I want to buy $25,000 worth of Bitcoin”).

If you are creating your own contest, you can choose whether participants can trade cryptocurrencies (we have them turned off by default):

crypto point

You can toggle this on or off from your “My Contests” page, and clicking “Edit Contest”.

 

Happy Trading!

Security is one of the key aspects of any business activity over the Internet. It is a top priority for any online company that is serious about gaining a customer’s trust and a positive feedback. If your business is not able to protect itself on the Internet, it is not able to protect customers’ data as well.

Despite all the benefits the Internet has, it is the easiest and the cheapest way for hackers and scammers to reach private and corporate networks. In the age of mobile communication, online marketing, and mobile commerce, the issue of data security has become the topical one. You can’t fully focus on making money online if you’re not sure whether everything you’ve worked hard on can be stolen at any moment. What can you do? You can get a VPN. Don’t underestimate the importance a VPN has in the e-commerce world, especially in the countries with the most advanced economies like Canada or US. You can check bestvpnrating.com for some interesting facts about VPNs in Canada.

How VPNs Prevent Data Leaks

The first step for any e-commerce project is to make sure that work-related data is 100% protected online. Preparing for hacker attacks and prevention of massive data leaks are better than solving the actual cybersecurity problems.

Cybersecurity is a critical issue for any organization, no matter how small or big it is. All organizations have valuable information that can be easily used against them if their servers and networks are hacked. It is either business information or anything related to the property and finances that belong to the company. This kind of information can be sold on the black market by cyber criminals. That’s why keeping any business data on the network well protected is a must.

Why VPN?

You can read more info about the role of a VPN in a business following the link. But the most significant thing you should know is that it keeps your business and personal networks protected online. How does it work?

A VPN is software that creates a new network inside already existing one to carry the traffic through. Instead of allowing your devices to connect to the Internet directly, remote server receives the traffic first. Thus, the traffic goes back and forth through a VPN service, being fully encrypted at the same time. This means that no one except your devices can reach and read your traffic on the network. This is the effect that no antivirus program has.

A VPN is a multifunctional tool. It is used for:

  • Data security (encryption technology);
  • Online anonymity (hiding and replacing a real Internet Protocol address and geographical location);
  • Unlimited Internet access (you get access to previously blocked content).

A VPN is a universal tool. No matter how old or new your online company is, you can always pick a service that suits your budget at the moment. For further instructions, check Bestvpnrating.com on how to check your devices and pick a service.

Leveraged ETFs: The What

There’s always more to know when it comes to investing. Leveraged ETFs are a relatively new financial tool that, while somewhat complex and high risk, can be extremely advantageous if used correctly.

A leveraged ETF is a fund that is designed to track a specific index while simultaneously multiplying its returns. Using a combination of derivatives and debt, leveraged ETFs attempt to maintain a constant multiplier, most commonly 2x or 3x the returns of the underlying index.

Investors most commonly use leveraged ETFs when there is an all but certain change in market conditions. Because they are a high risk and high cost investment vehicle, they are mostly used over short term spans with high certainty.

Leveraged ETFs exist for the entire investment spectrum, from 2x Bull S&P 500 ETFs to 3x Bear Natural Gas funds. Through these funds, one can speculate on bonds, commodities, currencies, real estate, stocks, and more. Today, I’ll highlight some funds to watch in each major category of leveraged ETFs.

I’ve broken the following ETFs into categories according to which type of assets they leverage. Each group contains notable funds that stand out in Total Assets, Year to Date return, or Average Volume. Click on the ticker symbol to trade on Wall Street Survivor, and click on the full name of each fund to see more data.

Leveraged Equity ETFs

  1. TQQQ– ProShares UltraPro QQQ:

This fund is the largest leveraged equity ETF by Total Assets with $4,091,080,000 invested. It is 3x leveraged and tracks the NASDAQ 100 Index.

  1. DUST– Direxion Daily Gold Miners Bear 3X Shares:

Up 82.54% this year, DUST profits when the NYSE Arca Gold Miners Index isn’t doing so hot. It’s called a “bear” fund because it acts in the inverse direction of the index it tracks.

  1. SQQQ– ProShares UltraPro Short QQQ:

The opposite of TQQQ, SQQQ is an inverse leverage of the NASDAQ 100. This fund gets a lot of action, with an Average Volume of 15,828,582 trades a day.

Leveraged Equity ETFs
Source: DUST Yahoo Finance

Leveraged Commodity ETFs

  1. UCO– ProShares Ultra Bloomberg Crude Oil:

UCO has the most Assets Under Management of any leveraged commodity ETF with $390,068,830. It is a 2x leveraged fund tracking the Dow Jones-UBS Crude Oil Sub-Index.

  1. DSLV– VelocityShares 3x Inverse Silver ETN:

It’s been a solid year for DSLV with an incredible YTD return of 63.01%. Although it’s expensive to bet against the S&P GSCI Silver Index, thus far in 2018 it’s been worth it.

  1. UWTI– VelocityShares 3x Long Crude ETN:

This hot commodity fund trades over 22 million times a day. It tracks the S&P 500 GSCI Crude Oil Index.

Leveraged Commodity ETFs
Source: DSLV Yahoo Finance

Leveraged Bond ETFs

  1. TBT– UltraShort Barclays 20+ Year Treasury:

Lots of money in debt. Nearly $1.7 billion in this fund. UltraShort and sweet.

  1. TTT– UltraPro Short 20+ Year Treasury:

As far as bonds go, a 16.26% YTD return is phenomenal. That’s what you get when you inverse leverage the Barclays Capital U.S. 20+ Year Treasury Index.

  1. TMV– Direxion Daily 20-Year Treasury Bear 3X– 2nd in YTD (14.99%) and Volume (587,883)

Another bear fund, TMV is up 15% this year and trades almost 600,000 times a day.

Leveraged Bond ETFs
Source: TTT Yahoo Finance

The above ETFs are by far the most common classes of leveraged funds. So check them out and figure out how each one could help you maximize your portfolio profits! If you’re interested in more unique funds, here are a few more to cut your teeth on!

Leveraged Currency ETFs

  1. EUO– ProShares UltraShort Euro: Highest Total Assets ($170,540,000)
  2. DAUD– VelocityShares Daily 4x Long USD vs AUD ETN: Highest YTD Return (24.59%)
  3. YCS– ProShares UltraShort Yen: Second highest in Avg. Volume and Total Assets

Leveraged Real Estate ETFs

  1. MORL– ETRACS Monthly Pay 2xLeveraged Mortgage REIT ETN: Highest Total Assets ($481,000,000)
  2. URE– ProShares Ultra Real Estate: Highest YTD Return (3.23%)
  3. DRN– Direxion Daily Real Estate Bull 3x Shares: Second in Avg. Volume and YTD Return

With our most recent update, the HTMW videos page got a great new revision – with each video getting a bigger window and better navigation!

htmw video

 

This also means if you create a HTMW Assignment, the links to view each video will now take your students right to the video they need!

Happy Trading!

You can now edit your assignments on HowTheMarketWorks!

In the past, once you created an assignment it was set in stone. With the newest HTMW update, you can add and remove tasks in real time, giving you more control of your class than ever before!

house

 

To edit an assignment you’ve already created, go to your “Manage Assignments” page and click “Edit”. Click on the green “plus” button to add an item not currently in the assignment, or the red “minus” arrow to remove tasks.

Happy Trading!

Graphing is one of the most important features of spreadsheets. When you need to present your findings, whether as a written report or a presentation, summarizing your data in graphs is the best way to quickly communicate large amounts of data.

This guide will walk through taking your raw portfolio data, making some simple calculations, and transforming the data into graphs that you can include in reports.

Line Graphs

Your Daily Portfolio Value

First, we want to make a line graph showing our daily portfolio value. First, open your spreadsheet that has your daily portfolio values, it should look something like this:

portfolio values

Portfolio values are calculated at the end of the day when the market is closed and all your assets (Stocks and Mutual Funds strictly on this site) are summed together which shows your ending portfolio value.

To insert a basic line chart of your portfolio data, highlight your data and click “Insert” in the Office Ribbon, or “Charts” in Google Sheets:

highlight data

And that is it! Your new chart is ready for display. You can even copy the chart and paste it in to Microsoft Word (if using Excel) or a Google Doc (if using Google Sheets) to make it part of a document, or paste it into an image editor to save it as an image to be used for any reports you might have it to use.

portfolio value chart

Microsoft Excel

sheets graph

Google Sheets

Portfolio Percent Changes

Next, we want to make a graph showing how much our portfolio has changed every day since the tournament has began. To do this, first we need to calculate the daily % change, instead of just our raw portfolio value.

Basic Calculations – Using Formulas

In the next column we will calculate our daily portfolio percentage change. First, in the next column, add the header “% Change”.

new column heading

Now we need to make our calculation. To calculate the percent change each day, we want to take the difference between the most recent day’s value minus the day before, then divide that by the value of the day before.

Percentage Change = (Day 2’s Value – Day 1’s Value) / Day 1’s Value

To do this, in cell C3 we can do some operations to make the calculation for percentage change. To enter a formula, start by typing “=”. You can use the same symbols you use when writing on paper to write your formulas, but instead of writing each number, you can just select the cells.

To calculate the percent change we saw between day 1 and day 2, use the formula above in the C3 cell. It should look like this:

Now click on the bottom right corner of that cell and drag it to your last row with data, Excel will automatically copy the formula for each cell:

percent change 3

You now have your percentages! If you want them to display as percentages instead of whole numbers, click on “C” to select the entire column, then click the small percentage sign in the tools at the top of the page:

percent change 4

Selecting Certain Columns For Your Graph

Now we want to make a graph showing how our portfolio was changing each day, but if we try to do the same thing as before (selecting all the data and inserting a “Line Chart”, the graph doesn’t tell us very much:

This is because it is trying to show both the total portfolio value and the percentage change at the same time, but they are on a completely different scale!

To correct this, we need to change what data is showing. If you are using Excel, right click on your graph and click “Select Data”:

select data

This is how we decide what data is showing in the graph. Items on the left side will make our lines, items on the right will make up the items that appear on the X axis (in this case, our Dates).

Uncheck “Portfolio Value”, then click OK to update your graph:

bad axis

For Google Sheets, this is done similarly, right click on your graph and select “Data Range” (the letters for this example will be the same as Excel, C2:C6)

 

This is closer to what we’re looking for, but the axis labels (the dates) are right in the middle of the graph, making it hard to read.

Formatting Your Line Graph

Now we want to move the dates to the bottom of the graph (here they are along the “0” point of the Y axis).

To do this in Excel, right-click on the dates and select “Format Axis”:

excel format

A new menu will appear on the right side of the screen. Here, click “Labels”, then set the Label Position to “Low”.

formatting 2

The method is similar on Google Sheets as well, start by selecting “Axis” then “Horizontal” or “Vertical” Axis to edit them.

With this feature you change the axis titles and add different features to it.

sheets format

Congratulations, your graph is now finished! You can now easily see which days your portfolio was doing great, and which days you made your losses.

Bar Charts and Pie Charts – Your Open Positions

Next we would like to make a bar chart showing how much of our current open positions is in each stock, ETF, or Mutual Fund.

Directions for Excel

First, open your spreadsheet with your Open Positions. It should look something like this:

b1

 

Since we want to make a bar chart, we can only have two columns of data – one for the X axis, and one for the Y axis of our chart.

We want one column showing the symbol, and a second column showing how much it is worth. The “Total Cost” column is the current market value of these stocks, so that is the one we want to keep. However, we don’t want to delete the quantity and price, since we might want it later. Instead, select the columns you don’t want, and right-click their letter (A and C in this case). Then, select “Hide”.

b2

Now the columns that we don’t want in our chart are hidden. We can always get them back later by going to “Format” -> “Visiblity” -> “Unhide Columns”.

Now select your data and insert a “Bar Chart” instead of a “Line Chart”:

b3

Before you’re finished, your chart will say “Total Cost”. You can change this by clicking on “Total Cost” and editing to say whatever you would like (like “Portfolio Allocation”).

b4

This graph is now finished, but you can also try changing the Chart Type to try to get a Pie Chart.

Switching Chart Types

Sometimes, our first chart type is not the best way to display our data. For example, a bar chart will show me how much of each symbol I am holding. A better choice might be a pie chart, which will show how much each symbol is as a percentage of my total holdings.

To change our bar chart to a pie chart, right click your graph and select “Change Chart Type”:

b5

Next, find the “Pie” charts, and pick whichever chart you like the best.

b6

Last, now we don’t know which piece of the pie represents which stock. To add this information, click your pie chart, then at the top of the page click “Design”. Then select any of the options to change how your pie chart looks.

b7

Congratulations, you’ve converted your bar chart into a pie chart! This one should look almost the same as the one you have on the right side of your Open Positions page. You can now copy and paste these charts directly into your Word document, or save it as an image to use elsewhere.

Directions for Google Sheets

To create a Bar Graph, select “Insert” then “Chart”, the same as we did for our previous line charts.

b9

When clicking this, one of the options in “Chart Editor”, will be “Chart Type”, their you can select the bar graph or pie chart.

b10

In this section you will also need your Data Range, which will be the same as the previous example (Symbol and Total Cost). To edit the axis and other information, is the same method as the previous type.

b11

The pie chart will look very similar to that on your Open Positions Page as well!

b12

Pop Quiz

If watching this video was an Assignment, get all 3 of these questions right to get credit!

Click "Next Question" to start the quiz!

The most important reason you would want to use excel to track your stock portfolio is trying to calculate your profit and loss from each trade. To do this, open the spreadsheet with your transaction history. It should look something like this:

profit 1

Tip: If you have not bought and then sold a stock, you can’t calculate how much profit you’ve made on the trade.

Simple Calculations

First, we want to change how the data is sorted so we can group all the trades of the same symbol together. Use the “Sort” tool to sort first by “Ticker”, next by “Date” (oldest to newest).

trans calc 2

For DWTI and SPY, we haven’t ever “closed” our positions (selling a stock you bought, or covering a stock you short), so we cannot calculate a profit or loss. For now, hide those rows.

trans calc 3

Now we’re ready to calculate! Lets start with the trade for S. This one is easy because the shares I sold equal the shares I bought. This means if we just add the “Total Amount”, it will tell us the exact profit or loss we made on the trade.

cost 3

This does not work for UWTI, because I sold a different number of shares than I bought. This means that I need to first calculate the total cost of the shares I sold, then I can use that to determine my profit.

Different Buy/Sell Calculations

First: multiply your purchase price times the number of shares you sold:

trans calc 5

Second: add this number to the “Total Amount” from when you sold your shares.

trans calc 6

Now you have your profit or loss for this trade. Note: this is the method for if you bought more shares than you sold – if you bought shares at different prices, then sell them later, you’ll need to calculate your Average Cost to use in your calculation.

Average Cost Calculations

To calculate this, lets use the same example of UWTI shares and delete the rows of the S shares. Suppose we bought 11,620 shares on January 12th, as we did above, but also bought 6000 shares on January 15th for a different price at $2.5 per share. To calculate our profit or loss we would first have to calculate the Average Cost of the shares we bought. To do this, we need to add our total amounts for both purchases and divide that value by the total number of shares we bought. The calculation for this would be (24402+15000)/ (11620+6000), which would give us a value of $2.24. We can easily create a function on Excel or Google Sheets to calculate this for us. In this case, our function would be “=(G2+G3)/(C2+C3)” which should look something like this on Excel or Google Sheets:

calculating cost

 

Next, we subtract this Average Cost from the Average Sale price of $1.9 and multiply the value we get by the number of shares we sold. This will then give us our profit and loss for the trade. We will have to create another function for this onto cell G10. However, since our average cost value is already negative, we would add it on our function instead of subtracting. Our function should be “=(E4+G7) *-C4” which should give us a value of $-1681.04 (Loss). We also put a negative sign in front of our C4 value to represent a sale. Our final spreadsheet should look something like this:

profit or loss

Pop Quiz

If watching this video was an Assignment, get all 3 of these questions right to get credit!

Click "Next Question" to start the quiz!

If you’ve been trading for a long period of time you might have been curious to know what your daily returns were. Excel and Google Sheets can help you efficiently calculate this in a simple way. Suppose we started trading on August 29th, 2017. It is now September 7th and we would like to know our daily returns for our portfolio. First, we would look up our Historical portfolio values by clicking “Graph My Portfolio” under the “My Portfolio” tab in the navigation bar.

 

Once there, simply click on Historical Portfolio Values and a new window will pop up displaying the data. The page should look something like this:

Next, you can highlight everything from “Date” to the last number under “Value”. Then, copy the data and paste it onto cell A1 in your blank spreadsheet.

As mentioned in our Getting Some Data article, values may sometimes appear as “#####”. To fix this, you simply need to adjust the column widths.

Next, we add a heading for Daily Returns under column “C”. We can then create a function on Excel or Google Sheets to calculate each days’ return for us in dollars. Since we only started trading on August 29th, we wouldn’t have any returns for that day and we can leave that cell blank. Instead, we would write the function onto the second cell under the column, cell C3, and drag it downwards from the bottom right of the cell to copy it onto the rest of the column. The function we would input is “=(B3-B2)”. It should look something like this on your Google spreadsheet or Excel:

The values we have calculated here are our daily returns in dollar amounts. If we wish, we can also find these amounts as a percentage. To do this, we would create another heading on column D and name it “Daily Returns %”. Then, we would click on the second cell under this column (Cell D3) and input the function “=(C3/B2) *100”. This should give us a value of 0.009%. To repeat this for the other dates, simply drag the 0.009% value downwards the same way we did for the dollar value. Google Sheets/Excel will then calculate the remaining values for us.  We have now calculated our daily returns in a dollar amount and as a percentage. The final spreadsheet should look something like this:

Pop Quiz

If watching this video was an Assignment, get all 3 of these questions right to get credit!

Click "Next Question" to start the quiz!

The first step in using any spreadsheet is getting some data! This tutorial will show you different ways to import some of your portfolio data into a spreadsheet and how to format it to make it easier to read.

 

Getting Data

The first step to using any spreadsheet is getting some data – once we have our data in our sheet, we will then start formatting it to make it easier to use.

Copy/Paste Method

The easiest way to import data is to just copy and paste it from a website or another source.

Getting Your Historical Portfolio Values

To get your old portfolio values, you can copy and paste them out of the HTMW website. First, you will need to get your historical portfolio values from the HTMW website. You can find these on the “Graph My Portfolio” page.

get data button

This will open up a small window showing what your portfolio value was for every day of the contest. Highlight the information you want, then right click and “Copy”.

portfolio value

Next, open a new blank spreadsheet and click cell A1. You can then right-click and “Paste” the data in. The column headings should be included too.

Adding Column Headings

If the column headings are not included, right-click the first row and select “Insert Row”. This will add a new row to the top of the spreadsheet where you can type in the column names. Google sheets gives you the option to add a row above or below the one you right clicked.

column headings

Now “Save” your file somewhere you can easily find it later, you’ve got some data!

Getting Historical Prices for Stocks

For this example, we want to get the historical prices for a stock, so we can look at how the price has been moving over time. First, create a new blank spreadsheet in Excel or Google Sheets. We will use Sprint stock (symbol: S). Go to the quotes page and search for S, then click “Price History” on the right side of the page:

s history

 

Next, change the “Start” and “End” dates to the time you want to look at. For this example, we will use the same dates that we saved for our portfolio values, January 11 through January 15, 2016. Once you load the historical prices, highlight everything from “Date” to the last number under “Adj. Close” (it should look like this):

price highlight

Now copy the data, select cell A1 in your blank spreadsheet, and paste.

Congratulations, we have now imported some data into our spreadsheet! You can now save it for future use. The data is a bit messy; we will look at formatting later.

Export Method

Sometimes, websites will make it easy for you to export data directly to your spreadsheet without copy/paste. If an export option is available, this is going to work better, since it will require less formatting later.

If we look back at the Historical Prices, you can see that there is also a “Download” button at the top of the table:

 

download button

 

This will download a spreadsheet you can just open directly – you can also see the data is already easier to read and better formatted, which will save us time later.

 

price export

 

Copying Between Spreadsheets

You can also export your portfolio data from the My Contests page – this will download one big spreadsheet showing your account balances, trades, open positions, and more:

portfolio export

 

Once you download the spreadsheet, you can open it to see the available data:

port export 2

 

The top red square is your transaction history, the bottom red square is your Open Positions. To use this data, you will need to open a new blank spreadsheet and copy these boxes (just like we did above) from one spreadsheet to another.

Start by taking your “Transaction History”, copying the data, and pasting it into a new spreadsheet.

trans history

 

To start using this data, we will need to look at formatting to make it easier to read.

Formatting Your Data

Now that we have a few saved spreadsheets, we can look at formatting the data to make it easy to read and use later.

Changing Data Order

If we look at the spreadsheets we have saved for our Historical Portfolio Values, it is the exact opposite of what we have for our Historical Prices.

To get them in the same order, we will want to open up our Historical Prices spreadsheet, and order the data from “Oldest” to “Newest”.

We will use the “Sort” function with Excel, or the “Data” function for Google Sheets.

sort excel

 

sort sheets

We can now choose what we want to sort by, and how to sort it. If you click the drop-down menu under “Sort By”, excel lists all the column headings it detects (select “Date “). Next, under “Order”, we want “Oldest to Newest “:

sort 3

Now your data should be in the same order as your portfolio values from earlier.

Changing Column Width

Next, you’ll notice that some of your data appears just as “########”. This is not because there is an error, the number is just too big to fit in the width of our cell. To fix this, we can increase and decrease the widths of our cells by dragging the boundaries between the rows and columns:

column width

Tip: if you double click these borders, the cell to the left will automatically adjust its width to fit the data in it.

If you want to automatically adjust all your cells at once, at the top menu click “Format”, and “Auto Fit Column Width”:

 

Once you’ve adjusted your volume column, everything should be visible!

Removing Columns

If we want to use this data for making a graph, we will not need all of the data in the sheet. We really only need the “Date” and “Closing Price”. To keep it easy to read, we will delete some of the extra data.

If you just highlight the data you don’t need and press “Delete”, you will end up with a bunch of blank cells, which is not very useful when trying to read the table:

Instead, click on “B” and drag all the way to “H” to select the full columns:

select columns

Now right-click and click “Delete”, and the entire rows will disappear. Now the Close will be your new column B, with no more empty space. You now have your historical price data, so save this excel file so you can use it later.

Unmerging Cells

Now let’s go back to our Transaction History spreadsheet. With this sheet, we cannot do many of the basic operations because there are some “Merged Cells”. Merged Cells can be used for formatting and presentation, but for now it is just getting in our way.

This is the case with the Ticker, Commission, and Total Amount cells. We need to “unmerge” these cells to make our data usable.

trans history

To do this, select all your data, then on the main menu bar click on “Merge and Center “. Under this, click “Unmerge Cells”. On Google Sheets, this can be done by clicking on the “Format” tab in the navigation bar and then clicking on “Text Wrapping” and then “Clip”.

unmerge cells

Putting It All Together

Now that we have our data all in their own cells, we can start deleting the rows and columns we don’t need. For example, rows 2 and 3 have our beginning cash, which we don’t need in our transaction history. Columns E and H are now blank, so we can get rid of those too. Once you delete the rows and columns you don’t need, you can also autofit the row width to make the “date” visible.

trans formatted

Pop Quiz

If watching this video was an Assignment, get all 3 of these questions right to get credit!

Click "Next Question" to start the quiz!

One of the benefits of using HowTheMarketWorks is that we do a lot of your homework for you so we can help you make more money! You can also learn how to invest in the stock market by following the same strategy we use with HTMW’s paper trading.

We subscribe to a few dozen stock market newsletters, and then we make their recommended trades in virtual trading accounts. While we do buy all of the stocks that the services recommend, we don’t always make the trade exactly when we get the recommendations. Like you, we are busy doing other things. We eventually get around to making all of the trades. They are usually within a few days of getting the recommendations.

The Best Stock Newsletter:

Based on our dozens of paper trading portfolios, the best stock newsletter and best stock sites over the last 24 months was the Motley Fool’s Stock Advisor. This service recommended stocks like SHOP (up 158% since we bought it), NVDA (up 120%) and MAR (up 97%). To have a stock portfolio that performs well, you MUST have a few stocks like these that double or triple in value. This Motley Fool service has a habit of picking these 2x and 3x stocks!

As recently as August 2018, the Stock Advisor recommended stocks such as PAYC (up 43.39%), FICO (up 25.77%), and OKTA (up 57.05%). Percentages are thru August 14, 2018. In our paper trading portfolios, we used 8% trailing stops to minimize risk of any poor picks. This trailing stop also helped us take profits on any high fliers that might have had a significant pullback.

The Fool’s marketing campaign for this service says their portfolio is up an amazing 348% since inception, compared to the SP’s 81%. See the graph below that shows their return versus the S&P500’s return over the same time period. It seems impossible right? But now we see that a lot of their picks do double or triple in a short period of time.

best stock sites - Best Stock Newsletter

The Best Stock Newsletter Offered by The Best Stock Sites:

Based on our dozens of paper trading portfolios, the best stock newsletter over the last 24 months was the Motley Fool’s Stock Advisor. This service recommended stocks like SHOP (up 158% since we bought it), NVDA (up 120%) and MAR (up 97%). To have a stock portfolio that performs well, you MUST have a few stocks like these that double or triple in value. This Motley Fool service has a habit of picking these 2x and 3x stocks! You should use the same HTMW paper trading platform to learn to invest.

As recently as August 2018, the Stock Advisor recommended stocks such as PAYC (up 43.39%), FICO (up 25.77%), and OKTA (up 57.05%). Percentages are thru August 14, 2018. In our paper trading portfolios, we used 8% trailing stops to minimize risk of any poor picks. This trailing stop also helped us take profits on any high fliers that might have had a significant pullback.

The Fool’s marketing campaign for this service says their portfolio is up an amazing 348% since inception, compared to the SP’s 81%. See the graph below that shows their return versus the S&P500’s return over the same time period. It seems impossible right? But now we see that a lot of their picks do double or triple in a short period of time.

learn to invest

Best of all, the Motley Fool currently has this stock newsletter on sale. It usually costs $299 a year, but they currently are running a too-good-to-be-true promotion of just $19 a month or $99 a year. That is a very reasonable price to pay for such solid stock picks in this stock newsletter. They also have a 30 day, 100% money back guarantee. You should definitely try it for 30 days!

If you are not sure that you are ready to trade on their suggestions, you can learn to invest by following the Motley Fools trade suggestions using a HTMW’s virtual trading account. This is an excellent way to learn. 

To get their next stock picks at this discounted price, you must click here. We recommend that you review their picks and analysis carefully. Make sure you buy in slowly with the expectation that over a year you should have 10-20 stocks in your portfolio. Do NOT put all of your money in their first few stock picks!

THE BEST NEWSLETTER CONCLUSION:

Based on the last 24 months of performance, the Motley Fool’s Stock Advisor is the best stock sites available. Best of all, it is currently on sale for just $19 a month or $99 a year. If you are looking for solid stock picks to add to your portfolios, this is where you should start. Click here to get this special price.

If you are still not satisfied, then read this Motley Fool Stock Advisor Review and get even more information. You will find that this site is the best stock site for maximizing your returns.


*August 9, 2018 Update:

A key aspect in selecting a good newsletter would be its consistency in suggesting undervalued stocks. To evaluate this, the HowTheMarketWorks team kept on trading the Fool’s stock picks. Here are some recent highlights from our portfolios for David and Tom’s recommendations since December 2017:

 

David’s Portfolio Highlights

Company Suggested Price Paid Last Price Return
OKTA January + April 2018 34.93 57.23 63.84%
ILMN January 2018 248.76 337.32 35.60%
FICO March 2018 169.71 213.73 25.94%
AMZN March + April 2018 1585.52 1898.89 19.76%
ADBE April 2018 221.90 254.95 14.89%
Tom’s Portfolio Highlights
Company Suggested Price Paid Last Price Return
NFLX February 2018 (trailing stop order activated) 264.18 361.99 37.02%
VRNS March 2018 (trailing stop order activated) 58.25 75.25 29.18%
SHOP May 2018 138.76 163.53 17.85%
APPN July 2018 32.30 34.69 7.40%
IRBT Dec 2017 (trailing stop order activated) 64.30 87.08 35.43%

One of the most recent suggestion by the Fool’s Stock Advisor is Appian Corporation (APPN:NASDAQ). In nearly two weeks, it has achieved a return of 7.40% in our portfolio and we believe there is still a lot more room for growth. On the 2nd of August 2018, Appian reported its Q2 results with a 39% revenue growth due to a “combination of new customer acquisition, a 119% subscription revenue retention rate among existing customers, and a one-off perpetual software deal. This figure grew much faster than management had previously predicted” (Source: MotleyFool News & Updates). Thanks to our friends at Motley Fool, we were able to get an early seat and capture APPN’s growth.


The Fool’s marketing campaign is still supporting its claim that it can beat the market. As of right now, the Fool’s Stock Advisor is averaging a 347% return since their inception, while the S&P has a 80% return.

how to invest in the stock market - best stock sites

How to get Their Next Stock Pick

Investing in the S&P can be advantageous due to its simplicity in investing in a diversified portfolio. However, we are confident that the Motley Fool’s Stock Advisor service can generate greater returns with a small effort from the investor. When factoring the discounted price of the service and the return it generates (4 times Standard & Poor’s return), we believe the Stock Advisor is still the best newsletter service available in their price range. You can get the next stock picks from this newsletter by clicking here.

Please remember, there is not time like the present to start to learn to invest using the Fool’s professional stock tips.