Automate data from Web

Hi,

I am completely new to programming and I was hoping someone could either help me get started or reccomend a viable source for an introduction on using macro/VBA. My goal is to populate various workbooks with data from various websites automatically, as I have a lot of websites, a lot of data, and waster a lot of time doing this manually every day. Any help would be greatly appreciated!

<Matt

The easieest way would be

Data ---> Import external data ---> new web query

look for the page you want, select the table and click IMPORT

it will import it,


to refresh it simply click DATA --> refresh data

Thanks for the tip, but let me clarify and hopefully you can help me further. I want this data to begin to populate a series, wherein say I have Columns a-v with different data from different sources, and each day I want it to updated so that, if the data started in A1:V1, on day 2 it will insert new data in a1:v1 and shift day 1 data down to a2:v2 and continue in this fashion every day..

Thanks again!

Hi
Can you give an example URL and the data range you wish to download everyday?
Ravi

Sure,

www.yahoo.com/finance,

then on the rights hand side of the page, there is a "RATES" section, with a 'mortgage' tab. All of these rates would be one such data series out of several I would like to automate daily. Let me know if it would help if I provide others or maybe once you explain how to do it for this one I will be able to figure out how to do it for others by myself. Thanks in advance!

HI
Click the button in sheet1 to run the macro. It downloads from yahoo finance the table with rates. I found the table numbers (9 to 15) by trial and error.
Ravi

Any way you could just copy and paste the text of the macro? I cannot download stuff on this computer....

Hi
Here are the codes

Please Login or Register  to view this content.

Ravi

Hi:

Today (26th Nov 08) only I saw ur macro.

Really fantastic.....

Me too have a macro similar to these. But I am searching one more change. I need to show the market price up and down by indicating color.

Like the price goes higher when compared to previous price it shows green else it goes to lower it show red color else it shows the default color.

But I dont store previous value. The same cell, when it updates it must check the previous values and show it as per above mentioned.

Thats it my probs....

Could you let me know please.....????

Thanks....