J
joeu2004
I want to import multiple tables from the same web page
that I find with a google search. Is there an easy way to
do that?
This is what I did (sigh). Click on Data > Import External
Data > New Web Query, go to google.com and search for
"1926 s&p 500" without quotes. Click on the link for "AIM
Investments: How to Survive the Stock Market's Ups and
Downs" at
http://www.aiminvestments.com/porta...Guid=a03abb4011db2010VgnVCM10000026b4bf0aRCRD .
Page down to the several tables under the titles "The Stock
Market: The Good Years" and "... The Bad Years". Select one
table and click Import.
I have to repeat the whole thing, including the Google search,
for each table :-(.
that I find with a google search. Is there an easy way to
do that?
This is what I did (sigh). Click on Data > Import External
Data > New Web Query, go to google.com and search for
"1926 s&p 500" without quotes. Click on the link for "AIM
Investments: How to Survive the Stock Market's Ups and
Downs" at
http://www.aiminvestments.com/porta...Guid=a03abb4011db2010VgnVCM10000026b4bf0aRCRD .
Page down to the several tables under the titles "The Stock
Market: The Good Years" and "... The Bad Years". Select one
table and click Import.
I have to repeat the whole thing, including the Google search,
for each table :-(.