FIELDVALUE(value, field_name)

Returns the field data from a Stocks or Geography linked data type.

valueThe company name (for stocks) or region name (for geography).
field_nameThe name (or names) of the fields you want.


* Only available in Microsoft 365.
* This function can be used with both the Stocks linked data type and the Geography linked data type.
* An alternative to using this function is to use the "cell" notation. If the "field_name" contains a space you must enclose it inside square brackets.
* Cell "C1" contains a Stocks linked data type. To create this type "Microsoft Corp" into a cell and select Data Tab, Stocks to display the Data Selector Task Pane.
* Cell "C28" contain a Geography linked data type. To create this type "United Kingdom" into a cell and select Data Tab, Geography.
* The Geography linked data type has a large number of fields, too many to list on this page.
* For the Microsoft documentation refer to

1=FIELDVALUE(C1,B1) = $190.7052 week highMicrosoft Corp (XNAS:MSFT)
2=FIELDVALUE(C1,B2) = $110.9852 week low 
3=FIELDVALUE(C1,B3) = $1.09Beta 
4=FIELDVALUE(C1,B4) = $10.30Change 
5=FIELDVALUE(C1,B5) = 6.84%Change (%) 
7=FIELDVALUE(C1,B7) = [see below for full description]Description 
9=FIELDVALUE($E$6789,D6797)Exchange abbreviation 
13=FIELDVALUE($E$6789,D6801)Instrument type 
14=FIELDVALUE($E$6789,D6802)Last trade time 
16=FIELDVALUE($E$6789,D6804)Market cap 
18=FIELDVALUE($E$6789,D6806)Official name 
21=FIELDVALUE($E$6789,D6809)Previous close 
23=FIELDVALUE($E$6789,D6811)Shares outstanding 
24=FIELDVALUE($E$6789,D6812)Ticker symbol 
26=FIELDVALUE($E$6789,D6814)Volume average 
27=FIELDVALUE($E$6789,D6815)Year incorporated 
28=FIELDVALUE(E6816,D6816)CapitalUnited Kingdom

7 - What is the "description" of this company. "Microsoft Corporation is a technology company. The Company develops, licenses, and supports a range of software products, services and devices. The Company's segments include Productivity and Business Processes, Intelligent Cloud and More Personal Computing. The Company's products include operating systems; cross-device productivity applications; server applications; business solution applications; desktop and server management tools; software development tools; video games, and training and certification of computer system integrators and developers. It also designs, manufactures, and sells devices, including personal computers (PCs), tablets, gaming and entertainment consoles, phones, other intelligent devices, and related accessories, that integrate with its cloud-based offerings. It offers an array of services, including cloud-based solutions that provide customers with software, services, platforms, and content, and it provides solution support and consulting services."

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top