I would like to download / import data from following webpage to excel.
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
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.
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
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.