Skip to main content

11 Reasons Why INVRS is Better Than Excel Alone

INVRS and Excel

If you work with your own investment models you likely use excel to build them, but excel isn’t ideal for many reasons and it costs you in other ways. 

First, you need good data and it isn’t just lying around in an easy to import format.  You’re either keying it in yourself or paying money for excel downloads.  

When you need data from numerous sources – price information, data from different statements and across multiple years - you must merge it from multiple sheets.  It's an inefficient process which can lead to data corruption.

After all this data is collected and merged, models built and tested, the net result is one statistic for one company.  A stand-alone number without context has limited use.  To be meaningful, you need to compare it to similar companies.  
This is just a sample of the challenges.  You need software that overcomes these problems and is designed for investment model creation.

Surprise!  This software exists, it's INVRS.  You can get a free analysis report on the stock of your choice by clicking here.

Here's how INVRS solves the problems associated with using excel alone for investment analysis.

1.       It fetches your data for you. 
Just point and click for the data points you want. 

2.       You build the model in the software using familiar operators and not in an obscure programming language.
Suppose you want to calculate the forward dividend yield and compare it to the five year average and score/rank the quotient.  You can create this in INVRS using the same operators and shortcuts you use in excel, optionally validating your equations as you go.

3.       Each model is a template that you can use repeatedly.
No need to establish another data source, no risk of it breaking and no need to copy and paste each time you have a new stock to analyze.  Once you’ve built your model you can run it repeatedly on different stocks. 

4.       You can experiment.
Change any of the elements in your models, whether data or formula. 

5.       Perform peer-based analysis.
Running a model against one stock hardly seems worth it because there’s no context for the result.  With peer-based analysis, you can answer the question “how does my target company compare to similar companies?”

6.       It archives every analysis automatically.
In excel, refreshing data can lead to the loss of an old analysis. Your ideal software would never let that happen. 

7.       Find every archived analysis easily. 
You can search chronologically, by portfolio and by template.  An important feature when you are doing hundreds or thousands of analyses. 

8.       No flipping between data source and formula.
Best practice in excel separates data and formula.  Sometimes you can keep everything on one sheet, often you can’t.  Flipping between sheets is a pain when you are checking a complicated formula and if you combine your formulas and data, reproducing it or changing variables becomes difficult.
INVRS separates data and formula while keeping it all visible on screen.

9.       Fast graphing.
You can create graphs of your analyses.  You can sort the results, add a benchmark, annotate and export.  It's easier than in excel and supports other options specific to investment analysis, such as price graphing.

10.   Create notes or articles.
If you discover interesting information, you might want to share it.  Make notes as you go along and evolve them into articles you can publish or share.

11.   It pays you.
You get paid to use the software, whether it is posting your analyses or recommending it to other users.

Go to and sign up for a free trial or request a sample analysis.  Experience the power of INVRS for investment research.


Popular posts from this blog

NextEra - Good Dividend in the Renewable Energy Sector

NextEra had good results relative to a group of peers in a factor-based analysis. NextEra has an appealing profitability and income profile. Its price momentum looks decent, with a caveat. Its relatively small size (a small mid-cap) coupled with its industry (renewable energy) further weight the odds that this company could be a strong performer in the future. If you want in on renewable energy, we recommend NextEra. The Analysis Overview I created a portfolio of stocks in the alternative energy sector, looking specifically for companies with a market cap over $1B but less than $4B.  This is a sweet spot that offers strong potential for growth but is also substantial enough not to be too speculative. It's my believe that alternative energy is on the ascendance, where as fossil fuels will inevitably decline (NextEra isn't a pure play in this regard however, natural gas assets are part of its portfolio).  If you share this belief and you want exposure to this ma

Analyzing Results - 2013/Y-6

 There were eight companies in Group 8 (no 9) in 2013/Y-6: EW  STZ LRCX ALXN MU MCHP AME DE This is how they each fared from 2014 to 2020 - the year runs from April 1 to March 31st:   EW         92%, -58%, 5%, 48%, 41%, -1% STZ        36%, 31%, 7%, 42%, -22%, -18% LRCX     27%, 10%, 57%, 60%, -6%, 32% ALXN     12%, -18%, -15%, -7%, 24%, -34% MU         11%, -61%, 162%, 82%, -17%, 0 MCHP     5%, 3%, 56%, 27%, -4%, -21% AME        1%, -4%, 9%, 42%, 12%, -14% DE           -2%, -9%, 45%, 45%, 24%, -34% Six Year Return: EW  69% STZ  81% LRCX  355% ALXN  -42% MU  72% MCHP  60% AME  42% DE  68% What score did each of the above have in 2014/Y-5? EW - 6 STZ - 8 (no 9) LRCX - 4 ALXN - 8 (no 9) MU - 6 MCHP - 5 AME - 6 DE -5 What score did each have in 2015/Y-4? EW - 5 STZ -6 LRCX - 6 ALXN -5 MU - 6 MCHP - 2 AME - 3 DE - 1 What score did each have in 2016/Y-3? EW - 8 STZ - 7 LRCX - 7 ALXN - 6 MU - 7 MCHP - 5 AME - 1 DE - 2 What score did each have in 2017/Y-2? EW - 8 STZ - 4 LRCX - 8 ALXN - 6 MU -