EXCEL: to retrive data from the web
 

Hello,
I am an excel novice.
I would like to know whether it is possible to make use of a VBA program or
some other mechanism so that I may instruct excel to automatically retrive
data from the web or, even better, an XLS file containing financial data from
"Yahoo finance" and load the data upon startup.
An example of the data I would like excel to fetch and import can be found
at http://finance.yahoo.com/
How may I configure excel for thios task? Thanks.
Aldo Pellizzi

EXCEL: to retrive data from the web
 

This is called a web query.

Click on DATA Import External Data New Web Query

This opens a mini-browser. Use it to navigate to Yahoo and the
financial info you want to collect. You'll notice little yellow
arrows...those represent sets of web data you can "grab".

When the data you want is onscreen, click on the arrow next to that
data and it becomes a green checkmark.

Click on "IMPORT" and point your spreadsheet to where you want this to
appear. Click on PROPERTIES to setup some extra parameters, like how
often the data should refresh from the web.

It's usually best to collect this info on a scrap worksheet, then use
cell references to pull info from it onto the sheets where you read it
laid out the way you want.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46783

EXCEL: to retrive data from the web
 

Check this out:
http://www.mrexcel.com/tip103.shtml

Practice a few times, then turn on the macro recorder before you do a full
run through. Hit Alt+F11 to see the code. You should learn quite a lot from
this exercise.

Regards,
Ryan---


--
RyGuy


"JBeaucaire" wrote:


This is called a web query.

Click on DATA Import External Data New Web Query

This opens a mini-browser. Use it to navigate to Yahoo and the
financial info you want to collect. You'll notice little yellow
arrows...those represent sets of web data you can "grab".

When the data you want is onscreen, click on the arrow next to that
data and it becomes a green checkmark.

Click on "IMPORT" and point your spreadsheet to where you want this to
appear. Click on PROPERTIES to setup some extra parameters, like how
often the data should refresh from the web.

It's usually best to collect this info on a scrap worksheet, then use
cell references to pull info from it onto the sheets where you read it
laid out the way you want.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46783