getting external data

  • Thread starter Thread starter Donald Lingerfelt
  • Start date Start date
D

Donald Lingerfelt

Does anyone know how to dowload data from web sites? I have a template file
from Microsoft that downloads stock data from MSMoney and places it into a
grid. I want to do likewise, but with different data from that site or from
Yahoo, But I can't seem to get the data to go into the cols and rows like
they do. I would apperciate any help. Thanks
Don L.
 
hope I have understood your requirements
use <data(menu)-getexternaldata-newwebquery>
in newwebquery window fill up items 1, 2 and 3 and click ok. item 2 should
be either only the tables or specified table. first time you get the data.
subsequently you have to <refresh> data which isavailable in getexternal
data toolbar.
 
Close. When I do what you suggest, I get the whole web page, not just the
data that I want. I've tried the "Saved web query" from MS and get most of
what I need but I would like to get "price/sales" ratio as well as what they
give aready. It is a good format though.
 
did you try < of one or more spcitific tables on the page> instead of
table only. You have to find out the table number - either by trial and
error or by counting table tags in html source (view- source)and give that
nummber in <enter table names or numbers separated by commas>
I get regularly data from yahoo indian finance webpagae.
 
Back
Top