Download and store data

Download and store data

I want to download data from: http://online.wsj.com/mdc/public/page/2_3024-EuropeanStocks_Stockholm.html?mod=topnav_2_3002_europe The date is located on the top of the page ie Tuesday, April 16, 2013. Once a day check if the date is different from last day. If it is then download the data. The two columns I need is name and % Chg. For each new day I want a new column to be created in the Zoho sheet for the new data ie: Column A Column B Column C name 2012-01-03 2012-01-04 .... stock1 % Chg % Chg .... stock2 % Chg % Chg .... stock3 % Chg % Chg .... It would also be great if zoho could check that the zoho table stock index name in column A is equal to the new stock name to make sure the data is stored on the right row. This is important since stocks might get deleted or added on the webbpage hence the order of the stocks might change over time. A new row would be created for a new stock and the new observation stored in the appropriate column and the previous columns of that row filled with the symbol for missing observations. Any missing observation need to be indicated with 0 instead of ..


Budget : $150 | Duration : One week

To leave a private message, please click the link for private response in post Action section.