Awarded

Excel Job by luigi83

hello, i need some small works to be done in excel

the first part is very easy

i need to extract data from a webpage with parameters

i did the iqy file for the webquery, but don't know how to loop it to extract all the info

i will now explain you what i need. after this part of the project (which i think is very simple) will be done, i'll explain you the second part

the url is

[url removed, login to view];lang=it

the .IQY file (web query is)

WEB

1

[url removed, login to view];lang=it

Selection=1,2,4

Formatting=None

PreFormattedTextToColumns=True

ConsecutiveDelimitersAsOne=True

SingleBlockTextImport=False

DisableDateRecognition=False

DisableRedirections=False

the parameter which change is the isin

so the urls will be

[url removed, login to view];lang=it

i have a list of around one thousand

so i need a webquery that will extract the same data from the 1.000 different pages (all identical, but with the different parameter ISIN)

and put all these data in one sheet to archive (each end of day i will have to extract the new values and archive them, day by day)

then, in a second sheet i need a very simple list

with on each row the following colums

( i use the example from the url page [url removed, login to view];lang=it

ISIN, NAME (Dexia C-15 Sch Tot E) , ULTIMO PREZZO , VAR % , DATA -ORA , Volume totale, Numero Contratti, Min Oggi, Max Oggi

CAN you do it?

hope i exlained well

so, each night, i open the file , it updates readingthe 1.000 pages

the isin parameters will be in a txt files or in a column in excel sheet

maybe sometimes i will have to add/delete some isin (maybe 3-5 every week)

thanks!

please tell me how much it could cost. after doing this,i will explain you the second part. thanks!

Skills: Excel

See more: var sheet, min cost, how much cost a web page, custom list in excel, cost of webpage, ToT, scheda, sch, put 23, mot, how to add example project, loop url list, excel sheet formatting, Excel WebQuery, extract excel files, query loop, excel selection list, excel delete row, excel list files add, custom loop, extract data excel files, excel selection html, custom web query excel, need simple custom webpage, custom webpage

About the Employer:
( 0 reviews ) Italy

Project ID: #2585147

1 freelancer is bidding on average $3 for this job

diamond247

Hired by the Employer

$3 USD / hour
(71 Reviews)
6.3