Dec 17 2018 11:44 AM
I am new to this community and want some help in inputting info. to retrieve correct stock data. Specifically having trouble with some Canadian stocks. Most work fine. For example when I input TO.NTR I get the correct CDN stock. However when I try a CDN REIT like Granite Real Estate Investment Trust (GRT-UN) I get nothing at all. Is there a guide somewhere. Understand Bloomberg is the source of this data. Help would be appreciated.
Dec 17 2018 12:52 PM
Hi Keith,
Not sure about concrete stocks, the source of the information is Moningstar, more about that is here https://support.office.com/en-us/article/about-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6
Mar 24 2019 09:56 PM
@Sergei BaklanSame query. I am trying to enter Enbridge Inc preferred shares class N (Canadian) into my spreadsheet using the stock data type. On the Morningside site I can get a quote on it with the symbol ENB.PR.N but searching with the stock data type in Excel only returns the basic stock symbols for US or Canada. Any suggestions? Thanks.
Mar 25 2019 12:59 AM
Hi @OldDogNewTrick , you may type the ticker instead of the company name, in this case Excel recognises it
Mar 25 2019 10:15 PM
@Sergei Baklan Thanks for the reply. I did try using the symbol alone and that did not work. Tried it again just now.
Mar 26 2019 01:25 AM
@OldDogNewTrick , unfortunately have no idea why, in my case it works.