Formula Examples
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJK
1
Sector Data
2
3
TickerGCISICB
4
GEIndustrials#REF!
5
INTC
Information Technology
#REF!
6
AAPL
Information Technology
#REF!
7
DEIndustrials#REF!
8
TSE:EXE#N/A#REF!
9
EXE.TO#N/A#REF!
10
11
GCIS:
=index(importxml("https://eresearch.fidelity.com/eresearch/goto/evaluate/snapshot.jhtml?symbols="&A4&"","//div[@class='sub-heading']//span[@class='right']"),1)
12
ICB:
=index(ImportHTML("http://finance.yahoo.com/q/pr?s="&A4&"", "table", 11), 2,2)
13
14
15
Loading...
Main menu