Forum Discussion

Copper Contributor

Dec 17, 2018

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...

excel

SergeiBaklan

Diamond Contributor

Dec 17, 2018

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

OldDogNewTrick
Copper Contributor
Mar 25, 2019
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.
- SergeiBaklan
  Diamond Contributor
  Mar 25, 2019
  Hi OldDogNewTrick , you may type the ticker instead of the company name, in this case Excel recognises it
  - OldDogNewTrick
    Copper Contributor
    Mar 26, 2019
    SergeiBaklan Thanks for the reply. I did try using the symbol alone and that did not work. Tried it again just now.