|
PureBytes Links
Trading Reference Links
|
This is your basic Excel 97 data download info:
Enjoy.
Walter
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
http://officeupdate.microsoft.com/excel/webquery/samples.htm
Microsoft Excel Web Queries Visit Microsoft Office Update
Web queries open up your spreadsheet models to use live data direct from the
Internet or Intranet web reporting packages.
To download a query from the left side of the list below:
Click on any of the query names and select "Save it to disk"
When prompted for a folder, select the Office Queries folder (usually
...\Queries in your Office main folder)
Note: Because web queries are text files, some computers will display the
query file in the browser window rather than letting you save it when you
click on the link below. If this happens, use Save As, either from the File
menu or by right-clicking on the hyperlink to save the file to the
appropriate folder.
Once you have downloaded and installed the additional sample queries, use
the Web Query feature in Excel to run them.
Start
Excel and choose "Data, --> Get External Data, --> Run Web Query, -->then
select the desired query"
Web Query Source
Stock Quote-Single Company
PC Quote Worksheet (xls) (92K) http://www.pcquote.com/
Stock Quotes-Multiple Company
Accutrade Quotes Accutrade by Quote.com
CNN Financial Network Quotes http://www.cnnfn.com/
Merrill Lynch Quotes http://www.ml.com/
Money Magazine Online Quotes http://www.money.com/
Quote.com Quotes http://www.quote.com/
USA Today Quotes http://www.usatoday.com/
Yahoo Detailed Quotes quote.yahoo.com
Yahoo Summary Quotes quote.yahoo.com
Stock Market Reports
CNN World Markets http://www.cnnfn.com/
DBC Dow Jones http://www.dbc.com/
DBC Major Markets http://www.dbc.com/
Money 30 http://www.money.com/
Currencies and Exchange Rates
Pacific Currencies of the World Pacific Commerce
Pacific Exchange Rates Pacific Commerce
Commodities
CNN Commodities http://www.cnnfn.com/
Money Market
Vanguard Money Market Report http://www.vanguard.com/
++++++++++++++++++++++++++++++++++++++++++++
|