IssueTracker

I'm also having this issue for any trust stocks. IE. EIT.UT

Also seeing this issue for all my REITs

Same here, also doesn't work if you actually go to Google Finance and try to type in a REIT on the TSX... only shows the NYSE ticker, if it exists.

I'm having the same issue, both with the GOOGLEFINANCE function and a straight-up Google search.

yes, it appears my REITs are affected as well SRU.UN and DIR.UN  turning up NA

I think this is also affecting https://www.google.com/finance/.
I am unable to add PLZ.UN to my Portfolio (even though it was there until last Sunday), at the same time my sheet stoped being able to pull this data also.

Same problem. All my Canadian REITs are showing N/A for the past week.

Same here

Yes - I am having the same problem for all TSX trust unit stocks. Would appreciate a fix so I don't have to start mixing in yahooF functions.

I am having the same problem with my Canadian REITS not showing up on Googlesheets.

Same problem here.

Same here, me too, don't help much. If you only need "end of day" price, do it manually. I have 3 stocks with .UN suffix and it's a temporary fix. Make sure you highlight the cells that are manual for correcting later, hopefully soon!

Using the Google Finance webpage you can find the NEW stock tickers when you type in the company name. For example "NorthWest Healthcare Properties REIT" shows up as OTCMKTS: NWHUF. HOWEVER, it is in USD not CAD so that it is not useful. Not sure why the exchange changed from TSE either!?! Hopefully they will consider this a bug and fix it. Either way it would be really good to know what Google is thinking so I can figure out what/when I can view my portfolio again!

BTW, there is an extension that is supposed to work for Canadian Trusts, Yahoo Finance (YHFIANCE). However it is $19/month and not even close to live. I would rather pay for a good working version if Google Finance, just saying.

Same. At this rate maybe I should just move to Yahoo finance instead

=iferror(substitute(index(IMPORTHTML("https://coindataflow.com/en/stock/SRU-UN.TO","table",1),1,2),"CAD",""))

Its been almost a week, when is google going to fix this

TSX ( or TSE )  REITS  are still not being read on Google Sheets.
Is there an easy work-around to fix this ?

Adding to help from post # 15 got me a temporary work around. It's not 100% accurate but does a close job for my day end value with no N/A cells.My 3 .UN stocks are BIP.UN, HR.UN and PMZ.UN
Check your stocks on Google Finance using stock name not symbol for proper market.
Temp work around for Can$$:
BIP.UN -  =GoogleFinance ("NYSE:BIP","price")*GOOGLEFINANCE("CURRENCY:USDCAD")
HR.UN -  =GoogleFinance ("OTCMKTS:HRUFF","price")*GOOGLEFINANCE("CURRENCY:USDCAD")
PMZ.UN - =GoogleFinance ("OTCMKTS:PMREF","price")*GOOGLEFINANCE("CURRENCY:USDCAD")
Of course it never fails in doing up this post 75% of Google Sheets prices failed. lol.

Still waiting

same issue.

Post 17 works - thanks

Same problem here...

Same problem. Can't search Google Finance or use Google Sheets with REI.UN and GRT.UN
Please fix this. : )

Same problem for Boston Pizza (BPF.UN) not working. Also have had same problem for Norwegian Stock EuroPris.

Hey Google! Open the code to community and we are happy to help with fixing these bugs. Thank you!!

Google Finance also is broken for things like mutual funds.
So =GOOGLEFINANCE("MUTF_CA:TDB908", "price") will generate a
"Error. When evaluating GOOGLEFINANCE, the query for the symbol: 'TDB900' returned no data."

Maybe Google finance is turning into an American only tool for Americans' only.

Post 28
When I read the Maybe "Maybe Google finance is turning into an American only tool for Americans' only"
I had a little chuckle BUT there may be some truth in this comment.
See below??
Google has started temporarily restricting news results for approximately four percent of randomly selected Canadian users in tests that will last five weeks. The decision directly responds to an online news bill called C-18, currently under debate in the Canadian parliament.

Google please liaise with Morningstar or ICE and clear this up ASAP.  This has a major impact on Canadian market participants.  Also, no TSX listing for Brookfield Corporation, one of the largest Canadian companies.  It's reasonable to expect better.

Don't like the "me too" but, well, me too! The website won't return a bunch of .un (unit) stock, I think of any type!
Arrrrrrgh. My apologes. I don't have anything constructive, becuase I don't know who/what/how I can communicate to and help or assist in this process.

Same here

SRU.UN always broken. . .

Still broken, in case anyone is watching...

still broken ... whats going on ?

I was able to develop a script using chatGPT that scraped the price from Yahoo Finance and inserted it into google sheets. This youtube video will give you an idea how to do that. https://www.youtube.com/watch?v=HO1z4k0QuwQ

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('Custom Macros')
    .addItem('Get Stock Price', 'getStockPrice')
    .addToUi();
}

function getStockPrice() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var dataRange = sheet.getRange("A2:A"); // Assuming stock symbols start from row 2 in column A
  var dataValues = dataRange.getValues();
  var prices = [];

  for (var i = 0; i < dataValues.length; i++) {
    var symbol = dataValues[i][0];

    if (symbol !== "") {
      var url = "https://query1.finance.yahoo.com/v8/finance/chart/" + symbol;

      try {
        var response = UrlFetchApp.fetch(url);
        var data = JSON.parse(response.getContentText());

        if (data.chart && data.chart.result && data.chart.result[0] && data.chart.result[0].meta && data.chart.result[0].meta.regularMarketPrice) {
          var price = data.chart.result[0].meta.regularMarketPrice;
          prices.push([price]);
        } else {
          prices.push(["Error"]);
          Logger.log("Unable to retrieve price for symbol: " + symbol);
        }
      } catch (error) {
        prices.push(["Error"]);
        Logger.log("Error fetching data for symbol: " + symbol);
        Logger.log("Error details: " + error);
      }
    } else {
      prices.push([""]);
    }
  }

  // Update column B with the retrieved prices
  var outputRange = sheet.getRange(2, 2, prices.length, 1); // Assuming prices start from row 2 in column B
  outputRange.setValues(prices);
}

i'm absolutely shocked at google's pure incompetence.. it has been broken for 2 months and they can't fix it.. just unbelievable.. whoever is in charge should be fired over this.

Problem is still occuring. Any update on when we can expect a fix??