Forum Discussion
Trying to make my Stock Spreadsheet work
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.
5 Replies
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
SergeiBaklanSame 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.
Hi OldDogNewTrick , you may type the ticker instead of the company name, in this case Excel recognises it
