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
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies