On this page we cover the fixes, changes, and improvements to the Premium Value Spreadsheet.

V5.0.1 | 12-10-2023

  • Correctly apply currency conversion rate to P/E model
  • Handle case where EPS and P/E are negative, so a negative P/E model value is given
  • Fix GBX error in GOOGLEFINANCE() currency conversion rate function
  • Changed "Current share price" label to "Last close price" as the former confused some clients

 

V5.0.0 | 06-09-2022

  • Replaced Morningstar ratios with ratios from financial data feed, since Morningstar discontinued their API

 

V4.3.2 | 15-07-2022

  • Fixed several judgment bugs on the Analysis tab

 

V4.3.1 | 24-03-2022

  • Set exchange rate to 1 if statement currency and ticker currency are equal

 

V4.3.0 | 03-03-2022

  • Fix IMPORTHTML() for Morningstar data was no longer working

 

V4.2.6 | 14-10-2021

  • Added override field for exchange rate
  • Added support for Indonesian stocks with .JK extension

 

V4.2.5 | 10-06-2021

  • Adjusted DCF and ROE valuations based on exchange rate for foreign stocks
  • Added override field for Shares Outstanding

 

V4.2.4 | 30-03-2021

  • Added loading indicator under ticker symbol
  • Show negative numbers with a minus sign instead of between brackets
  • Added link to changelog and supported tickers

 

V4.2.3 | 13-07-2020

 

V4.2.3 | 30-03-2020

  • Added support for Australian stocks
  • Removed $ symbol, since we now support multiple countries with multiple currencies

 

V4.2.2 | 23-03-2020

  • Use last close price instead of calculating price based on EPS and PE ratio, since that proved to be incorrect in several cases

 

V4.2.1 | 15-03-2020

  • Fix companies with A and B shares not getting data from Morningstar
  • Fix wrong email message being displayed when no data is available

 

V4.2.0 | 05-03-2020 

  • Added support for foreign stocks (Canada, UK, India, Singapore, Hong Kong, Netherlands, France, Germany)
  • Added explanation on ticker field about how to search for foreign stocks
  • Removed Google Finance dependency (price now calculated based on stats)
  • Removed YCharts dependency (avg P/E now calculated based on stats if YCharts doesn’t have the data, but YCharts is only checked for US stocks)
  • Turned line charts into area charts, and resized them for better viewing on laptop screens
  • Change color scheme and fonts to match Value Scout

 

V4.1.1 | 15-12-2019

  • Checked for zero operating income in enterprising profit calculation
  • Fix #DIV/0 errors if too little data for enterprising profit
  • Show message that users have to first click File > Make a Copy… 

 

V4.1.0 | 18-11-2019

  • Replaced login button with email field, only return data if the email filled in is of an active user
  • Added warning message in spreadsheet for incorrect login or if user is not using the latest version
  • Ability to display a promotional text inside the spreadsheet
  • Added sector field
  • Changed long term debt to total liabilities in DCF model
  • Added message if no data is available for ticker

 

V4.0.0

  • !! Use IEX data from local database, and them import ONCE into the spreadsheet to circumvent importHTML() errors
  • Drastic speed improvements
  • Added last 4 quarterly statements
  • Multiple bug fixes

 

V3.6.3

 

V3.6.2 | 5-09-2019

  • Small fix for when EBIT is not defined, use EBT instead

 

V3.6.1 | 15-08-2019

  • Fix login issues due to stricter PHP 7.X rules for POST requests, had not properly set JSON as type and not JSON encoded the data in the Google Script

 

V3.6.0 | 05-04-2019

  • Create workaround for Morningstar’s exportKR2CSV

 

V3.5.3 | 24-02-2019

  • Fix #DIV/0 errors by catching some “-” values
  • Fix layout of statements tab
  • Fix sector showing as #N/A
  • Fix Expected Rate of Return in case of a negative average intrinsic value

 

V3.5.2 | 04-06-2018

  • Fix issues with retrieving financial statements and growth estimates from Yahoo Finance

 

V3.5.1 | 22-03-2018

  • Fix debt reference on DCF tab
  • Small fix for retained earnings in Altman Z calculation

 

V3.4.7 | 30-04-2017

  • Fixed issue with industry and expected 5y growth rate not loading because Yahoo Finance changed layout of their website (also fixed these fields and the dividend yield field in the free spreadsheets)

 

V3.4.6 | 07-12-2016

  • Fixed issue with statements not loading due to Yahoo API no longer working for retrieving Exchange

 

V3.4.3 | 03-12-2014

  • Fixed some bugs with data from Yahoo Finance (industry, expected growth rate)

 

V3.4.2 |  14-10-2014

  • Added 10 years of key ratios from Morningstar
  • Improved graphs by adding trendline, comparing FCF and EPS in one chart, and by adding more grid lines
  • Added Expected Annual Compounding Rate of Return
  • Added back Expected Growth Rate Next 5 Years from Yahoo Finance
  • Changed median historical P/E ratio into industry average P/E ratio

 

V3.4.1 | 01-10-2014

  • Bug fix update because MSN Moneycentral changed the layout of their website, making the ten years of key ratios unavailable

 

V3.5 | 29-08-2014

  • Added function MINUTE(NOW()) to ImportHTML requests to circumvent Google caching the urls and data 

 

V3.4 | 01-08-2014

  • Uses NEW Google Spreadsheets. For benefits, see: https://support.google.com/docs/answer/3541068?hl=en 
  • Fix dates on 10 year key statistics data
  • Changed DCF to also subtract Total Debt before calculating value per share
  • Improved sustainable growth rate used in ROE calculation
  • Added reverse DCF
  • Added overrides for growth rates, P/E, average estimate, and EPS
  • Improved charts with dates and grid lines
  • Price from subscription to one-time fee

 

V3.3

  • Added login button and scripts to ensure only people who have a valid subscription can use the spreadsheet

 

V3.2

  • Bugfixes: MSN Moneycentral updated the layout of their 10 Year Summary table, which messed up the entire spreadsheet

 

V3.1

  • Added 4 years of financial statement data
  • Added Altman Z Score
  • Added Earnings Power calculations, including Debt Repayment Period, Quality of Profits & Earnings Power Chart
  • Fundamental analysis is expanded to include the above mentioned changes, as well as FCF yield and Asset Turnover Change (%)
  • Updated the dashboard to display the expanded fundamental analysis, and added some flexibility to the scoring system by allowing users to set a weight for each part of the fundamental analysis to indicate which factors are most important for their specific strategy

 

V2.2

  • Updated DCF model. It was growing COH, which it shouldn’t since all COH growth comes from future FCF’s. This means we were counting this growth double. Thanks to Mark Gahagan for pointing this out
  • Moved the 2nd MSN table next to the first, because sometimes the tables got messed up when a wrong ticker symbol was entered
Value Investing Bootcamp - Online Investment Course