Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have got a webpage
http://www.dukascopy.com/tradercontest/?action=liveForecast
Once you go to that page, change instrument to any, so all three parameters are "Any"

You will see there are quite a few pages with 10 trades on each page and all these trades are are having one of three background colors.

I want to import all these trades from all of the pages in excel on an interval of say 1 or 5 minutes or if the trades are imporeted when the excel is opened, it is acceptable as well.

So I have updated web address to fetch data from page 1,2,3 and likewise which are as follows.

http://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=1&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1
http://www.dukascopy.com/tradercontest/?instrument=USD%2FCHF&side=&state=&trader=&page=2&sort_by=&sort_dir=ASC&action=forecastGrid&ajax=1
you: please check the above pages

We have to change the page=1 to page=2 to page=3 and likewise.

If I use the above updated web addresses, I am not able to grab the back ground color of each trade in a way that the background color appears on first link above.

So the requirement is to import all the trades from all of the web pages with back ground color as a separate column is excel.

Please let me know if anyone have the solution.

Thanks and regards.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900