Home

Stock Quote - Adding user-defined fields

%3CLINGO-SUB%20id%3D%22lingo-sub-321397%22%20slang%3D%22en-US%22%3EStock%20Quote%20-%20Adding%20user-defined%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321397%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20have%20found%20Stock%20Quote%20very%20useful.%3CBR%20%2F%3EHowever%2C%20I%20wish%20there%20were%20more%20fields.%20I%20am%20aware%20the%20ones%20included%20are%20%22fixed%22%20to%20some%20extent%3A%20current%20stock%20price%2C%20employees%2C%20market%20cap...%20all%20set%20for%20current%20period.%20So%20I%20was%20wondering%20if%20there%20is%20any%20special%20syntax%20we%20could%20use%20to%20retrieve%20even%20more%20information%20from%20Morningstar.%20Example%3A%20I%20tried%20short%20interest%20by%20adding%20this%20formula%20to%20a%20cell%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DA2.%5Bshort%20ineterest%5D%20for%20company%20name%20in%20cell%20A2%20and%20did%20not%20retrieve%20any%20data%20from%20Morningstar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20only%20the%20established%20fields%20work%3F%20Can't%20we%20add%20our%20own%3F%20Could%20we%20add%20time%20frames%2C%20such%20as%20Revenues%202018%2C%20Revenues%20current%20quarter%2C%20etc.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20this%20could%20be%20added%20%22Stock%20Quote%22%20could%20be%20a%20great%20sandbox%20to%20play%20with%20financial%20information.%20My%20wish%3A%20adding%20fields%20for%20ownership%20and%20valuation%20data%20points%20on%20different%20time%20frames.%20Current%20period%20at%20a%20minimum.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20making%20this%20tool%20available.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-321397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Estock%20quote%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-321507%22%20slang%3D%22en-US%22%3ERe%3A%20Stock%20Quote%20-%20Adding%20user-defined%20fields%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-321507%22%20slang%3D%22en-US%22%3EI'm%20afraid%20you%20cannot%20(yet)%20add%20your%20own%20fields.%20If%20you%20would%20like%20to%20draw%20MSFT's%20attention%20to%20this%2C%20add%20a%20suggestion%20to%20Excel.uservoice.com%20and%20get%20people%20to%20vote%20for%20it.%3C%2FLINGO-BODY%3E
Highlighted
robrosen
New Contributor

Hello. I have found Stock Quote very useful.
However, I wish there were more fields. I am aware the ones included are "fixed" to some extent: current stock price, employees, market cap... all set for current period. So I was wondering if there is any special syntax we could use to retrieve even more information from Morningstar. Example: I tried short interest by adding this formula to a cell:

=A2.[short ineterest] for company name in cell A2 and did not retrieve any data from Morningstar.

 

Do only the established fields work? Can't we add our own? Could we add time frames, such as Revenues 2018, Revenues current quarter, etc.

If this could be added "Stock Quote" could be a great sandbox to play with financial information. My wish: adding fields for ownership and valuation data points on different time frames. Current period at a minimum. 

Thank you for making this tool available.

1 Reply
I'm afraid you cannot (yet) add your own fields. If you would like to draw MSFT's attention to this, add a suggestion to Excel.uservoice.com and get people to vote for it.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies