How to Fix Your FREE Stock Portfolio Tracker Showing $-1 in their Last Price | Yahoo Stock Price 401 Unauthorized Access Issue

Many readers have updated me they are seeing “-$1” in the prices on their Stock Portfolio Tracker.

For those readers who are newer, I created a FREE Google Spreadsheet Stock Portfolio Tracker to help people track their stock securities based on transactions.

If you are a more private person and would like to track your portfolio by yourself instead of using a good third-party tool such as Stocks.Cafe, then you can check out Stock Portfolio Tracker (Free Online Investment Stock Portfolio Tracker Spreadsheet).

I did up a video to explain the problem and how to alleviate the problem:

The problem is caused by Yahoo preventing access to their API call.

But I have two implementations when I implemented the last change to the Yahoo Price updater.

One of the implementations still works.

The short version of the solution: Instead of using getYPrice3() function, use getYPrice2() function!

Now, I am not sure how long this implementation will last, but at least it works for now.

Here is the code for getYPrice2()”

function getYPrice2(symbol) {
  symbol = symbol || "D05.SI";
  symbol = encodeURI(symbol);
  Utilities.sleep(Math.floor(Math.random() * 5000))
  var url = 'https://query2.finance.yahoo.com/v7/finance/options/'+ symbol; // last one day history
  Logger.log(url);  
  var response = UrlFetchApp.fetch(url, {muteHttpExceptions: true});
  var responseCode = response.getResponseCode();
  Logger.log("Response code:"+responseCode); 
  if (responseCode === 200) {
    var chain = JSON.parse(response.getContentText());
    Logger.log(parseFloat(chain.optionChain.result[0].quote.regularMarketPrice));
    return parseFloat(chain.optionChain.result[0].quote.regularMarketPrice);
  }else{
     return -1; 
  }
}

I am posting the code for those of you who are on very legacy implementation of the Stock Portfolio Tracker.

You might be interested to change it.

---

If you want to trade these stocks I mentioned, you can open an account with Interactive Brokers. Interactive Brokers is the leading low-cost and efficient broker I use and trust to invest & trade my holdings in Singapore, the United States, London Stock Exchange and Hong Kong Stock Exchange. They allow you to trade stocks, ETFs, options, futures, forex, bonds and funds worldwide from a single integrated account.

You can read more about my thoughts about Interactive Brokers in this Interactive Brokers Deep Dive Series, starting with how to create & fund your Interactive Brokers account easily.