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.

Remarks

* This function is 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 support.office.com

 ABC
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 (%) 
6=FIELDVALUE($E$6789,D6794)Currency 
7=FIELDVALUE(C1,B7) = [see below for full description]Description 
8=FIELDVALUE($E$6789,D6796)Employees 
9=FIELDVALUE($E$6789,D6797)Exchange abbreviation 
10=FIELDVALUE($E$6789,D6798)Headquarters 
11=FIELDVALUE($E$6789,D6799)High 
12=FIELDVALUE($E$6789,D6800)Industry 
13=FIELDVALUE($E$6789,D6801)Instrument type 
14=FIELDVALUE($E$6789,D6802)Last trade time 
15=FIELDVALUE($E$6789,D6803)Low 
16=FIELDVALUE($E$6789,D6804)Market cap 
17=FIELDVALUE($E$6789,D6805)Name 
18=FIELDVALUE($E$6789,D6806)Official name 
19=FIELDVALUE($E$6789,D6807)Open 
20=FIELDVALUE($E$6789,D6808)P/E 
21=FIELDVALUE($E$6789,D6809)Previous close 
22=FIELDVALUE($E$6789,D6810)Price 
23=FIELDVALUE($E$6789,D6811)Shares outstanding 
24=FIELDVALUE($E$6789,D6812)Ticker symbol 
25=FIELDVALUE($E$6789,D6813)Volume 
26=FIELDVALUE($E$6789,D6814)Volume average 
27=FIELDVALUE($E$6789,D6815)Year incorporated 
28=FIELDVALUE(E6816,D6816)CapitalUnited Kingdom
29=FIELDVALUE(E6816,D6817)Population 

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

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