ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
URLhttps://finance.yahoo.com/quote/NVTA//div/div/div/p/text()
https://finance.yahoo.com/quote/NVTA
2
GOALImport Company Profile Description
Invesco Mortgage Capital Inc. operates as a real estate investment trust (REIT) that primarily focuses on investing in, financing, and managing residential and commercial mortgage-backed securities, and other mortgage-related assets. It invests in residential mortgage-backed securities (RMBS) and commercial mortgage-backed securities (CMBS) that are guaranteed by a U.S. government agency or federally chartered corporation; RMBS and CMBS that are not issued or guaranteed by a U.S. government agency or federally chartered corporation; credit risk transfer securities that are unsecured obligations issued by government-sponsored enterprises; residential and commercial mortgage loans; and other real estate-related financing arrangements. Invesco Mortgage Capital Inc. has elected to be taxed as a REIT and would not be subject to federal corporate income taxes if it distributes at least 90% of its taxable income to its stockholders. The company was formally known as Invesco Agency Securities Inc. and changed its name to Invesco Mortgage Capital Inc. in June 2008. Invesco Mortgage Capital Inc. was incorporated in 2008 and is headquartered in Atlanta, Georgia.
//*[@id="quoteNewsStream-0-Stream"]/ul/li[1]/div/div/div[2]/p/text()
3
XPATH//*[@id="Col2-11-QuoteModule-Proxy"]/div/div/div/p
4
PROBLEMcontent is empty
//*[@id="Col2-11-QuoteModule-Proxy"]/div/div/div/p/text()
5
//*[@id="chart-header"]/div[3]/div[2]/div[2]/button/div/span/span
//*[@id="mat-tab-content-1-2"]/div/div/app-analyst-rating/div/div[1]/div[2]/div
6
TEST NUMBER123456789101112131415161718192021
7
52 week rangemarket capfirst news articleSTACK ANSWER - SUBSTRING
8
TEST NAMEclass- imported content is emptyxml path - formula parse errorxml path with single quotes - empty
xml path with single quotes and "text()" - empty
xml path with double quotes - empty
xml path for 52 week range //*[@id='quote-summary']/div[1]/table/tbody/tr[6]/td[2]
Bullish not workingxml path for first news article
xml path for LEFT 2/3 or page //div/div/div/p/text()
summarySector
Full Time Employees
9
#N/A#ERROR!
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'='Col2-11-QuoteModule-Proxy']/div/div/div/p")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'='Col2-11-QuoteModule-Proxy']/div/div/div/p/text()")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'=""Col2-11-QuoteModule-Proxy""]/div/div/div/p")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'='quote-summary']/div[1]/table/tbody/tr[6]/td[2]")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'='quote-summary']/div[2]/table/tbody/tr[1]/td[2]/span")
=IMPORTXML("https://finance.yahoo.com/chart/NVTA?technical'=short","//*[@id'='chart-header']/div[3]/div[2]/div[2]/button/div/span")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//*[@id'='quoteNewsStream-0-Stream']/ul/li[1]/div/div/div[2]/p/text()")
=IMPORTXML("https://finance.yahoo.com/quote/NVTA","//div/div/div/p/text()")
=IMPORTXML(B1,"substring-before(substring-after(//script[@id'='fc'],'""longBusinessSummary"":""'),'"",""city""')")
=IMPORTXML(B1,"substring-before(substring-after(//script[@id'='fc'],'""sector"":""'),'"",""fullTimeEmployees""')")
=IMPORTXML(B1,"substring-before(substring-after(//script[@id'='fc'],'""fullTimeEmployees"":""'),'"",""longBusinessSummary""')")
=IMPORTXML(B1,"substring-before(substring-after(//script[@id'='fc'],'""industry"":""'),'"",""address2""')")
=REGEXEXTRACT(IMPORTXML(B1,"substring-before(substring-after(//script[@id'='fc'],'""website"":""'),'"",""maxAge""')"),"www\..*")
=IMPORTXML(T1,"substring-before(substring-after(//script[@id'='fc'],'""longBusinessSummary"":""'),'"",""city""')")
=IMPORTXML("https://www.chartmill.com/stock/analyzer/stock/AMZN?view'=analyst-ratings","//*[@id'='mat-tab-content-1-2']/div/div/app-analyst-rating/div/div[1]/div[2]/div")
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100