Home

Trying to make my Stock Spreadsheet work

%3CLINGO-SUB%20id%3D%22lingo-sub-303008%22%20slang%3D%22en-US%22%3ETrying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303008%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20am%20new%20to%20t%3C%2FSPAN%3E%3CSPAN%3Ehis%20community%20and%20want%20some%20help%20in%20inputting%20info.%20to%20retrieve%20correct%20stock%20data.%20Specifically%20having%20trouble%20with%20some%20Canadian%20stocks.%20Most%20work%20fine.%20For%20example%20when%20I%20input%20TO.NTR%20I%26nbsp%3B%20get%20the%20correct%20CDN%20stock.%20However%20when%20I%20try%20a%20CDN%20REIT%20like%20Granite%20Real%20Estate%20Investment%20Trust%20(GRT-UN)%20I%20get%20nothing%20at%20all.%20Is%20there%20a%20guide%20somewhere.%20Understand%20Bloomberg%20is%20the%20source%20of%20this%20data.%20Help%20would%20be%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-303008%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388505%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303069%22%20target%3D%22_blank%22%3E%40OldDogNewTrick%3C%2FA%3E%26nbsp%3B%2C%20unfortunately%20have%20no%20idea%20why%2C%20in%20my%20case%20it%20works.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388454%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20Thanks%20for%20the%20reply.%26nbsp%3B%20I%20did%20try%20using%20the%20symbol%20alone%20and%20that%20did%20not%20work.%26nbsp%3B%20Tried%20it%20again%20just%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20712px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F100005i6982113297D041CF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222019-03-25%20Excel-data-type.jpg%22%20title%3D%222019-03-25%20Excel-data-type.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386571%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386571%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303069%22%20target%3D%22_blank%22%3E%40OldDogNewTrick%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20type%20the%20ticker%20instead%20of%20the%20company%20name%2C%20in%20this%20case%20Excel%20recognises%20it%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20204px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F99101iD1945E66C8BF9F78%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386535%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386535%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3ESame%20query.%26nbsp%3B%20I%20am%20trying%20to%20enter%20Enbridge%20Inc%20preferred%20shares%20class%20N%20(Canadian)%20into%20my%20spreadsheet%20using%20the%20stock%20data%20type.%26nbsp%3B%20On%20the%20Morningside%20site%20I%20can%20get%20a%20quote%20on%20it%20with%20the%20symbol%20ENB.PR.N%20but%20searching%20with%20the%20stock%20data%20type%20in%20Excel%20only%20returns%20the%20basic%20stock%20symbols%20for%20US%20or%20Canada.%20%26nbsp%3B%20Any%20suggestions%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-303042%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20make%20my%20Stock%20Spreadsheet%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-303042%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Keith%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENot%20sure%20about%20concrete%20stocks%2C%20the%20source%20of%20the%20information%20is%20Moningstar%2C%20more%20about%20that%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fabout-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fabout-our-data-sources-98a03e23-37f6-4776-beea-c5a6c8e787e6%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Keith_Courtenay
New Contributor

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

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

Hi @OldDogNewTrick , you may type the ticker instead of the company name, in this case Excel recognises it

 

image.png

@Sergei Baklan  Thanks for the reply.  I did try using the symbol alone and that did not work.  Tried it again just now.

 

2019-03-25 Excel-data-type.jpg

@OldDogNewTrick , unfortunately have no idea why, in my case it works.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies