Data Import MAcro

[maninjapan]

Im not sure if Im getting in over my head here, or how this would work but how difficult would it be to create a macro that pulls data from yahoo and imports to a spreadsheet? I'm specifically after Market Sector Data available in Yahoo Finance.

Thanks!!

[Oorang]

There are quite a few add-ins running around that already do this. If you don't want to have to build your own:)

If you do want to build your own, just ask whenever you hit trouble:)

I have not tested, nor do I endorse this add-in. However you might want to read this (http://fransking.blogspot.com/2006/06/getting-stock-prices-into-excel.html) to help you get the lay of the land. I can vouch for this one (http://www.microsoft.com/downloads/details.aspx?FamilyID=485FCCD8-9305-4535-B939-3BF0A740A9B1&displaylang=en), (and this one (http://www.microsoft.com/downloads/details.aspx?FamilyID=d20e2ca8-9f26-4ef6-8f07-f0ef37d3d35b&DisplayLang=en)) but it's MSN not Yahoo.