Data tables

[tenspeed2]

I have the 2019 Excel. After entering the url I am seeing 25 data tables. Question is I only need two tables.
As of now I have to open most of the tables to find the two I need. Is there a way to locate the two tables
I want to download into Excel?

 

[hernantorres23]

Hi, I understand that you getting data from web services, could you put the URL that you are using?

 

[tenspeed2]

Here is the web page.https://www.sec.gov/Archives/edgar/data/1176199/000114544319000436/d364003.htm
When the web page opens and I am seeing all the tables I know that there is
some data I want. There are about 15 tables so how do I find the data I want
that is somewhere under the tables without searching all 15 tables. Is there a
key word or someway to locate the data? After searching all the tables I do find
the data I want. I then can download the data to Excel with no problem.

 

[hernantorres23]

Hi, I loaded all tables in this Example
Go to menu Data / Show Queries
In Sheets2, Sheets3, Sheets4, you can see loaded Table13, Table17 and Table20
For load more tables, Right click over any Workbook Queries, then select Load To and follow instructions
After you have selected, tables that you want, remove all Queries
You can do, many things with this method

I hope, I helped you

 

[tenspeed2]

Hi Thanks for your reply. I have done that. No problem. Let's try one more time.
Example. I want the data showing the income statement only. I know it is somewhere
between tablet 10 and tablet 40 but I have no idea where. The only way I can find the
income statement is to start at table 10 and search until I find the income statement.
What a bummer that is. My question is there a way to do some kind of search using the
heading INCOME STATEMENT to find the data I want. While I have this on my mind how
about the NAVIGATOR and the box under the NAVIGATOR. What search should I do?
I would have thought I could use that box to search for the INCOME STATEMENT.
Thanks again for your time. You have come closer than anyone.
Max

 

[sandy666]

Income as keyword from all tables

Custom
(E)Non-income producing security.
Investment income
Total investment income50,645,763
Net investment income34,842,691
Net investment income$34,842,691$39,233,996
From net investment income and net realized gain(36,386,401)—
From net investment income—(43,698,893)
Net investment income1.341.511.611.601.65
From net investment income(1.40)(1.68)(1.68)(1.55)(1.68)
Net investment income6.497.107.407.337.58
Total return based on net asset value reflects changes in the fund’s net asset value during each period. Total return based on market value reflects changes in market value. Each figure assumes that distributions from income, capital gains and tax return of capital, if any, were reinvested.
Ordinary income$36,386,401$43,698,893

 

[sandy666]

or like this

Column1	Column2	Column3	Column4	Column5	Column6
(E)	Non-income producing security.
Investment income
Total investment income	50645763
Net investment income	34842691
Net investment income	$34,842,691	$39,233,996
From net investment income and net realized gain	-36386401	—
From net investment income	—	-43698893
Net investment income	1.34	1.51	1.61	1.6	1.65
From net investment income	-1.4	-1.68	-1.68	-1.55	-1.68
Net investment income	6.49	7.1	7.4	7.33	7.58
	Total return based on net asset value reflects changes in the fund’s net asset value during each period. Total return based on market value reflects changes in market value. Each figure assumes that distributions from income, capital gains and tax return of capital, if any, were reinvested.
Ordinary income	$36,386,401	$43,698,893
●	Investment Performance: The investment performance of all accounts managed by the investment professional over one- and three- and five-year periods are considered, and no specific benchmark is used to measure performance. With respect to fixed income accounts, relative yields are also used to measure performance.

 

[hernantorres23]

Hi, it is information that you want?

Book1
	A	B	C
1	Col1	Col2
2	Accounting and legal services fees	68271	Bad
3	Trustees' fees	526	Bad
4	Investment income
5	Dividends	$42,737,431
6	Interest	7969122
7	Less foreign taxes withheld	-60790
8	Total investment income	50645763
9	Expenses
10	Investment management fees	6221176
11	Interest expense	9100628
12	Accounting and legal services fees	116543
13	Transfer agent fees	27548
14	Trustees' fees	44674
15	Custodian fees	65430
16	Printing and postage	182832
17	Professional fees	63383
18	Stock exchange listing fees	25387
19	Other	18523
20	Total expenses	15866124
21	Less expense reductions	-63052
22	Net expenses	15803072
23	Net investment income	34842691
24	Realized and unrealized gain (loss)
25	Net realized gain (loss) on
26	Unaffiliated investments and foreign currency transactions	-1615670
27	Futures contracts	-3626652
28	Swap contracts	331029
29	Change in net unrealized appreciation (depreciation) of
30	Unaffiliated investments	18673369
31	Futures contracts	-1261066
32	Swap contracts	-3149654
33	Net realized and unrealized gain	9351356
34	Increase in net assets from operations	$44,194,047
35	Net investment income	$34,842,691
Sheet7

 

[tenspeed2]

Income as keyword from all tables

#VALUE!

Sandy. Let me explain what I need. After entering URL I am seeing a number of
tables. I need to find the INCOME part of the URL. I want to locate the INCOME
part of the URL. I know it is under one of the tables. I do not want to go thru all
the tablets to find the INCOME. I am looking for a short cut to the income statement.
There must be some way to locate the income without opening each tablet.

 

[tenspeed2]

Hi, it is information that you want?

Book1
	A	B	C
1	Col1	Col2
2	Accounting and legal services fees	68271	Bad
3	Trustees' fees	526	Bad
4	Investment income
5	Dividends	$42,737,431
6	Interest	7969122
7	Less foreign taxes withheld	-60790
8	Total investment income	50645763
9	Expenses
10	Investment management fees	6221176
11	Interest expense	9100628
12	Accounting and legal services fees	116543
13	Transfer agent fees	27548
14	Trustees' fees	44674
15	Custodian fees	65430
16	Printing and postage	182832
17	Professional fees	63383
18	Stock exchange listing fees	25387
19	Other	18523
20	Total expenses	15866124
21	Less expense reductions	-63052
22	Net expenses	15803072
23	Net investment income	34842691
24	Realized and unrealized gain (loss)
25	Net realized gain (loss) on
26	Unaffiliated investments and foreign currency transactions	-1615670
27	Futures contracts	-3626652
28	Swap contracts	331029
29	Change in net unrealized appreciation (depreciation) of
30	Unaffiliated investments	18673369
31	Futures contracts	-1261066
32	Swap contracts	-3149654
33	Net realized and unrealized gain	9351356
34	Increase in net assets from operations	$44,194,047
35	Net investment income	$34,842,691
Sheet7

Yes. So how do I find the information?